搜索栏显示结果到另一个页面



>我创建了以下搜索栏以显示产品结果。尽管我设法将它们显示在与搜索栏相同的页面中,但我无法创建从搜索栏到另一个页面的重定向以在那里显示结果。

搜索栏:

    div class="col-sm-3 col-md-3">
    <form action="<?=$_SERVER['PHP_SELF']?>" method="post" class="navbar-form" role="search" >
    <div class="input-group">
        <input type="text" class="form-control" placeholder="Search" name="searchcriteria">
        <div class="input-group-btn">
            <button class="btn btn-default" type="submit" name="submit" id="search" value="search"><i class="glyphicon glyphicon-search"></i></button>
        </div>
    </div>
    </form>
</div>

代码的其余部分(用于显示结果):

if ($_POST['submit']) {
$searchcriteria = (trim($_POST['searchcriteria']) == "")?
die ("You did not enter any search criteria. Try Again!"):
mysqli_real_escape_string($mysqli, trim($_POST['searchcriteria']));
echo "You searched for : " . $searchcriteria;
$query = "select * from album_info where upper(title) like '%". strtoupper($searchcriteria) . "%' or upper(name) like '%" . strtoupper($searchcriteria) . "%'";
if (! ($result = mysqli_query($mysqli,$query)))
die ("There is something wrong in the query :" . $query . "</body></html>");
 echo '<table border="1">';
 while ($rows = mysqli_fetch_array($result)) {
    $title = $rows['title'];
    $name = $rows['name'];
    $imagefile = $rows['imagefile'];
?> 
 <div class="col-sm-6 col-md-4">
                  <div class="thumbnail">
                      <img src="<?php echo "img/".$imagefile ?>" />
                      <div class="caption">
                          <h3><?php echo $title ?></h3>
                          <p><?php echo $name ?></p>
                          <p><a href="#" class="btn btn-primary" role="button">Button</a> <a href="#" class="btn btn-default" role="button">Button</a></p>
                      </div>
                  </div>
             </div> 

您可以查看 target="_blank" 以打开新页面。

<form action="" target="_blank">

另外,请使用PHP-PDO或mysql_real_escape_string来防止SQL注入攻击。

相关内容

最新更新