📄 personal.php

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


//  读用户资料
function ReadUserAttr() {
  global $USER_ATTR_TABLE;
  global $userid,$birthday,$hei,$wei,$hobby,$icq,$homepage,
         $merriage,$edu,$school,$music,$book,$best,$memory,$photo;

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

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

  $row=mysql_fetch_Array($result);

  $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];
}

//  修改用户昵称
function UpdateUserNickname() {
  global $USER_TABLE,$ONLINE_TABLE;
  global $id,$userid,$nick,$sex;

  $SQL="UPDATE $USER_TABLE SET nickname='$nick',sex='$sex' WHERE userid='$userid'";

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

  $SQL="UPDATE $ONLINE_TABLE SET nickname='$nick',sex='$sex' WHERE id='$id'";

  mysql_query($SQL) or die(mysql_error());
}

//  修改用户资料
function UpdateUserAttr() {
  global $USER_ATTR_TABLE;
  global $userid,$birthday,$hei,$wei,$hobby,$icq,$homepage,
         $merriage,$edu,$school,$music,$book,$best,$memory;

  $SQL="UPDATE $USER_ATTR_TABLE SET
          birthday='$birthday', hei='$hei', wei='$wei',
          hobby='$hobby', icq='$icq', homepage='$homepage',
          merriage='$merriage', edu='$edu', school='$school',
          music='$music', book='$book', best='$best', memory='$memory'
        WHERE userid='$userid'";

  mysql_query($SQL) or die(mysql_error());
}

  ReadUserid();
  CheckDemo();

if ($Ok) {
  $birthday=$year."-".$mon."-".$day;
  UpdateUserNickname();
  UpdateUserAttr();
  header("Location: ok.php?id=$id&code=1\n");
  exit;
} else {
  ReadUserAttr();
  $pieces=split("-",$birthday);
  $year=$pieces[0];
  $mon=$pieces[1];
  $day=$pieces[2];
}

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

<TABLE width=100% border=0 align=center>
  <TR class=wdBlack>
    <TD width=30%>　<font class=wdBlue>●</font> 修改个人资料</TD>
    <TD width=50%>&nbsp;</TD>
    <TD width=25% class=wdBlue align=center>【 <A href="JavaScript:history.back()">返回</A> 】</TD>
  </TR>
</TABLE>

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

<FORM METHOD="POST" ACTION=<? echo $PHP_SELF; ?>>

<TABLE border=0 width=95% align=center bgcolor=<? echo $BODY_COLOR; ?> class=wdBlack>
  <TR>
    <TD colspan=4 bgcolor=<? echo $HEADER_COLOR; ?>>&nbsp;</TD>
  </TR>
  <TR>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>　昵称：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="nick" value="<? echo $nickname; ?>" class=wdBlack>
    </TD>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>婚姻状况：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <SELECT name="merriage" class=wdBlack>
        <OPTION value="0"<? echo ($merriage==0) ? " selected" : ""; ?>>未婚</OPTION>
        <OPTION value="1"<? echo ($merriage==1) ? " selected" : ""; ?>>已婚</OPTION>
      </SELECT>
    </TD>
  </TR>
  <TR>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>　性别：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
        <INPUT type=radio name=sex value=0 <? echo ($sex==0) ? "checked" : ""; ?>> 男　　
        <INPUT type=radio name=sex value=1 <? echo ($sex==1) ? "checked" : ""; ?>> 女
    </TD>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>教育程度：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <SELECT name="edu" class=wdBlack>
        <OPTION value="0"<? echo ($edu==0) ? " selected" : ""; ?>>幼儿园</OPTION>
        <OPTION value="1"<? echo ($edu==1) ? " selected" : ""; ?>>小学</OPTION>
        <OPTION value="2"<? echo ($edu==2) ? " selected" : ""; ?>>初中</OPTION>
        <OPTION value="3"<? echo ($edu==3) ? " selected" : ""; ?>>高中</OPTION>
        <OPTION value="4"<? echo ($edu==4) ? " selected" : ""; ?>>中专</OPTION>
        <OPTION value="5"<? echo ($edu==5) ? " selected" : ""; ?>>大专</OPTION>
        <OPTION value="6"<? echo ($edu==6) ? " selected" : ""; ?>>大学</OPTION>
        <OPTION value="7"<? echo ($edu==7) ? " selected" : ""; ?>>双学士</OPTION>
        <OPTION value="8"<? echo ($edu==8) ? " selected" : ""; ?>>硕士</OPTION>
        <OPTION value="9"<? echo ($edu==9) ? " selected" : ""; ?>>博士</OPTION>
        <OPTION value=""<? echo ($edu=="") ? " selected" : ""; ?>>其它</OPTION>
      </SELECT>
    </TD>
  </TR>
  <TR>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>　生日：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <SELECT name="year" size="1" class=wdBlack>
