简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Rumah > php教程 > php手册 > teks badan

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

WBOY
Lepaskan： 2016-06-13 08:51:21
asal
892 orang telah melayarinya

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

文件列表。。文件内容。。
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;>
Salin selepas log masuk

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>
Salin selepas log masuk

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>
Salin selepas log masuk

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;>
Salin selepas log masuk

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>
Salin selepas log masuk

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;>
Salin selepas log masuk

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>
Salin selepas log masuk

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;>
Salin selepas log masuk

Label berkaitan：
mysql数据库 php 用户管理
sumber：php.cn
Artikel sebelumnya：深入理解PHP内核（二）之SAPI探究，深入理解sapi Artikel seterusnya：如何使用PHP Embed SAPI实现Opcodes查看器，sapiopcodes
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Artikel terbaru oleh pengarang
Isu terkini
Tatasusunan PHP yang diperoleh daripada parameter URL tidak berkelakuan seperti yang diharapkan Saya mempunyai parameter URL yang mengandungi id kategori dan saya mahu menganggapnya seba...
daripada 2024-04-06 22:09:02
0
1
1428
Di mana saya harus meletakkan arahan CustomLog dalam apache Saya menggunakan php:7.2-apachedocker. Saya perlu melumpuhkan log akses log masuk url sema...
daripada 2024-04-06 22:03:59
0
1
990
Apakah format pembolehubah dalam nilai pulangan? Saya seorang pelajar baru php. Saya menjumpai sekeping kod: if($x<time()){return[false,...
daripada 2024-04-06 21:55:20
0
1
778
Masalah yang dihadapi apabila menggunakan opentbs untuk menjana fail odt: nilai kunci yang sama dipaparkan dalam baris yang sama dan bukannya lajur yang berasingan. Saya menggunakan perpustakaan yang dipanggil OpenTbs untuk mencipta odt menggunakan PHP, s...
daripada 2024-04-06 20:18:18
0
1
483
Kumpulkan hasil MySQL mengikut ID untuk menggelung Saya mempunyai jadual dengan data penerbangan dalam mysql. Saya sedang menulis kod php yan...
daripada 2024-04-06 17:27:56
0
1
406
Topik-topik yang berkaitan
Lagi>
Cadangan popular
Tutorial Popular
Lagi>
Tutorial berkaitan
Cadangan popular
Kursus terkini
Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan
Tentang kita Penafian Sitemap
Laman web PHP Cina：Latihan PHP dalam talian kebajikan awam，Bantu pelajar PHP berkembang dengan cepat！