php select中的变量赋值,PHP和MYSQL：我如何忽略select中的空变量

好吧，有manu方法这样做，但我找到的最短的方法是创建一个以下形式的数组

$vars = array(

(isset($_GET["var1"]))? " keyword = '". $_GET["var1"] ."' ": null,

(isset($_GET["var2"]))? " author = '". $_GET["var2"] ."' ": null,

(isset($_GET["var3"]))? " date = '". $_GET["var3"] ."' ": null,

(isset($_GET["var4"]))? " forums = '". $_GET["var4"] ."' ": null

);

function myfilterarray($var)

{

return !empty($var)?$var: null;

}

$newvars = array_filter($vars, 'myfilterarray');

$where = join(" OR ", $newvars);

$sql = "SELECT DISTINCT title, description FROM table ".(($where)?"WHERE ".$where: null);

echo $sql;您对http://localhost/?var1=sadfsadf&var2=sadfasdf&var3=asdfasdf的结果

SELECT DISTINCT title, description FROM table WHERE keyword =

'sadfsadf' OR author = 'sadfasdf' OR date = 'asdfasdf'您对http://localhost/?的结果

SELECT DISTINCT title, description FROM table