杏林同学录(二)_php教程-查字典教程网

杏林同学录(二)

摘要：成员主页：main.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>

<TITLE>欢迎来到杏林同学录</TITLE>

</style>

</HEAD>

<tr>

</div>

</td>

</embed>

</object></td>

</tr>

</table>

<tr>

<td class="black9" width="302"> 北京时间

<? echo date("Y年m月d日");?>

</td>

<?php

echo "您好，",$name,"。";

echo "欢迎您第", $count,"次光临本站。";

</td>

</tr>

</table>

<tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

</td>

</tr>

<div align="center" class="yellow12">班级聊天室</div>

</td>

</tr>

<tr>

<div align="center" class="purple"> 【进入班级聊天室】 </div>

</td>

</tr>

<tr>

<td >

<div align="center" class="purple">【班级聊天室帮助】</div>

</td>

</tr>

<tr>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<div align="center" class="purple"><a href="http://medonline.51.net/" class="purple"target="_blank">杏林医疗在线</a></div>

</td>

</tr>

<tr>

<div align="center" ><a href="http://alumni.chinaren.com" title="非常有特色的同学录" class="purple" target="_blank" >ChinaRen校友录</a></div>

</td>

</tr>

<tr>

</td>

</tr>

</table>

</td>

<tr>

<td>

</td>

</tr>

<tr>

1.欢迎使用杏林同学录。</td>

</tr>

<tr>

2.如果发现bug,请尽快通知我。</td>

</tr>

<tr>

3.技术支持: <a href="mailto:webmaster@medguider.51.net" class="purple">webmaster@medguider.51.net</a></td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<?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>

<tr>

</td>

</tr>

<tr>

<?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>

<div align="center">通讯录名单</div>

</td>

</tr>

<tr>

$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>

<tr>

</tr>

<tr>

<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>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table>

</td>

</tr>

</table>

<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设计（五）

下一篇：杏林同学录(一)

学习工具