General Operation Application

Introduction

‘General Operation application’ helps you modify your database with data manipulation SQL statements. It consists of a FORM(or not) and some data manipulation SQL statements. When the user fill in the form, click the ‘submit’ button, DbFacePHP will execute SQL statements one by one, and show your the result.

Now, We will creating a “General Opertaion Application” that update order status by Order Number.

Step1. Enter Application Information

Enter application name, title and description. the application name will shown as the menu name in the left menu bar.
php mysql tool | Generation Operation Application
After application information inputted, click “Next” button to step2.

Creating the Application Detail

Generation Operation Application consists of
[check_list]

  • Form: Application user can input data in the form
  • Application Scripts: Application scripts executed when user clicked the “Submit” Button
  • Confirmation Message: shown before the real executation
[/check_list] php mysql tool | General Operation Application : Enter detail information
Since we will create a new form for the new application, we select the “Create New” radio button, the form builder will shown like below:
php mysql tool | Form Builder in General Operation Application
In the Form Builder, click the “Auto Generation From a Table” button:
php mysql tool | Auto generate form from a table

php mysql tool | Auto generate form from a table

Click the “Select” button, and Edit the field “Order Number”, Enter “Updating Script” like below(You can creating it with the help of Query Builder), This script will be executed for updating current form while this field changed(on user input). You can also use form variables in this script.
php mysql | Form Builder : Edit Field

php mysql | Form Builder : Edit Field

Now, you have created a form like this:
php mysql | Form Builder Sample Form

php mysql | Form Builder Sample Form

Input Application Scripts

You have create a Form that containing a order entry. Then, we should create application script, that updating status by Order Number
Click the “D-M-L” Builder which meanings Deleting/Modifying/Updating helper tool, and select fields like following:

php mysql web tool : Building updating query script

php mysql web tool : Building updating query script

Click the Copy and Close button to copy the buiding script to script editor

Input the confirmation message for the application

After doing this, we should input a confirmation message for the application, that will shown before the updating script executation.
We input:

Are you sure to update status to ${status} for order number ${orderNumber}

you may know, ${status}, ${orderNumber} are field names that user input.
So now, you have done a “General Operation Application” for DbFacePHP for MySQL, click the “Create” button, you will see a message that shown the application has been created. Now, you will see your application in the Application Menu at left.
Click the application menu, you will get a page like below:

php mysql tool | General Operation Application

php mysql tool | General Operation Application

Yes, this is just the application you created!, try input order number, and press “Enter”, the order information will fullfill the form, and select the status from the dropdown, and create submit Button, a confirmation will shown, and Click the confirm button, the script will executed, and an appropriate message will popup.
General Operation Application for DbFace

Updating Script Executation