Home  >  Article  >  pdo update operation in php

pdo update operation in php

无忌哥哥
无忌哥哥Original
2018-06-28 13:59:354630browse

* Preprocess update data

//1. Connect to the database and create the pdo object

try {
$pdo = new PDO('mysql:dbname=php','root','root');
} catch (PDOException $e) {
    exit($e->getMessage());
}

//2. Prepare the sql statement

$sql = "UPDATE user SET email=:email WHERE user_id=:user_id";

//3. Create Preprocessing object stmt object

if($stmt = $pdo->prepare($sql)) {

//4. Bind parameters to stmt object and execute

//Prepare parameters

$param = ['email'=>'lwt@qq.com','user_id'=>5];
    //绑定参数到SQL语句对象并执行
    if ($stmt -> execute($param)){
        //rowCount()返回更新的数量,如果大于0表示有记录被更新啦
        if ($stmt->rowCount()>0) {
            echo '成功更新了'.$stmt->rowCount().'条记录';
        } else {  //等于0表示没有记录被更新
            echo '没有记录被更新';
        }
    } else { //执行失败的信息
        print_r($stmt->errorInfo());
        exit();
    }
} else {  //$stmt语句对象创建失败
  print_r($pdo->errorInfo());
  exit();
}
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn