具有一個或多個參數(shù)的搜索表單我已經(jīng)完成了基礎(chǔ)工作，我創(chuàng)建了兩個文件，一個用戶輸入搜索參數(shù)的搜索表單，以及一個運行輸入項的結(jié)果文件。為了簡單起見，我們將搜索表單文件指定為search.php，將結(jié)果頁面指定為Resul.php。編輯：清理標(biāo)簽禮儀，以方便閱讀。search.php<?php if(!empty($_POST['id']) && isset($_POST['id'])) {
header("Location: ?m=search.results&id=".$_POST['id']."");
} elseif(!empty($_POST['major']) && isset($_POST['major'])) {
header("Location: ?m=search.results&major=".$_POST['major']."");
} elseif(!empty($_POST['college']) && isset($_POST['major'])) {
header("Location: ?m=search.results&college=".$_POST['college']."");
} elseif (!empty($_POST['name']) && isset($_POST['name'])) {
header("Location: ?m=search.results&name=".$_POST['name']."");
} elseif (!empty($_POST['id']) && !empty($_POST['college']) && !empty($_POST['major'])
&& isset($_POST['submit']) && !empty($_POST['name'])) {
echo "<div class='alert alert-danger'>No students found. Please try different parameters.</div>";
}
?>
<h4>Search</h4>
<form method="POST">
<table width="100%">
<tr><td>ID:</td><td> <input type="text" name="id" class="form-control"></textarea></td></tr>
<tr><td>Name:</td><td> <input type="text" name="name" class="form-control"></textarea></td></tr>
<tr><td>Major:</td><td><select name="major" class="form-control"><option></option><?php echo majorSelect(); ?></select></td></tr>
<tr><td>College:</td><td><select name="college" class="form-control"><option></option><?php echo collegeSelect(); ?></select></td>
</tr>
<tr><td colspan="2"><input type="submit" name="submit" value="Search" class="btn btn-lrg btn-primary" style="margin-top:10px;"></td>
</tr>
</table>
</form>因此，本質(zhì)上，我想重寫上面的內(nèi)容，而用戶可以輸入一個或多個參數(shù)，然后返回所需的結(jié)果(例如，名稱和學(xué)院名稱=x&College=y或如果需要的話所有項目)。我想我需要重新思考這兩個文件中的邏輯，但我愿意接受您的任何想法或建議，這個美妙的社區(qū)可能會有！如有任何建議/指導(dǎo)，將不勝感激。
3 回答
守候你守候我
TA貢獻(xiàn)1802條經(jīng)驗 獲得超10個贊
WHEREimplode()ANDOR
$wheres = array();$params = array();if (!empty($_GET['id'])) {
$wheres[] = 'a.uid = :uid';
$params[':uid'] = $_GET['id'];}if (!empty($_GET['major'])) {
$wheres[] = 'a.major = :major';
$params[':major'] = $_GET['major'];}if (!empty($_GET['name'])) {
$wheres[] = 'b.name LIKE :name';
$params[':name'] = '%'.$_GET['name'].'%';}// And so on for all parameters$sql = "SELECT *
FROM user_details AS a
JOIN user AS b ON a.uid = b.id";if (!empty($wheres)) {
$sql .= " WHERE " . implode(' AND ', $wheres);}$stmt = $db->prepare($sql);$stmt->execute($params);while ($student = $stmt->fetch()) {
...}
慕絲7291255
TA貢獻(xiàn)1859條經(jīng)驗 獲得超6個贊
<form action="<?= $_SERVER["REQUEST_URI"]; ?>" method="GET">
<input name="major" value="<?= $_GET["major"]; ?>" /> <select name="college">
<option value="1" <?PHP if( $_GET["college"] == 1 ) echo 'selected="true"'; ?>>Business</option>
</select></form><?PHPif( ! empty( $_GET ) ){
if (isset($_GET['major'])) {
$wheres[] = 'a.major = :major';
$params[':major'] = $_GET['major'];
}
if (isset($_GET['name'])) {
$wheres[] = 'b.name LIKE :name';
$params[':name'] = '%'.$_GET['name'].'%';
}
// And so on for all parameters
$sql = "SELECT *
FROM user_details AS a
JOIN user AS b ON a.uid = b.id";
if (!empty($wheres)) {
$sql .= " WHERE " . implode(' AND ', $wheres);
}
$stmt = $db->prepare($sql);
$stmt->execute($params);}?>- 3 回答
- 0 關(guān)注
- 532 瀏覽
添加回答
舉報
0/150
提交
取消