Home > headlines > pdo update operation in php

pdo update operation in php

无忌哥哥
Release: 2018-06-28 13:59:35
Original
4645 people have browsed it

* 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());
}
Copy after login

//2. Prepare the sql statement

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

//3. Create Preprocessing object stmt object

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

//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();
}
Copy after login
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template