Home > Article > Backend Development > PHP modifies the function that updates database user records_PHP tutorial
PHP modifies the function that updates database user records_PHP tutorial
- WBOYOriginal
- 2016-07-20 11:00:511022browse
php修改更新数据库用户记录的函数
$link_id = mysql_connect("localhist","root","qwaszx") or die("连接失败！");
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 "
| 编号 | 用户名称 | 性别 | 年龄 | 注册时间 | 操作 |
| ".$row[id]." | ".$row[uername]." | ".$row[gender]." | ".$row[age]." | ".$row[regdate]." | 编辑 |
}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 "记录已经成功修改
"继续修改记录;
else
echo "记录修改失败
返回";
}
}
}
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：php chmod function changes file mode_PHP tutorialNext article：php chmod function changes file mode_PHP tutorial