Programming Forums - View Single Post

Infinite Recursion · Dec 2nd, 2005, 10:11 AM

I'm oldschool... so I like Perl moreso than Python... although Python is very nice also. If this is going to be a web app, I suggest PHP.

Example of connecting to MySQL via Perl:

(Toggle Plain Text)

#!/usr/bin/perl
 
use DBI;
 
$dbh = DBI->connect('dbi:mysql:DBNAME','USERID','PWD');
 
$sql = "select * from TABLENAME";
 
$sth = $dbh->prepare($sql);
 
$sth->execute ||
die "Could not execute SQL statement ... maybe invalid?";

Dec 2nd, 2005, 10:11 AM	#7
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	I'm oldschool... so I like Perl moreso than Python... although Python is very nice also. If this is going to be a web app, I suggest PHP. Example of connecting to MySQL via Perl: (Toggle Plain Text) #!/usr/bin/perl use DBI; $dbh = DBI->connect('dbi:mysql:DBNAME','USERID','PWD'); $sql = "select * from TABLENAME"; $sth = $dbh->prepare($sql); $sth->execute \|\| die "Could not execute SQL statement ... maybe invalid?"; #!/usr/bin/perl use DBI; $dbh = DBI->connect('dbi:mysql:DBNAME','USERID','PWD'); $sql = "select * from TABLENAME"; $sth = $dbh->prepare($sql); $sth->execute \|\| die "Could not execute SQL statement ... maybe invalid?"; __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."