Synchronize PHP Web Forms with MySQL table fields

I have writen this  PHP Class a couple of years ago, its very practical for small systems in order to speed up maintenance.

Can be used to:

  • Generate form to edit data stored in MySQL databases.
  • It can generate HTML forms with several types of fields, executing SQL queries to retrieve the default values of the MySQL database table fields.
  • The class can generate text or textarea form inputs depending on length of the database table text fields.
  • It can also generate checkbox, radio, and select inputs to edit enum or set database table fields.
  • The output can be customized with configurable CSS styles and Javascript code.

Here is an short usage example:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

// Generate textfield
echo $formAt->genStrField("car_rental", // table
                      "customer_name"  // column
 
// Generate radio-set from enum column
//(Automatically select the default value in column)
echo $formAt->genEnumSetField("car_rental", // table
"rent_mode" //column
 
// Generate a select object table based
$formAt->setSelectIniLabel("Select a Car"); // Set the first option
echo $formAt->genCatalogueField("cars", // table
                                "car_id", //column for value
                                "car" // column for label
);
// Generate textfield
echo $formAt->genStrField("car_rental", // table
                      "customer_name"  // column

// Generate radio-set from enum column
//(Automatically select the default value in column)
echo $formAt->genEnumSetField("car_rental", // table
"rent_mode" //column

// Generate a select object table based
$formAt->setSelectIniLabel("Select a Car"); // Set the first option
echo $formAt->genCatalogueField("cars", // table
                                "car_id", //column for value
                                "car" // column for label
);

You can download it from PHPClasses.org at http://www.phpclasses.org/package/4396-PHP-Generate-forms-to-edit-data-in-MySQL-tables.html

Tags: ,

This entry was posted on Wednesday, November 9th, 2011 at 2:35 am and is filed under Scripts. You can follow any comments to this entry through the RSS 2.0 feed. You can leave a comment, or trackback from your own site.

Leave a comment