连接数据库,创建pdo对象 $pdo

原创 2018-12-27 19:48:44 675
摘要:<?php//1.连接数据库$pdo = new PDO('mysql:dbname=php_edu','root','root');//2.创建SQL语句$sql = "DELETE FROM `user` WHERE `id`=:id";$stmt = $pdo->prepare($sql);$id = 2;$st

<?php

//1.连接数据库

$pdo = new PDO('mysql:dbname=php_edu','root','root');

//2.创建SQL语句

$sql = "DELETE FROM `user` WHERE `id`=:id";

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

$id = 2;

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

if ($stmt->execute()) {

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

} else {

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

}


批改老师:韦小宝批改时间:2018-12-28 09:24:43
老师总结:pdo连接数据库还是非常常用的,特别是在实际的开发中!这点一定要掌握

发布手记

热门词条