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="delete from 2017_06_nnfp where id=74";$sth=$db->exec($sql);//新增$sql="insert into 2017_06_nnfp (openid,prize,prizename) values ('q123456789','3','手机')";$sth=$db->exec($sql);//返回最后增加的IDecho $db->lastInsertId()  //表解锁$sth=$db->exec("UNLOCK TABLE");$db = null;?>