基于PHP實(shí)現(xiàn)個人博客網(wǎng)站

第基于PHP實(shí)現(xiàn)個人博客網(wǎng)站7、刪除博客

這里普通用戶和管理員的代碼時基本一樣的，首先判斷是否登錄，接著判斷是否為普通用戶，若是，則判斷要刪除的博客是否為自己的博客，若為管理員，則無需判斷是否為自己的博客。

php

session_start();

metaname="viewport"charset="utf-8"content="width=device-width,initial-scale=1.0"

php

if($_SESSION["adminName"]!=""){

require_once"config.inc.php";

$level=$_SESSION["level"];

$mail_blog=$_SESSION['mail_blog'];

$adminMail=$_SESSION["adminMail"];

$no_blog=$_SESSION['no_blog'];

if($level=='user'){

if($adminMail!=$mail_blog){

echo'scriptalert("無權(quán)限！");location="user_index.php";/script

}else{

$demand="deletefromblogwhereblogNo='$no_blog'";

$res=mysqli_query($mysqli,$demand);

if($res){//跳轉(zhuǎn)頁面

mysqli_close($mysqli);

echo'scriptalert("刪除博客成功");location="user_index.php";/script

}else{

mysqli_close($mysqli);

echo'scriptalert("刪除博客失敗");location="user_index.php";/script

}else{

$demand="deletefromblogwhereblogNo='$no_blog'";

$res=mysqli_query($mysqli,$demand);

if($res){//跳轉(zhuǎn)頁面

mysqli_close($mysqli);

echo'scriptalert("刪除博客成功");location="super_index.php";/script

}else{

mysqli_close($mysqli);

echo'scriptalert("刪除博客失敗");location="super_index.php";/script

}else{

echo'scriptalert("請先登錄！");location="signin.php";/script

8、發(fā)表評論

注意評論不能為空。

php

session_start();

metaname="viewport"charset="utf-8"content="width=device-width,initial-scale=1.0"

php

if($_SESSION["adminName"]!=""){

require_once"config.inc.php";

$email=$_SESSION['adminMail'];//用戶名

$blogNo=$_SESSION['no_blog'];//博客號

$new_comment=$_REQUEST['new_comment'];//新評論

date_default_timezone_set('Asia/Shanghai');//設(shè)置為北京時間

$commentDate=date('Y-m-dH:i:s');//自動獲取時間(年月日時間)

$demand="INSERTINTO`comment`(`commentContent`,`adminMail`,`blogNo`,`commentDate`)values('$new_comment','$email',$blogNo,'$commentDate')";

$insertComment=mysqli_query($mysqli,$demand);

if($insertComment){

echo'scriptalert("發(fā)表成功");location="user_index.php";/script

else{

echo'scriptalert("輸入錯誤！");location="user_index.php";/script

else{

echo'scriptalert("請先登錄！");location="signin.php";/script

9、修改密碼

首先判斷是否已經(jīng)登錄，接著判斷新密碼和第二次輸入的新密碼是否一致，再判斷原密碼是否正確。

php

session_start();

metaname="viewport"charset="utf-8"content="width=device-width,initial-scale=1.0"

php

if($_SESSION["adminName"]!=""){

require_once"config.inc.php";

$email=$_SESSION['adminMail'];//用戶名

$real_pwd=$_SESSION['passWord'];//真實(shí)密碼

$past_pwd=$_REQUEST['past_pwd'];//原密碼

$new_pwd=$_REQUEST['new_pwd'];//新密碼

$pwd=$_REQUEST['new_pwd_2'];//第二次新密碼

if($new_pwd==$pwd){

if($real_pwd==$past_pwd){

$sql="updateadminsetpassword='$pwd'whereadminMail='$email'";

$updatepwd=mysqli_query($mysqli,$sql);

if($updatepwd){

echo'scriptalert("密碼修改成功，請重新登錄");location="signin.php";/script

}else{

echo'scriptalert("未知錯誤！");location="user_update_pwd.php";/script

}else{

echo'scriptalert("原密碼輸入錯誤！");location="user_update_pwd.php";/script

}else{

echo'scriptalert("兩次密碼輸入不相同！");location="user_update_pwd.php";/script

}else{

echo'scriptalert("請先登錄！");location="signin.php";/script

10、修改昵稱

php

session_start();

metaname="viewport"charset="utf-8"content="width=device-width,initial-scale=1.0"

php

if($_SESSION["adminName"]!=""){

require_once"config.inc.php";

$email=$_SESSION['adminMail'];//用戶名

$new_name=$_REQUEST['new_name'];//新昵稱

$sql="updateadminsetadminName='$new_name'whereadminMail='$email'";

$updatename=mysqli_query($mysqli,$sql);

if($updatename){

$_SESSION["adminName"]=$new_name;

echo'scriptalert("昵稱修改成功");location="user_index.php";/script

}else{

echo'scriptalert("輸入錯誤！");location="user_update_name.php";/script

}else{

echo'scriptalert("請先登錄！");location="signin.php";/script

11、管理員刪除用戶

需要注意的是，刪除用戶的同時會刪除有關(guān)他的所有信息，包括他發(fā)表的博客和評論。

php

session_start();

metaname="viewport"charset="utf-8"content="width=device-width,initial-scale=1.0"

php

if($_SESSION["adminName"]!=""){

require_once"config.inc.php";

$admai=$_GET['delete_mail'];

$sql="deletefromadminwhereadminMail='$admai'";

$delete=mysqli_query($mysqli,$sql);

$sql2="deletefromblogwhereadminMail='$admai'";

$delete2=mysqli_query($mysqli,$sql2);

$sql3="deletefromcommentwhereadminMail='$admai'";

$delete2=mysqli_query($mysqli,$sql3);

echo'scriptalert("刪除成功");location="super_user.php";/script

}else{

echo'scriptalert("請先登錄！");location="signin.php";/script

四、運(yùn)行環(huán)境

APMServ5.2.6forWindows2000/XP/2003

五、運(yùn)行說明

1、以管理員身份運(yùn)行APMServ，啟動服務(wù)器，點(diǎn)擊管理MySQL數(shù)據(jù)庫；

2、將數(shù)據(jù)庫設(shè)計(jì)源碼（.sql文件）中的數(shù)據(jù)導(dǎo)入數(shù)據(jù)庫當(dāng)中；

3、最后點(diǎn)擊訪問用戶本地網(wǎng)站，找到我們解壓