杏林同學錄(二)

2019-11-18 21:15:42

字體：大中小

來源：轉載

供稿：網友

成員主頁：main.php
<?
session_start(); // 開始session
session_register("userregister");
$userregister=$username;
include "class/config.php";
$result = MySQL_query("SELECT * FROM user where user='$username'",$db);
if (mysql_num_rows($result)==0){  //若返回列的數目為0，說明無此資料
echo "無此用戶！";
exit;}
$userpsw=strtoupper(trim($userpsw));
$passWord=trim(mysql_result($result,0,'psw'));
$password=strtoupper($password);//取得密碼,轉換成大寫
$userpsw=strtoupper($userpsw);
if (!($userpsw==$password)){
echo "密碼錯誤！";
mysql_close($db);
exit;
}
$name=mysql_result($result,0,"name");
$count=mysql_result($result,0,"count")+1;//成員計數器加1
mysql_query("UPDATE user SET count=$count where user='$username'",$db);
?>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>歡迎來到杏林同學錄</TITLE>
<style type="text/CSS">

</style>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<table width="755" border="1" height="65" cellpadding="0" cellspacing="0" bordercolorlight="#FF33CC" bordercolordark="#FFFFFF">
  <tr>
    <td width="241">
      <div align="right"><img src="class/image/classlogo.gif" width="224" height="60" alt="同學錄">
      </div>
    </td>
    <td width="508"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/Flash/swflash.cab#version=4,0,2,0" width="478" height="60" align="right">
        <param name=movie value="class/image/2.swf">
        <param name=quality value=high>
        <embed src="class/image/2.swf" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_PRod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="478" height="60" align="right">
        </embed>
      </object></td>
  </tr>
</table>
<table width="755" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td class="black9" width="302"> 北京時間
      <? echo date("Y年m月d日");?>
    </td>
    <td class="black9" width="453">
      <?php
              echo "您好，",$name,"。";
              echo "歡迎您第", $count,"次光臨本站。";
      ?>
    </td>
  </tr>
