Query parameter binding : MySql « Database « Perl






  1. Perl
  2. Database
  3. MySql

Query parameter binding

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

my $dbh = DBI->connect("$driver:$database:$host","$user","$password") or die "Can't connect: " . DBI->errstr;

$sth=$dbh->prepare("SELECT name FROM Employee where name LIKE ?") or die "Can't prepare sql statement" .
DBI->errstr;

$sth->bind_param(1, "Ch%");
$sth->execute();
$sth->dump_results();
$sth->finish();
$dbh->disconnect();








Related examples in the same category

1.Deleting Entries
2.Dumping a Query's Results
3.Error Diagnostic Variables
4.Handling Quotes
5.Inserting into a Database
6.Load text file to database
7.MySQL Data Types
8.Preparing a Statement Handle and Fetching Results
9.Pushing Query Results to an Array to Find Wildcard Hosts
10.Retrieving Query Results Listing MySQL Users and Hosts
11.Retrieving an Index ID