php實現mysql數據庫連接操作及用戶管理

2024-04-25 20:43:06

字體：大中小

來源：轉載

供稿：網友

文件列表。。文件內容。。

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

<!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='$pr

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

<!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中注冊器模式類用法實例分析

下一篇：php實現分頁顯示

學習交流

硬盤分區如何設置準確的分區空間

硬盤分區如何設置準確的分區空間...

熱門圖片

猜你喜歡的新聞

猜你喜歡的關注

新聞熱點

英偉達市值一夜大漲9246億創2023年5月以來最大單周漲幅

2024-04-27 13:35:46

雷軍：小米正在申請3萬件專利，以提升自身的競爭力

2024-04-27 13:33:47

人參泡酒15年后竟“復活”？網友：這酒還能喝不？

2024-04-24 22:53:44

芯片股普漲！英偉達市值一夜大漲6000億元

2024-04-23 19:32:50

面館老板1天賣100碗剛夠交房租要賣到150碗才能實現盈利

2024-04-23 19:25:50

跌近30%！茶百道上市一小時跌沒3年凈利潤

2024-04-23 19:13:19

疑難解答

圖片精選

網友關注