mysql pdo查询语句,PHP PDO准备语句 – mysql LIKE查询

这是我的第一篇文章Overflow，但我发现现有的知识体系非常有帮助。无论如何，这里是我的问题：

我试图做一个搜索通过php的PDO类(mysql驱动程序)。我有以下查询使用mysql客户端(表名改为保护无辜)：

SELECT hs.hs_pk,

hs.hs_text,

hs.hs_did,

hd.hd_did,

hd.hd_text,

hv.hv_text,

hc.hc_text

FROM hs

LEFT JOIN hd

ON hs.hs_did = hd.hd_did

LEFT JOIN hd

ON hd.hd_vid = hv.hv_id

LEFT JOIN hc

ON hd.hd_pclass = hc.hc_id

WHERE hs.hs_text LIKE "%searchTerm%"

LIMIT 25;

无论我使用的搜索字词，这都像一个魅力。但是，当我搬到php，我不能让它返回任何东西。我试过几种不同的语法，似乎合乎逻辑的工作，但没有我试过的工作。这里是我现有的代码：

$handle = fopen('/foo/bar/test.log', 'w+');

fwrite($handle, "doSearch, with search term: $searchTerm\n");

$sql =

'SELECT hs.hs_pk,

hs.hs_text,

hs.hs_did,

hd.hd_did,

hd.hd_text,

hv.hv_text,

hc.hc_text

FROM hs

LEFT JOIN hd

ON hs.hs_did = hd.hd_did

LEFT JOIN hd

ON hd.hd_vid = hv.hv_id

LEFT JOIN hc

ON hd.hd_pclass = hc.hc_id

WHERE hs.hs_text LIKE :searchTerm

LIMIT 25';

try {

$dbh = new PDO('mysql:host=localhost;dbname=awdb', "user", "password");

fwrite($handle, "connected to DB\n");

$prep = $dbh->prepare($sql);

$ret = $prep->execute(array(':searchTerm' => '"%'.$searchTerm.'%"'));

while ($row = $prep->fetch(PDO::FETCH_ASSOC)) {

$i++;

$result[$i]['subText'] = $row['hs_pk'];

$result[$i]['subText'] = $row['hs_text'];

$result[$i]['subDid'] = $row['hs_did'];

$result[$i]['devDid'] = $row['hd_did'];

$result[$i]['devText'] = $row['hd_text'];

$result[$i]['vendorText'] = $row['hv_text'];

$result[$i]['classText'] = $row['hc_text'];

}

$dbh = null;

}

catch (PDOException $e) {

print "Error!: " . $e->getMessage() . "
";

die();

}

我也试过以下(SQL WHERE子句和amp; prep->执行行都是改变)：

WHERE hs.hs_text LIKE CONCAT(\'%\', ?, \'%\')

$ret = $prep->execute(array($searchTerm));

WHERE hs.hs_text LIKE "%:searchTerm%"

$ret = $prep->execute(array(':searchTerm' => $searchTerm));

WHERE hs.hs_text LIKE ":searchTerm"

$ret = $prep->execute(array(':searchTerm' => '%'.$searchTerm.'%'));

等等…

谢谢提前，我希望代码不太太草率

– 时间