最基础的php分类查询程序
最初级的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><?phpif(!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 ?><?phpif(!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);}?><?phpif(!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);}?><?phpif(!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);}?><?phpif(!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>