PHP的bbs實現之二

1. on_ok.php

<?
include “header.inc.php”;
?>
<!–HTML的頭定義–>
<HTML>
<HEAD>
   <META http-equiv=”Content-Type” content=”text/html; charset=gb2312″>
</HEAD>

<BODY>
<!–滾動顯示提示資訊–>
<marquee scrolldelay=”165″ class=myYellow bgcolor=green>
歡迎光臨金風社群&nbsp&nbsp&nbsp&nbsp&nbsp
這是我們的PHP樂園&nbsp&nbsp&nbsp&nbsp&nbsp
希望您能喜歡它～&nbsp&nbsp&nbsp&nbsp&nbsp
</marquee>
<!–顯示一面迎風飄揚的旗幟作為歡迎資訊–>
<img src=”images/flag.gif” align=left>
<!–顯示本頁面的大標題–>
<h2 align=center color=red>
   金風社群歡迎您！
</h2>
<!–顯示一條紅色的水平的分隔線–>
<hr color=red>
<!–顯示歡迎資訊–>
<p align=center>
<FONT color=red size=5 align=center>
   <b>
     &nbsp&nbsp&nbsp&nbsp您已經成功了！恭喜恭喜
   </b>
</FONT>
</p>
<!–顯示歡迎資訊–>
<p align=center>
<FONT color=red size=5 align=center>
   <b>
     <?echo $ok_info ?>
   </b>
</FONT>
</p>
<!–提示使用者繼續進行選擇–>
<p align=center>
   <FONT color=red size=5 align=center>
      <b>
        &nbsp&nbsp請選擇繼續或者退回
      </b>
   </FONT>
</p>
<!–對最下面的按鈕進行說明–>
<p align=center>
    <FONT color=green size=4>
      <b>
        &nbsp&nbsp選擇左邊的按鈕繼續登記
      </b>
    </FONT>
    <FONT color=green size=4>
      <b>
        &nbsp&nbsp選擇右邊的按鈕退回到主介面
      </b>
    </FONT>
</p>
<!–顯示兩個動態的按鈕–>
<div align=center>
      <a href=”bookin.php”>
        <image src=”images/continue.gif” align=center border=0></a>
      <a href=”mainform.php”>
        <image src=”images/quit.gif” align=center border=0></a>
</div>
</BODY>
</HTML>

2. login.php

<?
include “common.inc.php”;

function User_Password($log_id)
{
global $USER_LOG_TABLE;

$SQL=”SELECT password FROM $USER_LOG_TABLE WHERE log_id=`$log_id`”;

$result=mysql_query($SQL) or die(mysql_error());
$row=mysql_fetch_Array($result);

return($row[password]);
}

function AddOneUser()
{
global $USER_LOG_TABLE,$USER_ONLINE_TABLE,$REMOTE_ADDR;
global $log_id,$nicker,$log_count,$log_time;
global $arc_count,$gender,$level,$right,$exp_count,$log_ip;

$log_time=time();
$log_ip=$REMOTE_ADDR;

$SQL=”DELETE FROM $USER_ONLINE_TABLE WHERE log_id=`$log_id`”;
mysql_query($SQL) or die(mysql_error());

$SQL=”SELECT * FROM $USER_LOG_TABLE WHERE log_id=`$log_id`”;
$result=mysql_query($SQL) or die(mysql_error());
$row=mysql_fetch_Array($result);

$nicker=$row[nicker];
$log_count=$row[log_count];
$arc_count=$row[arc_count];
$gender=$row[gender];
$level=$row[level];
$right=$row[right];
$exp_count=$row[exp_count];

$SQL=”INSERT INTO $USER_ONLINE_TABLE (
          log_id,nicker,log_count,log_time,arc_count,
          gender,level,right,exp_count,log_ip
        ) VALUES (
          `$log_id`,`$nicker`,`$log_count`,`$log_time`,
          `$arc_count`,`$gender`,`$level`,`$right`,`$exp_count`,`$log_ip`
        )”;

mysql_query($SQL) or die(mysql_error());
}

function CheckNicker($nicker_input)
{
global $USER_LOG_TABLE;
global $nicker,$log_id;

$SQL=”SELECT * FROM $USER_LOG_TABLE WHERE nicker=`$nicker_input`”;

$result=mysql_query($SQL) or die(mysql_error());
$row=mysql_fetch_Array($result);

$log_id=$row[log_id];
$nicker=$row[nicker];

if (!$row[nicker]) return “error!”;
}

