PHP modifies the function that updates database user records_PHP tutorial

WBOY
Release: 2016-07-20 11:00:51
Original
965 people have browsed it

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 "记录修改失败
返回";
  }
 }
}

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/445495.htmlTechArticlephp修改更新数据库用户记录的函数 $link_id = mysql_connect(localhist,root,qwaszx) or die(连接失败!); if($link_id) { mysql_select_db(my_test); if(!$_GET[id]) { $res...
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!