Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PHP MYSQL realizes user addition, deletion, modification and query, mysql addition and deletion_PHP tutorial

PHP MYSQL realizes user addition, deletion, modification and query, mysql addition and deletion_PHP tutorial

WBOY
Release： 2016-07-13 10:01:09
Original
1165 people have browsed it

PHP MYSQL implements user addition, deletion, modification and query, mysql addition and deletion

file list. . File content. .

dbconn.php
userListt.php
editUser.php
editDo.php
detailUser.php
deleteUser.php
addUser.php
addDo.php


<&#63;php
// 创建数据库连接
$con = mysql_connect("localhost",'root','') or die('error:'.mysql_error());
mysql_select_db('hyxx',$con) or die('error:'.mysql_error());
mysql_query('set NAMES utf8');
&#63;>
Copy after login

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>会员信息列表</title>
</head>
  <body>
    <table border="1" cellspacing="0" cellpadding="0" id="userList" align="center">
   <tr align="center">
    <td>id</td>
    <td>用户名</td>
    <td>密码</td>
    <td>性别</td>
    <td>年龄</td>
    <td>出生年月</td>
    <td>爱好</td>
    <td>注册时间</td>
    <td>最后登录时间</td>
    <td>操作</td>
   </tr>
<&#63;php
require_once 'inc/dbConn.php';
//这是啥东东。。
date_default_timezone_set("PRC");
//读数据。。。
  $sql = "select * from user order by id asc";
  $result = mysql_query($sql,$con);
  $userList = '';
  while($rs = mysql_fetch_array($result)){
        $userList[] = $rs;
    }
          // 循环用户列表
        foreach ($userList as $user){
          echo "
             <tr>
              <td> ".$user['id']."</td>
              <td> ".$user['username']."</td>
              <td> ".$user['password']."</td>
              <td> ".$user['sex']."</td>
              <td> ".$user['age']."</td>
              <td> ".date("Y-m-d",$user['birthday'])."</td>
              <td> ".$user['hobby']."</td>
              <td> ".date("Y-m-d",$user['add_time'])."</td>
              <td> ".date("Y-m-d",$user['last_login'])."</td>
              <td> <a href='addUser.php'>增</a> 
              <a href='deleteUser.php&#63;id=".$user['id']."');\">&nbsp删</a>
              <a href='editUser.php&#63;id=".$user['id']."');\">&nbsp改</a>
              <a href='detailUser.php&#63;id=".$user['id']."');\">&nbsp查</a>                    
              </td>
             </tr>
          ";
        }
&#63;>
  </table>
  </body>
</html>
Copy after login

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>编辑用户</title>
</head>
<body>
<&#63;php 
require_once 'inc/dbConn.php';
$userId=$_GET['id'];
//这是啥东东。。
date_default_timezone_set("PRC");
//读数据。。。
  $sql = "select * from user where id=".$userId;
  $result = mysql_query($sql,$con);
  $user = mysql_fetch_array($result);
