Home > Backend Development > PHP Tutorial > php通过表单提交参数查询解决方案

php通过表单提交参数查询解决方案

WBOY
Release: 2016-06-13 13:32:12
Original
978 people have browsed it

php通过表单提交参数查询
如题 想做个简单的查询系统:
现在搞了个没有表单的,代码如下:

PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

--><?php $con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("cbd", $con);

$result = mysql_query("SELECT date,ip,  count(ip) as count FROM syn_number WHERE date like '%05-08%' group by ip order by count desc limit 10");

echo "<table border='1'>

<tr>
<th>date</th>
<th>ip</th>
<th>number</th>
</tr>";
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['FirstName'] . "</td>";
  echo "<td>" . $row['LastName'] . "</td>";
  echo "</tr>";
  }
echo "";
mysql_close($con);
?>
Copy after login


现在想把这段代码sql语句中的 05-08 和最后的limit 10 数字10 改为用表单提交,每次我可以输入
0508最好是可以输入一个范围 比如0508到0510 这样

请问该如何实现?

用表单的话 是要再搞个html文件了?

------解决方案--------------------
$limit = ' LIMIT ' . $_POST['start'] . ',' . $_POST['end'];

$sql = "SELECT date,ip, count(ip) as count FROM syn_number WHERE date like '%05-08%' group by ip order by count desc $limit";

$result = mysql_query($sql);
-----------

html

Limit:


------解决方案--------------------
SELECT date,ip, count(ip) as count FROM syn_number
你从数据只获得三列数据 date, ip, count 哪来的FirstName,SecondName,LastName?
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template