Using a Placeholder : select « Database « Perl






  1. Perl
  2. Database
  3. select

Using a Placeholder

   

use DBI;
my $driver="DBI:mysql";
my $database="sample_db";
my $user="root";
my $host="localhost";

my $dbh = DBI->connect("$driver:$database:$host;user=$user;
password=quigley1")or die "Can't connect: ". DBI->errstr;
my $sth=$dbh->prepare("SELECT name FROM Employee WHERE name = ?") or die "Can't prepare sql statement" . DBI->errstr;

$name="Tom";
$sth->execute($name);
print "Selected data for team \"$name\".\n\n";

while(my @val = $sth->fetchrow_array()){
      print "name=$val[0]\n";
}
$sth->finish();
$dbh->disconnect();








Related examples in the same category

1.Select, Execute, and Dump the Results
2.Select, Execute, and Fetch a Row as a Hash
3.Select, Execute, and Fetch a Row as an Array
4.Simple query
5.The First SQL Query
6.Creating a Web Page Integrated with SQL Data
7.Creating an HTML Table