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