wpdb

301 Redirect Code

Assuming that the url parsing is correct and the data is actually set up correctly in the DB I think your SQL query is wrong. My suggestion is that you replace it by calling wp_query() api with the relevant parameters. Another suggestion that might not be a bug is not to use guid, as it … Read more

how to use $wpdb->prepare to update a custom table

When you look at the Codex article on $wpdb, then you will see that your current usage is correct. The last argument array( ‘%s’, ‘%d’, ‘%s’ ) already indicates that there is something like sprintf/printf going on in the background. The $wpdb->prepare() method isn’t needed for every other method. The ones that need it: $wpdb->query() … Read more

$wpdb->prepare with ON DUPLICATE KEY UPDATE

It’s my fault. Got the solution after @Otto’s comment: Do you actually have a duplicate key here? What is the structure of user_req and what are the keys and indexes? Here’s how my SQL query should be: INSERT INTO {$wpdb->prefix}user_req ( user_id, post_id ) VALUES ( %d, %d ) WHERE NOT EXISTS ( SELECT * … Read more

Problem in inserting row to custom database table

The simplest thing to do here is remove the: ‘id’ => “”, from the data array. Also, to simplify your database creation, you don’t need to do your get_var(), you can just change your SQL command to: CREATE TABLE IF NOT EXISTS $table_name This way you let the db handle creation of the table without … Read more

How can I combine one field using wpdb and group by?

Got it working with $uvusql = $wpdb->prepare( ” SELECT p.ID, p.post_title, p.post_date, wcom.order_item_name, wcomm.meta_key, wcomm.meta_value, wcomm2.meta_key AS meta_key_qty, wcomm2.meta_value AS meta_value_qty, pm2.meta_value AS meta_value_location FROM $wpdb->posts AS p INNER JOIN $wpdb->postmeta AS pm ON p.ID = pm.post_id INNER JOIN $wpdb->woocommerce_order_items AS wcom ON p.ID = wcom.order_id INNER JOIN $wpdb->woocommerce_order_itemmeta AS wcomm ON wcom.order_item_id = wcomm.order_item_id … Read more

+ More