我希望创建一个表单,允许用户输入搜索内容,从数据库中获取正确的值并显示它们。但是,由于某种原因,我的查询无法正常工作,只显示“无法搜索”。
以下是我的php代码:
这是我的表单。
以下是我的php代码:
<?php
include "connect.php";
$output = '';
if(isset($_POST['search'])) {
$search = $_POST['search'];
$search = preg_replace("#[^0-9a-z]i#","", $search);
$query = mysqli_query("SELECT * FROM house WHERE town LIKE '%$search%'") or die ("Could not search");
$count = mysqli_num_rows($query);
if($count == 0){
$output = "There was no search results!";
}else{
while ($row = mysqli_fetch_array($query)) {
$town = $row ['town'];
$street = $row ['street'];
$bedrooms = $row ['bedrooms'];
$bathroom = $row ['bathrooms'];
$output .='<div> '.$town.''.$street.''.$bedrooms.''.$bathrooms.'</div>';
}
}
}
?>
<form action ="home.php" method = "post">
<input name="search" type="text" size="30" placeholder="Belfast"/>
<input type="submit" value="Search"/>
</form>
<?php print ("$output");?>
'%".$search."%'
替换'%$search%'
... - Nishant SolankiSELECT * FROM house WHERE town LIKE '%$search%'
,并尝试从phpmyadmin或mysql运行该查询... - Nishant Solanki