PHP Message Board Admin-View Code

<meta http-equiv= "Content-type" content= "HTML; Charset=utf-8 "/>


<?php


$lianjie = mysql_connect ("localhost", "root", "Xiaolie") or Die ("Connection failed");


mysql_query ("Set names UTF8");


if ($lianjie)


{


mysql_select_db ("Xiaolie");


if (!@$_get["id"])


 {


$jieguo = "SELECT * from Zhuce";


$fasong = mysql_query ($jieguo) or Die (Mysql_error ());


echo "<table border=1>


<tr>


<td> numbering </td>


<td> user name </td>


<td> Gender </td>


<td> Age </td>


<td> Registration Time </td>


<td> Details </td>


</tr> ";


while ($nr =mysql_fetch_array ($fasong))


  {


echo "<tr>


<td> ". $nr [id]." </td>


<td> ". $nr [" name]. " </td>


<td> ". $nr [" Xingbie "]." </td>


<td> ". $nr [" nianling "]." </td>


<td> ". $nr [" Zc_shijian "]." </td>


<td><a href=ck_my.php?id= ". $nr [id]." > View </a></td>


</tr> ";


  }


echo "</table>";


 }


Else


 {


$jieguo = "SELECT * from Zhuce where id=". $_get["id"];


$fasong = mysql_query ($jieguo);


$nr = mysql_fetch_array ($fasong);


echo "No.:". $nr [id]. " <br> user name: ". $nr [" name]. " <br> sex: ". $nr [" Xingbie "]." <br> Age: ". $nr [" nianling "]." <br> registration Time: ". $nr [" Zc_shijian "]." <br> ";


echo "<br><br><a href=ck_my.php> continue query </a>";


 }


}

?>