php实现mysql数据库连接操作及用户管理,mysql数据库连接_PHP教程
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>"; } ?>

핫 AI 도구

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

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

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

Clothoff.io
AI 옷 제거제

AI Hentai Generator
AI Hentai를 무료로 생성하십시오.

인기 기사

뜨거운 도구

메모장++7.3.1
사용하기 쉬운 무료 코드 편집기

SublimeText3 중국어 버전
중국어 버전, 사용하기 매우 쉽습니다.

스튜디오 13.0.1 보내기
강력한 PHP 통합 개발 환경

드림위버 CS6
시각적 웹 개발 도구

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

뜨거운 주제











이번 장에서는 CakePHP의 환경 변수, 일반 구성, 데이터베이스 구성, 이메일 구성에 대해 알아봅니다.

PHP 8.4는 상당한 양의 기능 중단 및 제거를 통해 몇 가지 새로운 기능, 보안 개선 및 성능 개선을 제공합니다. 이 가이드에서는 Ubuntu, Debian 또는 해당 파생 제품에서 PHP 8.4를 설치하거나 PHP 8.4로 업그레이드하는 방법을 설명합니다.

CakePHP는 PHP용 오픈 소스 프레임워크입니다. 이는 애플리케이션을 훨씬 쉽게 개발, 배포 및 유지 관리할 수 있도록 하기 위한 것입니다. CakePHP는 강력하고 이해하기 쉬운 MVC와 유사한 아키텍처를 기반으로 합니다. 모델, 뷰 및 컨트롤러 gu

VS Code라고도 알려진 Visual Studio Code는 모든 주요 운영 체제에서 사용할 수 있는 무료 소스 코드 편집기 또는 통합 개발 환경(IDE)입니다. 다양한 프로그래밍 언어에 대한 대규모 확장 모음을 통해 VS Code는
