·您现在的位置: 云翼网络 >> 文章中心 >> 网站建设 >> 网站建设开发 >> php网站开发 >> 最基础的PHP分类查询程序

最基础的PHP分类查询程序

作者:佚名      php网站开发编辑:admin      更新时间:2022-07-23
最基础的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="智慧销售" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="manager" value="经营管理"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="serve" value="智慧客服" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="newemployee" value="智慧新员工" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>