NDSU CS Department Wiki

User Tools

Site Tools

Trace:
classes:general:dbsamples:perl_mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
classes:general:dbsamples:perl_mysql [2020/10/23 17:55] – localadminclasses:general:dbsamples:perl_mysql [2021/09/17 17:27] (current) – localadmin
Line 1: Line 1:
 +====== Perl example for MySQL database connection ======
 +
 <code> <code>
 use strict; use strict;
Line 17: Line 19:
 $db_conn_string = "dbi:mysql:$db_name:$db_host:$db_port"; $db_conn_string = "dbi:mysql:$db_name:$db_host:$db_port";
  
-# Connect to db on Hrothgar+# Connect to db 
 if ($conn = DBI->connect($db_conn_string, $db_user, $db_pwd)) if ($conn = DBI->connect($db_conn_string, $db_user, $db_pwd))
 { {
Line 26: Line 28:
   $stmt->execute;   $stmt->execute;
  
-  # retrieve the results+  # Retrieve the results
  
   print "Query Output \n";   print "Query Output \n";
Line 36: Line 38:
 else else
 { {
-  # Couldn't connect to MySQL db+  # Error! Couldn't connect to MySQL db
 } }
 </code> </code>
classes/general/dbsamples/perl_mysql.1603493745.txt.gz · Last modified: 2020/10/23 17:55 by localadmin