Non-SELECT statement (with no result set)
1. Establishing a Connection database
$mysqli =new mysqli ("localhost", "root", "" "," sqldb ");
2. Judging
if (Mysqli_connect_error ()) {
echo "Failed to connect to database". Mysqli_connect_error ();
Exit
}
3.SQL Statement Assembly
$sql = "INSERT into shops (name,price,description) VALUES (?,?,?,?)";
$sql = "Update shops set name=?,price=?,num=?,description=?; where id=? ";
4. Inserting SQL statements
$stmt = $mysqli->prepare ($sql);//More convenient
5. Send a value for each symbol (binding parameter)
$stmt->bind_param ("Sdisi", $name, $price, $num, $description, $id);
6. Transfer value
$name = "Zhangsan";
$price = 22.22;
$num = 10;
$description = "very good";
$id = 10;
7. Implementation
$stmt->execute ();
Number of rows affected: $stmt->insert_id;
Last inserted ID: $stmt->offected_rows;
$mysqli[Email protected]NewMysqli ("localhost", "root", "" "," Sqldb "); if(Mysqli_connect_error()){ Echo"Connection Database Error".$mysqli _connect_error (); } /*Assemble Data*/ $sql= "INSERT into shop values (null,?,?,?)"; $sql= "Update shop set name=?,price=?,description=?" where id=? "; /*Inserting Data*/ $stmt=$mysqli->prepare ($sql); /*binding Data*/ $stmt->bind_param ("Sdsi",$name,$price,$description,$id); /*Assign Value*/ $name= "ZHANGSANASDFADFASDFASDF"; $price=2.3; $description= "Very good"; $id=1; /*Execution*/ $stmt->execute ();
SELECT statement (with result set)
1. Connect to the database
$mysqli =new mysqli ("localhost", "root", "" "," sqldb ");
2. Judging the database
if (Mysqli_connect_error ()) {
echo "Error:". Mysqli_connect_error ();
}
3. Splicing the database
$sql = "Select Id,name,price,description where id=?";
4. Inserting a database
$stmt = $myqli->prepare ($sql);
5. Binding the Database
$stmt->bind_param (i, $id);
6. Binding result Set
$stmt->bind_result ($id, $name, $price, $description);
7. Assigning values
$id = 10;
8. Implementation
$stmt->execute ();
9. Remove the result set
$stmt->store_result ();
10.while Viewing results
while ($stmt->fetch ()) {
echo "$id---$name---$price-$description";
}
11. Close the result set
$stmt->free_result ();
12. Close the database
$stmt->close ();
<?PHP$mysqli= @NewMysqli ("localhost", "root", "" "," Sqldb "); if(Mysqli_connect_error()){ Echo"Error:".Mysqli_connect_error(); } /*Assemble SQL*/ $sql= "Select Id,name,price,description from shop where id<?"; /*Insert*/ $stmt=$mysqli->prepare ($sql); Var_dump($stmt); /*binding*/ $stmt->bind_param (I,$id); /*binding result Set*/ $stmt->bind_result ($id,$name,$price,$description); /*Assign Value*/ $id=10; /*Execution*/ $stmt-execute (); /*Remove result set*/ $stmt-Store_result (); Echo"<table border= ' 1 ' >"; //field information, column information $result=$stmt-Result_metadata (); Echo"<tr>"; while($field=$result-Fetch_field ()) { Echo"<th>{$field->name}</th> "; } Echo"</tr>"; /*fetch () View result set*/ /*Move Database Pointers*/ //$stmt->data_seek (2); while($stmt-Fetch ()) { Echo"<tr>"; Echo"<td>$id</td><td>$name</td><td>$price</td><td>$description</td> "; Echo"</tr>"; } Echo"</table>"; /*Close Result set*/ $stmt-Free_result (); /*Close Database D*/ $stmt-close ();?>