You can’t “delete” a field in MySQL, this only works for complete rows. However, you can unset values, meaning setting them to their original state, usually NULL or an empty string. $wpdb->update($wpdb->posts, array( ‘product_rank’ => NULL ), array( ‘ID’ => $post_id ));
$wpdb->prepare shouldn’t make any significant difference. As you can see here (https://developer.wordpress.org/reference/classes/wpdb/prepare/#source), it doesn’t do much. It’s just taking care of proper escaping and formatting variables, so the final query is safe to run. So if you’re asking if there is a big difference between $wpdb->query( $wpdb->prepare( … ) ) and $wpdb->query( <SAFE_SQL> ), then … Read more
No, it is not safe to resize columns in WP core tables, or to alter them. When you next update WordPress, the update process will alter the tables to the official table schema, truncating all your GUIDs and breaking them. Instead, you need to contact the support route for the plugin so that they can … Read more
You can try the following query SELECT * FROM `mytable` WHERE `question` = ‘\\\”creating world \\\” written by\?’ In php global $wpdb; $quest=addcslashes(‘\”creating world \” written by?’,’\”?’); $result = $wpdb->get_results(“SELECT * FROM mytable WHERE question ='{$quest}'”);
You can also try below code to retrieve count of rows. $myquery = $wpdb->get_results( “SELECT * FROM tablename WHERE ID=’some-value'” ); echo $wpdb->num_rows; Let me know if you have any problem. cheers
I used define( ‘SHORTINIT’, true ); $path = $_SERVER[‘DOCUMENT_ROOT’]; include_once $path . ‘/wp-load.php’; it seems to work fine.
if ajax returns zero, the function bound is not registered properly have a read: http://arresteddeveloper.net/woocommerce-get-variation-description-variation-select-changes/ this might point you in the right direction
Glancing at your code I see a few potential problems. According to this Codex page dbDelta is “picky”; You must put each field on its own line in your SQL statement. You must have two spaces between the words PRIMARY KEY and the definition of your primary key. You must use the key word KEY … Read more
Try with: function getComponents($page_id, $currentLanguage) { global $wpdb; $result = $wpdb->get_results($wpdb->prepare( ” SELECT id, post_content, post_title, post_excerpt, post_name, m1.meta_value AS ‘template’, m2.meta_value AS ‘home_description’ FROM {$wpdb->posts} p JOIN wp_term_relationships r ON p.ID = r.object_id JOIN wp_terms t ON r.term_taxonomy_id = t.term_id WHERE t.slug=%s AND post_parent = %d AND post_type=”page” AND post_status=”publish” ORDER BY menu_order ASC … Read more
As per the WordPress documentation you cannot connect to another DB using wpdb. https://codex.wordpress.org/Class_Reference/wpdb You best bet is to connect to the DB separately.