Php+mysqli method of database query using preprocessing technology, mysqli preprocessing _php tutorial

Php+mysqli the method of database query using preprocessing technology, MYSQLI preprocessing

In this paper, we describe the method of php+mysqli using preprocessing technology to query database. Share to everyone for your reference. Specific as follows:

Code is a bit difficult, need basic knowledge more solid to understand, code first put up:

This implements the Id,title,contents value for querying all id>5:
Copy the Code code as follows: <?php
$mysqli = new Mysqli ("localhost", "root", "123456", "Liuyan");
if (! $mysqli) {
Die ($mysqli->error);
}
Create a pre-defined object? placeholder
$sql = "Select Id,title,contents from News where Id>?";
$mysqli _stmt = $mysqli->prepare ($sql);
$id = 10;
Binding parameters
$mysqli _stmt->bind_param ("i", $id);
Binding result Set
$mysqli _stmt->bind_result ($id, $title, $contents);
Perform
$mysqli _stmt->execute ();
Take out the bound result set
while ($mysqli _stmt->fetch ()) {
echo "--$id--$title--$contents--";
}
Close result set
$mysqli _stmt->free_result ();
$mysqli _stmt->close ();
$mysqli->close ();
?>

I hope this article is helpful to everyone's PHP programming.

http://www.bkjia.com/PHPjc/949460.html www.bkjia.com true http://www.bkjia.com/PHPjc/949460.html techarticle Php+mysqli The method of database query using preprocessing technology, mysqli the method of Php+mysqli using preprocessing technology to query database is described in this paper. To share with you ...

