PHP+MYSQL实现用户的增删改查_

1、PHP+MYSQL实现用户的增删改查_ 本文给大家分享的是用法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:.mysq

2、l_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 tdi

3、d/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)

4、$userList = $rs; / 循环用户列表 foreach ($userList as $user) echo tr td .$userid./td td .$userusername./td td .$userpassword./td td .$usersex./td td .$userage./td td .date(Y-m-d,$userbirthday)./td td .$userhobby./td td .date(Y-m-d,$useradd_time)./td td .date(Y-m-d,$userlast_login)./td td a href=addUser.ph

5、p增/a a href=deleteUser.php?id=.$userid.); 删/a a href=editUser.php?id=.$userid.); 改/a a href=detailUser.php?id=.$userid.); 查/a /td /tr ; ? /table /body /html editUser.php !DOCTYPE html PUBLIC -/W3C/DTD XHTML 1.0 Transitional/EN html xmlns= head meta http-equiv=Content-Type content=text/html; charset=

6、utf-8 / title编辑用户/title /head body ?php require_once inc/dbConn.php; $userId=$_GETid; /这是啥东东。 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=hidde

7、n name=user_id value=?php echo $userid?/ table width=444 border=1 align=center tr td用户名 /td td input type=text name=user_name size=10 value=?php echo $userusername ? /td /tr tr td密码/td td input type=password name=password size=10 value=?php echo $userpassword ? /td /tr tr td性别/td td input type=radio

8、 name=sex value=男 ?php if($usersex=1) echo checked=checked ? / 男input type=radio name=sex value=女 ?php if($usersex=2) echo checked=checked ? / 女 /td /tr tr td年龄/td td input type=text name=age size=3 value=?php echo $userage ? /td /tr tr td诞生年月/td td !- 1。取得年月日。2。相应的年月日。你懂的 - ?php $birday_y=date(Y,$u

9、serbirthday); $birday_m=date(m,$userbirthday); $birday_d=date(d,$userbirthday); ? 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

10、=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=19

11、86 ?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/op

12、tion 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

13、 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=select

14、ed; ? 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/op

15、tion 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 selec

16、ted=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; ?

17、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 o

18、ption 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 optio

19、n 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 va

20、lue=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=

21、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 ?

22、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

23、td爱好/td td input type=text name=hobby size=44 value=?php echo $userhobby ? /td /tr tr td个人简介/td td textarea name=profile rows=10 cols=30 ?php echo $userprofile ? /textarea /td /tr tr td colspan=2 align=centerinput type=submit value=确定修改 /td /tr /table p /p p /p p /p /form /body /html editDo.php ?php

24、 require_once inc/dbConn.php; / /猎取用户信息 / $user_id = $_POSTuser_id; $user_name = $_POSTuser_name; $password= $_POSTpassword; if($_POSTsex=男) $sex=1; else if($_POSTsex=女) $sex=2; else $sex=3; ; $age = $_POSTage; $birthday_y = $_POSTbirthday_y; $birthday_m = $_POSTbirthday_m; $birthday_d = $_POSTbirth

25、day_d; $birthday=mktime(0,0,0,$birthday_m,$birthday_d,$birthday_y); $hobby = $_POSThobby; $profile = $_POSTprofile; $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=$birt

26、hday,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=

27、text/javascriptalert($title);/script; function href($url) echo script type=text/javascriptwindow.location.href=$url/script; ? detailUser.php !DOCTYPE html PUBLIC -/W3C/DTD XHTML 1.0 Transitional/EN html xmlns= head meta http-equiv=Content-Type content=text/html; charset=utf-8 / title查看用户明细/title /he

28、ad body ?php require_once inc/dbConn.php; $userId=$_GETid; /这是啥东东。 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

29、 /tr tr td用户名 /td td ?php echo $userusername ? /td /tr tr td密码/td td ?php echo $userpassword ? /td /tr tr td性别/td td ?php if($usersex=1) echo 男; else if($usersex=2) echo 女; else 保密; ? /td /tr tr td年龄/td td ?php echo $userage ? /td /tr tr td诞生年月/td td !- 1。取得年月日。2。相应的年月日。你懂的 - ?php $birday_y=date(Y,$

30、userbirthday);echo $birday_y.年; $birday_m=date(m,$userbirthday);echo $birday_m.月; $birday_d=date(d,$userbirthday);echo $birday_d.日; ? /td /tr tr td爱好/td td ?php echo $userhobby ? /td /tr tr td个人简介/td !-亦可框起 td textarea name=profile rows=10 cols=30 readonly?php echo $userprofile ? /textarea /td - td

31、?php echo $userprofile ? /td /tr tr td colspan=2 align=centera 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 = $_GETid; $row = delete($id,$con); if($row =1) alert(删除胜利); else alert(删除失败); / 跳转到用户列表页面 href

32、(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/javascriptalert($title);/script; function href($url) echo script type=text/java

33、scriptwindow.location.href=$url/script; ? addUser.php !DOCTYPE html PUBLIC -/W3C/DTD XHTML 1.0 Transitional/EN html xmlns= 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 w

34、idth=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

35、 name=age size=3 /td /tr tr td诞生年月/td td select name=birthday_y option value=19801980/option option value=19811981/option option value=19821982/option option value=19831983/option option value=19841984/option option value=19851985/option option value=19861986/option option value=19871987/option opti

36、on value=19881988/option option value=19891989/option option value=19901990/option /select 年 select name=birthday_m option value=11/option option value=22/option option value=33/option option value=44/option option value=55/option option value=66/option option value=77/option option value=88/option

37、option value=99/option option value=1010/option option value=1111/option option value=1212/option /select 月 select name=birthday_d option value=11/option option value=22/option option value=33/option option value=44/option option value=55/option option value=66/option option value=77/option option v

38、alue=88/option option value=99/option option value=1010/option option value=1111/option option value=1212/option option value=1313/option option value=1414/option option value=1515/option option value=1616/option option value=1717/option option value=1818/option option value=1919/option option value

39、=2020/option option value=2121/option option value=2222/option option value=2323/option option value=2424/option option value=2525/option option value=2626/option option value=2727/option option value=2828/option option value=2929/option option value=3030/option option value=3131/option /select 日 /td /tr tr td爱好/td td input type=text name=hobby size=44 /td /tr tr td个人简介/td td textarea name=profile r