📄 show_contacts.php
字号:
<?
include "logincheck.php";
include_once "myconnect.php";
include_once "date_time_format.php";
$msg1="";
$to_delete="";
$items_removed=0;
if ( count($_POST)<>0 )
{
/////////////////////////// A REQUEST TO DELETE SOME CONTACTS ///////////////
for($i=1;$i<=$_REQUEST["cnt"];$i++)
{
if ( isset($_REQUEST["checkbox" . $i]) ) //Is the checkbox ticked
{
if ($to_delete!="") { $to_delete.="," ; } //To insert comma??
$to_delete.= $_REQUEST["checkbox" . $i]; //Add another item to delete
$items_removed++;
}
} //End For
if ($to_delete=="")
{
$msg1=" Unable to remove any user from the Contact List ";
}
else
{
$del_str=" Delete from sbbleads_contacts where sb_id IN (" . $to_delete .")";
mysql_query($del_str);
$msg1= $items_removed . " User(s) have been removed from your Contact List";
}
header("Location:"." msg_confirm_mem.php?errmsg=".urlencode($msg1));
die();
/////////////////////////////CONTACTS HAVE BEEN REMOVED /////////////////////
}
function main()
{
$config=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
$rs0_query=mysql_query("Select count(*) from sbbleads_contacts where sb_uid =" .$_SESSION["sbbleads_userid"] );
$rs0=mysql_fetch_array($rs0_query);
$contact_count=$rs0[0];
$rs0_query=mysql_query("Select * from sbbleads_members,sbbleads_contacts where sbbleads_contacts.sb_contact_id=sbbleads_members.sb_id and sb_uid =" .$_SESSION["sbbleads_userid"] );
?>
<script language="JavaScript">
function validate(form)
{
if((form.username.value==""))
{
alert('Please specify Member ID');
form.username.focus();
return false;
}
return true;
}
</script>
<table width="100%" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td colspan="3" valign="top"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="titlestyle"> Add to Contact List</td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="5" class="onepxtable">
<form name="form1" method="post" action="addcontact.php" onSubmit="return validate(this);">
<tr valign="top">
<td width="40%" align="right" class="innertablestyle"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="right">
<td width="60%"><font class="normal"><strong><font class='normal'>
</font></strong></font></td>
<td><font class="normal"><strong><font class='normal'>Member
ID</font></strong></font></td>
</tr>
</table></td>
<td width="6"> </td>
<td width="60%"><font face="Arial, Helvetica, sans-serif" size="2">
<input type="text" name="username">
</font></td>
</tr>
<tr valign="top">
<td align="right" class="innertablestyle"> </td>
<td> </td>
<td><input type="submit" name="Submit2" value="Add User"></td>
</tr>
</form>
</table></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="25" colspan="3" valign="middle"> <div align="center"><font class='red'>
</font></div></td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" class="onepxtable">
<tr >
<td valign="top"> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="0" class="innertablestyle">
<tr>
<td height="25" class="titlestyle"> My Contacts</td>
</tr>
<tr>
<td height="25" valign="middle"><font class='normal'>Your
contact list contains <strong><font class='red'><?php echo $contact_count; ?></font></strong>
entries.</font><font class='red'><br>
</font></td>
</tr>
<tr>
<td height="25" valign="middle"><font class='normal'>To
remove a user from your contacts list just click the check
box and click the remove button below.</font></td>
</tr>
<tr>
<td valign="top"> <script language="JavaScript">
//<!--
function select_all()
{
for (var i=0;i<document.form2.elements.length;i++)
{
var e =document. form2.elements[i];
if ((e.name != 'check_all') && (e.type=='checkbox'))
{
e.checked = document.form2.check_all.checked;
}
}
}
//-->
</script> <form name="form2" method="post" action="show_contacts.php">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr class="subtitle">
<td width="10" align="right"> <input name="check_all" type="checkbox" id="check_all" onClick="select_all();" value="yes"></td>
<td height="25"><b><font class='normal'>Member
ID </font></b></td>
<td><b><font class='normal'>Company Name </font></b></td>
<td><b><font class='normal'>Phone</font></b></td>
<td><b><font class='normal'>Fax</font></b></td>
</tr>
<?
$cnt=0;
while ($rs0=mysql_fetch_array($rs0_query))
{
$cnt++;
$company_name=$config["sb_null_char"];
$phone=$config["sb_null_char"];
$fax=$config["sb_null_char"];
$mem_comp=mysql_fetch_array(mysql_query("select * from sbbleads_companyprofiles where sb_uid=".$rs0["sb_contact_id"]));
if($mem_comp)
{
$company_name=$mem_comp["sb_companyname"];
$phone=$mem_comp["sb_phone"];
$fax=$mem_comp["sb_fax"];
}
?>
<tr>
<td width="10" align="right" ><font class='normal'>
<input type="checkbox" name="checkbox<?php echo $cnt;?>" value="<?php
echo $rs0["sb_id"];?>">
</font></td>
<td ><font class='normal'><a href="replyuser.php?type=contact&tid=<?php echo $rs0["sb_contact_id"];?>" ><?php echo $rs0["sb_username"];?></a>
</font></td>
<td><font class='normal'><? echo $company_name;?></font></td>
<td><font class='normal'><? echo $phone;?></font></td>
<td><font class='normal'><? echo $fax;?></font></td>
</tr>
<?
}
?>
<tr >
<td colspan="2" align="left"> <input type="hidden" name="cnt" value="<?php echo $cnt; ?>">
<input type="submit" name="Submit3" value="Remove">
</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
</table>
<?
}// end main
include "template1.php";
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -