我有一段有效的代码,但是很乱。目的是从用户搜索中检索所有相关的行。例如:如果用户搜索“ Jo”,它将检索John和Josh:
起作用的代码:
if($_SERVER["REQUEST_METHOD"] == "POST") {
$search = trim(filter_input(INPUT_POST,"user_search",FILTER_SANITIZE_SPECIAL_CHARS));
$search = preg_replace("#[^0-9a-z]#i", "", $search);
if(!isset($error_message)) {
$query = $db->query("SELECT * FROM User WHERE U_Forename LIKE '%$search%'
OR U_Surname LIKE '%$search%' OR U_Team LIKE '%$search'
OR U_City LIKE '%$search%'");
}
}
<?php
if ($query->num_rows == 0) {
$output = "No results found!";
} else {
echo "<h2>Search results for: " . $search . "</h2>";
while($row = $query->fetch_assoc()) {
$id = $row['U_ID'];
$firstname = $row['U_Forename'];
$lastname = $row['U_Surname'];
$team = $row['U_Team'];
$city = $row['U_City'];
echo "<div class='searchresults'>";
echo "<p> Name: " . ucfirst($firstname) . " " . ucfirst($lastname) . "</p>";
echo "<p> Favourite Team: " . ucfirst($team) . "</p>";
echo "<p> Location: " . ucfirst($city) . "</p>";
echo "<a class='lift' href='profile.php?=[$id]'>View Profile</a>";
echo "<a class='lift' href='#'>Follow Driver</a>";
echo "</div>";
}
}
?>
我尝试过的是:
function getSearchResults($search) {
global $db;
$searchArray = array();
$query = $db->query("SELECT * FROM User WHERE U_Forename LIKE '%$search%'
OR U_Surname LIKE '%$search%' OR U_Team LIKE '%$search'
OR U_City LIKE '%$search%'");
if ($query->num_rows == 0) {
echo "No results found!";
} else {
while($row = $query->fetch_assoc()) {
$searchArray['U_ID'] = $row['U_ID'];
$searchArray['U_Forename'] = $row['U_Forename'];
$searchArray['U_Surname'] = $row['U_Surname'];
$searchArray['U_Team'] = $row['U_Team'];
$searchArray['U_City'] = $row['U_City'];
}
}
return $searchArray;
}
但是,这将不起作用,因为仅来自fetch_assoc()的第一个结果存储在$ searchArray中,而没有别的!有没有人有什么建议?我不确定接下来从哪里开始编码。
詹姆士。
每次运行循环时,您都将覆盖数组。您需要创建一个数组数组,以便可以返回一个数组。下面,我简化了您的代码,以将当前行追加到您要返回的数组中。然后,您可以foreach
对返回的数据进行操作并显示您的代码
while($row = $query->fetch_assoc()) {
$searchArray[] = $row;
}
另外,一个提示:将数据库连接器作为参数传递,并避免将其用作全局参数(这是另一种最佳实践)
function getSearchResults($search) {
global $db;
成为
function getSearchResults($search, $db) {
最后但并非最不重要的一点是,不要让您的函数回显事情(让调用此函数的图层执行此操作)。相反,只需返回一个空数组
if ($query->num_rows == 0) {
return $searchArray;
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句