โดย nakikaede » 15/05/2009 5:57 pm
code จะประมาณนี้ครับ
<?
$reqName = $_POST['name'];
$reqSurname = $_POST['surname'];
$reqEmail = $_POST['email'];
$reqSex = $_POST['sex'];
$reqAddress = $_POST['address'];
$reqHobbies = $_POST['hobbies'];
$reqKnowFrom = $_POST['knowFrom'];
// make sqlCriteria
$sqlCriteria = "";
if(isset($reqName)) $sqlCriteria .= " name like '%$reqName%' or ";
if(isset($reqSurname)) $sqlCriteria .= " surname like '%$reqSurname%' or ";
if(isset($reqEmail)) $sqlCriteria .= " email like '%$reqEmail%' or ";
if(isset($reqSex)) $sqlCriteria .= " sex like '%$reqSex%' or ";
if(isset($reqAddress)) $sqlCriteria .= " address like '%$reqAddress%' or ";
if(isset($reqHobbies)) $sqlCriteria .= " hobbies like '%$reqHobbies%' or ";
if(isset($reqKnowFrom)) $sqlCriteria .= " knowFrom like '%$reqKnowFrom%' or ";
if($sqlCriteria != "") {
$sqlCriteria = substr($sqlCriteria,0,$sqlCriteria-3);
$sqlCriteria = " where ".$sqlCriteria;
}
$_query = "select * from table ".$sqlCriteria;
?>
ที่เหลือเอาไปต่อยอดเองนะครับ
code จะประมาณนี้ครับ
<?
$reqName = $_POST['name'];
$reqSurname = $_POST['surname'];
$reqEmail = $_POST['email'];
$reqSex = $_POST['sex'];
$reqAddress = $_POST['address'];
$reqHobbies = $_POST['hobbies'];
$reqKnowFrom = $_POST['knowFrom'];
// make sqlCriteria
$sqlCriteria = "";
if(isset($reqName)) $sqlCriteria .= " name like '%$reqName%' or ";
if(isset($reqSurname)) $sqlCriteria .= " surname like '%$reqSurname%' or ";
if(isset($reqEmail)) $sqlCriteria .= " email like '%$reqEmail%' or ";
if(isset($reqSex)) $sqlCriteria .= " sex like '%$reqSex%' or ";
if(isset($reqAddress)) $sqlCriteria .= " address like '%$reqAddress%' or ";
if(isset($reqHobbies)) $sqlCriteria .= " hobbies like '%$reqHobbies%' or ";
if(isset($reqKnowFrom)) $sqlCriteria .= " knowFrom like '%$reqKnowFrom%' or ";
if($sqlCriteria != "") {
$sqlCriteria = substr($sqlCriteria,0,$sqlCriteria-3);
$sqlCriteria = " where ".$sqlCriteria;
}
$_query = "select * from table ".$sqlCriteria;
?>
ที่เหลือเอาไปต่อยอดเองนะครับ