Keep It Simple, Stupid | |
PerlMonks |
Re: my first databaseby rdfield (Priest) |
on Feb 13, 2003 at 14:32 UTC ( [id://234987]=note: print w/replies, xml ) | Need Help?? |
To be honest, this looks like a random selection of lines from the CGI and DBI pods :) First up, SHOW TABLES isn't an SQL statement, so don't use that: something like $dbh->table_info is more like it. Second up, you issue a disconnect to your database before you try to prepare your "SQL". There's no chance of that working at all - if you add or die $dbh->errstr after prepare and execute statements you might get some better information (you are checking the webserver log file?) Third up, you're issuing an end_html command and then printing some more lines (spaced with tabs - which a browser wouldn't honour anyway). Fourth up, even if you move the end_html after the db related prints, it's going to print them out whether or not the submit is pressed - you need something like if (defined($cgi->param('submit')) {print ...} in there somewhere. I suspect that you're in for a steep learning curve - have a look in Tutorials: there are several well written articles on the DBI and CGI topics. rdfield
In Section
Seekers of Perl Wisdom
|
|