&#63;>
<form action="editDo.php" method="post">
    <input type="hidden" name="user_id" value="<&#63;php echo $user['id']&#63;>"/>
    <table width="444" border="1" align="center">
       <tr>
        <td>用户名 </td>
        <td> <input type="text" name="user_name" size="10" value=<&#63;php echo $user['username'] &#63;> /></td>
       </tr>
       <tr>
        <td>密码</td>
        <td> <input type="password" name="password" size="10" value=<&#63;php echo $user['password'] &#63;> /></td>
       </tr>
       <tr>
        <td>性别</td> 
        <td> <input type="radio" name="sex" value="男"
         <&#63;php if($user[sex]=='1') echo "checked=\"checked\"" &#63;> /> 男<input type="radio" name="sex" value="女" <&#63;php if($user[sex]=='2') echo "checked=\"checked\"" &#63;>
         /> 女 </td>
       </tr>
       <tr>
        <td>年龄</td>
        <td> <input type="text" name="age" size="3" value=<&#63;php echo $user['age'] &#63;> /></td>
       </tr>
       <tr>
        <td>出生年月</td>
        <td> 
        <!-- 1。取得年月日。2。相应的年月日。。。你懂的 -->
        <&#63;php
        $birday_y=date("Y",$user['birthday']);
        $birday_m=date("m",$user['birthday']);
        $birday_d=date("d",$user['birthday']);
        &#63;>
          <select name="birthday_y">
          <option value="1980" <&#63;php if($birday_y==1980) echo "selected=\"selected\""; &#63;> >1980</option>
          <option value="1981" <&#63;php if($birday_y==1981) echo "selected=\"selected\""; &#63;> >1981</option>
          <option value="1982" <&#63;php if($birday_y==1982) echo "selected=\"selected\""; &#63;> >1982</option>
          <option value="1983" <&#63;php if($birday_y==1983) echo "selected=\"selected\""; &#63;> >1983</option>
          <option value="1984" <&#63;php if($birday_y==1984) echo "selected=\"selected\""; &#63;> >1984</option>
          <option value="1985" <&#63;php if($birday_y==1985) echo "selected=\"selected\""; &#63;> >1985</option>
          <option value="1986" <&#63;php if($birday_y==1986) echo "selected=\"selected\""; &#63;> >1986</option>
          <option value="1987" <&#63;php if($birday_y==1987) echo "selected=\"selected\""; &#63;> >1987</option>
          <option value="1988" <&#63;php if($birday_y==1988) echo "selected=\"selected\""; &#63;> >1988</option>
          <option value="1989" <&#63;php if($birday_y==1989) echo "selected=\"selected\""; &#63;> >1989</option>
          <option value="1990" <&#63;php if($birday_y==1990) echo "selected=\"selected\""; &#63;> >1990</option>
          </select>
          年
          <select name="birthday_m">
          <option value="1" <&#63;php if($birday_m==1) echo "selected=\"selected\""; &#63;> >1</option>
          <option value="2" <&#63;php if($birday_m==2) echo "selected=\"selected\""; &#63;> >2</option>
          <option value="3" <&#63;php if($birday_m==3) echo "selected=\"selected\""; &#63;> >3</option>
          <option value="4" <&#63;php if($birday_m==4) echo "selected=\"selected\""; &#63;> >4</option>
          <option value="5" <&#63;php if($birday_m==5) echo "selected=\"selected\""; &#63;> >5</option>
          <option value="6" <&#63;php if($birday_m==6) echo "selected=\"selected\""; &#63;> >6</option>
          <option value="7" <&#63;php if($birday_m==7) echo "selected=\"selected\""; &#63;> >7</option>
          <option value="8" <&#63;php if($birday_m==8) echo "selected=\"selected\""; &#63;> >8</option>
          <option value="9" <&#63;php if($birday_m==9) echo "selected=\"selected\""; &#63;> >9</option>
          <option value="10" <&#63;php if($birday_m==10) echo "selected=\"selected\""; &#63;> >10</option>
          <option value="11" <&#63;php if($birday_m==11) echo "selected=\"selected\""; &#63;> >11</option>
          <option value="12" <&#63;php if($birday_m==12) echo "selected=\"selected\""; &#63;> >12</option>
          </select>
          月 
          <select name="birthday_d">
          <option value="1" <&#63;php if($birday_d==1) echo "selected=\"selected\""; &#63;> >1</option>
          <option value="2" <&#63;php if($birday_d==2) echo "selected=\"selected\""; &#63;> >2</option>
          <option value="3" <&#63;php if($birday_d==3) echo "selected=\"selected\""; &#63;> >3</option>
          <option value="4" <&#63;php if($birday_d==4) echo "selected=\"selected\""; &#63;> >4</option>
          <option value="5" <&#63;php if($birday_d==5) echo "selected=\"selected\""; &#63;> >5</option>
          <option value="6" <&#63;php if($birday_d==6) echo "selected=\"selected\""; &#63;> >6</option>
          <option value="7" <&#63;php if($birday_d==7) echo "selected=\"selected\""; &#63;> >7</option>
          <option value="8" <&#63;php if($birday_d==8) echo "selected=\"selected\""; &#63;> >8</option>
          <option value="9" <&#63;php if($birday_d==9) echo "selected=\"selected\""; &#63;> >9</option>
          <option value="10" <&#63;php if($birday_d==10) echo "selected=\"selected\""; &#63;> >10</option>
          <option value="11" <&#63;php if($birday_d==11) echo "selected=\"selected\""; &#63;> >11</option>
          <option value="12" <&#63;php if($birday_d==12) echo "selected=\"selected\""; &#63;> >12</option>
          <option value="13" <&#63;php if($birday_d==13) echo "selected=\"selected\""; &#63;> >13</option>
          <option value="14" <&#63;php if($birday_d==14) echo "selected=\"selected\""; &#63;> >14</option>
          <option value="15" <&#63;php if($birday_d==15) echo "selected=\"selected\""; &#63;> >15</option>
          <option value="16" <&#63;php if($birday_d==16) echo "selected=\"selected\""; &#63;> >16</option>
          <option value="17" <&#63;php if($birday_d==17) echo "selected=\"selected\""; &#63;> >17</option>
          <option value="18" <&#63;php if($birday_d==18) echo "selected=\"selected\""; &#63;> >18</option>
          <option value="19" <&#63;php if($birday_d==19) echo "selected=\"selected\""; &#63;> >19</option>
          <option value="20" <&#63;php if($birday_d==20) echo "selected=\"selected\""; &#63;> >20</option>
          <option value="21" <&#63;php if($birday_d==21) echo "selected=\"selected\""; &#63;> >21</option>
          <option value="22" <&#63;php if($birday_d==22) echo "selected=\"selected\""; &#63;> >22</option>
          <option value="23" <&#63;php if($birday_d==23) echo "selected=\"selected\""; &#63;> >23</option>
          <option value="24" <&#63;php if($birday_d==24) echo "selected=\"selected\""; &#63;> >24</option>
          <option value="25" <&#63;php if($birday_d==25) echo "selected=\"selected\""; &#63;> >25</option>
          <option value="26" <&#63;php if($birday_d==26) echo "selected=\"selected\""; &#63;> >26</option>
          <option value="27" <&#63;php if($birday_d==27) echo "selected=\"selected\""; &#63;> >27</option>
          <option value="28" <&#63;php if($birday_d==28) echo "selected=\"selected\""; &#63;> >28</option>
          <option value="29" <&#63;php if($birday_d==29) echo "selected=\"selected\""; &#63;> >29</option>
          <option value="30" <&#63;php if($birday_d==30) echo "selected=\"selected\""; &#63;> >30</option>
          <option value="31" <&#63;php if($birday_d==31) echo "selected=\"selected\""; &#63;> >31</option>
          </select>
          日
        </td>
       </tr>
       <tr>
        <td>爱好</td>
        <td> <input type="text" name="hobby" size="44" value=<&#63;php echo $user['hobby'] &#63;> /></td>
       </tr>
       <tr>
        <td>个人简介</td>
        <td> <textarea name="profile" rows="10" cols="30" ><&#63;php echo $user['profile'] &#63;> </textarea> </td>
       </tr>
       <tr>
          <td colspan="2" align="center"><input type="submit" value="确定修改" /></td>
       </tr>
 </table>
      <p> </p>
      <p> </p>
      <p> </p>
