数据库写操作

创建一张表：money

//1.创建PDO对象，连接数据库

$pdo = new PDO('mysql:host=127.0.0.1;dbname=web','root','root');

/* 添加数据

//2.创建sql语句

$sql = 'insert into `money` (`username`,`balance`,`province`,`age`,`sex`) values (:name,:balance,:province,:age,:sex)';

//3.验证sql语句，创建预处理对象

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

// var_dump($stmt);

//4.参数绑定

$name = '欧阳锋';

$balance = 234.44;

$province = '陕西';

$age = 50;

$sex = 1;

$stmt->bindParam(':name',$name,PDO::PARAM_STR,20);

$stmt->bindParam(':balance',$balance,PDO::PARAM_STR,20);

$stmt->bindParam(':province',$province,PDO::PARAM_STR,20);

$stmt->bindParam(':age',$age,PDO::PARAM_INT);

$stmt->bindParam(':sex',$sex,PDO::PARAM_INT);

//5.执行添加

//规范写法

if ($stmt->execute()){

echo ($stmt->rowCount()>0) ? '成功添加'.$stmt->rowCount().'条记录' : '没有记录被添加';

}else {

exit(print_r($stmt->errorInfo(),true));

}

*/

/*更新数据

//2.创建sql语句

$sql = 'update `money` set `balance`=:balance,`username`=:name where `user_id`=:user_id';

//3.验证sql语句，创建预处理对象

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

// var_dump($stmt);

//4.参数绑定

$id = 8;

$name = '黄药师';

$balance = 250.44;

$stmt->bindParam(':user_id',$id,PDO::PARAM_INT);

$stmt->bindParam(':balance',$balance,PDO::PARAM_STR,20);

$stmt->bindParam(':name',$name,PDO::PARAM_STR,20);

//5.执行添加

//规范写法

if ($stmt->execute()){

echo ($stmt->rowCount()>0) ? '成功更新'.$stmt->rowCount().'条记录' : '没有记录被更新';

}else {

exit(print_r($stmt->errorInfo(),true));

}

*/

/*删除数据

//2.创建sql语句

$sql = 'delete from `money` where `user_id`=:user_id';

//3.验证sql语句，创建预处理对象

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

// var_dump($stmt);

//4.参数绑定

$id = 8;

$stmt->bindParam(':user_id',$id,PDO::PARAM_INT);

//5.执行删除

//规范写法

if ($stmt->execute()){

echo ($stmt->rowCount()>0) ? '成功删除'.$stmt->rowCount().'条记录' : '没有记录被删除';

}else {

exit(print_r($stmt->errorInfo(),true));

}

*/