Share on Google+Share on Google+

PHP MySQLI Prep Statement

Advertisement
In the current tutorial we will study how to create prepared statement in mysql and how to retrieve values using mysqli::prepare, mysqli::prepare - Prepares a SQL query and returns a statement handle to be used for further operations on the statement. The query should consist of a single sql query.

PHP-MySQLI:Prepared-Statement

mysqli::prepare - Prepares a SQL query and returns a statement handle to be used for further operations on the statement. The query should consist of a single sql query.

There are two styles are available in this current statement:

  1. Object oriented style
  2. Procedural style

In the following example we use Object Oriented Style. The format of this style is:

mysqli_stmt mysqli::prepare (string $query)

Table is as follows:

city_id city_name
1 new delhi
2 kolkata
3 mumbai
4 chennai
5 ahmedabad
6 ajmer

PHP Mysqli Prepares Example:

<?php

$mysqli=new mysqli("localhost","root","","ajax");

if(mysqli_connect_errno()){

printf("connection failed:%f\n", mysql_connect_error());

exit();}

$city="ahmedabad";

if($stmt=$mysqli->prepare("select city_id from city where city_name=?")){

$stmt->bind_param("s",$city);

$stmt->execute();

$stmt->bind_result($cityid);

$stmt->fetch();

printf("%s",$cityid);

$stmt->close();}

$mysqli->close();

?>

 

Output:

5

Advertisements

Advertisement

Posted on: February 17, 2010 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.