</form>
</body>
</html>
Copy after login

<&#63;php
require_once 'inc/dbConn.php';
////////////////////
///获取用户信息
////////////////////
$user_id = $_POST['user_id'];
$user_name = $_POST['user_name'];
$password= $_POST['password'];
if($_POST['sex']=='男')
{
  $sex=1;
}
else if($_POST['sex']=='女')
{
    $sex=2;
}
else $sex=3;    
;
$age = $_POST['age'];
$birthday_y = $_POST['birthday_y'];
$birthday_m = $_POST['birthday_m'];
$birthday_d = $_POST['birthday_d'];
$birthday=mktime(0,0,0,$birthday_m,$birthday_d,$birthday_y);
$hobby = $_POST['hobby'];
$profile = $_POST['profile'];
$addTime=mktime(date("h"),date("m"),date("s"),date("m"),date("d"),date("Y"));
$lastLoginTime=$addTime;
  $sql = "update user set username='$user_name',password='$password',sex='$sex',age='$age',birthday='$birthday',hobby='$hobby',profile='$profile' where id='$user_id'";
  echo $sql;
  // 执行sql语句
  mysql_query($sql,$con);
  // 获取影响的行数
  $rows = mysql_affected_rows();
  // 返回影响行数
  // 如果影响行数>=1,则判断添加成功,否则失败
  if($rows >= 1)
  {
    alert("编辑成功");
    href("userListt.php");
  }else{
    alert("编辑失败");
//   href("addUser.php");
    }
