I have a shortcode in my WordPress page with which I access the WordPress database with wpdb.
It works perfectly with wpdb-> get_results () and wpdb-> query (), but I am not able to execute an insert with a blob data.
With wpdb:: insert I can’t as it only accepts a string, int and float. With wpdb-> query () it doesn’t work for me either (I even tried with fbsql_read_blob ())
I can insert using the PDO class, but I don’t know if it can be done with any WordPress function. I understand that it is safer and will work better.
Thanks in advance.
Go to Source
Trying figure out how I can use some SQL/$wpdb->query to delete all the terms from a taxonomy that are related to specific post IDs. The following works beautifully to delete all the terms from a specific taxonomy, but I need to modify it to only remove ones associated with specific post IDs as mentioned.
// Clear Terms from Taxonomy 'post_tag'
DELETE t, tr, tt
FROM wp_terms t
INNER JOIN wp_term_taxonomy tt ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships tr ON tt.term_taxonomy_id = tr.term_taxonomy_id
WHERE tt.taxonomy = 'post_tag'
I’m also using the following to delete posts (works great):
$wpdb->query( "DELETE FROM $wpdb->posts WHERE ID IN (".implode( ", ", $postIds ).")" );
I’ve tried to do the following but it doesn’t clear the associated terms they just remain as orphaned in the DB, it just clears the relationship.
// Delete Post Terms
$wpdb->query( "DELETE FROM wp_term_relationships WHERE object_id IN (".implode( ", ", $postIds ).")" );
I’m a novice when it comes to SQL, any help is appreciated, thanks in advance!
Go to Source