杏林同学录(二)
成员主页: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%">&nbsp;</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%">&nbsp;</td>
                </tr>
                <tr> 
                  
                <td colspan="3" height="4">&nbsp;</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>