標籤:style blog http color io os ar for sp
最初級的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>
最基礎的PHP分類查詢程式