PHP+Access设计留言版实战

添加时间:2007-4-22　

以下是postfunction.php文件的内容：

<?php
function postfunction($user="",$qq="",$title="",$ly="",$id=0,$rep="",$mode=1){
$ubb_file="images/ubbimages";
if($mode==1){
$form_action_file="post.php";
}else{
$form_action_file="admin.php?doaction=editor";
}
if($qq)
{
$qq="";}
?>
<form action="<?=$form_action_file?>" method="post" name="newform" id="newform">
<label>昵称:<input name="user" type="text" size="10" maxlength="10" value="<?=$user?>"/>QICQ:<input name="qq" type="text" size="10" maxlength="10" value="<?=$qq?>"/></label>
<label>主题:<input name="title" type="text" size="35" maxlength="30"   value="<?=htmlspecialchars($title)?>" /></label>
<script src="js/ubbcode.js"></script>
<script language="JavaScript" src="js/common.js" type="text/javascript"></script></label>
<label>字体:<SELECT name="font" onchange="FontChange('font',this.options[this.selectedIndex].value)">
<option value="宋体" selected>宋体</option>
<option value="楷体_GB2312">楷体</option>
<option value="新宋体">新宋体</option>
<option value="黑体">黑体</option>
<option value="隶书">隶书</option>
<OPTION value="Andale Mono">Andale Mono</OPTION>
<OPTION value=Arial>Arial</OPTION>
<OPTION value="Arial Black">Arial Black</OPTION>
<OPTION value="Book Antiqua">Book Antiqua</OPTION>
<OPTION value="Century Gothic">Century Gothic</OPTION>
<OPTION value="Comic Sans MS">Comic Sans MS</OPTION>
<OPTION value="Courier New">Courier New</OPTION>
<OPTION value=Georgia>Georgia</OPTION>
<OPTION value=Impact>Impact</OPTION>
<OPTION value=Tahoma>Tahoma</OPTION>
<OPTION value="Times New Roman">Times New Roman</OPTION>
<OPTION value="Trebuchet MS">Trebuchet MS</OPTION>
<OPTION value="Script MT Bold">Script MT Bold</OPTION>
<OPTION value=Stencil>Stencil</OPTION>
<OPTION value=Verdana>Verdana</OPTION>
<OPTION value="Lucida Console">Lucida Console</OPTION>
</SELECT>字体大小：<select name="size" onChange="FontChange('size',this.options[this.selectedIndex].value)">
<option value="1">1</option>
<option value="2" SELECTED>2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
颜色：
<SELECT name="color" onchange="FontChange('color',this.options[this.selectedIndex].value)">
<option style="background-color:#F0F8FF;color: #F0F8FF" value="#F0F8FF">#F0F8FF</option>
<option style="background-color:#FAEBD7;color: #FAEBD7" value="#FAEBD7">#FAEBD7</option>
<option style="background-color:#00FFFF;color: #00FFFF" value="#00FFFF">#00FFFF</option>
<option style="background-color:#7FFFD4;color: #7FFFD4" value="#7FFFD4">#7FFFD4</option>
<option style="background-color:#F0FFFF;color: #F0FFFF" value="#F0FFFF">#F0FFFF</option>
<option style="background-color:#F5F5DC;color: #F5F5DC" value="#F5F5DC">#F5F5DC</option>
<option style="background-color:#FFE4C4;color: #FFE4C4" value="#FFE4C4">#FFE4C4</option>
<option style="background-color:#000000;color: #000000" value="#000000" SELECTED>#000000</option>
<option style="background-color:#FFEBCD;color: #FFEBCD" value="#FFEBCD">#FFEBCD</option>
<option style="background-color:#0000FF;color: #0000FF" value="#0000FF">#0000FF</option>
<option style="background-color:#8A2BE2;color: #8A2BE2" value="#8A2BE2">#8A2BE2</option>
<option style="background-color:#A52A2A;color: #A52A2A" value="#A52A2A">#A52A2A</option>
<option style="background-color:#DEB887;color: #DEB887" value="#DEB887">#DEB887</option>
<option style="background-color:#5F9EA0;color: #5F9EA0" value="#5F9EA0">#5F9EA0</option>
<option style="background-color:#7FFF00;color: #7FFF00" value="#7FFF00">#7FFF00</option>
<option style="background-color:#D2691E;color: #D2691E" value="#D2691E">#D2691E</option>
<option style="background-color:#FF7F50;color: #FF7F50" value="#FF7F50">#FF7F50</option>
<option style="background-color:#6495ED;color: #6495ED" value="#6495ED">#6495ED</option>
<option style="background-color:#FFF8DC;color: #FFF8DC" value="#FFF8DC">#FFF8DC</option>
<option style="background-color:#DC143C;color: #DC143C" value="#DC143C">#DC143C</option>
<option style="background-color:#00FFFF;color: #00FFFF" value="#00FFFF">#00FFFF</option>
<option style="background-color:#00008B;color: #00008B" value="#00008B">#00008B</option>
<option style="background-color:#008B8B;color: #008B8B" value="#008B8B">#008B8B</option>
<option style="background-color:#B8860B;color: #B8860B" value="#B8860B">#B8860B</option>
<option style="background-color:#A9A9A9;color: #A9A9A9" value="#A9A9A9">#A9A9A9</option>
<option style="background-color:#006400;color: #006400" value="#006400">#006400</option>
<option style="background-color:#BDB76B;color: #BDB76B" value="#BDB76B">#BDB76B</option>
<option style="background-color:#8B008B;color: #8B008B" value="#8B008B">#8B008B</option>
<option style="background-color:#556B2F;color: #556B2F" value="#556B2F">#556B2F</option>
<option style="background-color:#FF8C00;color: #FF8C00" value="#FF8C00">#FF8C00</option>
<option style="background-color:#9932CC;color: #9932CC" value="#9932CC">#9932CC</option>
<option style="background-color:#8B0000;color: #8B0000" value="#8B0000">#8B0000</option>
<option style="background-color:#E9967A;color: #E9967A" value="#E9967A">#E9967A</option>
<option style="background-color:#8FBC8F;color: #8FBC8F" value="#8FBC8F">#8FBC8F</option>
<option style="background-color:#483D8B;color: #483D8B" value="#483D8B">#483D8B</option>
<option style="background-color:#2F4F4F;color: #2F4F4F" value="#2F4F4F">#2F4F4F</option>
<option style="background-color:#00CED1;color: #00CED1" value="#00CED1">#00CED1</option>
<option style="background-color:#9400D3;color: #9400D3" value="#9400D3">#9400D3</option>
<option style="background-color:#FF1493;color: #FF1493" value="#FF1493">#FF1493</option>
<option style="background-color:#00BFFF;color: #00BFFF" value="#00BFFF">#00BFFF</option>
<option style="background-color:#696969;color: #696969" value="#696969">#696969</option>
<option style="background-color:#1E90FF;color: #1E90FF" value="#1E90FF">#1E90FF</option>
<option style="background-color:#B22222;color: #B22222" value="#B22222">#B22222</option>
<option style="background-color:#FFFAF0;color: #FFFAF0" value="#FFFAF0">#FFFAF0</option>
<option style="background-color:#228B22;color: #228B22" value="#228B22">#228B22</option>
<option style="background-color:#FF00FF;color: #FF00FF" value="#FF00FF">#FF00FF</option>
<option style="background-color:#DCDCDC;color: #DCDCDC" value="#DCDCDC">#DCDCDC</option>
<option style="background-color:#F8F8FF;color: #F8F8FF" value="#F8F8FF">#F8F8FF</option>
<option style="background-color:#FFD700;color: #FFD700" value="#FFD700">#FFD700</option>
<option style="background-color:#DAA520;color: #DAA520" value="#DAA520">#DAA520</option>
<option style="background-color:#808080;color: #808080" value="#808080">#808080</option>
<option style="background-color:#008000;color: #008000" value="#008000">#008000</option>
<option style="background-color:#ADFF2F;color: #ADFF2F" value="#ADFF2F">#ADFF2F</option>
<option style="background-color:#F0FFF0;color: #F0FFF0" value="#F0FFF0">#F0FFF0</option>
<option style="background-color:#FF69B4;color: #FF69B4" value="#FF69B4">#FF69B4</option>
<option style="background-color:#CD5C5C;color: #CD5C5C" value="#CD5C5C">#CD5C5C</option>
<option style="background-color:#4B0082;color: #4B0082" value="#4B0082">#4B0082</option>
<option style="background-color:#FFFFF0;color: #FFFFF0" value="#FFFFF0">#FFFFF0</option>
<option style="background-color:#F0E68C;color: #F0E68C" value="#F0E68C">#F0E68C</option>
<option style="background-color:#E6E6FA;color: #E6E6FA" value="#E6E6FA">#E6E6FA</option>
<option style="background-color:#FFF0F5;color: #FFF0F5" value="#FFF0F5">#FFF0F5</option>
<option style="background-color:#7CFC00;color: #7CFC00" value="#7CFC00">#7CFC00</option>
<option style="background-color:#FFFACD;color: #FFFACD" value="#FFFACD">#FFFACD</option>
<option style="background-color:#ADD8E6;color: #ADD8E6" value="#ADD8E6">#ADD8E6</option>
<option style="background-color:#F08080;color: #F08080" value="#F08080">#F08080</option>
<option style="background-color:#E0FFFF;color: #E0FFFF" value="#E0FFFF">#E0FFFF</option>
<option style="background-color:#FAFAD2;color: #FAFAD2" value="#FAFAD2">#FAFAD2</option>
<option style="background-color:#90EE90;color: #90EE90" value="#90EE90">#90EE90</option>
<option style="background-color:#D3D3D3;color: #D3D3D3" value="#D3D3D3">#D3D3D3</option>
<option style="background-color:#FFB6C1;color: #FFB6C1" value="#FFB6C1">#FFB6C1</option>
<option style="background-color:#FFA07A;color: #FFA07A" value="#FFA07A">#FFA07A</option>
<option style="background-color:#20B2AA;color: #20B2AA" value="#20B2AA">#20B2AA</option>
<option style="background-color:#87CEFA;color: #87CEFA" value="#87CEFA">#87CEFA</option>
<option style="background-color:#778899;color: #778899" value="#778899">#778899</option>
<option style="background-color:#B0C4DE;color: #B0C4DE" value="#B0C4DE">#B0C4DE</option>
<option style="background-color:#FFFFE0;color: #FFFFE0" value="#FFFFE0">#FFFFE0</option>
<option style="background-color:#00FF00;color: #00FF00" value="#00FF00">#00FF00</option>
<option style="background-color:#32CD32;color: #32CD32" value="#32CD32">#32CD32</option>
<option style="background-color:#FAF0E6;color: #FAF0E6" value="#FAF0E6">#FAF0E6</option>
<option style="background-color:#FF00FF;color: #FF00FF" value="#FF00FF">#FF00FF</option>
<option style="background-color:#800000;color: #800000" value="#800000">#800000</option>
<option style="background-color:#66CDAA;color: #66CDAA" value="#66CDAA">#66CDAA</option>
<option style="background-color:#0000CD;color: #0000CD" value="#0000CD">#0000CD</option>
<option style="background-color:#BA55D3;color: #BA55D3" value="#BA55D3">#BA55D3</option>
<option style="background-color:#9370DB;color: #9370DB" value="#9370DB">#9370DB</option>
<option style="background-color:#3CB371;color: #3CB371" value="#3CB371">#3CB371</option>
<option style="background-color:#7B68EE;color: #7B68EE" value="#7B68EE">#7B68EE</option>
<option style="background-color:#00FA9A;color: #00FA9A" value="#00FA9A">#00FA9A</option>
<option style="background-color:#48D1CC;color: #48D1CC" value="#48D1CC">#48D1CC</option>
<option style="background-color:#C71585;color: #C71585" value="#C71585">#C71585</option>
<option style="background-color:#191970;color: #191970" value="#191970">#191970</option>
<option style="background-color:#F5FFFA;color: #F5FFFA" value="#F5FFFA">#F5FFFA</option>
<option style="background-color:#FFE4E1;color: #FFE4E1" value="#FFE4E1">#FFE4E1</option>
<option style="background-color:#FFE4B5;color: #FFE4B5" value="#FFE4B5">#FFE4B5</option>
<option style="background-color:#FFDEAD;color: #FFDEAD" value="#FFDEAD">#FFDEAD</option>
<option style="background-color:#000080;color: #000080" value="#000080">#000080</option>
<option style="background-color:#FDF5E6;color: #FDF5E6" value="#FDF5E6">#FDF5E6</option>
<option style="background-color:#808000;color: #808000" value="#808000">#808000</option>
<option style="background-color:#6B8E23;color: #6B8E23" value="#6B8E23">#6B8E23</option>
<option style="background-color:#FFA500;color: #FFA500" value="#FFA500">#FFA500</option>
<option style="background-color:#FF4500;color: #FF4500" value="#FF4500">#FF4500</option>
<option style="background-color:#DA70D6;color: #DA70D6" value="#DA70D6">#DA70D6</option>
<option style="background-color:#EEE8AA;color: #EEE8AA" value="#EEE8AA">#EEE8AA</option>
<option style="background-color:#98FB98;color: #98FB98" value="#98FB98">#98FB98</option>
<option style="background-color:#AFEEEE;color: #AFEEEE" value="#AFEEEE">#AFEEEE</option>
<option style="background-color:#DB7093;color: #DB7093" value="#DB7093">#DB7093</option>
<option style="background-color:#FFEFD5;color: #FFEFD5" value="#FFEFD5">#FFEFD5</option>
<option style="background-color:#FFDAB9;color: #FFDAB9" value="#FFDAB9">#FFDAB9</option>
<option style="background-color:#CD853F;color: #CD853F" value="#CD853F">#CD853F</option>
<option style="background-color:#FFC0CB;color: #FFC0CB" value="#FFC0CB">#FFC0CB</option>
<option style="background-color:#DDA0DD;color: #DDA0DD" value="#DDA0DD">#DDA0DD</option>
<option style="background-color:#B0E0E6;color: #B0E0E6" value="#B0E0E6">#B0E0E6</option>
<option style="background-color:#800080;color: #800080" value="#800080">#800080</option>
<option style="background-color:#FF0000;color: #FF0000" value="#FF0000">#FF0000</option>
<option style="background-color:#BC8F8F;color: #BC8F8F" value="#BC8F8F">#BC8F8F</option>
<option style="background-color:#4169E1;color: #4169E1" value="#4169E1">#4169E1</option>
<option style="background-color:#8B4513;color: #8B4513" value="#8B4513">#8B4513</option>
<option style="background-color:#FA8072;color: #FA8072" value="#FA8072">#FA8072</option>
<option style="background-color:#F4A460;color: #F4A460" value="#F4A460">#F4A460</option>
<option style="background-color:#2E8B57;color: #2E8B57" value="#2E8B57">#2E8B57</option>
<option style="background-color:#FFF5EE;color: #FFF5EE" value="#FFF5EE">#FFF5EE</option>
<option style="background-color:#A0522D;color: #A0522D" value="#A0522D">#A0522D</option>
<option style="background-color:#C0C0C0;color: #C0C0C0" value="#C0C0C0">#C0C0C0</option>
<option style="background-color:#87CEEB;color: #87CEEB" value="#87CEEB">#87CEEB</option>
<option style="background-color:#6A5ACD;color: #6A5ACD" value="#6A5ACD">#6A5ACD</option>
<option style="background-color:#708090;color: #708090" value="#708090">#708090</option>
<option style="background-color:#FFFAFA;color: #FFFAFA" value="#FFFAFA">#FFFAFA</option>
<option style="background-color:#00FF7F;color: #00FF7F" value="#00FF7F">#00FF7F</option>
<option style="background-color:#4682B4;color: #4682B4" value="#4682B4">#4682B4</option>
<option style="background-color:#D2B48C;color: #D2B48C" value="#D2B48C">#D2B48C</option>
<option style="background-color:#008080;color: #008080" value="#008080">#008080</option>
<option style="background-color:#D8BFD8;color: #D8BFD8" value="#D8BFD8">#D8BFD8</option>
<option style="background-color:#FF6347;color: #FF6347" value="#FF6347">#FF6347</option>
<option style="background-color:#40E0D0;color: #40E0D0" value="#40E0D0">#40E0D0</option>
<option style="background-color:#EE82EE;color: #EE82EE" value="#EE82EE">#EE82EE</option>
<option style="background-color:#F5DEB3;color: #F5DEB3" value="#F5DEB3">#F5DEB3</option>
<option style="background-color:#FFFFFF;color: #FFFFFF" value="#FFFFFF">#FFFFFF</option>
<option style="background-color:#F5F5F5;color: #F5F5F5" value="#F5F5F5">#F5F5F5</option>
<option style="background-color:#FFFF00;color: #FFFF00" value="#FFFF00">#FFFF00</option>
<option style="background-color:#9ACD32;color: #9ACD32" value="#9ACD32">#9ACD32</option>
</SELECT></label>
<label><img onclick="FontType('[B]','[/B]')" src="<?=$ubb_file?>/ubb_bold.gif" width="22" alt="粗体"/>
<img onclick="FontType('[I]','[/I]')" src="<?=$ubb_file?>/ubb_italicize.gif" alt="斜体"/>
<img onclick="FontType('[U]','[/U]')" src="<?=$ubb_file?>/ubb_underline.gif" alt="下划线"/>
<img onclick="FontType('[align=cener]','[/align]')" src="<?=$ubb_file?>/ubb_center.gif" alt="居中"/>
<img onclick="Curl()" src="<?=$ubb_file?>/ubb_url.gif" alt="超级连接"/>
<img onclick="Cemail()" src="<?=$ubb_file?>/ubb_email.gif" alt="Email连接"/>
<img onclick="Cimage()" src="<?=$ubb_file?>/ubb_image.gif" alt="图片"/>
<img onclick="FontType('{code1}')" src="<?=$ubb_file?>/ubb_code.gif" alt="代码"/>
<img onclick="Cswf()" src="<?=$ubb_file?>/ubb_swf.gif" alt="Flash图片"/>
<img onclick="Cdir()" src="<?=$ubb_file?>/ubb_Shockwave.gif" alt="Shockwave文件"/>
<img onclick="Crm()" src="<?=$ubb_file?>/ubb_rm.gif" alt="realplay视频文件"/>
<img onclick="Cwmv()" src="<?=$ubb_file?>/ubb_mp.gif" alt="Media Player视频文件"/>
<img onclick="Cmov()" src="<?=$ubb_file?>/ubb_qt.gif" alt="QuickTime视频文件"/>
<img onclick="FontType('[quote]','[/quote]')" src="<?=$ubb_file?>/ubb_quote.gif" alt="引用"/>
</label><label>
<textarea name="ly" rows="6" cols="45"   rows="8" wrap="VIRTUAL"><?=$ly?> </textarea></label>
<?
  if ($mode<>1){?>
<label><textarea name="rep" rows="6" cols="45" rows="8" wrap="VIRTUAL" > <?=$rep?></textarea>
<input name="id" type="hidden" size="20" maxlength="20"   value="<?=$id?>" /></label>
<?}?>
<label><input maxlength="20" type="submit" name="Submit" value=" 我要保存" > </label>
</form>
<?}?>

