杏林同学录(二)- PHP - 软晨网（RuanChen.com）

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

PHP: 工作笔记：配置MySQL为高可用集群（1）; MySQL (C API)VC实例及代码下载（1）(5); MySQL (C API)VC实例及代码下载（1）(4); MySQL (C API)VC实例及代码下载（1）(3); MySQL (C API)VC实例及代码下载（1）(2); MySQL (C API)VC实例及代码下载（1）; 用JSP连接mysql数据库的方法（1）(2); 用JSP连接mysql数据库的方法（1）; MySQL数据库账户授权的相关管理解析（1）(2); MySQL数据库账户授权的相关管理解析（1）; SAP MaxDB MySQL修补数据库严重漏洞; MySQL研发中心成立发布会会后访问整理（1）(2); MySQL研发中心成立发布会会后访问整理（1）; MySQL中SQL-TEXT、DATE和SET数据类型; MySQL存在权限提升及安全限制绕过漏洞; MySQL 卸载的问题; windows下安装、卸载mysql服务; 如何正确卸载MySQL; MySQL手册版本 5.0.20-MySQL优化(四) （1）(5); MySQL手册版本 5.0.20-MySQL优化(四) （1）(4)

No. « ‹ 183 184 185 186 › »

技术文章搜索

关键字

PHP 中的杏林同学录(二)

出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-13 浏览: 96 ::

收藏到网摘: n/a

基于mysql的bbs设计（五）杏林同学录(一)

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

基于mysql的bbs设计（五）杏林同学录(一)

PHP 中的 杏林同学录(二)

评论 (0) All

PHP 中的杏林同学录(二)