The close() function was added for completeness in the database abstraction. If the database is prematurely closed in a plugin or theme (as you are using it), the next call to wpdb::query() will re-open the connection. Your Commands out of sync error is a MySQL error, not a WordPress one, and it might be coming … Read more
At a higher level, there truly isn’t any means to know if the php/db connector will return the correct id by relying on $wpdb->insert_id. The only way to be 100% sure is to have add a key you know will be unique (and indexed as such); you can then retrieve the id by querying the … Read more
If you really just want a single row, use $wpdb->get_row($sql) instead. But your query looks funny…it looks like you’re trying to get the latest ‘client status’ for the user in which case your query should be: ‘SELECT status FROM Clients WHERE UserID = ‘.$current_user->ID.’ ORDER BY ID DESC LIMIT 1′. And if you do that, … Read more
Ok I have cracked it, by spoofing the $_SERVER variable and pre-defing some constants, I was able to prevent WordPress from redirecting after the inclusion of wp-load.php. define(‘WP_USE_THEMES’, false); define( ‘DOMAIN_CURRENT_SITE’, $siteRow[‘domain’] ); define( ‘PATH_CURRENT_SITE’, “https://wordpress.stackexchange.com/” ); define( ‘SITE_ID_CURRENT_SITE’, 1 ); define( ‘BLOG_ID_CURRENT_SITE’, $siteRow[‘wp_blog_id’] ); $_SERVER = array( “HTTP_HOST” => $siteRow[‘domain’], “SERVER_NAME” => $siteRow[‘domain’], “REQUEST_URI” … Read more
This will not work because you call example.com/markers.php directly, and that file does not load anything from WordPress, like the $wpdb object. You can include wp-load.php, but this might break if you move the WordPress installation to somewhere else. To be more in line with how Ajax calls in WordPress should be made, you should … Read more
The filter on posts_orderby should return a string that does not begin with ORDER BY, WordPress will add that itself. By default WordPress will filter by post_date. If you don’t want that, you should overwrite the order clause, not append to it. So your filter should look like this: function filter_orderby( $orderby ) { global … Read more
You need to connect your script to WordPress before you can use $wpdb. The usual way to do this is to include wp-blog-header.php: include “/path/to/wordpress/wp-blog-header.php”;
You cannot replace the main query with the output of $wpdb. The main query is a WP_Query object. $wpdb returns a simple array or object, but not a WP_Query object. Even if you could shove raw SQL into a query (something in the back of my head makes me think you can but I can’t … Read more
Try to replace: AND meta_value LIKE %s with AND meta_value LIKE ‘%%%s%%’ so your SQL will become: AND meta_value LIKE ‘%The%’ instead of: AND meta_value LIKE ‘The’
Try adding the single quotes back around the %s: $countthem = $wpdb->get_var($wpdb->prepare(“SELECT COUNT(*) FROM wp_cmapg WHERE lang=’%s'”, $lang) );