⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 who.php

📁 这是使用PHP编程的虚拟社区MySQL的简易版
💻 PHP
字号:
<?
  include "config.inc.php";
  include "func.php";

//  读用户昵称
function ReadUserNickname() {
  global $USER_TABLE;
  global $who,$nickname,$sex;

  $SQL="SELECT nickname,sex FROM $USER_TABLE WHERE userid='$who'";

  $result=mysql_query($SQL) or die(mysql_error());

  $row=mysql_fetch_Array($result);
  $nickname=$row[nickname];
  $sex=$row[sex];
}


function ReadUserStatus() {
  global $ONLINE_TABLE;
  global $who,$status;

  $SQL="SELECT Count(*) AS total FROM $ONLINE_TABLE WHERE userid='$who'";

  $result=mysql_query($SQL) or die(mysql_error());

  $row=mysql_fetch_Array($result);
  $total=$row[total];
  $status= ($total==1 ) ? 1 : 0;
}


function ReadUserAttr() {
  global $USER_ATTR_TABLE;
  global $who,$count,$level,$exper_cent,$act_cent,$life_cent,
         $last_time,$last_ip,$article,
         $birthday,$hei,$wei,$hobby,$icq,$homepage,$merriage,
         $edu,$school,$music,$book,$best,$memory,$photo,$readme,$star;

  $SQL="SELECT * FROM $USER_ATTR_TABLE WHERE userid='$who'";

  $result=mysql_query($SQL) or die(mysql_error());

  $row=mysql_fetch_Array($result);

  $count=$row[count];
  $level=$row[level];
  $exper_cent=$row[exper_cent];
  $act_cent=$row[act_cent];
  $life_cent=$row[life_cent];
  $last_time=$row[last_time];
  $last_ip=$row[last_ip];
  $article=$row[article];
  $birthday=$row[birthday];
  $hei=$row[hei];
  $wei=$row[wei];
  $hobby=$row[hobby];
  $icq=$row[icq];
  $homepage=$row[homepage];
  $merriage=$row[merriage];
  $edu=$row[edu];
  $school=$row[school];
  $music=$row[music];
  $book=$row[book];
  $best=$row[best];
  $memory=$row[memory];
  $photo=$row[photo];
  $readme=$row[readme];

  $pieces=split("-",$birthday);
  $mon=$pieces[1];
  $day=$pieces[2];

  if (($mon==1 and $day>=20) or ($mon==2 and $day<=18)) $star="水瓶";
  if (($mon==2 and $day>=19) or ($mon==3 and $day<=20)) $star="双鱼";
  if (($mon==3 and $day>=21) or ($mon==4 and $day<=20)) $star="白羊";
  if (($mon==4 and $day>=21) or ($mon==5 and $day<=20)) $star="金牛";
  if (($mon==5 and $day>=21) or ($mon==6 and $day<=21)) $star="双子";
  if (($mon==6 and $day>=22) or ($mon==7 and $day<=22)) $star="巨蟹";
  if (($mon==7 and $day>=23) or ($mon==8 and $day<=22)) $star="狮子";
  if (($mon==8 and $day>=23) or ($mon==9 and $day<=22)) $star="处女";
  if (($mon==9 and $day>=23) or ($mon==10 and $day<=22)) $star="天秤";
  if (($mon==10 and $day>=23) or ($mon==11 and $day<=21)) $star="天蝎";
  if (($mon==11 and $day>=22) or ($mon==12 and $day<=21)) $star="射手";
  if (($mon==12 and $day>=22) or ($mon==1 and $day<=19)) $star="山羊";
}

  ReadUserid();
  ReadUserNickname();
  ReadUserAttr();
  ReadUserStatus();

  switch ($level) {
    case 0:
      $level="新手上路";
      break;
    case 1:
      $level="初级站友";
      break;
    case 2:
      $level="中级站友";
      break;
    case 3:
      $level="本站支柱";
      break;
    case 4:
      $level="开国大老";
      break;
    case 5:
      $level="神~~~~~~";
      break;
  }

  switch ($edu) {
    case 0:
      $edu="幼儿园";
      break;
    case 1:
      $edu="小学";
      break;
    case 2:
      $edu="初中";
      break;
    case 3:
      $edu="高中";
      break;
    case 4:
      $edu="中专";
      break;
    case 5:
      $edu="大专";
      break;
    case 6:
      $edu="大学";
      break;
    case 7:
      $edu="双学士";
      break;
    case 8:
      $edu="硕士";
      break;
    case 9:
      $edu="博士";
      break;
    default:
      $edu="其它";
      break;
  }

  include "header.inc.php";
  include "ad.php";
