Building MySQL Query Application
If you want displaying results of a SELECT query from database, then Query Application could be used.
Query Application’ helps you get data rows from target database with a query SQL statement(SELECT).
- It consists of a FORM (or not) and a query SQL statement.
- When the user fill in the form and click the ‘submit’ button, the SQL query statement will be executed with the form parameters and the data rows show on the page.
Step1. Enter application information
Click the Application menu, and click the Create New Application button in the opened page. In the opened page:
After entering application information, click “Next>>” button. a page like below will be shown
Step2. Creating a Form which contains a “Status” dropdown
Step3. Building Query Scripts with the help of Query Builder
Now, expand the application menu in the left, you will see the application just created.