数据库连接操作 用户管理
1.数据库连接 用户管理
<php>
文件列表。。文件内容。。
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');
?>
</dbconn.php>
<userlistt.php><meta>
<title>会员信息列表</title>
<table>
<tr>
<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>增</a>
<a> 删</a>
<a> 改</a>
<a> 查</a>
</td>
";
}
?>
</table>
</userlistt.php>
<edituser.php>
html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta>
<title>编辑用户</title>
<?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>
<input>"/>
<table>
<tr>
<td>用户名 </td>
<td> <input> /></td>
</tr>
<tr>
<td>密码</td>
<td> <input> /></td>
</tr>
<tr>
<td>性别</td>
<td> <input> /> 男<input>
/> 女 </td>
</tr>
<tr>
<td>年龄</td>
<td> <input> /></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>
<option> >1980</option>
<option> >1981</option>
<option> >1982</option>
<option> >1983</option>
<option> >1984</option>
<option> >1985</option>
<option> >1986</option>
<option> >1987</option>
<option> >1988</option>
<option> >1989</option>
<option> >1990</option>
</select>
年
<select>
<option> >1</option>
<option> >2</option>
<option> >3</option>
<option> >4</option>
<option> >5</option>
<option> >6</option>
<option> >7</option>
<option> >8</option>
<option> >9</option>
<option> >10</option>
<option> >11</option>
<option> >12</option>
</select>
月
<select>
<option> >1</option>
<option> >2</option>
<option> >3</option>
<option> >4</option>
<option> >5</option>
<option> >6</option>
<option> >7</option>
<option> >8</option>
<option> >9</option>
<option> >10</option>
<option> >11</option>
<option> >12</option>
<option> >13</option>
<option> >14</option>
<option> >15</option>
<option> >16</option>
<option> >17</option>
<option> >18</option>
<option> >19</option>
<option> >20</option>
<option> >21</option>
<option> >22</option>
<option> >23</option>
<option> >24</option>
<option> >25</option>
<option> >26</option>
<option> >27</option>
<option> >28</option>
<option> >29</option>
<option> >30</option>
<option> >31</option>
</select>
日
</td>
</tr>
<tr>
<td>爱好</td>
<td> <input> /></td>
</tr>
<tr>
<td>个人简介</td>
<td> <textarea><?php echo $user['profile'] ?> </textarea> </td>
</tr>
<tr>
<td><input></td>
</tr>
</table>
<p> </p><div class="aritcle_card flexRow artxards">
<div class="artcardd flexRow">
<a class="aritcle_card_img" rel="nofollow" href="/ai/3803" title="造梦次元"><img
src="https://img.php.cn/upload/ai_manual/001/246/273/178599574646852.png" alt="造梦次元" onerror="this.onerror='';this.src='/static/lhimages/moren/morentu.png'" ></a>
<div class="aritcle_card_info flexColumn">
<a rel="nofollow" href="/ai/3803" title="造梦次元" class="overflowclass">造梦次元</a>
<p class="overflowclass">造梦次元是一款内容运营工具,AI互动内容平台,虚拟角色逗你开心。</p>
</div>
<a rel="nofollow" href="/ai/3803" title="造梦次元" class="aritcle_card_btn flexRow flexcenter"><b></b><span>下载</span>
</a>
</div>
</div>
<p> </p>
<p> </p>
</form>
</edituser.php>
<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>alert('$title');</script>";
}
function href($url){
echo "<script>window.location.href='$url'</script>";
}
?>
</editdo.php>
<detailuser.php>html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta>
<title>查看用户明细</title>
<?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>
<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><a>返回用户列表</a></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</detailuser.php>
<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>alert('$title');</script>";
}
function href($url){
echo "<script>window.location.href='$url'</script>";
}
?>
</deleteuser.php>
<adduser.php>html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta>
<title>新增用户</title>
<form>
<input>
<table>
<tr>
<td>用户名 </td>
<td> <input>
</td>
</tr>
<tr>
<td>密码</td>
<td> <input>
</td>
</tr>
<tr>
<td>性别</td>
<td> <input> 男<input> 女 </td>
</tr>
<tr>
<td>年龄</td>
<td> <input>
</td>
</tr>
<tr>
<td>出生年月</td>
<td>
<select>
<option>1980</option>
<option>1981</option>
<option>1982</option>
<option>1983</option>
<option>1984</option>
<option>1985</option>
<option>1986</option>
<option>1987</option>
<option>1988</option>
<option>1989</option>
<option>1990</option>
</select>
年
<select>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
</select>
月
<select>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
日
</td>
</tr>
<tr>
<td>爱好</td>
<td> <input>
</td>
</tr>
<tr>
<td>个人简介</td>
<td> <textarea></textarea>
</td>
</tr>
<tr>
<td><input></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</form>
</adduser.php>
<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>alert('$title');</script>";
}
function href($url){
echo "<script>window.location.href='$url'</script>";
}
?>
</adddo.php></php>+MYSQL用户增删改查小练手>










