foreach( $wpdb->get_results(“SELECT * FROM your_table_name WHERE id LIKE’ . $id . ‘;”) as $key => $row) { // each column in your row will be accessible like this $my_column = $row->column_name;} More info here
Update: Since WordPress 4.4. this is now supported by the insert, update, replace and delete methods of wpdb and the ticket #15158 has been closed as fixed. Thanks to @dmsnell for commenting about that update. On the other hand, the null support in wpdb::prepare() is currently closed as wontfix in ticket #12819. Previous answer: NULL … Read more
I was sure that wp_update_user() should do this. It even gets user_login as param, but it looks like it ignores it, when you set this param. So this code looks OK, but it doesn’t work as you wish it did 🙁 : wp_update_user( [‘ID’ => $user_id, ‘user_login’ => $new_login] ); You have to call custom … Read more
global $wpdb; $result = $wpdb->get_results ( ” SELECT * FROM $wpdb->posts WHERE post_type=”page” ” ); foreach ( $result as $page ) { echo $page->ID.'<br/>’; echo $page->post_title.'<br/>’; }
No, you shouldn’t prepare or escape the data, this is done for you by the wpdb class. From the wpdb class reference: data: (array) Data to insert (in column => value pairs). Both $data columns and $data values should be “raw” (neither should be SQL escaped). If, however, you were writing your own SQL rather … Read more
It is mandatory, though it is not enforced. Consider the scenario when two WordPress site has been setup in the same database. One with prefix wp_ and another with wp2_. If you install your plugin in both of the sites with the prefix, your created tables will be wp_liveshoutbox for first site and wp2_liveshoutbox for … Read more
If you are merely trying to get a count, $wpdb->get_var(); along with using COUNT() in your sql will be better: ### Search for IP in database function postviews_get_ip($id, $ip) { global $post, $wpdb; $rowcount = $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->wp_postviews_ips WHERE postid = $id AND ip = ‘$ip'”); return $rowcount; } postviews_get_ip($id, $_SERVER[‘REMOTE_ADDR’]); //both $id and … Read more
I would recommend running the following code right after your query to see what’s happening: exit( var_dump( $wpdb->last_query ) ); This should print the last query that hit your database. In cases like these, I usually will manually run such a query through phpMyAdmin to see if it runs without errors and to see if … Read more
Thank you everyone for your help! In the end the query below got me the results I desired – which was to show and sort the posts by a custom field of “publication_date” first – sorting by the date, and if there were multiple of the same date (say, 4 marked June 2013), it would … Read more
First, you are using prepare incorrectly. You seem to have $wpdb->update‘s arguments wrapped in $wpdb->prepare like that. That won’t work. In effect, you are passing update a single argument– the output of prepare. Try something simple like the following and you will see why that won’t work: $post_id = 123; $item_stock = 567; var_dump( $wpdb->prepare( … Read more