468,550 Members | 2,086 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,550 developers. It's quick & easy.

bash script that generate PHP from SQL

hi..
as i write on the topic, i'm programing a Bash script using the
standard GNU Linux text utilities (gawk, grep, sed, and so on) that get
information from SQL source (table attib, type per column, constrains,
etc.) and finally generate PHP codification.

This is not a magic tool that makes whole site from SQL tables, but i
just want to make easy repetitive task. Almost every table on a
database has certain page asociatted, ex.:

from Company relation (table) we should, for sure, do:
(1) company-index.php // just links to other pages
(2) company-query.php // perform company data filter
(3) company-insert.php // insert a new company
(4) company-delete.php // delete
(5) company-browse.php // browse (all or filtered) brief companies data
(6) company-update.php // update
(7) company-detail.php // show every
(8) company-operation.php // SQL queries

This example could also be apply to Customers, Suppliers, and so on.
I just want to know if someone would like to join this project. It'd be
publicated under GNU/GPL license. Thoughts are welcome!!..

thanks in advance

Jul 17 '05 #1
1 1740
Gonzalo Aguirre wrote:
hi..
as i write on the topic, i'm programing a Bash script using the
standard GNU Linux text utilities (gawk, grep, sed, and so on) that get
information from SQL source (table attib, type per column, constrains,
etc.) and finally generate PHP codification.


ehh, why?

write the site in PHP, and just fetch the properties from the
database. Why are you wasting time writing script to generate scripts?

/Marcin
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Bernhard Kuemel | last post: by
5 posts views Thread by Phil Powell | last post: by
4 posts views Thread by Tom Purl | last post: by
11 posts views Thread by Magnus Jonneryd | last post: by
9 posts views Thread by Synapse Syndrome | last post: by
6 posts views Thread by Ishpeck | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.