一.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 连接数据库 预处理
标签:预处理roopdobspampfetchescnewout
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:/nice/p/10499620.html
如果觉得《php pdo总结 php 总结(10) PDO 连接数据库 预处理》对你有帮助,请点赞、收藏,并留下你的观点哦!