-
- 论斤烤 2020-09-16
面向过程之新增预处理
-
截图0赞 · 0采集
-
- 论斤烤 2020-09-16
面向过程之更新删除数据
-
截图0赞 · 0采集
-
- 碰磁王110 2019-05-16
//print_r(extension_loaded('mysqli'));
//预处理语句 -参数绑定
$mysqli = new mysqli('localhost','root','123456','shopsn');
if($mysqli->errno){
die('Connet Error'.$mysqli->error);
}
$sql = "Insert atext(username,password,age) value (?,?,?)";
//$sql = 'select * from atext where username = ? and password = ?';
$mysqli_stmt = $mysqli->prepare($sql);
$username = 'admin';
$password = md5(123456);
$age = 18;
// ssi 规定参数的数据类型，防止SQL注入
$mysqli_stmt->bind_param('ssi',$username,$password,$age);
if($mysqli_stmt->execute()){
echo $mysqli_stmt->insert_id;
//$mysqli_stmt->bind_result($id,$username,$age);
}else{
$mysqli_stmt->error;
}
$mysqli_stmt->free_result();
$mysqli_stmt->close();
$mysqli->close();
- 0赞 · 0采集
-
- 慕仰9559744 2018-05-08
mysqli_stmt_bind_param($stmt, "ssi",$user,$pass,$mail)
-
截图0赞 · 0采集
-
- 慕仰9559744 2018-05-08
mysqli_set_charset(); mysqli_prepare(); mysqli_stmt_bind_param(); mysqli_stmt_execute();
-
截图0赞 · 0采集
-
- Object_is_null 2017-11-13
- 4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 预处理语句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);
- 0赞 · 0采集
-
- 我可以ping 2017-07-29
- 更新删除
-
截图0赞 · 0采集
-
- heibaimeng 2016-12-02
- 预处理。。。
-
截图0赞 · 0采集
-
- 菲尔活该 2016-11-06
- 4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 预处理语句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);
- 0赞 · 0采集
-
- 流浪佳人纳入怀 2016-10-27
- 面向过程预处理完成插入截图2
-
截图0赞 · 0采集
-
- 流浪佳人纳入怀 2016-10-27
- 面向过程截图1；单条，多条sql语句执行
-
截图0赞 · 0采集
-
- 浮沉随浪 2016-03-07
- 4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 预处理语句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);
- 2赞 · 2采集
-
- 縌麟 2015-10-27
- 4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 预处理语句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);
- 1赞 · 1采集
-
- n4558899655 2015-07-15
- 法规
-
截图0赞 · 0采集
-
- 永远的零 2015-07-13
- 4. 更新 $sql=“UPDATE user SET age=age+10 WHERE id=12;”; $sql.=“DELETE FROM user WHERE id=13”; $res=$mysqli_multi_query($link,$sql); var_dump($res); echo ‘<hr/>’; 5. 预处理语句 $sql=“INSERT user(username,password,age) VALUES(?,?,?)”; $stmt=$mysqli_prepare($link,$sql); $username=“abc”; $password=“123”; $age=“12”; mysqli_stmt_bind_param($stmt, ‘ssi’, $username,$password,$age); mysqli_stmt_execute($stmt);
- 1赞 · 1采集
