wpdb - Read For Learn

How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page

$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

Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?

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

selecting row using wpdb which contain special symbols

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}'”);

Convert a WP Query into a simpler SQL query to fetch only COUNT of posts

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

How do you get a reference to $wpdb in a PHP script

I used define( ‘SHORTINIT’, true ); $path = $_SERVER[‘DOCUMENT_ROOT’]; include_once $path . ‘/wp-load.php’; it seems to work fine.

Ajax Query returns zero

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

DBDelta: “table doesn’t exist” for a table that was just created

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

$wpdb->prepare returns empty array

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

Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]

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.

wpdb LIKE request shows all database data

Can you verify that $_POST[‘name’] is obtaining a value. I suggest echoing it out to the page for debugging (maybe in comment tags if site is live). If $_POST[‘name’] is empty, then all results will be returned because the query will say user_nicename LIKE ‘%’ Just as a precaution in any case, you should do … Read more

+ More