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
TPolyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jmcgConnect With a Mentor OwnerCommented:
Here a couple of older questions that contain examples of retrieving data from a MySQL database and formatting the results as an HTML table. I'm not sure selecting from one column is going to get you an interesting table, but if you take a look at these examples, I'm sure you can adapt them to do what you want.

http:Q_20995819.html

http:Q_20873609.html

The experts who contributed those answers are still active here and you should be able to get answers to any further questions you have.
0
 
jmcgOwnerCommented:
Yes, it can. There are several experts here who will be glad to help you but for an example to be more useful to you, it would help to know some specifics:

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.
0
 
TPolyAuthor Commented:
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?

0
All Courses

From novice to tech pro — start learning today.