本文給大家分享的是使用PHP+MYSQL實現用戶的增刪改查功能的全部頁面代碼，非常的詳細，也很實用，適合php的初學者，有需要的小伙伴參考下。
文件列表。。文件內容。。
dbconn.php
userListt.php
editUser.php
editDo.php
detailUser.php
deleteUser.php
addUser.php
addDo.php
<dbconn.php>
? 1 2 3 4 5 6 <?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'); ?><userListt.php>
? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 <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> <?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?id=".$user['id']."');"> 刪</a> <a href='editUser.php?id=".$user['id']."');"> 改</a> <a href='detailUser.php?id=".$user['id']."');"> 查</a> </td> </tr> "; } ?> </table> </body> </html><editUser.php>
? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 <!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> <?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); ?> <form action="editDo.php" method="post"> <input type="hidden" name="user_id" value="<?php echo $user['id']?>"/> <table width="444" border="1" align="center"> <tr> <td>用戶名 </td> <td> <input type="text" name="user_name" size="10" value=<?php echo $user['username'] ?> /></td> </tr> <tr> <td>密碼</td> <td> <input type="password" name="password" size="10" value=<?php echo $user['password'] ?> /></td> </tr> <tr> <td>性別</td> <td> <input type="radio" name="sex" value="男" <?php if($user[sex]=='1') echo "checked="checked"" ?> /> 男<input type="radio" name="sex" value="女" <?php if($user[sex]=='2') echo "checked="checked"" ?> /> 女 </td> </tr> <tr> <td>年齡</td> <td> <input type="text" name="age" size="3" value=<?php echo $user['age'] ?> /></td> </tr> <tr> <td>出生年月</td> <td> <!-- 1。取得年月日。2。相應的年月日。。。你懂的 --> <?php $birday_y=date("Y",$user['birthday']); $birday_m=date("m",$user['birthday']); $birday_d=date("d",$user['birthday']); ?> <select name="birthday_y"> <option value="1980" <?php if($birday_y==1980) echo "selected="selected""; ?> >1980</option> <option value="1981" <?php if($birday_y==1981) echo "selected="selected""; ?> >1981</option> <option value="1982" <?php if($birday_y==1982) echo "selected="selected""; ?> >1982</option> <option value="1983" <?php if($birday_y==1983) echo "selected="selected""; ?> >1983</option> <option value="1984" <?php if($birday_y==1984) echo "selected="selected""; ?> >1984</option> <option value="1985" <?php if($birday_y==1985) echo "selected="selected""; ?> >1985</option> <option value="1986" <?php if($birday_y==1986) echo "selected="selected""; ?> >1986</option> <option value="1987" <?php if($birday_y==1987) echo "selected="selected""; ?> >1987</option> <option value="1988" <?php if($birday_y==1988) echo "selected="selected""; ?> >1988</option> <option value="1989" <?php if($birday_y==1989) echo "selected="selected""; ?> >1989</option> <option value="1990" <?php if($birday_y==1990) echo "selected="selected""; ?> >1990</option> </select> 年 <select name="birthday_m"> <option value="1" <?php if($birday_m==1) echo "selected="selected""; ?> >1</option> <option value="2" <?php if($birday_m==2) echo "selected="selected""; ?> >2</option> <option value="3" <?php if($birday_m==3) echo "selected="selected""; ?> >3</option> <option value="4" <?php if($birday_m==4) echo "selected="selected""; ?> >4</option> <option value="5" <?php if($birday_m==5) echo "selected="selected""; ?> >5</option> <option value="6" <?php if($birday_m==6) echo "selected="selected""; ?> >6</option> <option value="7" <?php if($birday_m==7) echo "selected="selected""; ?> >7</option> <option value="8" <?php if($birday_m==8) echo "selected="selected""; ?> >8</option> <option value="9" <?php if($birday_m==9) echo "selected="selected""; ?> >9</option> <option value="10" <?php if($birday_m==10) echo "selected="selected""; ?> >10</option> <option value="11" <?php if($birday_m==11) echo "selected="selected""; ?> >11</option> <option value="12" <?php if($birday_m==12) echo "selected="selected""; ?> >12</option> </select> 月 <select name="birthday_d"> <option value="1" <?php if($birday_d==1) echo "selected="selected""; ?> >1</option> <option value="2" <?php if($birday_d==2) echo "selected="selected""; ?> >2</option> <option value="3" <?php if($birday_d==3) echo "selected="selected""; ?> >3</option> <option value="4" <?php if($birday_d==4) echo "selected="selected""; ?> >4</option> <option value="5" <?php if($birday_d==5) echo "selected="selected""; ?> >5</option> <option value="6" <?php if($birday_d==6) echo "selected="selected""; ?> >6</option> <option value="7" <?php if($birday_d==7) echo "selected="selected""; ?> >7</option> <option value="8" <?php if($birday_d==8) echo "selected="selected""; ?> >8</option> <option value="9" <?php if($birday_d==9) echo "selected="selected""; ?> >9</option> <option value="10" <?php if($birday_d==10) echo "selected="selected""; ?> >10</option> <option value="11" <?php if($birday_d==11) echo "selected="selected""; ?> >11</option> <option value="12" <?php if($birday_d==12) echo "selected="selected""; ?> >12</option> <option value="13" <?php if($birday_d==13) echo "selected="selected""; ?> >13</option> <option value="14" <?php if($birday_d==14) echo "selected="selected""; ?> >14</option> <option value="15" <?php if($birday_d==15) echo "selected="selected""; ?> >15</option> <option value="16" <?php if($birday_d==16) echo "selected="selected""; ?> >16</option> <option value="17" <?php if($birday_d==17) echo "selected="selected""; ?> >17</option> <option value="18" <?php if($birday_d==18) echo "selected="selected""; ?> >18</option> <option value="19" <?php if($birday_d==19) echo "selected="selected""; ?> >19</option> <option value="20" <?php if($birday_d==20) echo "selected="selected""; ?> >20</option> <option value="21" <?php if($birday_d==21) echo "selected="selected""; ?> >21</option> <option value="22" <?php if($birday_d==22) echo "selected="selected""; ?> >22</option> <option value="23" <?php if($birday_d==23) echo "selected="selected""; ?> >23</option> <option value="24" <?php if($birday_d==24) echo "selected="selected""; ?> >24</option> <option value="25" <?php if($birday_d==25) echo "selected="selected""; ?> >25</option> <option value="26" <?php if($birday_d==26) echo "selected="selected""; ?> >26</option> <option value="27" <?php if($birday_d==27) echo "selected="selected""; ?> >27</option> <option value="28" <?php if($birday_d==28) echo "selected="selected""; ?> >28</option> <option value="29" <?php if($birday_d==29) echo "selected="selected""; ?> >29</option> <option value="30" <?php if($birday_d==30) echo "selected="selected""; ?> >30</option> <option value="31" <?php if($birday_d==31) echo "selected="selected""; ?> >31</option> </select> 日 </td> </tr> <tr> <td>愛好</td> <td> <input type="text" name="hobby" size="44" value=<?php echo $user['hobby'] ?> /></td> </tr> <tr> <td>個人簡介</td> <td> <textarea name="profile" rows="10" cols="30" ><?php echo $user['profile'] ?> </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><editDo.php>
? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 <?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>"; } ?><detailUser.php>
? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 <!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> <?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); ?> <table width="444" border="1" align="center"> <tr> <td>用戶ID </td> <td> <?php echo $userId ?> </td> </tr> <tr> <td>用戶名 </td> <td> <?php echo $user['username'] ?> </td> </tr> <tr> <td>密碼</td> <td> <?php echo $user['password'] ?> </td> </tr> <tr> <td>性別</td> <td> <?php if($user[sex]=='1') echo "男"; else if($user[sex]=='2') echo "女"; else "保密"; ?> </td> </tr> <tr> <td>年齡</td> <td> <?php echo $user['age'] ?> </td> </tr> <tr> <td>出生年月</td> <td> <!-- 1。取得年月日。2。相應的年月日。。。你懂的 --> <?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."日"; ?> </td> </tr> <tr> <td>愛好</td> <td> <?php echo $user['hobby'] ?> </td> </tr> <tr> <td>個人簡介</td> <!--亦可框起 <td> <textarea name="profile" rows="10" cols="30" readonly><?php echo $user['profile'] ?> </textarea> </td> --> <td> <?php echo $user['profile'] ?> </td> </tr> <tr> <td colspan="2" align="center"><a href="userListt.php" >返回用戶列表</a></td> </tr> </table> <p> </p> <p> </p> <p> </p> </body> </html><deleteUser.php>
? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 <?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>"; } ?><addUser.php>
? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 <!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><addDo.php>
? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 <?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>"; } ?>以上所述就是本文的全部內容了，希望大家能夠喜歡。
請您花一點時間將文章分享給您的朋友或者留下評論。我們將會由衷感謝您的支持！
