Php modifies the function for updating database user records
$ Link_id = mysql_connect ("localhist", "root", "qwaszx") or die ("connection failed! ");
If ($ link_id)
{
Mysql_select_db ("my_test ");
If (! $ _ GET [id])
{
$ Result = mysql_query ("select * from userinfo ");
Echo"
";
While ($ row = mysql_fetch_array ($ result ))
{
Echo"
";
}
Echo"
No. |
User Name |
Gender |
Age |
Registration Time |
Operation |
". $ Row [id]." |
". $ Row [uername]." |
". $ Row [gender]." |
". $ Row [age]." |
". $ Row [regdate]." |
Edit |
";
} Else
{
If (! $ _ POST [OK])
{
$ SQL = "select * frim userinfo where id =". $ _ GET [id];
$ Result = mysql_query ($ SQL );
$ Row = mysql_fetch_array ($ result );
?>
} Else
{
$ SQL = "update userinfo set username = '". $ _ POST [username]. "', gender = '". $ _ POST [gender]. "', age = '". $ _ POST [age]. "', regdate = '". $ _ POST [regdate]. "'where id = '". $ _ POST [id]. "'";
$ Result = mysql_query ($ SQL );
If ($ result)
Echo "record modified successfully
"Continue modification record;
Else
Echo "record modification failed
Return ";
}
}
}