楼主:
rjackie (向前走，才知道转角)
2017-01-21 03:07:25各位先进 小弟有一事想要请教各位大大
因目前专案有一功能是需要LIKE多组字串，以下程式
$p_search = explode(" ",$p_search_name);
$product_info_sql = $db->prepare("SELECT no FROM product_info
where name LIKE '%".$p_search_name."%' ");
foreach($p_search as $k){
$product_info_sql = $db->prepare( " OR name LIKE '%$k%' ");
}
$product_info_sql = $db->prepare(" AND status = ? order by sequence
DESC limit " . $startRow_records . ",$pageRow_records");
$product_info_sql->execute(array('1'));
主要是判断有几组字串(关键字)，产生多组OR name LIKE
但是PDO好像不能这样用，还想请大大们解惑
万分感谢