TL;DR This is not possible with wpdb. Use dbDelta(). Even better, use something else to run raw queries. Explanation wpdb->query() uses the mysql_query() function. From PHP manual: mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that’s associated with the specified link_identifier. In order for that … Read more
I solved my issue by passing the page variable as a hidden field: <form method=”get”> <input type=”hidden” name=”page” value=”<?php echo $_REQUEST[‘page’] ?>” /> <?php $this->customers_obj->prepare_items(); $this->customers_obj->search_box(‘Search’, ‘search’); $this->customers_obj->display(); ?> </form>
The SQL for creating tables in dbDelta() has very specific requirements. From the codex: 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 rather than its synonym … Read more
You don’t need to remove the prepare(), but you just need to do it properly. And please check the $wpdb->prepare() reference for the function’s syntax etc., but basically, instead of (wrapped for brevity): $insert_query = “INSERT INTO `”.$computer_repair_items.”` VALUES(NULL, ‘”.$wc_service_name.”‘, ‘services’, ‘”.$post_id.”‘)”; $wpdb->query( $wpdb->prepare($insert_query) ); you should do it like this: (presuming $computer_repair_items is a … Read more
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
Unlikely that you will need intermediary database, from your description this is likely to be easy enough with bit of PHP and WP APIs. Create WP-Cron task (if you need automated recurrent import). Read data from flat files, for example with fgetcsv(). Use wp_insert_post() for creating posts and custom field functions to add your data. … Read more
On your if(), it should be like this: if (!($wpdb->get_row(“SELECT voter_ip FROM ” . $wpdb->prefix . “voter_ips WHERE post_id = $post_id AND voter_ip = ‘$voter_ip'”) Notice the quotation mark added on $voter_ip.
Your template code includes $wpdb->print_error(). This function prints the last database error between [ and ] brackets, and the executed SQL code. But if there is no error, you just see the empty brackets and the SQL. $wpdb->show_errors() is used to enable displaying of database errors. If you want to see all database errors, you … 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
So after about a year (on and off!) I had managed to hopefully get a fix on encoding issue. Why it breaks What my experience boiled down to, is that encoding issue like this are mostly caused by miscommunication when moving data around. in best case this is read mismatch, when correct data is wrongly … Read more