lastInsertId()
<?php header('content-type:text/html; charset=utf-8'); //实例化pdo对象 $pdo = new PDO('mysql:host=127.0.0.1;port=3306;dbname=test;', 'root', '888888'); //通过query函数执行sql命令 $pdo->query('set names utf8'); //插入数据 $sql = "insert into persons (name,age) values (?, ?);"; $preObj = $pdo->prepare($sql); $res = $preObj->execute(array('小明', 22)); $lastInsertId = $pdo->lastInsertId(); echo "刚刚插入数据的id为 {$lastInsertId}";
rowCount()
<?php header('content-type:text/html; charset=utf-8'); //实例化pdo对象 $pdo = new PDO('mysql:host=127.0.0.1;port=3306;dbname=test;', 'root', '888888'); //通过query函数执行sql命令 $pdo->query('set names utf8'); //删除数据 $sql = "delete from persons where id = ?"; $preObj = $pdo->prepare($sql); $res = $preObj->execute(array(16)); $rowCount = $preObj->rowCount(); echo "受到影响的数据条目 : {$rowCount}";