php pdo 实现搜索功能,php – 使用LIKE的PDO搜索数据库

从占位符中删除引号,并在绑定引用之前添加冒号：

$query = $connDB->prepare('SELECT * FROM topic WHERE topic_name LIKE :keywords');

$query->bindValue(':keywords', '%' . $searchQ . '%');

这是我的文字示例：

SQL

CREATE TABLE IF NOT EXISTS `items` (

`id` mediumint(9) NOT NULL auto_increment,

`name` varchar(30) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `items` (`id`, `name`) VALUES

(1, 'apple'),

(2, 'orange'),

(3, 'grape'),

(4, 'carrot'),

(5, 'brick');

PHP

$keyword='ap';

$sql="SELECT * FROM `items` WHERE `name` LIKE :keyword;";

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

$q->bindValue(':keyword','%'.$keyword.'%');

$q->execute();

while ($r=$q->fetch(PDO::FETCH_ASSOC)) {

echo"

".print_r($r,true)."

";

}

产量

Array

(

[id] => 1

[name] => apple

)

Array

(

[id] => 3

[name] => grape

)