if ($Ok) {

if (!$username) $error=”使用者名稱不能為空”;

if(CheckNicker($username)) $error=”使用者名稱不存在”;

if (!$password) $error=”請輸入你的密碼”;

    if (!isset($error))
    {
      $p=User_Password($log_id);
      if ($password!=$p) $error=”密碼不正確”;
    }

   if (!isset($error))
   {
           AddOneUser();
           header(“Location: on_ok.php?log_id=$log_id/n”);
   }
   else
       header(“Location: login_error.php?error=$error/n”);
}
include “header.inc.php”;
?>

<BODY>

<FORM METHOD=”POST” ACTION=”<? echo $PHP_SELF; ?>”>
<TABLE width=60% border=0 align=center bgcolor=yellow>
    <TR bgcolor=green>
      <TD height=20 align=center>
           <FONT class=myYellow>
             請認真輸入您的暱稱和密碼！
          </FONT>
      </TD>
    </TR>

    <TR >
      <TD height=50 align=center>使用者名稱：
        <INPUT type=text name=username size=20 maxlength=20>
      </TD>
    </TR>

    <TR>
      <TD height=30 width=18% align=center>密　碼：
        <INPUT type=password name=password size=20 maxlength=10>
      </TD>
    </TR>

    <TR>
      <TD height=20 align=center>
        <INPUT type=submit name=Ok value=” 傳送 ” class=myBlack>        　　　　　　　　　　　
        <INPUT type=button name=Back value=” 返回 ” class=myBlack
            onClick=JavaScript:history.back()>
      </TD>
    </TR>

</TABLE>
</FORM>

</BODY>
</HTML>

3.bookin.php

<?
include “common.inc.php”;

function ReadUserAttr() {
global $USER_ATTR_TABLE,$USER_LOG_TABLE;
global $log_id,$nicker,$realname,$email,$address,$birthday,
         $oicq,$last_time,$homepage,$merriage,$edu_level,
         $edu_school,$province,$city,$postalcode,$fond;
$SQL=”SELECT nicker FROM $USER_LOG_TABLE WHERE log_id=$log_id”;

$result=mysql_query($SQL) or die(mysql_error());
$row=mysql_fetch_Array($result);

$nicker=$row[nicker];

$SQL=”SELECT * FROM $USER_ATTR_TABLE WHERE log_id=$log_id”;
$result=mysql_query($SQL) or die(mysql_error());

$row=mysql_fetch_Array($result);

$birthday=$row[birthday];
$realname=$row[realname];
$email=$row[email];
$address=$row[address];
$oicq=$row[oicq];
$last_time=$row[last_time];
$homepage=$row[homepage];
$merriage=$row[merriage];
$edu_level=$row[edu_level];
$edu_school=$row[edu_school];
$province=$row[province];
$city=$row[city];
$postalcode=$row[postalcode];
$fond=$row[fond];
}

function UpdateUserNickname() {
global $USER_LOG_TABLE,$USER_ONLINE_TABLE;
global $log_id,$nicker;
$SQL=”UPDATE $USER_LOG_TABLE SET nicker=`$nicker`
       WHERE log_id=`$log_id`”;
mysql_query($SQL) or die(mysql_error());

}

function UpdateUserAttr() {
global $USER_ATTR_TABLE;
global $log_id,$realname,$email,$address,$birthday,$oicq,
         $last_time,$homepage,$merriage,$edu_level,$edu_school,
         $province,$city,$postalcode,$fond;
$SQL=”UPDATE $USER_ATTR_TABLE SET
          realname=`$realname`,email=`$email`,address=`$address`,
          birthday=`$birthday`, oicq=`$oicq`,homepage=`$homepage`,
          edu_level=`$edu_level`, edu_school=`$edu_school`,
          merriage=`$merriage`,province=`$province`,city=`$city`,
          postalcode=`$postalcode`,fond=`$fond`
        WHERE log_id=`$log_id`”;

mysql_query($SQL) or die(mysql_error());
}

