Query for Updating Application

Introduction

‘Query for Updating Application’ helps you search and modify the searched result on the fly. It consists of a FORM (or not) and a simple query SQL statement. When the user fill in the form, click the ‘submit’ button, the data rows will shown, then you can update, delete the row on the fly.

Creating Query for Updating Application

Like other application, first click the “Create New Application” link and enter the application information like below:

Creating Query for updating application | php mysql tool

Creating Query for updating application | php mysql tool

Query for updating Form

Query for updating Form

Query Builder in DbFacePHP for MySQL

Query for updating application

Query for updating application

Query for updating application | php mysql tool

Query for updating application | php mysql tool

Expand the resultset row will shown editable form for current row

Expand the resultset row will shown editable form for current row

Upating resultset from the searched resultset | php mysql tool

Upating resultset from the searched resultset | php mysql tool