环境
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