Connecting Tech Pros Worldwide Help | Site Map

bash script that generate PHP from SQL

 
LinkBack Thread Tools Search this Thread
  #1  
Old July 17th, 2005, 11:27 AM
Gonzalo Aguirre
Guest
 
Posts: n/a
Default 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


  #2  
Old July 17th, 2005, 11:30 AM
Marcin Dobrucki
Guest
 
Posts: n/a
Default 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
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.