edit.php

来自「极限网络智能办公系统 Office Automation V3.0官方100%源」· PHP 代码 · 共 280 行

PHP
280
字号
<?
include_once("inc/auth.php");
?>

<html>
<head>
<title>编辑联系人</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script Language="JavaScript">
function CheckForm()
{
   if(document.form1.PSN_NAME.value=="")
   { alert("联系人姓名不能为空!");
     return (false);
   }
   return (true);
}


function td_calendar(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;

  window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>

<body class="bodycolor" topmargin="5" >

<?

 //============================ 显示联系人 =======================================
 $connection=OpenConnection();

 $query = "SELECT * from ADDRESS where ADD_ID=$ADD_ID";
 $cursor= exequery($connection,$query);

 if($ROW=mysql_fetch_array($cursor))
 {
    $GROUP_ID=$ROW["GROUP_ID"];
    $PSN_NAME=$ROW["PSN_NAME"];
    $SEX=$ROW["SEX"];
    $BIRTHDAY=$ROW["BIRTHDAY"];

    $NICK_NAME=$ROW["NICK_NAME"];
    $MINISTRATION=$ROW["MINISTRATION"];
    $MATE=$ROW["MATE"];
    $CHILD=$ROW["CHILD"];

    $DEPT_NAME=$ROW["DEPT_NAME"];
    $ADD_DEPT=$ROW["ADD_DEPT"];
    $POST_NO_DEPT=$ROW["POST_NO_DEPT"];
    $TEL_NO_DEPT=$ROW["TEL_NO_DEPT"];
    $FAX_NO_DEPT=$ROW["FAX_NO_DEPT"];

    $ADD_HOME=$ROW["ADD_HOME"];
    $POST_NO_HOME=$ROW["POST_NO_HOME"];
    $TEL_NO_HOME=$ROW["TEL_NO_HOME"];
    $MOBIL_NO=$ROW["MOBIL_NO"];
    $BP_NO=$ROW["BP_NO"];
    $EMAIL=$ROW["EMAIL"];
    $OICQ_NO=$ROW["OICQ_NO"];
    $ICQ_NO=$ROW["ICQ_NO"];

    $NOTES=$ROW["NOTES"];
 }

?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/address.gif" align="absmiddle"><span class="big3"> 编辑联系人</span>
    </td>
  </tr>
</table>

<br>

 <table border="0" width="450" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
  <form action="update.php"  method="post" name="form1" onsubmit="return CheckForm();">
    
        <tr>
      <td nowrap class="TableHeader" colspan="2"><b>&nbsp;分组</b></td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 分组:</td>
      <td class="TableData">
        <select name="GROUP_ID" class="BigSelect">
        <option value="0" <?if($GROUP_ID==0) echo "selected";?>>默认</option>
<?
$connection=OpenConnection();
$query = "select * from ADDRESS_GROUP where USER_ID='$LOGIN_USER_ID' order by GROUP_NAME asc";

$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
   $GROUP_ID1=$ROW["GROUP_ID"];
   $GROUP_NAME=$ROW["GROUP_NAME"];
?>
        <option value="<?=$GROUP_ID1?>" <?if($GROUP_ID==$GROUP_ID1) echo "selected";?>><?=$GROUP_NAME?></option>
<?
}
?>
        </select>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableHeader" colspan="2"><b>&nbsp;个人信息</b></td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 姓名:</td>
      <td class="TableData">
        <input type="text" name="PSN_NAME" size="20" maxlength="50" class="BigInput" value="<?=$PSN_NAME?>">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 性别:</td>
      <td class="TableData">
        <select name="SEX" class="BigSelect">
          <option value="0" <? if($SEX==0) echo "selected";?>>男</option>
          <option value="1" <? if($SEX==1) echo "selected";?>>女</option>
        </select>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData">生日:</td>
      <td class="TableData">
        <input type="text" name="BIRTHDAY" size="10" maxlength="10" class="BigInput" value="<?=$BIRTHDAY?>"> 
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.BIRTHDAY');">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 昵称:</td>
      <td class="TableData">
        <input type="text" name="NICK_NAME" size="25" maxlength="25" class="BigInput" value="<?=$NICK_NAME?>">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 职务:</td>
      <td class="TableData">
        <input type="text" name="MINISTRATION" size="25" maxlength="25" class="BigInput" value="<?=$MINISTRATION?>">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 配偶:</td>
      <td class="TableData">
        <input type="text" name="MATE" size="25" maxlength="25" class="BigInput" value="<?=$MATE?>">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 子女:</td>
      <td class="TableData">
        <input type="text" name="CHILD" size="25" maxlength="25" class="BigInput" value="<?=$CHILD?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableHeader" colspan="2"><b>&nbsp;联系方式(单位)</b></td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 单位名称:</td>
      <td class="TableData">
        <input type="text" name="DEPT_NAME" size="25" maxlength="25" class="BigInput" value="<?=$DEPT_NAME?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData">单位地址:</td>
      <td class="TableData">
        <input type="text" name="ADD_DEPT" size="40" maxlength="100" class="BigInput" value="<?=$ADD_DEPT?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 单位邮编:</td>
      <td class="TableData">
        <input type="text" name="POST_NO_DEPT" size="25" maxlength="25" class="BigInput" value="<?=$POST_NO_DEPT?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 单位电话:</td>
      <td class="TableData">
        <input type="text" name="TEL_NO_DEPT" size="25" maxlength="25" class="BigInput" value="<?=$TEL_NO_DEPT?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 单位传真:</td>
      <td class="TableData">
        <input type="text" name="FAX_NO_DEPT" size="25" maxlength="25" class="BigInput" value="<?=$FAX_NO_DEPT?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableHeader" colspan="2"><b>&nbsp;联系方式(家庭)</b></td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 家庭住址:</td>
      <td class="TableData">
        <input type="text" name="ADD_HOME" size="40" maxlength="100" class="BigInput" value="<?=$ADD_HOME?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 家庭邮编:</td>
      <td class="TableData">
        <input type="text" name="POST_NO_HOME" size="25" maxlength="25" class="BigInput" value="<?=$POST_NO_HOME?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 家庭电话:</td>
      <td class="TableData">
        <input type="text" name="TEL_NO_HOME" size="25" maxlength="25" class="BigInput" value="<?=$TEL_NO_HOME?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 手机:</td>
      <td class="TableData">
        <input type="text" name="MOBIL_NO" size="25" maxlength="25" class="BigInput" value="<?=$MOBIL_NO?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 小灵通:</td>
      <td class="TableData">
        <input type="text" name="BP_NO" size="25" maxlength="25" class="BigInput" value="<?=$BP_NO?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> 电子邮件:</td>
      <td class="TableData">
        <input type="text" name="EMAIL" size="25" maxlength="80" class="BigInput" value="<?=$EMAIL?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> QQ号码:</td>
      <td class="TableData">
        <input type="text" name="OICQ_NO" size="25" maxlength="25" class="BigInput" value="<?=$OICQ_NO?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableData"> MSN:</td>
      <td class="TableData">
        <input type="text" name="ICQ_NO" size="25" maxlength="25" class="BigInput" value="<?=$ICQ_NO?>">
      </td>
    </tr>

    <tr>
      <td nowrap class="TableHeader" colspan="2"><b>&nbsp;备 注</b></td>
    </tr>
    <tr>
      <td class="TableData" colspan="2">
        <textarea cols="60" name="NOTES" rows="5" class="BigInput" wrap="on"><?=$NOTES?></textarea>
      </td>
    </tr>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
        <input type="hidden" value="<?=$ADD_ID?>" name="ADD_ID">
        <input type="submit" value="保存" class="BigButton">&nbsp;&nbsp;
        <input type="button" value="返回" class="BigButton" onClick="location='index.php?GROUP_ID=<?=$GROUP_ID?>'">
      </td>
    </tr>
  </table>
</form>

</body>
</html>

⌨️ 快捷键说明

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