这里我主要是考虑到管理员编辑留言的时候要用到这个表单的,增加了2个参数,mode和id,如果mode不是1的话就是编辑页面,action的处理文件也不一样,还输出隐藏的id选项。

1、如果写信息留言的话，显示如下：

PHP+Access设计留言版实战

2、如果管理员回复留言的就是这个界面：

PHP+Access设计留言版实战

admin.php :

<?php
require_once('inc/config.php');
require_once(confign_path.'header.php');
?>
<div id="show_c">
<?

function showf($mode=1){
if ($mode==1)
{$admin_f="admin.php";}
else
{
$admin_f="admin.php?doaction=sys";
}
?>
<form action="<?=$admin_f?>" method="post" name="newform" id="newform">
<label>用户:<input name="username" type="text" size="10" maxlength="10" /></label>
<label>密码:<input name="password" type="text" size="20" maxlength="10" /></label>
<label><input maxlength="20" type="submit" name="Submit" value=" 登陆" > </label>
</form>
<?}?>

<?php

$admin = false;
session_start();
if (isset($_SESSION["admin"]) )
{
echo "<h4>您已经成功登陆--></h4>";

if(isset($_GET['doaction']))
{
$doaction = $_GET['doaction'];
    switch($doaction){
     case 'sys':
      echo"系统设置-->";
     if($Submit)
     {
    foreach ($posts as $key => $value)
{ $posts[$key] = trim($value); }
$password=md5($password);
$conn->execute("update [php_admin] set [szd_user]='$username',[szd_password]='$password'");
    echo "成功,2秒后返回";
    echo "<meta http-equiv=\"refresh\" content=\"1;URL=admin.php\">";

     }else{
     showf(2);
     }

     break;
    case 'logout':
    session_start();
     unset($_SESSION["admin"]);
    header('location:index.php');
    die;
    break;
    case 'delete':
    $conn->execute("delete * from [php_guest] where id=$id") ;
    echo "删除成功,2秒后返回";
    echo "<meta http-equiv=\"refresh\" content=\"1;URL=index.php\">";
    die;
    break;
    case 'editor':

    if($Submit)
     { $posts = $_POST;
      foreach ($posts as $key => $value)
      { $posts[$key] = trim($value);

}

     $conn->execute("update [php_guest] set [szd_user]='$user',[szd_title]='$title',[szd_qq]='$qq',[szd_content]='$ly',[szd_rep]='$rep' where id=$id");
     header("location:index.php");
     }

    else
     {
    $rs=$conn->execute("select * from [php_guest] where id=$id");
    if($rs->eof and $rs->bof){
     header("location:index.php");
     die;}
       require_once('postfunction.php');
   postfunction($rs->fields[1],$rs->fields[3],$rs->fields[2],$rs->fields[4],$rs->fields[0],$rs->fields[6],2); }

     default:
     break;

   }
}else
{
?>
<ul>
<li><a href="?doaction=sys">系统设置</a></li>
<li><a href="?doaction=logout">退出登陆</a></li>
</ul>
<?}
}
else
{
?>
<?php
if($Submit){
    $posts = $_POST;
    foreach ($posts as $key => $value)
    {
        $posts[$key] = trim($value);
    }
    $password = md5($posts["password"]);
    $username = $posts["username"];
if (empty($password)||empty($username))
{echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">";
echo "<script language=javaScript> \n alert(\"输入必要的信息\") \n</script>";
echo "<script language=javascript>javascript:history.back()</script>";
exit();}

$query = "SELECT id FROM [php_admin] WHERE [szd_password] = '$password' and [szd_user]='$username'";
$userInfo = $conn->execute($query);

    if (!($userInfo->eof and $userInfo->bof ))
    {
            session_start();
            $_SESSION["admin"] = 1;
header('location:admin.php');

    }
    else
    {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">";
echo "<script language=javaScript> \n alert(\"密码错误或者用户名错误\") \n</script>";
echo "<script language=javascript>javascript:history.back()</script>";
exit();
    }
}
else
{
showf();
}
?>
<?}?>
</div>
<?php
require_once(confign_path.'footer.php');
?>

