How to view the MySQL query sent by an admin form?
PHP CRUD Tutorial

How to view the MySQL query sent by an admin form?

PHP Form Builder is included in PHP CRUD Generator's package.
With all its functionnalities and plugins.

The MySQL queries sent to your database are built with PHP Form Builder's MySQL wrapper class.

Documentation and sample codes are available here on PHP Form Builder's website.

All the Admin forms are located in the same folder in admin/inc/forms/.

Each table uses 3 forms:

• table-create.php
• table-edit.php
• table-delete.php

where "table" is the sanitized name of your table.

All the actions (database recordings) are done in the same files after validation.

There's 2 different cases:

1. If your query fails
   (you see the ugly alert message Error while recording after posting the form)

   • In development mode (on localhost), you should already see the error details with the SQL query

   • In production mode (on production server)

     Find the following block in your form file:

     if (ENVIRONMENT == 'development') {
         $msg_content .= '<br>' . $e->getMessage() . '<br>' . $db->getLastSql();
     }

     and replace == with !== Then post your form again and the SQL query will be shown.

2. If your query is successfull

   To show the MySQL query sent by a form you just have to add the following code to the form
   just after the code where the query is sent:

   echo $db->getLastSql();

Prerequisites

To edit the Bootstrap Admin Forms you must beforehand:

• have purchased and installed PHPCG
• have created your MySQL database
• Have generated the form you want to customize with the CRUD Generator

Back to the PHP CRUD Tutorials