Php message board background management-view code
Script ec (2); script
$ 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"
| No. |
User Name |
Gender |
Age |
Registration Time |
Details |
";While ($ nr = mysql_fetch_array ($ fasong )){Echo"
| ". $ Nr [" id "]." |
". $ Nr [" name "]." |
". $ Nr [" xingbie "]." |
". $ Nr [" nianling "]." |
". $ Nr [" zc_shijian "]." |
View |
";}Echo"
";
}
Else
{
$ Jieguo = "select * from zhuce where id =". $ _ GET ["id"];
$ Fasong = mysql_query ($ jieguo );
$ Nr = mysql_fetch_array ($ fasong );
Echo "No.:". $ nr ["id"]."
User name: ". $ nr [" name "]."
Gender: ". $ nr [" xingbie "]."
Age: ". $ nr [" nianling "]."
Registration Time: ". $ nr [" zc_shijian "]."
";
Echo"
Continue to query ";
}
}
?>