天天看點

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>                                                                  

     <?echo $ok_info ?>                                               

<!--提示使用者繼續進行選擇-->                                           

   <FONT color=red size=5 align=center>                               

      <b>                                                             

        &nbsp&nbsp請選擇繼續或者退回                                  

      </b>                                                            

   </FONT>                                                            

<!--對最下面的按鈕進行說明-->                                         

    <FONT color=green size=4>                                         

        &nbsp&nbsp選擇左邊的按鈕繼續登記                              

    </FONT>                                                           

        &nbsp&nbsp選擇右邊的按鈕退回到主界面                          

<!--顯示兩個動态的按鈕-->                                             

<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'";

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

        )";

function CheckNicker($nicker_input)

  global $nicker,$log_id;

  $SQL="SELECT * FROM $USER_LOG_TABLE WHERE nicker='$nicker_input'";

  $row=mysql_fetch_Array($result);               

  $log_id=$row[log_id];

  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>

    </TR>

    <TR>

      <TD height=30 width=18% align=center>密 碼:

        <INPUT type=password name=password size=20 maxlength=10>

        <INPUT type=submit name=Ok value=" 發送 " class=myBlack>                   

        <INPUT type=button name=Back value=" 傳回 " class=myBlack

            onClick=JavaScript:history.back()>

  </TABLE>

</FORM>

<DIV class=myGreen align=center>

    <? echo $COPYRIGHT; ?>

</DIV>

<BR>

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

  $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'";                                                                

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

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

      <TD height=20 width=50% align=left class=myRed>真實姓名&nbsp                              

        <INPUT type=text name=realname maxlength=20                                             

              value="<? echo $realname; ?>" >                                                   

    <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 "</OPTION>/n";                                                                         

  }                                                                                             

</SELECT>                                                                                       

        月                                                                                      

<SELECT name="day" size="1" class=myRed>                                                        

  for ($i=1;$i<=31;$i++) {                                                                      

    echo ($day=="$i") ? " selected" : "";                                                       

      </SELECT></td>                                                                            

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

      <td width="50%" align="left" class=myRed>畢業院校&nbsp                                    

        <input type="text" name="edu_school" size="20"                                          

             maxlength="20" value=<?echo $edu_school;?>>                                        

    </tr>                                                                                       

      <td width="50%" align="left" class=myRed>                                                 

            省&nbsp&nbsp&nbsp&nbsp份&nbsp                                                       

        <input type="text" name="province" value=<?echo $province;?>>                           

             城&nbsp&nbsp&nbsp&nbsp市&nbsp                                                      

        <input type="text" name="city" maxlength="12"                                           

             size="12" value=<?echo $city;?>>                                                   

             郵&nbsp&nbsp&nbsp&nbsp編&nbsp                                                      

        <input type="text" name="postalcode" value=<?echo $postalcode;?>>                       

      <td width="50%" align="left" class=myRed>OICQ&nbsp&nbsp号&nbsp                            

        <input type="text" name="oicq" size="8"                                                 

               maxlength="8" value=<?echo $oicq;?>>                                             

      <td colspan="2" align="left" class=myRed>通信位址&nbsp                                    

          <input type="text" name="address"                                                     

             size="40" value=<?echo $address;?>>                                                

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

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

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

  </table>                                                                                      

</form>                                                                                         

<DIV class=myGreen align=center>                                                                

    <? echo $COPYRIGHT; ?>                                                                      

</DIV>                                                                                          

<BR>                                                                                            

</body>                                                                                         

</html>