我想要创建搜索页面(php),在其中我想在“div”中显示从数据库搜索到的数据?我与数据库建立了连接,并在一个 phppage 中搜索数据,并在另一个 phppage 中创建了一个 div 标签。我怎样才能将一个php页面的搜索数据显示在另一个php页面的“div”中
搜索.php:
<?php
include 'Searchdata.php';
include 'connect.php';
if(isset($_POST['submit'])){
$searchkey= $_POST['search'];
$searchkey=preg_replace("#[^0-9a-z]#i", "", $searchkey);
$query = mysqli_query($conn, "SELECT * FROM newentry WHERE Date LIKE '%$searchkey%'")or die("Could not search!");
$count = mysqli_num_rows($query);
if(!($count == 0)) {
while($row=mysqli_fetch_array($query)){
$Date=$row['Date'];
$Entry=$row['Entry'];
echo'<div>'.$Date.'<br>'.$Entry.'</div>';
}
} else {echo "There was no search result!";}
}?>
搜索数据.php:
<div>
<form action="Search.php" method="post">
<input type="text" name="search" placeholder="Search">
<input type="submit" value="Search" />
</form>
只需创建一个变量来存储结果,在本例中为 $data。将 include searchdata.php 移至代码底部,以便它可以重新识别 $data。
然后在你的 html 页面上回显它。
html页面
<div>
<form action="Searchdata.php" method="post">
<input type="text" name="search" placeholder="Search">
<input type="submit" value="Search">
</form>
<div><?php echo $data ?></div>
</div>
PHP 代码。
<?php
include 'connect.php';
$data = '';
if(isset($_POST['submit'])){
$searchkey= $_POST['search'];
$searchkey=preg_replace("#[^0-9a-z]#i", "", $searchkey);
$query = mysqli_query($conn, "SELECT * FROM newentry WHERE Date LIKE '%$searchkey%'")or die("Could not search!");
$count = mysqli_num_rows($query);
if(!($count == 0)) {
while($row=mysqli_fetch_array($query)){
$Date=$row['Date'];
$Entry=$row['Entry'];
$data = '<div>'.$Date.'<br>'.$Entry.'</div>';
}
} else {
$data = "There was no search result!";}}
include 'Search.php';
?>
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)