The most basic PHP classification query program

the initial class of PHP classification query program<! DOCTYPE html Public"-//w3c//dtd XHTML 1.0 transitional//en" "Http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >$_server[' php_self '];? > "method=" POST "><input type=" submit "name=" sell "value=" wisdom sales/>&nbsp;&nbsp;&nbsp;& nbsp;&nbsp;&nbsp;<input type= "Submit" Name= "manager" value= "Management"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& Nbsp;<input type= "Submit" name= "Serve" value= "smart customer Service"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<input type= "Submit" Name= "NewEmployee" value= "smart new employee"/>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;<input type= "Submit" name= "development" value= "personal development"/&GT;&LT;/FORM&GT;&LT;?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 '% Smart Sales% '";$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 '% smart customer service% '";$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 '% Operating management% '";$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 '% Smarter New Employee% '";$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 '% Personal development% '";$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>
The most basic PHP classification query program