首页 > 代码库 > 最基础的PHP分类查询程序
最基础的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="http://www.mamicode.com/智慧销售" /> <input type="submit" name="manager" value="http://www.mamicode.com/经营管理"/> <input type="submit" name="serve" value="http://www.mamicode.com/智慧客服" /> <input type="submit" name="newemployee" value="http://www.mamicode.com/智慧新员工" /> <input type="submit" name="development" value="http://www.mamicode.com/个人发展" /></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>
最基础的PHP分类查询程序
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。