在bindParam中使用LIKE进行MySQL PDO查询 [英] Using LIKE in bindParam for a MySQL PDO Query

问题描述

我已经阅读了关于如何编写这些查询的多个示例，但是我很难在使用 bindParam

I've read multiple examples on how these queries should be written but I'm struggling to get this specific like to run when using bindParam

这是与以？开头的用户名匹配的正确方法。

Would this be the correct way to match usernames that begin with a?

$term = "a";
$term = "'$term%'";

$sql = "SELECT username 
        FROM `user` 
        WHERE username LIKE :term 
        LIMIT 10";      

$core = Connect::getInstance();

$stmt = $core->dbh->prepare($sql);
$stmt->bindParam(':term', $term, PDO::PARAM_STR);
$stmt->execute();
$data = $stmt->fetchAll();

推荐答案

不，你不需要内部单引号所以只要 $ term =$ term％;

No, you don't need the inner single quotes so just $term = "$term%";

'a％'而不是 a％

bindParam将确保所有字符串数据在给定SQL语句时自动正确引用。

bindParam will make sure that all string data is automatically properly quoted when given to the SQL statement.

这篇关于在bindParam中使用LIKE进行MySQL PDO查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！