| 作者: hlmhlm 发布日期:
2006-9-25 |
第一步：conn.php
<? include("ldap.cs.php"); //类文件 ?>
<?
$conn=new ldap("192.168.1.214","cn=root,dc=test,dc=com","secret");参数分别为：服务器ＩＰ，组织结构ＤＮ，数据库密码，端口[一般默认出]
一个简单的示例
$select=new selectRs($conn);
$arr=$select->getArray("o=mail,dc=test,dc=com","cn=*");
echo "共传回资料".$arr["count"]."条
";
//for($j=0;$j<=$arr["count"];$j++){
//echo $a[$j]=$arr[$j]["mail"][0]."
";
//}
$column[0]="mail";
$column[1]="cn";
$column[2]="dn";
$column[3]="userpassword";
//echo "当前的CN为".$arr[1]["dn"];
$a=$select->arrsort($arr,$column);
for($i=0;$i<=count($a);$i++){
echo $a[$i][0]."
";
echo $a[$i][1]."
";
echo $a[$i][2]."
";
echo $a[$i][3]."
";
}
echo $select->getRowNum()."
";
?>
|
| 作者: hlmhlm 发布日期:
2006-9-25 |
需用说明一下，下面这段代码是对存储邮件账号的库进行的增删改查分页的操作，没用使用分页的方法，$this->pagepage($page //初史页,$arr //查询后的结果数组,$column //需要返回的属性，参数类型为数组,$num=5 //每页的记录数);这里就不需要我介绍了吧
include "include/login_inc.php";
include "config/config_inc.php";
include "include/fun_inc.php";
include "language/$CFG_LANGUAGE"."_inc.php";
// get
//$get_page = $_GET['page'];
$get_keyword = $_POST['keyword'];
$Cmd=$_REQUEST["Cmd"];
$mail=$_REQUEST["email"];
$active=chop($_REQUEST["active"]);
$mailuser=chop($_REQUEST["mailuser"]);
$username=$_REQUEST["mail"];
$cn=$_REQUEST["cn"];
$passwd=trim($_REQUEST["passwd"]);
$mquota=$_REQUEST["mquota"];
$fquota=$_REQUEST["fquota"];
if($mquota=="") $mquota=0;
if($fquota=="") $fquota=0;
$quota=($mquota*1024*1024)."S,".$mquota."C";
$description=$_REQUEST["description"];
$accountstatus=$_REQUEST["accountstatus"];
switch($Cmd){
case "del":
$ldaprdn="cn=".$CFG_LDAP_USER.",dc=test,dc=com";
$ldappass=$CFG_LDAP_PASS;
include("conn.php");
$select=new selectRs($conn);
$domain=str_replace('@',"",strrchr($mail,"@"));
$username=str_replace(strrchr($mail,"@"),"",$mail);
exec("/usr/bin/sudo /etc/scripts/sysctrl del mailuser $domain $username",$res,$rc);
if($rc!=0) {
echo "<script>alert('服务操作失败！请重试一次！);location.href='mailuserset.php';</script>";
exit;
}
$select->delete("mail=$mail,domain=$domain,o=mail,dc=test,dc=com");
echo "<script>alert('删除成功！');location.href='mailuserset.php?page=$page';</script>";
//header("location: mailuserset.php?page=$page");
break;
case "active":
$ldaprdn="cn=".$CFG_LDAP_USER.",dc=test,dc=com";
$ldappass=$CFG_LDAP_PASS;
include("conn.php");
$select=new selectRs($conn);
$domain=str_replace('@',"",strrchr($mail,"@"));
$column["accountstatus"]="active";
$select->update("mail=$mail,domain=$domain,o=mail,dc=test,dc=com",$column);
header("location: mailuserset.php?page=$page");
break;
case "deactive":
$ldaprdn="cn=".$CFG_LDAP_USER.",dc=test,dc=com";
$ldappass=$CFG_LDAP_PASS;
include("conn.php");
$select=new selectRs($conn);
$domain=str_replace('@',"",strrchr($mail,"@"));
$column["accountstatus"]="no";
$select->update("mail=$mail,domain=$domain,o=mail,dc=test,dc=com",$column);
header("location: mailuserset.php?page=$page");
break;
case "edit":
$ldaprdn="cn=".$CFG_LDAP_USER.",dc=test,dc=com";
$ldappass=$CFG_LDAP_PASS;
include("conn.php");
$select=new selectRs($conn);
//$domain=str_replace('@',"",strrchr($mail,"@"));
$column["mail"]=$username."@".$SG_DOMAIN;
$column["cn"]=$cn;
if($passwd!=""){
$column["userpassword"]='{MD5}'.base64_encode(pack( 'H*',md5("$passwd")));
}
$column["quota"]=$quota;
$column["description"]=$description;
$column["accountstatus"]=$accountstatus;
$select->update("mail=".$username."@".$SG_DOMAIN.",domain=$SG_DOMAIN,o=mail,dc=test,dc=com",$column);
echo "<script>alert('修改成功！');location.href='mailuserset.php?page=$page';</script>";
//header("location: mailuserset.php?page=$page");
break;
case "insert":
$ldaprdn="cn=".$CFG_LDAP_USER.",dc=test,dc=com";
$ldappass=$CFG_LDAP_PASS;
include("conn.php");
$sel=new selectRs($conn);
$arrs=$sel->getArray("domain=$domain,o=mail,dc=test,dc=com","mail=".$username."@".$SG_DOMAIN."");
if($sel->getRowNum()>0){
echo "<script>alert('对不起！这个账号已有人使用，请重新填写一个');history.back(-1);</script>";
exit;
}
$select=new selectRs($conn);
$column["mail"]=$username."@".$SG_DOMAIN;
if($cn=="") $cn=$username;
if($description=="") $description="_";
$column["cn"]=$cn;
$column["userPassword"]='{MD5}'.base64_encode(pack( 'H*',md5("$passwd")));
$column["quota"]=$quota;
$column["homeDirectory"]="/var/mail/";
$column["objectClass"]="CourierMailAccount";
$column["mailbox"]="$SG_DOMAIN/$username/Maildir/";
$column["description"]=$description;
$column["accountStatus"]=$accountstatus;
exec("/usr/bin/sudo /etc/scripts/sysctrl addmailuser $SG_DOMAIN $username $quota",$res,$rc);
if($rc!=0) {
echo "<script>alert('服务操作失败！请重试一次！);location.href='mailuserset.php';</script>";
exit;
}
$select->insert("mail=".$username."@".$SG_DOMAIN.",domain=$SG_DOMAIN,o=mail,dc=test,dc=com",$column);
echo "<script>alert('操作成功！');location.href='mailuserset.php';</script>";
break;
}
$ldaprdn="cn=".$CFG_LDAP_USER.",dc=test,dc=com";
$ldappass=$CFG_LDAP_PASS;
include("conn.php");
$select=new selectRs($conn);
if($mailuser!=""){ $if="mail=*".$mailuser."*@".$SG_DOMAIN; } else { $if="mail=*@".$SG_DOMAIN;}
if($active=="no"){
$if="accountStatus=no";
//$arr=$select->getArray("domain=$SG_DOMAIN,o=mail,dc=test,dc=com","accountStatus=no");
}
$arr=$select->getArray("domain=$SG_DOMAIN,o=mail,dc=test,dc=com",$if);
//}
$column[0]="mail";
$column[1]="cn";
$column[2]="quota";
$column[3]="accountstatus";
$column[4]="description";
$page=$_REQUEST["page"];
if($page<1) $page=1;
$num=8;
$rownum=$select->getRowNum();
$pagecount=ceil($rownum/$num);
if($page>$pagecount) $page=$pagecount;
$a=$select->arrsort($arr,$column);
$start=($page-1)*$num+1;
$end=$page*$num;
// 处理排序关键字
if($rownum>0){
for($i=$start;$i<=$end;$i++){
if($i>$rownum){
continue;
}
$username=$a[$i][0];
$realname=$a[$i][1];
$quota=$a[$i][2];
$accountstatus=$a[$i][3];
$description=$a[$i][4];
$aa=explode(',',$quota);
$mquota=str_replace('S','',$aa[0]);
$mquota=ceil($mquota/1024/1024);
$fquota=str_replace('C','',$aa[1]);
$user=str_replace(strrchr($username,"@"),"",$username);
unset($aa);
//if($SG_USERNAME==$admin){
if($accountstatus=="active"){ $type=" "; $status=true;$n=0;} else { $type=" "; $status=false;$n=1;}
//if($accountstatus=="active"){ $type="";} else { $type=" |  | "; }
//}
if($SG_USERNAME."@".$SG_DOMAIN!=$username){ $img="";}
$ListOut .= " \n".
"\t".$i." | ".
"".$username." | \n".
"".$realname." | \n".
"".$mquota."/".$fquota." | \n".
"".$type." | \n".
" ".$img." | \n".
"\t \n";
}
}
// 生成page连接索引
function PageIndex($page,$pagecount,$rownum,$mailuser){
$list.="当前是第 $page/$pagecount 页 首页 上一页 ";
$list.="下一页 尾页 共 ".$rownum." 条
";
return $list;
}
// load Template
$OUT['CHARSET'] = $CFG_CHARSET[$Get_Lang]; // 页面字符编码设置
$OUT['HREF_NAME'] = "?sortby=name&page=$get_page&direct=$get_direct";
$OUT['HREF_EMAIL'] = "?sortby=email&page=$get_page&direct=$get_direct";
$OUT['LIST'] = $ListOut;
$OUT['PAGEINDEX'] = PageIndex($page,$pagecount,$rownum,$mailuser);
$OUT['LANG'] = $Get_Lang; // 登录后显示语言
$OUT['NICKNAME'] = $SG_NICKNAME; // 用户姓名
$OUT['EMAIL'] = "$SG_USERNAME@$SG_DOMAIN"; // 用户email地址
include "template/$CFG_TEMPLATE/_adv.php";
include "template/$CFG_TEMPLATE/_mailuserset.php";
ＬＤＡＰ是一种专为读而设计的库，查询速度是目前快的，非常适合于在邮件系统中对大量的邮件账号的存储
|
