[adsense id=”0514458240″ width=”468″ height=”60″]
We have just updated this script (v1.02) to generate output supporting Windows machines.
Today we have completed a PHP script that will generate table stored procedures based on the CRUD concept i.e. Create, Read, Update and Delete, except we do it on an existing MySQL database with already existing tables. Our script is automated in that it identifies the primary keys of the tables and generates the stored procedures based on each tables primary key fields. Click here to read about testimonials.
Further down we have a demo showing the script in action.
This is an ideal for developers who need to develop against an existing database. The stored procedures can act as a template for more complex stored procedures.
There are 4 stored procedures generated per table:
- A stored procedure that returns a complete listing of the table
- A stored procedure that returns a single row based on the primary key parameters passed in
- A stored procedure that deletes a single row based on the primary key parameters passed in
- A stored procedure that will check based on the primary key for an existing record and perform an update on the existing row or inserts a new row
The script requires PHP5 and MySQL client installed for PHP.
This script is available for free. Just register below to receive your free copy.
Here is a very quick demo of the script in action:
Read what people are saying about it
“I love this script, and I need it badly as it will save ton’s of my time and moreover all the errors
that I would have creating all these stored procedures.”
Jim Douglas
President
Genesis Software Development, Dallas TX USA