wpdb Archives - Page 5 of 21

WordPress

IT Nursery

store custom WP table names in a global variable

I was being creative and put this in one of the files loaded with my plugin. Are there implications with storing the table ...

May 26, 2022
0 Comments

WPDB update row with != in where clause

I’m using wpdb to develop a plugin to add a custom form to wordpress. To update a row, I use an array and ...

May 26, 2022
0 Comments

When and why should I use $wpdb different return types?

This one returns an object $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE link_id = 10"); An associative array $mylink = $wpdb->get_row("SELECT * FROM ...

May 26, 2022
0 Comments

How to get top 10 user is based on user meta value

I’m trying to get top 10 users in my wordpress blog based on user meta value. I’ve tried few methods & finally able ...

May 26, 2022
0 Comments

Activation hook not creating table

For some reason my activation hook is not creating new database table. Code: function mm_booking_activate() { global $wpdb; $mm_booking_table_name = $wpdb->prefix . "mm_booking"; ...

May 25, 2022
0 Comments

Get random row from custom table

I have custom table where I store quotes and author: function quote_install(){ global $wpdb; global $quote_db_version; $table_name = $wpdb->prefix . 'quote'; // create ...

May 25, 2022
0 Comments

PHP syntax error when using wpdb update?

I’m not too good with PHP, so I’m having trouble with some code that is supposed to update the wp_posts table. The problem ...

May 25, 2022
0 Comments

$wpdb not returning data

I have the feeling that the answer to my problem is going to be very simple. I have written the following code to ...

May 25, 2022
0 Comments

Get WooCommerce product attribute taxonomies in a SQL query on WordPress database

I am trying to retrieve a list of all my attributes_name values (carat, color, size etc) from the WooCommerce table wp_woocommerce_attribute_taxonomies in WordPress ...

May 25, 2022
0 Comments

how to execute different sql query in non-sanitized $wpdb->get_results function

I saw $wpdb->get_results that function is not sanitized by core code($wpdb is get_results escaped). For example, in following code $wpdb->get_results( "DELETE FROM `wp_postmeta` ...

May 25, 2022
0 Comments