FormProcessor

A class to perform CRUD ops easily and quickly

FormProcessor is a php class which allows to perform CRUD operations. More precisely, it allows the user to add, edit and delete records to/from a specific table.

You can visit <a href="https://formprocessor.codingfix.com">this page</a> to get more details.

Update 10 september 2018

• Added a new class just to manage the database connection a singleton
• Migrated DbModel and FormModel classes from mysqli to PDO
• Added the new setting 'dbDriver' to config.php in order to allow to choose which database driver must be used
• Converted all queries to prepared statements to improve security

Update 7 september 2018

Fixed residual underscore names in some file (delitem.php, delete.php, edit.php etc.) Changed example logic: before, example files used the classes in 'lib' folder but this made me implement wrong logic for config file. Now in example folder you find a FormProcessor folder which contains classes used by the example files (like normally we'd have in real world. I hope to be able to publish soon a small website to illustrate the package in detail.

Update 20 august 2018

• removed FormProcessor and FormProcessor classes, merged into the FormProcessor one.
• fixed bug deleting pictures or documents from an existing record
• fixed a bug adding pictures or documents to an existing record
• added code to delete all file associated with a given record when this record is deleted

Update 16 august 2018

• fixed a bug which prevent to create multiple selects from external tables
• removed table_name from the config file: now you must pass table_name to the constructor: this makes the class more flexible.

General description

FormProcessor class

FormProcessor has been originated by the need to easily create a form reading the table structure from a mysql database. Currently, only a little number of MySql field types are supported: - varchar - text - int - decimal - tinyint - bit I also added some configuration options int a config file which allows to manage checkboxes, radiobuttons and selects (these ones in 2 different ways).

FormProcessor gives you the ability to save the form data and upload the supported files types with few lines of code.

FormTable class

FormTable builds a simple html table to show data stored in the mysql table. The resulting table allows to sort records in ascending or descending order clicking on each column name; in addition, each record has 2 action buttons, 'Edit' end 'Delete'. This class is included only to make it easy to show how FromProcessor works and it is not really part of the package.

FormModel class

FormModel is used to perform database operations.

Usage

To illustrate the use of these classes I have included a full working example. To see it in action you have to use the 2 sql files provided in the folder 'db' and create the 2 table 'products' and 'category' in your local or remote server. Then you have to upload to your server the content of the 'example' folder and finally just set the values required for the database connection in the config.php file and the correct siteUrl. Now you're ready to go to yourserver.com/manage.php.

I plan to write a more detailed description in the next weeks and even to create a mini website, even if I prefer to work to improve the class itself (and there is a lot of work to do to improve at least security and flexibility).

If you want to see an example of the code required to create a form, here you go:

Add a new record

require_once "../lib/FormProcessor.class.php";
$fb = new FormProcessor();
echo $fb->build_form();

Save a new record

require_once "../lib/FormProcessor.class.php";
$fs = new FormProcessor();
echo $fs->save();

Edit an existing record

require_once "../lib/FormProcessor.class.php";
$fb = new FormProcessor(123);//the id value for the record to edit
echo $fb->build_form();

Save an updated record

require_once "../lib/FormProcessor.class.php";
$item_id = filter_input(INPUT_POST, 'item_id', FILTER_SANITIZE_NUMBER_INT);
$fs = new FormProcessor($item_id); //you can use this code even to save a new record: if $item_id is null there is no problem
echo $fs->save();

Conclusions

That's all folks. Hope you can find it useful and don't hexitate to contact me for criticism and suggestions... okay, even for congrats, if you really think I deserve them :)

You can find me at my blog codingfix.com, on Twitter, Facebook and Instagram.