lastinsertid mysql_pdo对象的常用方法 lastInsertId(),rowCount()

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}";