Menu Title

WordPress – How to pass variable as parameter in URL

  This simple method worked for my WordPress website to pass a parameter in URL. In this tutorial, the Datewise Invoices page lists down all the invoices created between the dates. When you click on a specific Invoice No, the invoice no is passed as parameter value and a new webpage opens up more details of the invoice. Continue Reading

showing errors with wpdb update or insert query

exit(var_dump( $wpdb->last_query )) prints the last query that is executed by database. This is very useful for developers to verify and troubleshoot errors in your query syntax or data format. One sample is presented here for you. if ($wpdb->update(“laundry_item_master”, array( ‘dryclean_normal’ => $dryclean_normal, ‘dryclean_urgent’ => $dryclean_urgent, ‘washing_normal’ => $washing_normal, ‘washing_urgent’ => $washing_urgent, ‘pressing_normal’ Continue Reading

wpdb last_query, last_result, last_error

There are times that you wanted to print the exact query itself or query result right after it is executed. Use following wpdb class variables to troubleshoot. $wpdb->last_query This prints that last query that is executed, I mean the exact MySQL Query itself. $laundrycustomer = $wpdb->get_row(“SELECT company_name, customer_name, phone, address FROM Continue Reading

Difference between wpdb get_row(), get_results(), get_var() and get_query()

WordPress defines a class called wpdb, which contains a set of functions used to interact with a database. Its primary purpose is to provide an interface with the WordPress database, but can be used to communicate with any other appropriate database. The $wpdb object can talk to any number of Continue Reading