PHP学习 mysqli 预处理更新

<?php
$mysqli=new mysqli("localhost", "root", "123456", "xsphpdb");






//准备好一条语句放到服务器中，插入语句
$sql="update shops set name=?, price=?, num=?, desn=? where id=?";


$stmt=$mysqli->prepare($sql);


//给占位符号每个?号传值（绑定参数） i  d  s  b  表示int double string
$stmt->bind_param("sdisi", $name, $price, $num, $desn,$id);


$name="zhangsan1";
$price=56.781;
$num=661;
$desn="hello good1";
$id=100;


//执行
$stmt->execute();




$name="lisi1";
$price=56.781;
$num=661;
$desn="aaaaaaaa1";
$id=101;
//执行
$stmt->execute();




$name="wangwu1";
$price=56.781;
$num=961;
$desn="bbbbbbbbb1";
$id=102;
//执行
$stmt->execute();




$name="zhaoliu111";
$price=56.7811;
$num=6118;
$desn="cccccccccccc111";
$id=103;



//执行
$stmt->execute();


echo "最后ID".$stmt->insert_id."<br>";
echo "影响了".$stmt->affected_rows."行<br>";


$stmt->close();