<?php
$pdo = new \PDO('mysql:host=localhost;dbname=guest;port=3306', 'guest', 'p6yhG8iDRMNxdJ9w');
// 第一种绑定方式
$param1 = "bfw";
$sql1 = "select * from User where username like ?";
$stmt1 = $pdo->prepare($sql1);
if ($stmt1->execute([
"%$param1%",
])) {
$res1 = $stmt1->fetchAll(\PDO::FETCH_ASSOC);
print_r($res1);
}
//第二种绑定方法
$sql1 = 'SELECT * FROM User WHERE username LIKE :username';
$stmt = $pdo->prepare($sql1);
$stmt->bindValue(':username','%'.$param1.'%');
$stmt->execute();
$rows = $stmt->fetchAll();
print_r($rows);
// IN 查询预处理
$param2 = [2,3,4];
$prepare = rtrim( str_pad('?', 2 * count($param2), ',?') , ',');
$sql2 = "select * from User where id in($prepare)";
$stmt2 = $pdo->prepare($sql2);
if ($stmt2->execute($param2)) {
$res2 = $stmt2->fetchAll(\PDO::FETCH_ASSOC);
print_r($res2);
}
网友回复
gpt-image2能直接将图片转成分层透明的psd设计文件?
claude code、codex、gemini cli如何切换国内大模型使用?
蒸馏最强ai大模型是中小ai模型低成本升级的最好通道?
arena.ai上为啥没有最新的claude4.7及gpt5.5呢?
ai大模型公司为啥开始大量招聘文科生了?
cloudflared如何在低版本centos6或7上安装?
bfwsoa框架如何开启异步缓存与异步任务模式?
selenium如何获取网页js加载渲染后的真实dom结构?
go编写的Eino与python编写的langchain如何选择?
LangChain如何编写多个agent协同工作的代码?


