PHPÖеĶàÌõ¼þÄ£ºý²éѯ

<?php

//»ñÈ¡²éѯÌõ¼þ

$wherelist = array();

if(!empty($_POST['title'])){

$wherelist[] = "title like '%{$_POST['title']}%'";

}

if(!empty($_POST['keywords'])){

$wherelist[] = "keywords like '%{$_POST['keywords']}%'";

}

if(!empty($_POST['content'])){

$wherelist[] = "content like '%{$_POST['content']}%'";

}

if(!empty($_POST['author'])){

$wherelist[] = "author like '%{$_POST['author']}%'";

}

//×é×°²éѯÌõ¼þ

if(count($wherelist) > 0){

$where = " where ".implode(' AND ' , $wherelist);

}

//ÅжϲéѯÌõ¼þ

$where = isset($where) ? $where : '';

echo $where;

//µÃµ½²éѯÌõ¼þ

// $sql = "SELECT * FROM `table` '&where' ";

//$sql = "SELECT * FROM `table` {&where} ";

?>