TPoly
asked on
CGI
i want to be able to view certain data from the database and though of using CGI to display it.
can Perl CGI be used to extract data from database? (50 pts)
If so, can anyone show me? the steps perhaps (will add on pts)
thanks
can Perl CGI be used to extract data from database? (50 pts)
If so, can anyone show me? the steps perhaps (will add on pts)
thanks
ASKER
ok thanks..
I'm using Mysql.
Sample SQL statement: select job from test where job = "abc";
Is this what you mean by sample SQL statement?
I'm using Mysql.
Sample SQL statement: select job from test where job = "abc";
Is this what you mean by sample SQL statement?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what database product(s) are you using?
do you have a sample SQL statement that produces the data you want displayed?
In addition to the CGI module, you'll most likely end up with the DBI module and one of the DBD driver modules.
=============
Some databases have native web interfaces that work out-of-the-box for simple stuff and can be customized to do less simple stuff. Sometimes it's better to use Perl, sometimes it's better to embrace the product.