if ($Ok)
{
$birthday=$year.”:”.$mon.”:”.$day;
$fond=`1`;
if($radiobutton==1)
     {$merriage=`Y`;}
else
     {$merriage=`N`;}
if($sport)$fond=$fond.”S”;
if($literature)$fond=$fond.”L”;
if($music)$fond=$fond.”M”;
if($computer)$fond=$fond.”C”;
UpdateUserNickname();
UpdateUserAttr();
header(“Location: on_ok.php?ok_info=使用者的資料更新成功”);
exit;
}
else
{
ReadUserAttr();
if($merriage==`Y`)
     {$radiobutton=1;}
else
     {$radiobutton=0;}
$temp_date=split(“:”,$birthday);
$year=$temp_date[0];
$mon=$temp_date[1];
$day=$temp_date[2];
if (strrpos($fond,`S`)){$sport=1;}else $sport=0;
if (strrpos($fond,`L`)){$literature=1;}else $literature=0;
if (strrpos($fond,`M`)){$music=1;}else $music=0;
if (strrpos($fond,`C`)){$computer=1;}else $computer=0;
}
include “header.inc.php”;
?>
<html>
<body bgcolor=”#FFFFFF”>
<TABLE width=100% border=0 align=left>
<TR>
    <TD height=25 align=center>
        <FONT class=myRed>
         <?echo “用　戶　情況　表”?>
        </FONT>
    </TD>
</TR>
</TABLE>

<hr>

<FORM METHOD=”POST” ACTION=
      “<? echo $PHP_SELF.”?log_id=”.$log_id; ?>”>
<TABLE width=80% border=1 align=center bgcolor=yellow>
    <TR class=myBlack bgcolor=green>
      <TD colspan=2 height=20 align=center>
          <FONT class=myYellow>
             請按照要求填寫下列各項！
          </FONT>
      </td>
    </TR>
    <TR>
      <TD height=20 width=50% align=left class=myRed>
            暱&nbsp&nbsp&nbsp&nbsp稱&nbsp
        <INPUT type=text name=nicker maxlength=20
             value=”<? echo $nicker; ?>” >
      </TD>
      <td width=”50%” align=left class=myRed>
           婚&nbsp&nbsp&nbsp&nbsp否&nbsp
        <input type=”radio” name=”radiobutton” value=1
             <? if ($radiobutton==1) {echo “checked”;}?>>
        已婚
        <input type=”radio” name=”radiobutton” value=0
             <? if ($radiobutton==0) {echo “checked”;}?>>
        未婚 </td>
    </TR>
    <TR>
      <TD height=20 width=50% align=left class=myRed>真實姓名&nbsp
        <INPUT type=text name=realname maxlength=20
              value=”<? echo $realname; ?>” >
      </TD>
    <TD width=32% width=50% align=left class=myRed>
           生&nbsp&nbsp&nbsp&nbsp日&nbsp
      <SELECT name=”year” size=”1″ class=myRed>
    <?
       for ($i=1950;$i<=2000;$i++) {
            echo ”        <OPTION value=/”$i/””;
            echo ($year==”$i”) ? ” selected” : “”;
            echo “>$i</OPTION>/n”;
            }
    ?>
      </SELECT>
        年
<SELECT name=”mon” size=”1″ class=myRed>
<?
for ($i=1;$i<=12;$i++) {
    echo ”        <OPTION value=/””;
    echo ($i<10) ? “0$i” : “$i”;
    echo “/””;
    echo ($mon==”$i”) ? ” selected” : “”;
    echo “>”;
    echo ($i<10) ? “0$i” : “$i”;
    echo “</OPTION>/n”;
}
?>
</SELECT>
        月
<SELECT name=”day” size=”1″ class=myRed>
<?
for ($i=1;$i<=31;$i++) {
    echo ”        <OPTION value=/””;
    echo ($i<10) ? “0$i” : “$i”;
    echo “/””;
    echo ($day==”$i”) ? ” selected” : “”;
    echo “>”;
    echo ($i<10) ? “0$i” : “$i”;
    echo “</OPTION>/n”;
}
?>
      </SELECT></td>
    </TR>
    <tr>
    <TD width=50% align=left class=myRed>
          學&nbsp&nbsp&nbsp&nbsp歷&nbsp
      <SELECT name=”edu_level” class=myBlack>
        <OPTION value=”1″<? echo ($edu_level==1)
               ? ” selected” : “”; ?>>小學</OPTION>
        <OPTION value=”2″<? echo ($edu_level==2)
               ? ” selected” : “”; ?>>初中</OPTION>
        <OPTION value=”3″<? echo ($edu_level==3)
               ? ” selected” : “”; ?>>高中</OPTION>
        <OPTION value=”4″<? echo ($edu_level==4)
               ? ” selected” : “”; ?>>中專</OPTION>
        <OPTION value=”5″<? echo ($edu_level==5)
               ? ” selected” : “”; ?>>大專</OPTION>
        <OPTION value=”6″<? echo ($edu_level==6)
               ? ” selected” : “”; ?>>大學</OPTION>
        <OPTION value=”7″<? echo ($edu_level==7)
               ? ” selected” : “”; ?>>碩士</OPTION>
        <OPTION value=”8″<? echo ($edu_level==8)
               ? ” selected” : “”; ?>>博士</OPTION>
      </SELECT>
    </TD>
      <td width=”50%” align=”left” class=myRed>畢業院校&nbsp
        <input type=”text” name=”edu_school” size=”20″
             maxlength=”20″ value=<?echo $edu_school;?>>
      </td>
    </tr>
    <tr>
      <td width=”50%” align=”left” class=myRed>
            省&nbsp&nbsp&nbsp&nbsp份&nbsp
        <input type=”text” name=”province” value=<?echo $province;?>>
      </td>
      <td width=”50%” align=”left” class=myRed>
             城&nbsp&nbsp&nbsp&nbsp市&nbsp
        <input type=”text” name=”city” maxlength=”12″
             size=”12″ value=<?echo $city;?>>
      </td>
    </tr>
    <tr>
      <td width=”50%” align=”left” class=myRed>
             郵&nbsp&nbsp&nbsp&nbsp編&nbsp
        <input type=”text” name=”postalcode” value=<?echo $postalcode;?>>
      </td>
      <td width=”50%” align=”left” class=myRed>OICQ&nbsp&nbsp號&nbsp
        <input type=”text” name=”oicq” size=”8″
               maxlength=”8″ value=<?echo $oicq;?>>
      </td>
    </tr>
    <tr>
      <td colspan=”2″ align=”left” class=myRed>通訊地址&nbsp
          <input type=”text” name=”address”
             size=”40″ value=<?echo $address;?>>
      </td>
    </tr>
    <tr>
      <td colspan=”2″>
        <div align=left align=”left” class=myRed>電子郵件信箱
          <input type=”text” name=”email” size=”50″
               maxlength=”50″ value=<?if (strlen($email)<5)
                    echo”@”;else echo $email;?>>
        </div>
      </td>
    </tr>
    <tr>
      <td colspan=”2″>
        <div align=”left” align=”left” class=myRed>主頁地址&nbsp
          <input type=”text” name=”homepage” size=”50″
              value=<?if (strlen($homepage)<9)
                     { echo “http://”;} else echo $homepage;?>>
        </div>
      </td>
    </tr>
    <tr>
      <td colspan=”2″>
        <div align=”left” align=”left” class=myRed>
                愛&nbsp&nbsp&nbsp&nbsp好&nbsp
          <input type=”checkbox” name=”sport”
                <?if ($sport==1)echo “checked”;?>>
          體育
          <input type=”checkbox” name=”literature”
                <?if ($literature==1)echo “checked”;?>>
          文學
          <input type=”checkbox” name=”music”
                <?if ($music==1)echo “checked”;?>>
          音樂
          <input type=”checkbox” name=”computer”
                <?if ($computer==1)echo “checked”;?>>
          計算機 </div>
      </td>
    </tr>
    <TR class=myBlack>
      <TD height=30 width=80% colspan=2 align=center><BR>
        <INPUT type=reset name=Start value=” 重置 ” class=myBlack>        　　　　　　　　　　　
        <INPUT type=submit name=Ok value=” 傳送 ” class=myBlack>        　　　　　　　　　　　
        <INPUT type=button name=Back value=” 返回 ” class=myBlack
            onClick=JavaScript:history.back()>
      </TD>
    </TR>
</table>
</form>
<DIV class=myGreen align=center>
    <? echo $COPYRIGHT; ?>
</DIV>
<BR>
</body>
</html>

PHP的bbs實現之二

相關文章