function alert($title){
  echo "<script type='text/javascript'>alert('$title');</script>";
}
function href($url){
  echo "<script type='text/javascript'>window.location.href='$url'</script>";
}
&#63;>
Copy after login

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>查看用户明细</title>
</head>
<body>
<&#63;php 
require_once 'inc/dbConn.php';
$userId=$_GET['id'];
//这是啥东东。。
date_default_timezone_set("PRC");
//读数据。。。
  $sql = "select * from user where id=".$userId;
  $result = mysql_query($sql,$con);
  $user = mysql_fetch_array($result);
&#63;>
    <table width="444" border="1" align="center">
       <tr>
        <td>用户ID </td>
        <td> <&#63;php echo $userId &#63;> </td>
       </tr>
       <tr>
        <td>用户名 </td>
        <td> <&#63;php echo $user['username'] &#63;> </td>
       </tr>
       <tr>
        <td>密码</td>
        <td> <&#63;php echo $user['password'] &#63;> </td>
       </tr>
       <tr>
        <td>性别</td> 
        <td> <&#63;php if($user[sex]=='1') echo "男"; else if($user[sex]=='2') echo "女"; else "保密"; &#63;>
        </td>
       </tr>
       <tr>
        <td>年龄</td>
        <td> <&#63;php echo $user['age'] &#63;> </td>
       </tr>
       <tr>
        <td>出生年月</td>
        <td> 
        <!-- 1。取得年月日。2。相应的年月日。。。你懂的 -->
        <&#63;php
        $birday_y=date("Y",$user['birthday']);echo $birday_y."年";
        $birday_m=date("m",$user['birthday']);echo $birday_m."月";
        $birday_d=date("d",$user['birthday']);echo $birday_d."日";
        &#63;>
        </td>
       </tr>
       <tr>
        <td>爱好</td>
        <td> <&#63;php echo $user['hobby'] &#63;> </td>
       </tr>
       <tr>
        <td>个人简介</td>
        <!--亦可框起 <td> <textarea name="profile" rows="10" cols="30" readonly><&#63;php echo $user['profile'] &#63;> </textarea> </td> -->
        <td> <&#63;php echo $user['profile'] &#63;> </td>
       </tr>
       <tr>
          <td colspan="2" align="center"><a href="userListt.php" >返回用户列表</a></td>
       </tr>
 </table>
      <p> </p>
      <p> </p>
      <p> </p>
</body>
</html>
Copy after login


