You’re using $term->ID. Taxonomy terms do not have an ID property. They have a term_id property: $display_type = get_term_meta( $term->term_id ); You’ll notice that WooCommerce is using this, while your attempts are not.
class MyClass{ function __construct(){ global $wpdb; $this->db = $wpdb; } function query(){ return $this->db->query( $this->db->prepare(“INSERT INTO {$this->db->wp_competitors} (id, ield_key, field_value) VALUES ( %d, %s, %s )”, 1, $field_key, $field_value) ); } }
You won’t be able to translate a complicated SQL query directly to a WP_Query. What you can do is return Post IDs from the SQL and pass those IDs into the WP_Query args. Do note that this is highly inefficient and will likely create slow queries as post__in is not fast. You need to modify … Read more
Hi @Holidaymaine: Not sure where you are doing wrong, but try the following instead which is a self contained test.php file you can drop into the root of your website and load in your browser with http://yoursite.com/test.php (assuming you replace yoursite.com with your site’s domain! Also, note how I adding in a WHERE {$wpdb->usermeta}.meta_key = … Read more
WP 4.5 had introduced wpdb->close() method to close connection in current instance. Old answer There is no explicit method. It stores link identifier in $wpdb->dbh field, but it is protected, so not convenient to run close on.
You don’t. Not with the WPDB update() function. The update function assumes that the values of the columns are strings. You can override that with the format parameter, but that only allows %d, %f, and %s (integer, float, string). It doesn’t allow operations on columns like total+1. You’d have to use the query() function directly … Read more
In code you posted you do not retrieve ‘list of posts’ as you say, but retrieve a list of rows in the meta table. If you want really retrieve a list of posts rely on WP_Query using meta_query param. Something like: $id = ’10’; // unserialized value $args = array( ‘post_type’ => ‘post’, ‘post_status’ => … Read more
I got the same problem. Solution 1: Strip your data.. WordPress rejects the query if the length of value is greater than the field length defined on the database. On your insert query, the value for post_type field exceeded the 20 character limit. Solution 2: Use the $wpdb->query method
When working with database in WordPress you should never use the low lever mysql_* or mysqli_* functions. Always use $wpdb methods, in your case you should use prepare(): $query = $wpdb->prepare( “SELECT post_title from $wpdb->posts WHERE post_title LIKE %s”, “%” . $myTitle . “%” ); Moreover, once you are getting a single column, you have … Read more
Why not use the SELECT INTO OUTFILE syntax: $wpdb->query(“SELECT * INTO OUTFILE ‘/path/to/file’ FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’ FROM tracking”);