修改 删除用户修改 删除用户.doc

此文档教你如何修改用户，删除用户信息 **删除用户信息 1：gindex.php(界面) 2：delete.php(包含删除用户) 1：gindex.php(界面) !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head meta http-equiv=Content-Type content=text/html; charset=utf-8 / title无标题文档/title /head body ?php include lianjie.php;//引入lianjie页面 con(); $sql=select * from users; $result1=mysql_query($sql); //执行一条SQL语句 $zong=mysql_num_rows($result1); //返回数据库中表中信息的总行数 $psize=2; //每页中含有的信息条数 $lianjie=gindex.php; if(isset($_GET[pnum])) //$pum=页码 { $pnum=$_GET[pnum]; } else $pnum=2; //假如从第3页开始分析，($pum-1)表示第二页，($pum-1)*$psize表示第二页显示的条数； //limit2,3---表示从第二条记录开始，添加三条记录 $sql2=select * from users limit .($pnum-1)*$psize.,.$psize; $result2=mysql_query($sql2); mysql_close(); ? p用户管理/p table width=610 height=67 border=0 tr td width=91用户名/td td width=61密码/td td width=120真实姓名/td td width=120手机号码/td td width=59邮箱/td td width=63nbsp;/td td width=66nbsp;/td /tr ?php while($row=mysql_fetch_row($result2)) //mysql_fetch_row()---是返回结果集中逐行获取记录 { ? tr td?php echo $row[1];?/td td?php echo $row[2];?/td td?php echo $row[3];?/td td?php echo $row[4];?/td td?php echo $row[5];?/td tda href=update.php?userId=?php echo $row[0];?修改/a/td tda href=delete.php?userId=?php echo $row[0];?删除/a/td /tr ?php } ? /table table width=610 height=36 border=0 tr td height=32 align=center?php fenye($zong,$psize,$lianjie);? /td /tr /table /body /html 2：delete.php(包含删除用户) !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head meta http-equiv=Content-Type content=text/html; charset=utf-8 / title无标题文档/title /head ?php includelianjie.php; $userId=$_GET[userId]; con(); $con=mysql_connect(localhost,root,); $del_sql=delete from users