douxi4114 2016-11-20 20:40 采纳率: 100%
浏览 47
已采纳

搜索引擎使用网址

I started making site for songs. It is lyrics site and I wanted a search engine that works something like picture below.

It should works with URL.

Like this

<form action="#" method="POST">
  <input type="text" name="search"/>
  <input type="submit" name="submit" value="Submit">
</form>
<?php
 require "connection-to.php";
  $notFound = "";
  $song = "";
  if(isset($_POST['submit'])){
  $search = mysqli_real_escape_string($conn, $_POST['search']);
  $search = strtolower($search);
  $sql = "SELECT * FROM `music` WHERE `name` = '" . $search . "'";
  $query = mysqli_query($conn, $sql);
  $numRows = mysqli_num_rows($query);
  if($numRows != 0){
    while($row = mysqli_fetch_array($query)){
    echo $row['lyrics'] . "<br><br><br>";
}
} else {
    echo $search . " Was Not Found.";
}
}
?>
  • 写回答

1条回答 默认 最新

  • douguadao3883 2016-11-20 21:04
    关注

    You don't want send a POST request. Change

    <form action="#" method="POST">
    

    to

    <form action="" method="GET">
    

    Then you can retrive it with $_GET['search'] instead of $_POST['search'].

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求帮我调试一下freefem代码
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法
  • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
  • ¥100 为什么这个恒流源电路不能恒流?
  • ¥15 有偿求跨组件数据流路径图