Connecting Tech Pros Worldwide Help | Site Map

bash script that generate PHP from SQL

  #1  
Old July 17th, 2005, 12:27 PM
Gonzalo Aguirre
Guest
 
Posts: n/a
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

  #2  
Old July 17th, 2005, 12:30 PM
Marcin Dobrucki
Guest
 
Posts: n/a

re: bash script that generate PHP from SQL


Gonzalo Aguirre wrote:[color=blue]
> 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.[/color]

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
Closed Thread