php pdo总结,php 总结（10） PDO 连接数据库 预处理

一.PDO 增删改查

连接    $pdo= New PDO (‘mysql:host=localhost;dbname=houtaiablyycnbak‘,‘root‘,‘Aa122‘ );

接下来增删改查

$sql = "select * from patient_13 where age between 20 and 30 && sex =‘女‘ order by age desc";

$sq="insert into patient_13(age,name,sex) Values(33,‘张小姐酒‘,‘女‘)";

$sql="delete from patient_13 where name=‘彭昌雲‘";

$sql="update patient_13 set name = ‘李值‘where name=‘李亚飞‘";

执行语句

$a=$pdo->exec($sql);

查询语句

$smt = $pdo -> query($sql);

$arr = $smt -> fetchAll(pdo::FETCH_ASSOC);

foreach ($arr as $arrs) {

echo ‘

‘;

echo "

{$arrs[‘age‘]} ";

echo "

{$arrs[‘name‘]}";

echo "

{$arrs[‘sex‘] }";

echo "
";

echo "

";

}

php 总结(10) PDO 连接数据库 预处理

标签：预处理   roo   pdo   bsp   amp   fetch   esc   new   out

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/nice2018/p/10499620.html