php实现mysql数据库连接操作及用户管理,mysql数据库连接
文件列表。。文件内容。。
dbconn.php
userListt.php
editUser.php
editDo.php
detailUser.php
deleteUser.php
addUser.php
addDo.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>"; } ?>

PHP에서는 session_status () 또는 session_id ()를 사용하여 세션이 시작되었는지 확인할 수 있습니다. 1) session_status () 함수를 사용하십시오. php_session_active가 반환되면 세션이 시작되었습니다. 2) session_id () 함수를 사용하십시오. 비어 있지 않은 문자열이 반환되면 세션이 시작되었습니다. 두 방법 모두 세션 상태를 효과적으로 확인할 수 있으며 사용할 방법을 선택하면 PHP 버전 및 개인 선호도에 따라 다릅니다.

SessionSareVitalInWebApplications, 특히 상수도가 포함되어 있습니다.

PHP에서 동시 세션 액세스 관리 다음 방법으로 수행 할 수 있습니다. 1. 데이터베이스를 사용하여 세션 데이터를 저장하십시오. 이러한 방법은 데이터 일관성을 보장하고 동시성 성능을 향상시키는 데 도움이됩니다.

phpsessionshaveseverallimitations : 1) StorageConstraintsCanleadToperFormanceIssues; 2) SecurityVulnerabilitiesSessionFixationAtCATACKSEXIST; 3) 확장 성분이 ANCHALLENGINGDUETOSERVERS-SCIFICSTORAGE; 4) SessionExpirationManagementCanbeproblematic; 5) Datapersis

로드 밸런싱은 세션 관리에 영향을 미치지 만 세션 복제, 세션 끈적임 및 중앙 집중식 세션 스토리지로 해결할 수 있습니다. 1. 세션 복제 복사 서버 간의 세션 데이터. 2. 세션 끈은 사용자 요청을 동일한 서버로 안내합니다. 3. 중앙 집중식 세션 스토리지는 Redis와 같은 독립 서버를 사용하여 세션 데이터를 저장하여 데이터 공유를 보장합니다.

SessionLockingIsateChniqueSureDureauser의 SessionLockingSsessionRemainSexclusivetoOneuseratatime.itiscrucialforpreptingdatacorruptionandsecurityBreachesInmulti-userApplications.sessionLockingSogingSompletEdusingserVerver-sidelockingMegynisms, unrasprantlockinj

PHP 세션의 대안에는 쿠키, 토큰 기반 인증, 데이터베이스 기반 세션 및 Redis/Memcached가 포함됩니다. 1. Cookies는 클라이언트에 데이터를 저장하여 세션을 관리합니다. 이는 단순하지만 보안이 적습니다. 2. Token 기반 인증은 토큰을 사용하여 사용자를 확인합니다. 이는 매우 안전하지만 추가 논리가 필요합니다. 3. Database 기반 세션은 데이터베이스에 데이터를 저장하여 확장 성이 좋지만 성능에 영향을 줄 수 있습니다. 4. Redis/Memcached는 분산 캐시를 사용하여 성능 및 확장 성을 향상하지만 추가 일치가 필요합니다.

SessionHijacking은 사용자의 SessionID를 얻음으로써 사용자를 가장하는 공격자를 말합니다. 예방 방법은 다음과 같습니다. 1) HTTPS를 사용한 의사 소통 암호화; 2) SessionID의 출처를 확인; 3) 보안 세션 생성 알고리즘 사용; 4) 정기적으로 SessionID를 업데이트합니다.


핫 AI 도구

Undresser.AI Undress
사실적인 누드 사진을 만들기 위한 AI 기반 앱

AI Clothes Remover
사진에서 옷을 제거하는 온라인 AI 도구입니다.

Undress AI Tool
무료로 이미지를 벗다

Clothoff.io
AI 옷 제거제

Video Face Swap
완전히 무료인 AI 얼굴 교환 도구를 사용하여 모든 비디오의 얼굴을 쉽게 바꾸세요!

인기 기사

뜨거운 도구

Atom Editor Mac 버전 다운로드
가장 인기 있는 오픈 소스 편집기

에디트플러스 중국어 크랙 버전
작은 크기, 구문 강조, 코드 프롬프트 기능을 지원하지 않음

SublimeText3 Mac 버전
신 수준의 코드 편집 소프트웨어(SublimeText3)

안전한 시험 브라우저
안전한 시험 브라우저는 온라인 시험을 안전하게 치르기 위한 보안 브라우저 환경입니다. 이 소프트웨어는 모든 컴퓨터를 안전한 워크스테이션으로 바꿔줍니다. 이는 모든 유틸리티에 대한 액세스를 제어하고 학생들이 승인되지 않은 리소스를 사용하는 것을 방지합니다.

Eclipse용 SAP NetWeaver 서버 어댑터
Eclipse를 SAP NetWeaver 애플리케이션 서버와 통합합니다.
