Debug bar is one of the recommended (by WordPress) plugins to install for theme and plugin development. I also use debug-bar-extender: http://wordpress.org/extend/plugins/debug-bar-extender/
The output that you posted above is expected behaviour for $wpdb->print_error() if the following is true – You are running a single site, not multisite $wpdb->suppress_errors is set to false $wpdb->show_errors is set to false From the looks of your code, you meet all those conditions. Note also that, unless you have turned them off … Read more
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