How to connect MySQL from Perl script

priyan · #1 (**permalink**) 07-12-2007, 06:34 AM

Hi techies,

Can someone explain me about the Perl -> Mysql database connection details ?

raj · #2 (**permalink**) 07-12-2007, 07:16 AM

hi..

see this link..

http://blob.perl.org/books/beginning...145_Chap13.pdf

Gopisoft · #3 (**permalink**) 07-12-2007, 10:26 PM

Hi,

Use perl script to access the MySQL Database. See below for a sample perl script that connects to a MySQL database, runs a query, and then disconnects:

#!/usr/bin/perl
print "Content-type: text/html \n\n";
use DBI;

# Connect To Database
$database = "your database name";
$username = "your database username";
$password = "your database password";
$hostname = "mysqlhost";
$db = DBI->connect("DBI:mysql:$database:$hostname", $username, $password);

# Execute a Query
$query = $db->prepare("SELECT * FROM test");
$query->execute;

# How many rows in result?
$numrows = $query->rows;

# Display Results
while (@array = $query->fetchrow_array) {
($field1, $field2, $field3) = @array;
print "field1 = $field1, field2 = $field2, field3 = $field3 ";
}

# Cleaning Up
$query->finish;
$db->disconnect;
exit(0);

NOTE: The mysql password should be no more than 8 alpha-numeric characters. To identify the database username, password and dbid.

-R.Gopi

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ERROR 2002 (HY000): Can't connect to local MySQL server through socket	Gopisoft	Database Support	1	10-29-2007 03:07 AM
How to connect FTP Server using Perl?	raj	Perl	1	07-20-2007 03:45 AM
How to set Perl Interpreter within perl script	sivaramakrishnan	Perl	1	07-19-2007 06:45 AM
problem when connect mysql for php	Jeyaseelansarc	PHP Programming	1	05-20-2007 10:39 PM
My Favorite Perl Script	theseokit	Perl	2	03-24-2007 12:20 AM