</table>
<table width="755" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="19%" bgcolor="#FFeeFF" valign="top">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td height="20" background="class/image/redbar.gif">
            <div align="center" class="yellow12" >同學錄</div>
          </td>
        </tr>
        <tr>
          <td height="19" >
            <div align="center"><a href="class/address.php" title="最新通訊信息" class="purple" target="_blank">【班通訊錄】</a></div>
          </td>
        </tr>
        <tr>
          <td height="19">
            <div align="center" class="purple" ><a href="class/modify.php" title="修改個人資料" class="purple" target="_blank">【資料修改】</a></div>
          </td>
        </tr>
        <tr>
          <td height="19">
            <div align="center"  class="purple"><a href="class/upload/uploadphoto.php" title="修改個人資料" class="purple" target="_blank">【上傳照片】</a></div>
          </td>
        </tr>
        <tr>
          <td height="21">
            <div align="center"><a href="class/classphoto.php"  class="purple" target="_blank" >【班級照片】</a></div>
          </td>
        </tr>
        <tr>
          <td height="19">
            <div align="center"><a href="class/privatephoto.php" title="展現個人風采" class="purple" target="_blank" >【個人照片】</a></div>
          </td>
        </tr>
        <tr>
          <td height="19">
            <div align="center"><a href="class/shoolphoto.php" title="喚起你美好回憶" class="purple" target="_blank" >【校園風光】</a></div>
          </td>
        </tr>
        <tr>
          <td height="19">
            <div align="center"><a href="class/privatenote.php" title="給單個同學留言" class="purple" target="_blank">【私人留言】</a></div>
          </td>
        </tr>
        <tr>
          <td height="19">
            <div align="center"><a href="class/notebook/index.php" title="留下你的祝福" class="purple" target="_blank" >【班留言板】</a></div>
          </td>
        </tr>
        <tr bgcolor="#FF99CC">
          <td height="20" bgcolor="#FF99CC" background="class/image/redbar.gif" >
            <div align="center" class="yellow12">班級聊天室</div>
          </td>
        </tr>
        <tr>
          <td height="21">
            <div align="center" class="purple"> 【進入班級聊天室】 </div>
          </td>
        </tr>
        <tr>
          <td >
            <div align="center" class="purple">【班級聊天室幫助】</div>
          </td>
        </tr>
        <tr>
          <td height="20" background="class/image/redbar.gif">
            <div align="center" class="yellow12" >友情鏈接</div>
          </td>
        </tr>
        <tr>
          <td>
            <div align="center"><a href="http://www.medguider.com" title="neo的個人主頁" target="_blank"><img src="class/image/logo2.gif" width="82" height="31" border=0></a></div>
          </td>
        </tr>
        <tr>
          <td>
            <div align="center"><a href="http://www.5460.net" target="_blank"><img src="class/image/a31.gif" width="81" height="33" border="0" alt="國內最好的同學錄"></a></div>
          </td>
        </tr>
        <tr>
          <td height="24">
            <div align="center" class="purple"><a href="http://medonline.51.net/" class="purple"  target="_blank">杏林醫療在線</a></div>
          </td>
        </tr>
        <tr>
          <td height="22">
            <div align="center" ><a href="http://alumni.chinaren.com" title="非常有特色的同學錄" class="purple" target="_blank" >ChinaRen校友錄</a></div>
          </td>
        </tr>
        <tr>
          <td height="22" bgcolor="#FFCCFF">
            <div align="center"><a href="superadmin.php" class="purple" target="_blank">班級管理</a></div>
          </td>
        </tr>
      </table>
    </td>
    <td width="61%" height="308">
      <div align="center"><img src="class/image/821036.jpg" width="400" height="166" alt="這里換成班級照片"></div>
      <table width="87%" border="1" cellspacing="0" cellpadding="0" align="center" height="109" bordercolorlight="#9999FF" bordercolordark="#FFFFFF">
        <tr>
          <td>
            <div align="center" class="redlarge"><b>祝賀詞</b> </div>
          </td>
        </tr>
        <tr>
          <td class="brown9" height="19"><img src="class/image/bz.gif" width="15" height="16">
            1.歡迎使用杏林同學錄。</td>
        </tr>
        <tr>
          <td class="brown9"><img src="class/image/bz.gif" width="15" height="16">
            2.如果發現bug,請盡快通知我。</td>
        </tr>
        <tr>
          <td class="brown9"> <img src="class/image/bz.gif" width="15" height="16">
            3.技術支持: <a href="mailto:webmaster@medguider.51.net" class="purple">webmaster@medguider.51.net</a></td>
        </tr>
        <tr>
          <td>
            <div align="center" class="redlarge"> 最新留言</div>
          </td>
        </tr>
        <tr>
          <td class="brown9">
            <?php
   $result = mysql_query("SELECT * FROM notebook",$db);
   $row=mysql_num_rows($result);
   if ($row<=1) {$x=$row;} else {$x=2;}
   $result = mysql_query("select * from notebook ORDER BY time DESC limit 0,$x",$db);//讀取最近2條留言
   for ($i=0;$i<=($x-1);$i++) {
   $user=mysql_result($result,$i,'user');
   $resulty=mysql_query("select * from user where user='$user'",$db);
   $name=mysql_result($resulty,0,'name');
   $time=mysql_result($result,$i,'time');
   $title=mysql_result($result,$i,'title');
   $nnote=mysql_result($result,$i,'nnote');
   echo "◆留言人：$name 時間 $time <BR>主題:$title<BR>內容：$nnote<BR>";
    }
          ?>
          </td>
        </tr>
      </table>
    </td>
    <td valign="top" width="20%" bgcolor="#CFBD9B">
      <table border="0" cellspacing="0" cellpadding="0" width="100%">
        <tr>
          <td background="class/image/yellowbar3.gif" class="white12" height="19">
            <div align="center">悄悄話</div>
          </td>
        </tr>
        <tr>
          <td bgcolor="#FFFEEFF">
            <div align="center" class="brown9" >
              <?php
            $result = mysql_query("SELECT * FROM privatenote where touser='$userregister'",$db);
            $row=mysql_num_rows($result);        //悄悄話總數
            $unlook=0;
              if (!$row==0){
              for ($i=0;$i<$row;$i++){
               $look=mysql_result($result,$i,'look');//計算未看過的悄悄話數目
               if ($look=="0"){$unlook++;}
              }
              }
            echo "您有".$unlook."條新悄悄話.總共有".$row."條。<a href='class/privatenote.php' target='_blank'>查看悄悄話</a>";
            ?>
             </div>
          </td>
        </tr>
        <tr>
          <td bgcolor="#FFCC66" class="white12" height="20">
            <div align="center">通訊錄名單</div>
          </td>
        </tr>
        <tr>
          <td class="brown9" height="77" bgcolor="#FFFEEFF">
          <?
            $result = mysql_query("SELECT * FROM user",$db);
            $row=mysql_num_rows($result);//查看結果有多少行,即成員人數
            for ($i=0;$i<=($row-1);$i++){
             $name=mysql_result($result,$i,'name');
             echo $name,",";
            }
            mysql_close($db);
            ?>
            </td>
        </tr>
        <tr>
          <td>

            <table border="0" cellspacing="0" cellpadding="0" bgcolor="#CFBD9B" width="150">
              <tr>
                <td height="24" colspan="3"><img src="class/image/noticebar.gif" width="150" height="25"></td>
                </tr>
                <tr>

                <td height="182" width="6%"> </td>

                <td width="88%" bgcolor="#FFFFFF" background="class/image/fanhor01-1.jpg" class="deepblue10"><marquee direction=up scrollamount=1 scrolldelay=130 ><font color="#FFCC66">★</font>本網站已被搜狐、新浪收錄<br>
                  <font color="#FFCC66">★</font>感謝leo為我們做的新動畫logo.<br>
                  <font color="#FFCC66">★</font>經過數日的努力，終于用php和mysql數據庫將新版同學錄做好。特點：用戶可在線修改資料；上傳照片；悄悄話，oicq頭像。<br>
                    <font color="#FFCC66">★</font>5460中國同學錄上我們班已有14人加入。<br>
                  <font color="#FFCC66">★</font> 如果您有漂亮的掃描好的個人照片，請盡快上傳。<br>
                  </marqee>
                  </td>

                <td height="182" width="6%"> </td>
                </tr>
                <tr>

                <td colspan="3" height="4"> </td>
                </tr>
              </table>                        </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<div align="center">
  <p class="black9">您是第
    <?php
//總計數器
$fs = fopen("class/counter.txt","r+");
$hit = fgets($fs,10);
$hit+=1;
rewind($fs);
fwrite($fs,$hit,10);
$hit = number_format($hit);
fclose($fs);
echo "<font color='#33FF00'>$hit</font>";
?>
    位來訪者!<br>
    主頁制作：<a href="http://www.medguider.com" class="black9">醫學導航網</a><br>
    <span class="grey9">本頁使用了flash，如果不能正常瀏覽，請安裝<a href="http://medonline.51.net/plugsin/InstallAXFlash.exe">flash插件</a></span></p>
</div>
</BODY>
</HTML>

上一篇：杏林同學錄(三)

下一篇：杏林同學錄(一)