下面解释:

function showf($mode=1){
//--------------------->这个小函数是输出管理员登陆表单的,2中模式,和发表留言的思路一样
    if ($mode==1)
    {$admin_f="admin.php";}
    else
        {
    $admin_f="admin.php?doaction=sys";
    }
?>
<form action="<?=$admin_f?>" method="post" name="newform" id="newform">
<label>用户:<input name="username" type="text" size="10" maxlength="10" /></label>
<label>密码:<input name="password" type="text" size="20" maxlength="10" /></label>
<label><input maxlength="20" type="submit" name="Submit" value=" 登陆" > </label>
</form>
<?}?>

<?php
$admin = false;
//--------------------->防止全局变量造成安全隐患
session_start();
//--------------------->启动会话，这步必不可少

if (isset($_SESSION["admin"]) )
{
//--------------------->判断是否登陆,如果session["admin"]不为空,已经登陆.深度是 1
echo "<h4>您已经成功登陆--></h4>";

        if(isset($_GET['doaction']))
    {
        //--------------------->登陆成功后,提交字段action不为空时执行,深度 2

        $doaction = $_GET['doaction'];
         switch($doaction){
             case 'sys':
//--------------------->登陆成功后,提交字段action为"sys"执行,深度 3

                 echo"系统设置-->";
             if($Submit)
             {
            foreach ($posts as $key => $value)
        { $posts[$key] = trim($value); }
        $password=md5($password);
    $conn->execute("update [php_admin] set [szd_user]='$username',[szd_password]='$password'");
                echo "成功,2秒后返回";
                echo "<meta http-equiv=\"refresh\" content=\"1;URL=admin.php\">";
             }else{
             showf(2);
             }
             break;
                case 'logout':
//--------------------->登陆成功后,提交字段action为"logout"执行清除session,深度 3

                session_start();
                 unset($_SESSION["admin"]);
                header('location:index.php');
                die;
                break;
                case 'delete':
//--------------------->登陆成功后,提交字段action为"delete"执行删除留言,深度 3
                $conn->execute("delete * from [php_guest] where id=$id") ;
                echo "删除成功,2秒后返回";
                echo "<meta http-equiv=\"refresh\" content=\"1;URL=index.php\">";
                die;
                break;
                case 'editor':
//--------------------->登陆成功后,提交字段action为"editor"执行编辑留言,深度 3
                if($Submit)
             {
//--------------------->登陆成功后,提交字段action为"editor"而且表单已经提交时执行,深度 4

                    $posts = $_POST;
                     foreach ($posts as $key => $value)
                 { $posts[$key] = trim($value);

    }
             $conn->execute("update [php_guest] set [szd_user]='$user',[szd_title]='$title',[szd_qq]='$qq',[szd_content]='$ly',[szd_rep]='$rep' where id=$id");
             header("location:index.php");
             }
                else
             {
//--------------------->登陆成功后,提交字段action为"editor"而且表单已经没有执行,深度 4
                $rs=$conn->execute("select * from [php_guest] where id=$id");
                if($rs->eof and $rs->bof){
                    header("location:index.php");
                    die;}
                        require_once('postfunction.php');
            postfunction($rs->fields[1],$rs->fields[3],$rs->fields[2],$rs->fields[4],$rs->fields[0],$rs->fields[6],2); }

             default:
             break;

            }
    }else
    {
//--------------------->登陆成功后,提交字段action为空时执行,深度 2

?>
<ul>
    <li><a href="?doaction=sys">系统设置</a></li>
    <li><a href="?doaction=logout">退出登陆</a></li>
</ul>
<?}
}
else
{
//--------------------->判断:如果session["admin"]为空,没登陆.深度是 1
?>
<?php
if($Submit){
    //--------------------->判断表单提交后.深度是 2

$posts = $_POST;
        //--------------------->清除一些空白符号.深度是 3
foreach ($posts as $key => $value)
{
$posts[$key] = trim($value);
}
$password = md5($posts["password"]);
//--------------------->自带md5加密

$username = $posts["username"];
if (empty($password)||empty($username))
{echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">";
echo "<script language=javaScript> \n alert(\"输入必要的信息\") \n</script>";
echo "<script language=javascript>javascript:history.back()</script>";
exit();}

$query = "SELECT id FROM [php_admin] WHERE [szd_password] = '$password' and [szd_user]='$username'";
$userInfo = $conn->execute($query);
    //--------------------->取得查询结果,深度是 4
if (!($userInfo->eof and $userInfo->bof ))
{
//--------------------->如果有符合输入的记录,登陆成功
session_start();
//--------------------->当验证通过后，启动 Session
$_SESSION["admin"] = 1;
//--------------------->登陆成功的 admin 变量，并赋值 1
            header('location:admin.php');
}
else
{
    //--------------------->如果发生eof 和 bof 错误,用户名或者密码错,报错,深度是 4
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">";
echo "<script language=javaScript> \n alert(\"密码错误或者用户名错误\") \n</script>";
echo "<script language=javascript>javascript:history.back()</script>";
exit();
}
}
else
{
//--------------------->用户没登陆而且表单没提交,输出表单.深度是 2
showf();
}
?>
<?}?>

