php 查询多个值,PHP-替换SQL查询中的多个值？

我想使用用户在字段中的输入来搜索数据.也就是说,如果用户输入“ D t y g,k,j,h”,则要搜索具有字母“ d和t和y和g或k或j或h”的值.我尝试了PHP str_replace函数,但不喜欢结果.

//kw is text field...

if($kw != "") {

//here we check for some data in field; if yes, continue below

//c is for ',' replaced in JavaScript

$kw1 = str_replace("c"," OR bcm.keywords LIKE '$kw%' ",$kw);

//p is for '+' replaced in JavaScript//'bcm' is table name.

$kw3 = str_replace("p"," AND bcm.keywords LIKE '$kw%' ",$kw1);

//for appending into main query string

$app.=$kw3;

//$app.=" AND bcm.keywords LIKE '$kw%'";

}

…但是对于输入“ D t y g,k,j,h”,查询如下所示：

AND bcm.keywords LIKE 'Dptpypgckcjch%' t

AND bcm.keywords LIKE 'Dptpypgckcjch%' y

AND bcm.keywords LIKE 'Dptpypgckcjch%' g

OR bcm.keywords LIKE 'D

AND bcm.keywords LIKE 'Dptpypgckcjch%' t

AND bcm.keywords LIKE 'Dptpypgckcjch%' y

AND bcm.keywords LIKE 'Dptpypgckcjch%' gckcjch%' k

OR bcm.keywords LIKE 'D

AND bcm.keywords LIKE 'Dptpypgckcjch%' t

AND bcm.keywords LIKE 'Dptpypgckcjch%' y

AND bcm.keywords LIKE 'Dptpypgckcjch%' gckcjch%' j

OR bcm.keywords LIKE 'D

AND bcm.keywords LIKE 'Dptpypgckcjch%' t

AND bcm.keywords LIKE 'Dptpypgckcjch%' y

AND bcm.keywords LIKE 'Dptpypgckcjch%' gckcjch%' h**

…当我想要/需要的是：

AND bcm.keywords LIKE 'D%'

AND bcm.keywords LIKE 't%'

AND bcm.keywords LIKE 'y%'

AND bcm.keywords LIKE 'g%'

OR bcm.keywords LIKE 'k%'

OR bcm.keywords LIKE 'j%'

OR bcm.keywords LIKE 'h%'

解决方法:

JavaScript解决方案

var getSearchSql = function(kw)

{

if(kw != "")

{

var ors = kw.split(",");

var sql = "";

var sqlVariable = "bcm.keywords";

for(i = 0; i < ors.length; i++)

{

var ands = ors[i].split("+");

sql += (i == 0)? "(": " OR (";

for(j = 0; j < ands.length; j++)

{

sql += (j == 0)? "": " AND ";

sql += sqlVariable + " LIKE '%" + ands[j] + "%' "

}

sql += ")"

}

}

return sql;

}

产生以下结果(当kw =“ D t y g,k,j,h”时)

(bcm.keywords LIKE '%D%'

AND bcm.keywords LIKE '%t%'

AND bcm.keywords LIKE '%y%'

AND bcm.keywords LIKE '%g%')

OR (bcm.keywords LIKE '%k%')

OR (bcm.keywords LIKE '%j%')

OR (bcm.keywords LIKE '%h%')

标签：string,javascript,sql,php

来源： https://codeday.me/bug/20191210/2101225.html