📄 add_detail.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>联系人详情</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<?
//============================ 显示联系人详情 =======================================
$connection=OpenConnection();
$query = "SELECT * from ADDRESS where ADD_ID=$ADD_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$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"];
switch($SEX)
{
case "0":
$SEX="男";
break;
case "1":
$SEX="女";
break;
}
?>
<body class="bodycolor" topmargin="5">
<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"> 联系人详情 - <?=$PSN_NAME?></span><br>
</td>
</tr>
</table>
<table border="0" width="100%" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<tr>
<td nowrap class="TableHeader" colspan="2"><b> 个人信息</b></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 姓名：</td>
<td class="TableData"><?=$PSN_NAME?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 性别：</td>
<td class="TableData"><?=$SEX?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80">生日：</td>
<td class="TableData"><?=$BIRTHDAY?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 昵称：</td>
<td class="TableData"><?=$NICK_NAME?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 职务：</td>
<td class="TableData"><?=$MINISTRATION?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 配偶：</td>
<td class="TableData"><?=$MATE?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 子女：</td>
<td class="TableData"><?=$CHILD?></td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="2"><b> 联系方式（单位）</b></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 单位名称：</td>
<td class="TableData"><?=$DEPT_NAME?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80">单位地址：</td>
<td class="TableData"><?=$ADD_DEPT?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 单位邮编：</td>
<td class="TableData"><?=$POST_NO_DEPT?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 单位电话：</td>
<td class="TableData"><?=$TEL_NO_DEPT?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 单位传真：</td>
<td class="TableData"><?=$FAX_NO_DEPT?></td>
</tr>
<tr>
<td nowrap class="TableHeader" colspan="2"><b> 联系方式（家庭）</b></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 家庭住址：</td>
<td class="TableData"><?=$ADD_HOME?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 家庭邮编：</td>
<td class="TableData"><?=$POST_NO_HOME?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 家庭电话：</td>
<td class="TableData"><?=$TEL_NO_HOME?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 手机：</td>
<td class="TableData"><?=$MOBIL_NO?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 小灵通：</td>
<td class="TableData"><?=$BP_NO?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 电子邮件：</td>
<td class="TableData"><?=$EMAIL?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> QQ号码：</td>
<td class="TableData"><?=$OICQ_NO?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> MSN：</td>
<td class="TableData"><?=$ICQ_NO?></td>
</tr>
<tr>
<td nowrap class="TableContent" align="right" width="80"> 备 注：</td>
<td class="TableData"><?=$NOTES?></td>
</tr>
<tr align="center" class="TableControl">
<td colspan="2" nowrap>
<input type="button" value="打印" class="BigButton" onclick="document.execCommand('Print');" title="直接打印表格页面">
<input type="button" value="关闭" class="BigButton" onClick="window.close();" title="关闭窗口">
</td>
</tr>
</table>
<?
}
else
Message("","无未找到相应记录！");
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -