Php message board update code-PHP source code

Php message board update 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)
{
$ Xuanbiao = "select * from zhuce ";
$ Fasong = mysql_query ($ xuanbiao) or die (mysql_error ());
Echo"

";While ($ nr = mysql_fetch_array ($ fasong )){Echo" ";}Echo"

No.	User Name	Gender	Age	Registration Time	Operation
". $ Nr [" id "]."	". $ Nr [" name "]."	". $ Nr [" xingbie "]."	". $ Nr [" nianling "]."	". $ Nr [" zc_shijian "]."	Edit

";
}
Else
{
If (! $ _ POST)
{
$ Xianid = "select * from zhuce where id =". $ _ GET ["id"];
$ Fasong = mysql_query ($ xianid) or die (mysql_error ());
$ Nr = mysql_fetch_array ($ fasong );
?>

}
Else
{
$ Gx = "update zhuce set name = '". $ _ POST ["name"]. "', xingbie = '". $ _ POST ["xingbie"]. "', nianling = '". $ _ POST ["nianling"]. "', zc_shijian = '". $ _ POST ["zc_shijian"]. "'where id = '". $ _ POST ["id"]. "'";
$ Fasong = mysql_query ($ gx );
If ($ fasong ){
Echo "record modified successfully
Modify record ";}
Else {
Echo "record modification failed
Return ";}
}
}
}