Home >Backend Development >PHP Tutorial >php通过表单提交参数查询解决方案
php通过表单提交参数查询
如题 想做个简单的查询系统:
现在搞了个没有表单的,代码如下:
<!--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);?>