如图，管理员没登陆：

PHP+Access设计留言版实战

管理员登陆成功：

PHP+Access设计留言版实战

管理员登陆成功以后首页出现了超连接：

PHP+Access设计留言版实战

function ubb($Text) {
$Text=htmlspecialchars($Text);
$Text=ereg_replace("\r\n","<br>",$Text);
$Text=ereg_replace("\r","<br>",$Text);
$Text=nl2br($Text);
$Text=preg_replace("/\\t/is"," ",$Text);
$Text=preg_replace("/\[h1\](.+?)\[\/h1\]/is","<h1>\\1</h1>",$Text);
$Text=preg_replace("/\[h2\](.+?)\[\/h2\]/is","<h2>\\1</h2>",$Text);
$Text=preg_replace("/\[h3\](.+?)\[\/h3\]/is","<h3>\\1</h3>",$Text);
$Text=preg_replace("/\[h4\](.+?)\[\/h4\]/is","<h4>\\1</h4>",$Text);
$Text=preg_replace("/\[h5\](.+?)\[\/h5\]/is","<h5>\\1</h5>",$Text);
$Text=preg_replace("/\[h6\](.+?)\[\/h6\]/is","<h6>\\1</h6>",$Text);
$Text=preg_replace("/\[url\](http:\/\/.+?)\[\/url\]/is","<a href=\\1>\\1</a>",$Text);
$Text=preg_replace("/\[url\](.+?)\[\/url\]/is","<a href=\"http://\\1\">http://\\1</a>",$Text);
$Text=preg_replace("/\[url=(http:\/\/.+?)\](.*)\[\/url\]/is","<a href=\\1>\\2</a>",$Text);
$Text=preg_replace("/\[url=(.+?)\](.*)\[\/url\]/is","<a href=http://\\1>\\2</a>",$Text);
$Text=preg_replace("/\[img\](.+?)\[\/img\]/is","<img src=\\1>",$Text);
$Text=preg_replace("/\[color=(.+?)\](.+?)\[\/color\]/is","<font color=\\1>\\2</font>",$Text);
$Text=preg_replace("/\[size=(.+?)\](.+?)\[\/size\]/is","<font size=\\1>\\2</font>",$Text);
$Text=preg_replace("/\[sup\](.+?)\[\/sup\]/is","<sup>\\1</sup>",$Text);
$Text=preg_replace("/\[sub\](.+?)\[\/sub\]/is","<sub>\\1</sub>",$Text);
$Text=preg_replace("/\[pre\](.+?)\[\/pre\]/is","<pre>\\1</pre>",$Text);
$Text=preg_replace("/\[email\](.+?)\[\/email\]/is","<a href=mailto:\\1>\\1</a>",$Text);
$Text=preg_replace("/\[i\](.+?)\[\/i\]/is","<i>\\1</i>",$Text);
$Text=preg_replace("/\[b\](.+?)\[\/b\]/is","<b>\\1</b>",$Text);
$Text=preg_replace("/\[quote\](.+?)\[\/quote\]/is","<blockquote><font size='1' face='Courier New'>quote:</font><hr>\\1<hr></blockquote>", $Text);
$Text=preg_replace("/\[code\](.+?)\[\/code\]/is","<blockquote><font size='1' face='Times New Roman'>code:</font><hr color='lightblue'><i>\\1</i><hr color='lightblue'></blockquote>", $Text);
$Text=preg_replace("/\[sig\](.+?)\[\/sig\]/is","<div style='text-align: left; color: darkgreen; margin-left: 5%'><br><br>--------------------------<br>\\1<br>--------------------------</div>", $Text);
return $Text;
}

使用的时候,把要UBB显示的字符串这样写：

<?=ubb($str)?>

没啥解释的,我也不太明白,不说了,这段是抄的代码,好了,加到inc/function.php里面就行了。

上一页

作者：5do8 来源：蓝色理想 (责任编辑:ninedns)

请您留言

1122（124.227.*.* 2008-8-29）

不错

唐润康（218.75.*.* 2007-12-10）

我想学习怎样编程

唐润康（218.75.*.* 2007-12-10）

我想编程

收藏：PHP+Access设计留言版实战