当前位置: 首页 > 图文教程 > 网络编程 > PHP > 杏林同学录(二)

PHP
PHP 开发环境的选择、建立及使用(5)
PHP 开发环境的选择、建立及使用(6)
PHP 开发环境的选择、建立及使用(7)
PHP 开发环境的选择、建立及使用(8)
PHP 开发环境的选择、建立及使用(9)
Win2003下APACHE PHP5 MYSQL4 PHPMYADMIN 的简易安装配置
PHP新手上路（八） 文件上传
PHP新手上路（九） 投票系统
PHP新手上路（十） 简易banner动态更替
PHP新手上路（十一） 数据库链接
PHP新手上路（十二）使用PHP来操作Oracle数据库
PHP新手上路（十三）PHP资源
PHP新手上路（十四） 其他杂项
session全教程(一)
session全教程(二)
session全教程(三)
PHP编码规范
第十五节--Zend引擎的发展 -- Classes and Objects in PHP5 [15]
第十四节--命名空间 -- Classes and Objects in PHP5 [14]
第十二节--类的自动加载 -- Classes and Objects in PHP5 [12]

No. « 195 196 197 198 »

技术文章搜索

关键字

PHP 中的 杏林同学录(二)

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-09-13   浏览: 61 ::
收藏到网摘: n/a

成员主页：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>