<?
  for ($i=1940;$i<=2000;$i++) {
    echo "        <OPTION value=\"$i\"";
    echo ($year=="$i") ? " selected" : "";
    echo ">$i</OPTION>\n";
  }
?>
      </SELECT>-<SELECT name="mon" size="1" class=wdBlack>
<?
  for ($i=1;$i<=12;$i++) {
    echo "        <OPTION value=\"";
    echo ($i<10) ? "0$i" : "$i";
    echo "\"";
    echo ($mon=="$i") ? " selected" : "";
    echo ">";
    echo ($i<10) ? "0$i" : "$i";
    echo "</OPTION>\n";
  }
?>
      </SELECT>-<SELECT name="day" size="1" class=wdBlack>
<?
  for ($i=1;$i<=31;$i++) {
    echo "        <OPTION value=\"";
    echo ($i<10) ? "0$i" : "$i";
    echo "\"";
    echo ($day=="$i") ? " selected" : "";
    echo ">";
    echo ($i<10) ? "0$i" : "$i";
    echo "</OPTION>\n";
  }
?>
      </SELECT>
    </TD>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>毕业院校：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="school" value="<? echo $school; ?>" class=wdBlack>
    </TD>
  </TR>
  <TR>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>　身高：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <SELECT NAME="hei" class=wdBlack>
        <OPTION value="0">请选择</OPTION>
<?
  for ($i=150;$i<=200;$i++) {
    echo "        <OPTION value=\"$i\"";
    echo ($hei=="$i") ? " selected" : "";
    echo ">$i</OPTION>\n";
  }
?>
      </SELECT>
      厘米(cm)
    </TD>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>爱听的歌：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="music" value="<? echo $music; ?>" class=wdBlack>
    </TD>
  </TR>
  <TR>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>　体重：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <SELECT NAME="wei" class=wdBlack>
        <OPTION value="0">请选择</OPTION>
<?
  for ($i=40;$i<=120;$i++) {
    echo "        <OPTION value=\"$i\"";
    echo ($wei=="$i") ? " selected" : "";
    echo ">$i</OPTION>\n";
  }
?>
      </SELECT>
      公斤(kg)
    </TD>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>爱看的书：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="book" value="<? echo $book; ?>" class=wdBlack>
    </TD>
  </TR>
  <TR>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>　嗜好：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="hobby" value="<? echo $hobby; ?>" class=wdBlack>
    </TD>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>最欣赏的：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="best" value="<? echo $best; ?>" class=wdBlack>
    </TD>
  </TR>
  <TR>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>　ICQ：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="icq" value="<? echo $icq; ?>" class=wdBlack>
    </TD>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>最难忘的：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="memory" value="<? echo $memory; ?>" class=wdBlack>
    </TD>
  </TR>
  <TR>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>　个人主页：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>
      <INPUT type=text name="homepage" value="<? echo $homepage; ?>" class=wdBlack>
    </TD>
    <TD width=18% bgcolor=<? echo $BODY_COLOR; ?>>我的照片：</TD>
    <TD width=32% bgcolor=<? echo $BODY_COLOR; ?>>[ <A href="<? echo "photo.php?id=$id"; ?>">上传照片</A> ]</TD>
  </TR>
  <TR bgcolor=<? echo $BODY_COLOR; ?>>
    <TD colspan=4 align=center>
      <INPUT type=submit name="Ok" value=" 发送 " class=wdBlack>
      <INPUT type=hidden name="id" value="<? echo $id; ?>">
    </TD>
  </TR>
</TABLE>
</FORM>

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

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

</BODY>
</HTML>
⌨️ 快捷键说明

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