The main problem, I see in your code, is that you use query method of wpdb and assume that it is PDO statement object… But it is not. Take a look at wpdb Codex: https://codex.wordpress.org/Class_Reference/wpdb query method is used to run custom queries on DB – that’s all. What you want to use is get_results. … Read more
You need to look at the documentation for the function, which is available here. The function takes the following arguments: $table The table name. $data A PHP array where the keys are the columns and the values are the the values to be inserted into those columns. $where A PHP array where the key is … Read more
There’s nothing wrong with it from WPs point of view. If you want to join posts with your own table and change the way of ordering, then that’s the way to do it. The only thing is a little bit tricky, I guess, is that you use posts_join_paged and not posts_join – it can make … Read more
There’s indeed a WordPress function for counting posts: wp_count_posts(). So you can do something like: $memo_count = wp_count_posts( ‘memo’ )->pending;
That is a placeholder escape string generated by wpdb::placeholder_escape() which is used by wpdb::add_placeholder_escape() and which is called by wpdb::prepare(). So it is safe to keep those escape strings, but there is a wpdb method for removing them: wpdb::remove_placeholder_escape(): // In your case, you’d use $this->wpdb in place of $wpdb. $query = $wpdb->add_placeholder_escape( ‘LIKE %night%’ … Read more
Always escape/prepare your data Don’t leave it open to injections: global $wpdb; $all_posts = $wpdb->get_results( $wpdb->prepare( ” SELECT %s.* FROM %s LEFT JOIN %s ON(%s = %s) WHERE %s=”soundcloud” AND %s=”%s” ” ,$wpdb->posts ,$wpdb->posts ,”{$wpdb->prefix}soundcloud” ,$wpdb->posts.ID ,”{$wpdb->prefix}soundcloud.idpost” ,$wpdb->posts.post_type ,$wpdb->posts.post_name ,$name ), OBJECT ); echo ‘<pre>’.var_export( $all_posts, true ).'</pre>’; Use the prefix $wpdb; offers the $wpdb->prefix, … Read more
You can’t mix wpdb with mysql_fetch_array. They are not compatible. You need to use wpdb methods, plus PHP functions like while, foreach, and for. wpdb does not return the references that PHP’s mysql functions use. It returns an object, and array, or sometimes a string. In your case, though, the database part is done. You … Read more
In the name of bad practices, I’m going to advise that you immediately rule out these using raw SQL queries with remote databases in the same page. It would be slow, insecure, and a hassle to maintain. That you’ve landed yourself in a predicament where a combination of hyperDB+multisite is not an option demonstrates that … Read more
I have some suggestions for you: 1, create MySQL insert queries on your own. 2, combine multiple insert values queries into one like values(1,2,3),(4,5,6) 3, use $wpdb->query then you need to figure out what the appropriate number of “multiple” is. I’ve tried with 100 and it worked for me but I think the number varies … Read more
You need to join the post_meta table twice to the posts table, once for each meta value: SELECT p.ID id, p.post_title title, country.meta_value country, region.meta_value region FROM {$wpdb->posts} p JOIN {$wpdb->postmeta} country ON p.ID = country.post_id AND country.meta_key = ‘search_country’ JOIN {$wpdb->postmeta} region ON p.ID = region.post_id AND region.meta_key = ‘search_region’ WHERE p.post_status=”publish” AND p.post_type=”films” … Read more