PHP PDO 增删查改，表锁，返回新增ID

环境

IIS7.5

PHP5.4

MYSQL5.5.34

<?php
//构造PDO连接
$dbh = "mysql:host=localhost;dbname=rws";
$db = new PDO($dbh, 'root', '123');
$db->query("set character set 'UTF8'");




//表加锁
$sth=$db->exec("LOCK TABLE 2017_06_nnfp WRITE");


//查询数据
$sql = "SELECT * FROM 2017_06_nnfp";
$sth = $db->query($sql);
while($row = $sth->fetch()){
    echo "openid:".$row['openid']."<br />";
    echo "奖品:".$row['prizename']."<br />";
    echo "日期:".$row['day']."<br />";
}


//修改
$sql="update 2017_06_nnfp_prize set dx50m=10 where id = 1";
$sth=$db->exec($sql);




//删除
$sql