I have a query that runs fine in raw PHP but I cannot run using $wpdb. I seem to be missing something in the advice provided at How do you properly prepare a %LIKE% SQL statement? My code is global $wpdb; // Create a SQL statement with placeholders for the string input. $sql3 = “SELECT … Read more
There is a problem: I want to add a table ‘linkmeta’ to work like ‘postmeta’ or ‘commentmeta’.. and use functions like add_metadata / update_metadata / delete_metadata! but, in this functions call “_get_meta_table()” to verify the name in db, this code: function _get_meta_table($type) { global $wpdb; $table_name = $type . ‘meta’; if ( empty($wpdb->$table_name) ) return … Read more
how do I get all posts and postmetas in an associative array? $allposts = $wpdb->get_results(” SELECT $wpdb->posts.post_title, $wpdb->postmeta.meta_key FROM $wpdb->posts JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id = $wpdb->posts.id WHERE $wpdb->posts.post_type=”post” AND $wpdb->posts.post_status=”publish”;”, OBJECT_K); I just don’t get it…. 1 Answer 1 Basically, you can’t do it in a single SQL query. You need two. You don’t have … Read more
I’m working on a project with WP, a bit like a plugin, but not quite one. I’m encountering an issue, when trying to include a file that contains some custom SQL functions in a class, in a completely different file, I get redirected to http://example.com/folder1/file.php/wp-admin/install.php Which states that I’ve already installed WP and I need … Read more
Hi I’m just curious as to how WordPress accesses it’s own database, meaning that when I look into an admin page like link-manager.php or class-wp-list-table.php I don’t see any occurences of $wpdb. So again, is there an internal way that WordPress queries its own DB? If so, could I use that type of function to … Read more
This question already has answers here: Closed 9 years ago. Possible Duplicate: How to query posts based on lat-lng coordinate as post meta? I want to create a $wpdb query that select the closest places (custom post type) near the current coordinates ($lat and $long) but I’m not able to get two custom field values … Read more
I’m querying the postmeta table to see if a url has already been entered, using this statement (where $thisLink is the url I’m checking) $mypostids = $wpdb->get_results(“select * from $wpdb->postmeta where meta_key = ‘rssmi_source_link’ and meta_value like ‘%”.$thisLink.”%'”); The problem is that on some servers it appears it’s not finding urls that already exist in … Read more
I need to insert multiple array. I get error: mysql_real_escape_string() expects parameter 1 to be string, array given My example code: $array_info is Array ( [0] => Array ( [0] => a [1] => b [2] => c ) [1] => Array ( [0] => d [1] => e [2] => f ) ) $data … Read more
As i want to manage the NULL fields in my db and wordpress functions doesn’t allow to do so, i will need to dynamically generate a query depending on the situation. The problem is that i don’t know how to pass a variable number of fields as second argument! this is what i’ve been tr … Read more
Been looking for a clean and simple way to produce comments from across a network using the $wpdb database class. I did find this answer, which has been protected, and is four years old. I wrapped it in a function and attempted to call it on the front page of my network, but it didn’t … Read more