<&#63;php
// 包含数据库文件
require_once 'inc/dbConn.php';
// 获取删除的id
$id = $_GET['id'];
$row = delete($id,$con);
if($row >=1){
  alert("删除成功");
}else{
  alert("删除失败");
}
// 跳转到用户列表页面
href("userListt.php");
function delete($id,$con){
  $sql = "delete from user where id='$id'";
  // 执行删除
  mysql_query($sql,$con);
  // 获取影响的行数
  $rows = mysql_affected_rows();
  // 返回影响行数
  return $rows;
}
function alert($title){
  echo "<script type='text/javascript'>alert('$title');</script>";
}
function href($url){
  echo "<script type='text/javascript'>window.location.href='$url'</script>";
}
&#63;>
Copy after login

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>新增用户</title>
</head>
<body>
<form action="addDo.php" method="post">
      <input type="hidden" name="user_id" value=" "/>
      <table width="444" border="1" align="center">
       <tr>
        <td>用户名 </td>
        <td> <input type="text" name="user_name" size="10" /></td>
       </tr>
       <tr>
        <td>密码</td>
        <td> <input type="password" name="password" size="10" /></td>
       </tr>
       <tr>
        <td>性别</td>
        <td> <input type="radio" name="sex" value="男" checked="checked" /> 男<input type="radio" name="sex" value="女" /> 女 </td>
       </tr>
       <tr>
        <td>年龄</td>
        <td> <input type="text" name="age" size="3" /></td>
       </tr>
       <tr>
        <td>出生年月</td>
        <td> 
          <select name="birthday_y">
          <option value="1980">1980</option>
          <option value="1981">1981</option>
          <option value="1982">1982</option>
          <option value="1983">1983</option>
          <option value="1984">1984</option>
          <option value="1985">1985</option>
          <option value="1986">1986</option>
          <option value="1987">1987</option>
          <option value="1988">1988</option>
          <option value="1989">1989</option>
          <option value="1990">1990</option>
          </select>
          年
          <select name="birthday_m">
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          <option value="6">6</option>
          <option value="7">7</option>
          <option value="8">8</option>
          <option value="9">9</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          </select>
          月
          <select name="birthday_d">
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          <option value="6">6</option>
          <option value="7">7</option>
          <option value="8">8</option>
          <option value="9">9</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="24">24</option>
          <option value="25">25</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
          </select>
          日
        </td>
       </tr>
       <tr>
        <td>爱好</td>
        <td> <input type="text" name="hobby" size="44" /></td>
       </tr>
       <tr>
        <td>个人简介</td>
        <td> <textarea name="profile" rows="10" cols="30"></textarea></td>
       </tr>
       <tr>
          <td colspan="2" align="center"><input type="submit" value="增加用户" /></td>
  </tr>
 </table>
      <p> </p>
      <p> </p>
      <p> </p>
</form>
</body>
</html>
Copy after login

<&#63;php 
require_once 'inc/dbConn.php';
////////////////////
///获取用户信息
////////////////////
$user_id = $_POST['user_id'];
$user_name = $_POST['user_name'];
echo $user_name;
$password= $_POST['password'];
if($_POST['sex']=='男')
{
  $sex=1;
}
else if($_POST['sex']=='女')
{
    $sex=2;
}
else $sex=3;    
;
$age = $_POST['age'];
$birthday_y = $_POST['birthday_y'];
$birthday_m = $_POST['birthday_m'];
$birthday_d = $_POST['birthday_d'];
$birthday=mktime(0,0,0,$birthday_m,$birthday_d,$birthday_y);
$hobby = $_POST['hobby'];
$profile = $_POST['profile'];
$addTime=mktime(date("h"),date("m"),date("s"),date("m"),date("d"),date("Y"));
$lastLoginTime=$addTime;
  $sql = "insert into user (username,password,sex,age,birthday,hobby,profile,add_time,last_login) ".
  "values('$user_name','$password','$sex','$age','$birthday','$hobby','$profile','$addTime','$lastLoginTime')";
  echo $sql;
  // 执行sql语句
  mysql_query($sql,$con);
  // 获取影响的行数
  $rows = mysql_affected_rows();
  // 返回影响行数
  // 如果影响行数>=1,则判断添加成功,否则失败
  if($rows >= 1){
    alert("添加成功");
    href("userListt.php");
  }else{
    alert("添加失败");
//   href("addUser.php");
    }
function alert($title){
  echo "<script type='text/javascript'>alert('$title');</script>";
}
function href($url){
  echo "<script type='text/javascript'>window.location.href='$url'</script>";
}
&#63;>
Copy after login

The above is the entire content of this article, I hope you all like it.

Please take a moment to share the article with your friends or leave a comment. We will sincerely thank you for your support!

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/972625.htmlTechArticlePHP MYSQL realizes user's addition, deletion, modification and query, mysql addition and deletion of file list. . File content. . dbconn.php userListt.php editUser.php editDo.php detailUser.php deleteUser.php addUser.php a...
Related labels：
mysql php Add, delete, modify and check
source：php.cn
Previous article：How to create multi-level directories in php, php creation_PHP tutorial Next article：How to load multiple views at one time in eigniter_PHP tutorial
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
Latest Articles by Author
Latest Issues
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Where should I place CustomLog directive in apache I'm using php:7.2-apachedocker. I need to disable health check url login access log. Based...
From 2024-04-06 22:03:59
0
1
990
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template