?? contact_search.php
字號:
<?
########################################
#OsoonCrm
#聯系人檢索
########################################
include "include/db.inc.php";
include "include/check.inc.php";
include "include/header.inc.php";
include "include/array.inc.php";
// 翻頁
$tblname = $tbl_crm_contact;
$where = " where ContactName like '%$contactname%' AND AddID='$G_uid' ";
$url = "contact_search.php?";
$sql_count = "select count(*) from $tblname $where";
$res_count = mysql_query($sql_count);
$row_count = @mysql_fetch_array($res_count);
$total = $row_count[0];
include "include/function.inc.php";
pagelink($total, $url);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="90%">
<tr valign=top>
<td width="201">
<?
include "include/left.inc.php";
?>
</td>
<td>
<?
$limitstart = ($page-1)*$perpage;
$sql="select * from $tbl_crm_contact $where order by ContactID desc limit $limitstart,$perpage";
$res=mysql_query($sql);
?>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height=25>
<tr align="right">
<td>
<a href="contact_add.php">添加聯系人</a>
|
<a href="contact_list.php">聯系人列表</a>
</td>
</tr>
</table>
<hr>
<table width=95% cellpadding="5" cellspacing="0" align=center border="1" bordercolor="#F5F1E9">
<tr bgcolor=#ede5d2>
<td>聯系人</td>
<td>稱謂</td>
<td>職務</td>
<td>部門</td>
<td>工作電話</td>
<td>電子郵件</td>
<td bgcolor="#ede5d2">操作</td>
</tr>
<? while($row=mysql_fetch_array($res)){?>
<tr>
<td><? echo $row[ContactName]?></td>
<td><? echo $row[ChenWei]?></td>
<td><? echo $row[ZhiWu]?></td>
<td><? echo $row[Dept]?></td>
<td><? echo $row[OfficeTel]?></td>
<td><a href=mailto:<? echo $row[Email]?>><? echo $row[Email]?></a></td>
<td><A HREF="contact_view.php?viewid=<? echo $row[ContactID]?>">詳細</A></td>
</tr>
<?}?>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height=25>
<tr align="right">
<td><? echo $pagelink; ?></td>
</tr>
</table>
</td>
</tr>
</table>
<? include "include/footer.inc.php"; ?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -