PHP+MYSQL实现用户的增删改查
文件列表。。文件内容。。
dbconn.php
userListt.php
editUser.php
editDo.php
detailUser.php
deleteUser.php
addUser.php
addDo.php
<dbconn.php>
<?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>
<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>
<!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>
<?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>
<!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>
<?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>
<!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>
<?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>\";
}
?>
以上所述就是本文的全部内容了，希望大家能够喜欢。
请您花一点时间将文章分享给您的朋友或者留下评论。我们将会由衷感谢您的支持！
本文地址：https://www.stayed.cn/item/5894
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我
我的博客
人生若只如初见，何事秋风悲画扇。
我的标签
随笔档案
- 2024-02(2)
- 2023-06(1)
- 2023-05(1)
- 2023-04(14)
- 2023-03(3)
- 2023-01(6)
- 2022-12(5)
- 2022-11(5)
- 2022-07(2)
- 2022-06(4)
- 2022-05(3)
- 2022-03(1)
- 2021-12(6)
- 2021-11(1)
- 2021-10(3)
- 2021-09(5)
- 2021-07(5)
- 2021-02(2)
- 2021-01(7)
- 2020-12(18)
- 2020-11(14)
- 2020-10(12)
- 2020-09(10)
- 2020-08(22)
- 2020-07(2)
- 2020-06(1)
- 2020-04(5)
- 2020-03(9)
- 2020-02(7)
- 2020-01(9)
- 2019-12(8)
- 2019-11(10)
- 2019-10(11)
- 2019-09(17)
- 2019-08(16)
- 2019-07(6)
- 2019-06(3)
- 2019-04(1)
- 2019-03(8)
- 2019-02(5)
- 2019-01(1)
- 2018-11(2)
- 2018-10(3)
- 2018-09(1)
- 2018-08(3)
- 2018-07(3)
- 2018-06(7)
- 2018-04(4)
- 2018-03(5)
- 2018-02(4)
- 2018-01(22)
- 2017-12(3)
- 2017-11(5)
- 2017-10(15)
- 2017-09(26)
- 2017-08(1)
- 2017-07(3)