PHP+MYSQL实现用户的增删改查_php教程

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

本文给大家分享的是使用PHP+MYSQL实现用户的增删改查功能的全部页面代码，非常的详细，也很实用，适合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');

<userListt.php>

<html>

<head>

<title>会员信息列表</title>

</head>

<body>

<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['username']."</td>

<td> ".$user['password']."</td>

<td> ".date("Y-m-d",$user['birthday'])."</td>

<td> ".$user['hobby']."</td>

<td> ".date("Y-m-d",$user['last_login'])."</td>

</td>

</tr>

}

</table>

</body>

</html>

<editUser.php>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

</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);

<tr>

</tr>

<tr>

</tr>

<tr>

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

</tr>

<tr>

<td>

<?php

$birday_y=date("Y",$user['birthday']);

$birday_m=date("m",$user['birthday']);

$birday_d=date("d",$user['birthday']);

</select>

年

</select>

月

</select>

日

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</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">

<head>

<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);

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</td>

</tr>

<tr>

</tr>

<tr>

<td>

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

</tr>

<tr>

</tr>

<tr>

<td colspan="2" align="center"><a href="userListt.php" >返回用户列表</a></td>

</tr>

</table>

</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>

100

101

102

103

104

105

106

107

108

109

110

111

112

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

</head>

<body>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>

</select>

年

</select>

月

</select>

日

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</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+MYSQL实现用户的增删改查

相关文章

PHP之友评论