This article illustrates the method of Php+mysqli database query using preprocessing technology. Share to everyone for your reference. Specifically as follows:
The code has some difficulty, needs the basic knowledge to be able to understand better, the code first puts up:
This implements the query for all id>5 id,title,contents values:
Copy Code code as follows:
<?php
$mysqli = new Mysqli ("localhost", "root", "123456", "Liuyan");
if (! $mysqli) {
Die ($mysqli->error);
}
Create a predefined 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 Sets
$mysqli _stmt->bind_result ($id, $title, $contents);
Perform
$mysqli _stmt->execute ();
To remove a 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 will help you with your PHP program design.