The best WP API solution for this goal is to use the delete() function to remove a row. A small example, to delete the raw ‘ID’ in the custom table ‘eLearning_progress.’ $id = 0815; $table=”eLearning_progress”; $wpdb->delete( $table, array( ‘id’ => $id ) ); But I can’t see which raw you will delete in your table … Read more
This sounds like you do not have mysqli installed and/or enabled on your server. IIRC mysqli was added to php in version 5.5, and the older mysql extension had been deprecated and fully retired since then. If you upgraded from a very old PHP version it might be that you still need the extra step … Read more
Let’s say the primary key of the table is my_part_ID. So we will check if there is any primary key value for the combination of user_ID and PL_part_ID as below $my_part_ID = $wpdb->get_var( $wpdb->prepare( “SELECT my_part_ID FROM ” . $wpdb->prefix . “pl_my_parts WHERE user_ID = %d AND PL_part_ID = %d LIMIT 1”, $user_ID, $PL_part_ID ) … Read more
wpdb‘s get_results method takes an optional second argument that lets you specify how the data is returned. The default return is an object. But you can also set it to… OBJECT – result will be output as a numerically indexed array of row objects. OBJECT_K – result will be output as an associative array of … Read more
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
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
Indeed, use get_row() only when you expect to get one result, else you can use get_results()