Gemeinschaft Lernen Tools-Bibliothek Freizeit
suchen
Deutsch
Heim > Backend-Entwicklung > PHP-Tutorial > php实现mysql数据库连接操作及用户管理_php技巧

php实现mysql数据库连接操作及用户管理_php技巧

WBOY
Freigeben： 2016-05-16 20:05:10
Original
1222 Leute haben es durchsucht

文件列表。。文件内容。。
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;>
Nach dem Login kopieren

userListt.php

<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>
Nach dem Login kopieren

editUser.php

<!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>
Nach dem Login kopieren

editDo.php

<&#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;>
Nach dem Login kopieren

detailUser.php

<!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>
Nach dem Login kopieren

deleteUser.php

<&#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;>
Nach dem Login kopieren

addUser.php

<!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>
Nach dem Login kopieren

addDo.php

<&#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;>
Nach dem Login kopieren

Verwandte Etiketten：
php操作mysql数据库 php用户管理
Quelle：php.cn
Vorheriger Artikel：PHP递归创建多级目录_php技巧 Nächster Artikel：php实现处理输入转义字符的代码_php技巧
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Neueste Artikel des Autors
Aktuelle Ausgaben
Gruppieren Sie MySQL-Ergebnisse nach ID für die Schleife Ich habe eine Tabelle mit Flugdaten in MySQL. Ich schreibe einen PHP-Code, der Daten mithi...
Aus 2024-04-06 17:27:56
0
1
406
Möglichkeit, ASP Classic-Code als String in der MYSQL-Datenbank zu speichern Ist es möglich, klassischen ASP-Code in einer MySQL-Datenbank zu speichern und ihn beim Ab...
Aus 2024-04-06 13:38:43
0
1
358
Probleme mit der Verbindung zwischen dem Gesichtserkennungsterminal iVMS-4200 und der Basis Das Gesichtserkennungsterminal iVMS-4200 zeigt beim Herstellen einer Verbindung zur MySQL-...
Aus 2024-04-06 12:20:33
0
1
347
**Fehlertyp: „NoneType'-Objekt kann nicht iteriert werden** Ich möchte den SSH-Tunnel verwenden, um auf die MySQL-Datenbank zuzugreifen. Leider schein...
Aus 2024-04-06 10:26:38
0
1
378
Gruppieren Sie Benutzer (Gesamtbenutzer, Administratorbenutzer, Kontrolloperatoren, Wachen) mithilfe von Eloquent-Abfragen Ich habe eine Abfrage, die alle Benutzer zählt, die Gesamtzahl der Benutzer mit der Rolle ...
Aus 2024-04-05 12:11:26
0
1
332
verwandte Themen
Mehr>
Beliebte Empfehlungen
Beliebte Tutorials
Mehr>
Verwandte Tutorials
Beliebte Empfehlungen
Aktuelle Kurse
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage