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); ?>