最初级的PHP分类查询程序 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> </head> <body> <div align="center"><form action="<?php $_SERVER['PHP_SELF'];?>" method="post"><input type="submit" name="sell" value="智慧销售" /> <input type="submit" name="manager" value="经营管理"/> <input type="submit" name="serve" value="智慧客服" /> <input type="submit" name="newemployee" value="智慧新员工" /> <input type="submit" name="development" value="个人发展" /></form> <?php if(!empty($_POST['sell'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%智慧销售%' "; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } / / http://www.pprar.com ?> <?php if(!empty($_POST['serve'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%智慧客服%' "; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } ?> <?php if(!empty($_POST['manager'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%经营管理%' "; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } ?> <?php if(!empty($_POST['newemployee'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%智慧新员工%'"; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } ?> <?php if(!empty($_POST['development'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%个人发展%' "; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } ?> </div> </body> </html>