Posted inwordpress

how to insert query in wordpress using wpdb? – Examples

WordPress has a built-in Data object class for dealing with SQL query of Insert Update Select and Delete database queries. It’s called wpdb as well as this is a get in the path of includes/wp-db.php file. When you are running queries you required always use this added class to execute them. To use $wpdb class you first required to define $wpdb as a global main WordPress $wpdb variable before you can use it. Just place $wpdb added line of wordpress CMS PHP Source code before every global variable declare as $wpdb method:

global $wpdb
$wpdb->insert,wpdb insert query,wpdb insert,$wpdb- insert not working,$wpdb- insert,select query in wordpress,insert query in wordpress for custom table
insert-update-delete-query-in-wordpress-using-wpdb

Before we get into the nitty-gritty of $wpdb, we should mention that messing with your database unless you’re absolutely confident you know what you’re doing is a bad idea. If you think that your website will require you to do this often, and you aren’t well versed with development, it’s probably a good idea to look into WordPress maintenance plans that offer continuous support.

Functions for running database queries

The $wpdb->query method is used mainly for SELECT as well as DELETE statements but can actually be used for any sql statement.

$wpdb->query – any query method

$wpdb->query($wpdb->prepare ("DELETE FROM $wpdb->user_define_tbl WHERE ID = 1" ));

As you can see, we use the wp->user_define_tbl to reference a custom Database table in our query.

$wpdb->get_var – return single variable

The get_var() method is used for retrieving a single variable from the database

$count_posts = $wpdb->get_var( $wpdb->prepare(" SELECT COUNT(*) FROM $wpdb->wp_posts" ));
echo "$count_posts";

$wpdb->get_row – return single row

To retrieve an entire row You would like to use the get_row() method. By default the row is returned as an object, but you can add the PRODUCT_ARRAY or PRODUCT_ARR_ALL parameter at the end of your method. The PRODUCT_ARRAY parameter will return an associative array and the PRODUCT_ARR_ALL parameter will return a numerically index array.

$wpdb->get_row( $wpdb->prepare( "SELECT * from $wpdb->posts WHERE ID=1"), PRODUCT_ARRAY );

$wpdb->get_results – return multiple rows

To retrieve multiple rows from a Database table You would like to use the $wpdb->get_results() method.

$wpdb->get_results( $wpdb->get_results( $wpdb->prepare( " SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' "));

This wordpress select query in wordpress will fetch all the published all the available group of the posts as Data an object.

$wpdb->insert – Insert query

insert query in wordpress for custom table The are specific wordpress wpdb methods for an insert or update sql. The basic usage of the insert() method

$wpdb->insert($table, $data);

$wpdb->num_rows – number of rows returned

We use the num_rows() methods to return the number of rows returned by a sql query.

var_dump( $wpdb->num_rows);

$wpdb->print_error() – display sql errors

When dealing with usage functions it can be hard to debug what’s wrong with your sql. The print_error() method will display the errors of your sql to the page

$wpdb->show_errors();
$wpdb->get_row( $wpdb->prepare(" SELECT * FROM $wpdb->posts WHERE ID = 3000"); // unexisting ID
$wpdb->print_error();

The show_errors() method must be called before executing a sql query. The print_error() method directly after running the query.

$wpdb->last_query – print last query executed

The last_query() method will print the last sql query executed. This can be useful to test why a query isn’t working as expected.

var_dump( $wpdb->last_query ); 

update query in sql

$wpdb->update – update query : update query in wordpress with where clause

We do a update query in a similar fashion. I first of all put our Database table, and then data pass our Column values in an array and then put our where clause variable.

$wpdb->update( $table, $data, $where );

The where variable is an array of Column names and Database table Column values for the where clause. In this example We shall use a unique ID in our mysql where clause.

$wpdb->update( $wpdb->posts, array( 'post_title' => "Welcome to papega 2020", 'post_content' => "free download bolly4u"), array( "ID", 1));

Both the insert() and update() do not required to use the prepare() method because both these methods use the prepare method internally.

insert query in sql with PHP

Question: how to insert data in mysql using wordpress? also WordPress CMS System allow the $wpdb class of functions for all the data interacting with the PHP MySQL database.

Use $wpdb->insert(). – wpdb->insert id

$wpdb->insert('wp_submitted_form', array(
    'name' => 'Pakainfo',
    'email' => '[email protected]',
    'phone' => '989822566666', // ... and so on
));

select query in wordpress

For example to PHP MySQL SELECT query to get information from a custom Database table called “postmeta”, you can do the bellow Query.

$post_id = $wpdb->get_results("SELECT post_id FROM $wpdb->postmeta WHERE (meta_key = 'pakainfo-post-jdkgroup' AND meta_value = '". $data_frm ."')");
print_r($post_id); 

insert query in wordpress

An example of an insert sql query:

$shop_name = "Pakainfo, com";
$store_address = "Kothariya ring road chokdi rajkot";

$wpdb->insert( $wpdb->user_define_tbl, array("shop_name" => $shop_name, "store_address" => $store_address ));

You first required to set your Database table and then pass your field values in an array. No required to use the prepare method here. We shall learn why in the update MySQL statement query.

Web Programming Tutorials Example with Demo

Read :

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about select Insert Update and Delete query in wordpress.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.

Leave a Reply

Your email address will not be published. Required fields are marked *

We accept paid guest Posting on our Site : Guest Post Chat with Us On Skype