+
95
-

php pdo 执行 like sql查询代码怎么写?

请问php pdo 执行 like sql查询代码怎么写?

网友回复

+
15
-
<?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...

点击查看剩余70%

我知道答案,我要回答