?>

<TABLE width=100% border=0 align=center>
  <TR class=wdBlack>
    <TD width=15%> <FONT class=wdBlue>●</FONT> 资料查询</TD>
    <TD width=60% align=center>&nbsp;
    </TD>
    <TD width=25% class=wdBlue align=center>
【 <A href="JavaScript:history.back()">返回</A> 】</TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=98% size=1>

<TABLE border=0 width=95% align=center cellspacing=2 cellpadding=2 bgcolor=white class=wdBlack>
  <TR>
    <TD colspan=4 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
  </TR>
  <TR>
    <TD colspan=2 rowspan=8 valign=middle align=center bgcolor=<? echo $BODY_COLOR; ?>><IMG src=images/photo.jpg width=200 height=150></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  ID:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<FONT color=red><? echo $who; ?></FONT></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  昵称:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<FONT color=red><? echo $nickname; ?></FONT></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  性别:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<FONT color=red><? echo ($sex==0) ? "男" : "女"; ?></FONT></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  E-Mail:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>><MARQUEE><A href="email.php?id=<? echo $id; ?>&who=<? echo $who; ?>"><FONT color=red>点这里可以给我写信!</FONT></A></MARQUEE></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  ICQ:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<FONT color=red><? echo $icq; ?></FONT></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  个人主页:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<A href=<? echo $homepage; ?>><FONT color=red><? echo $homepage; ?></FONT></A></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  星座:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo ($star!="") ? $star."座" : ""; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  身高:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo ($hei>0) ? $hei." 厘米(cm)" : ""; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  当前状态:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?> class=<? echo ($status==0) ? "wdGray" : "wdBlue"; ?>>&nbsp;<? echo ($status==0) ? "离线" : "在线"; ?></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  体重:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo ($wei>0) ? $wei." 公斤(kg)" : ""; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  上站次数:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $count; ?></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  嗜好:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $hobby; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  等级:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?> class=wdBlue>&nbsp;<FONT color=red><? echo $level; ?></FONT></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  婚姻状况:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo ($merriage==0) ? "未婚" : "已婚"; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  经验:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?> class=wdBlue>&nbsp;<? echo $exper_cent; ?></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  教育程度:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $edu; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  表现:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?> class=wdBlue>&nbsp;<? echo $act_cent; ?></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  毕业院校:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $school; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  生命:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?> class=wdBlue>&nbsp;<? echo $life_cent; ?></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  爱听的歌:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $music; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  上次进站时间:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo date("Y.m.d H:i",$last_time); ?></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  爱看的书:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $book; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  从哪里到本站:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $last_ip; ?></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  最欣赏的:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $best; ?></TD>
  </TR>
  <TR>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  发表文章篇数:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $article; ?></TD>
    <TD width=18% nowrap bgcolor=<? echo $BODY_COLOR; ?>>  最难忘的:</TD>
    <TD width=32% nowrap bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;<? echo $memory; ?></TD>
  </TR>
</TABLE>

<TABLE border=0 width=95% align=center class=wdBlack>
  <TR>
    <TD bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
  </TR>
</TABLE>
<TABLE width=95% height=80 align=center class=wdBlack>
  <TR valign="top">
    <TD width="4%" bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;</TD>
    <TD width="92%" bgcolor=<? echo $BODY_COLOR; ?>><BR><? echo ReadProc($readme,0); ?><BR></TD>
    <TD width="4%" bgcolor=<? echo $BODY_COLOR; ?>>&nbsp;</TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=98% size=1>

<DIV class=wdBlack align=center><? echo $COPYRIGHT; ?></DIV><BR>

</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -