最基础的PHP分类查询程序

浏览数：69 / 时间：2015年06月09日

最初级的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>





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