程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> 網頁編程 >> PHP編程 >> 關於PHP編程 >> 杏林同學錄(二)

杏林同學錄(二)

編輯:關於PHP編程

成員主頁: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">
<!--
.deepblue10 {  font-family: "宋體"; font-size: 10pt; color: #3333FF; text-decoration: none}
A.purple:hover {  font-size: 9pt; color: #3366FF; background-color: #99FFFF; text-decoration: none}
A.purple:link {  font-size: 10pt; text-decoration: none}
a:hover {  text-decoration: none}
a:visited {  text-decoration: none}
A.purple {  font-size: 10pt; color: #CC00FF; text-decoration: none}
.white12 {  font-size: 12pt; color: #FFFFFF; text-decoration: none}
.purple {  color: #CC00FF; text-decoration: none; font-size: 10pt}
.brown9 {  font-size: 10pt; color: #6600CC; text-decoration: none}
.black9 {  font-size: 9pt; text-decoration: none}
.yellow12 {  font-size: 12px; color: #9900CC; text-decoration: none; font-weight: normal}
.redlarge {  font-size: 18px; font-weight: bolder; color: #FF00CC}
.grey9 {  font-size: 9pt; color: #CCCCCC}
-->
</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:[email protected]" class="purple">[email protected]</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>

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved