pdo处理PHP

2019独角兽企业重金招聘Python工程师标准>>>

 $dbh = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'root', 'root');
$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (:name, :value)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':value', $value);
// 插入一行

$name = 'one';
$value = 1;
$stmt->execute();
$name = 'two';
$value = 2;
$stmt->execute();

//查询
$name = "one";
$value = "1";
$stmt = $dbh->prepare("SELECT * FROM REGISTRY WHERE name=:name AND value=:value");
$stmt->execute(array(':name' => $name, ':value' => $value));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
//print_r($rows);
$_GET['name'] = 'two';
$stmt = $dbh->prepare("SELECT * FROM REGISTRY where name = ?");
    if ($stmt->execute(array($_GET['name']))) {
        while ($row = $stmt->fetch()) {
       // print_r($row);
    }
}

//删除
$name = "two";
$stmt = $dbh->prepare("DELETE FROM REGISTRY WHERE name=:name");
$stmt->bindValue(':name', $name, PDO::PARAM_STR);
$stmt->execute();
$affected_rows = $stmt->rowCount();
var_dump($affected_rows); //删除条数

//修改

$name = "two";
$value = 'new';
$stmt = $dbh->prepare("UPDATE REGISTRY SET value=:value WHERE name=:name");
$stmt->bindValue(':name', $name);
$stmt->bindValue(':value', $value);
$stmt->execute();
$affected_rows = $stmt->rowCount();
var_dump($affected_rows); //删除条数

 

表结构  CREATE TABLE `registry` (
  `name` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

转载于:https://my.oschina.net/hongjiang/blog/1552069