PHPBuilder - Cutting out redundant SQL code



RSS Twitter
Tips Databases

Cutting out redundant SQL code

by: Matt Springfield
|
August 21, 2001

Well as we are all interested in cutting out redundant code of any kind, there is a little simple script out there that can greatly assist in this. It's called the Echelon SQL Scripter (http://www.digitalthought.com/echelon/). The PHP version supports both MySQL & PostgreSQL. Very simply, you: 1.) create your html forms (name your form element names the same as your column names in your database) 2.) point the form action to echelon.php and pass a url to redirect to And that's it! Echelon will build the sql script on the fly, connect to the database & insert/update or delete data accordingly. It has a built in debugger for trouble shooting as well.

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
Matt Springfield

Comment:



Comment:

(Maximum characters: 1200). You have characters left.