My First Time For PHP
前言
第一次接触PHP，功能需求很简单：负责提供WEB接口，接收数据，然后与数据库交互，最终响应XML结果。过程中接触了PHP的很多常用语法和功能，比如PDO对数据库的操作、XML操作、面向对象、正则表达式、输出输出......等等。基本是上网搜索示例，然后自己摸索着写代码，因为N年来一直写的是.Net，所以项目过程中受到.Net很大影响，用了三层构架，甚至为每个PHP接口写了一个类似CodeBehind的Class，没有时间了解PHP下的开发框架，完全按自己的想法搭建的项目。在此篇随笔记录，以便以后备忘查询，也希望得到PHP专业人士的指点。
DAL
原本是想封装个DBUtility的类，但几天时间无法对PDO了解的全面和应用自如，只得把数据库相关操作混合在DAL中。
代码<?php
/************************************************************
DAL
wujian 2010-01-19
************************************************************/
define("DB_BASIC", "mysql:host=localhost;dbname=asterisk");
define("DB_USER","root");
define("DB_PSWD", "root");
class DAL
{
private static $pdo;
//构造函数
public function __construct()
{
//
}
//判断分组是否存在
public function GroupExist($grpid)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "SELECT COUNT(*) FROM extension_group WHERE `grp_id` = ".$grpid;
$rs = $this->pdo->query($cmd);
$arr = $rs->fetchAll();
$this->pdo = null;
if($arr[0][0] == 1)
{
return true;
}
else
{
return false;
}
}
//判断分机是否存在
public function ExtensionExist($etn)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "SELECT COUNT(*) FROM extension_email WHERE `etn` = '".$etn."'";
$rs = $this->pdo->query($cmd);
$arr = $rs->fetchAll();
$this->pdo = null;
if($arr[0][0] == 1)
{
return true;
}
else
{
return false;
}
}
//添加分机(分机号，分组ID，EMAIL，名称，备注)
public function ExtensionAdd($etn, $grpid, $email, $name, $desc)
{
/*prepare方式
$stmt = $this->pdo->prepare("INSERT INTO extensionemail (`etn`, `grp_id`, `email`, `nm`, `desc`) VALUES (:a, :b, :c, :d, :e)");
$stmt->bindParam(':a', $etn);
$stmt->bindParam(':b', $grpid);
$stmt->bindParam(':c', $email);
$stmt->bindParam(':d', $name);
$stmt->bindParam(':e', $desc);
$stmt->execute();
*/
/*exec方式*/
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "INSERT INTO extension_email (`etn`, `grp_id`, `email`, `nm`, `desc`) VALUES ('".$etn."', ".$grpid.", '".$email."', '".$name."', '".$desc."')";
$s = $this->pdo->exec($cmd);
$this->pdo = null;
if($s == 1){
return true;
}
else{
return false;
}
}
//更新分机(分机号，分组ID，EMAIL，名称，备注)
public function ExtensionEdit($etn, $grpid, $email, $name, $desc)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "UPDATE extension_email SET `grp_id` = ".$grpid.", `email` = '".$email."', `nm` = '".$name."', `desc` = '".$desc."' WHERE `etn` = ".$etn;
$s = $this->pdo->exec($cmd);
$this->pdo = null;
if($s == 1){
return true;
}
else{
return false;
}
}
//激活分机
public function ExtensionAct($etn, $state)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "UPDATE extension_email SET `state` = ".$state.", `reg_time` = CURRENT_TIMESTAMP() WHERE `etn` = ".$etn;
$s = $this->pdo->exec($cmd);
$this->pdo = null;
if($s == 1){
return true;
}
else{
return false;
}
}
//分机列表
public function ExtensionList($grpid)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "SELECT * FROM extension_email WHERE `grp_id` = ".$grpid;
if($grpid == 0)
{
$cmd = "SELECT * FROM extension_email";
}
$rs = $this->pdo->query($cmd);
$arr = $rs->fetchAll();
$this->pdo = null;
return $arr;
}
//分组列表
public function GroupList()
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "SELECT * FROM extension_group";
$rs = $this->pdo->query($cmd);
$arr = $rs->fetchAll();
$this->pdo = null;
return $arr;
}
}
?>
/************************************************************
DAL
wujian 2010-01-19
************************************************************/
define("DB_BASIC", "mysql:host=localhost;dbname=asterisk");
define("DB_USER","root");
define("DB_PSWD", "root");
class DAL
{
private static $pdo;
//构造函数
public function __construct()
{
//
}
//判断分组是否存在
public function GroupExist($grpid)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "SELECT COUNT(*) FROM extension_group WHERE `grp_id` = ".$grpid;
$rs = $this->pdo->query($cmd);
$arr = $rs->fetchAll();
$this->pdo = null;
if($arr[0][0] == 1)
{
return true;
}
else
{
return false;
}
}
//判断分机是否存在
public function ExtensionExist($etn)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "SELECT COUNT(*) FROM extension_email WHERE `etn` = '".$etn."'";
$rs = $this->pdo->query($cmd);
$arr = $rs->fetchAll();
$this->pdo = null;
if($arr[0][0] == 1)
{
return true;
}
else
{
return false;
}
}
//添加分机(分机号，分组ID，EMAIL，名称，备注)
public function ExtensionAdd($etn, $grpid, $email, $name, $desc)
{
/*prepare方式
$stmt = $this->pdo->prepare("INSERT INTO extensionemail (`etn`, `grp_id`, `email`, `nm`, `desc`) VALUES (:a, :b, :c, :d, :e)");
$stmt->bindParam(':a', $etn);
$stmt->bindParam(':b', $grpid);
$stmt->bindParam(':c', $email);
$stmt->bindParam(':d', $name);
$stmt->bindParam(':e', $desc);
$stmt->execute();
*/
/*exec方式*/
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "INSERT INTO extension_email (`etn`, `grp_id`, `email`, `nm`, `desc`) VALUES ('".$etn."', ".$grpid.", '".$email."', '".$name."', '".$desc."')";
$s = $this->pdo->exec($cmd);
$this->pdo = null;
if($s == 1){
return true;
}
else{
return false;
}
}
//更新分机(分机号，分组ID，EMAIL，名称，备注)
public function ExtensionEdit($etn, $grpid, $email, $name, $desc)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "UPDATE extension_email SET `grp_id` = ".$grpid.", `email` = '".$email."', `nm` = '".$name."', `desc` = '".$desc."' WHERE `etn` = ".$etn;
$s = $this->pdo->exec($cmd);
$this->pdo = null;
if($s == 1){
return true;
}
else{
return false;
}
}
//激活分机
public function ExtensionAct($etn, $state)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "UPDATE extension_email SET `state` = ".$state.", `reg_time` = CURRENT_TIMESTAMP() WHERE `etn` = ".$etn;
$s = $this->pdo->exec($cmd);
$this->pdo = null;
if($s == 1){
return true;
}
else{
return false;
}
}
//分机列表
public function ExtensionList($grpid)
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "SELECT * FROM extension_email WHERE `grp_id` = ".$grpid;
if($grpid == 0)
{
$cmd = "SELECT * FROM extension_email";
}
$rs = $this->pdo->query($cmd);
$arr = $rs->fetchAll();
$this->pdo = null;
return $arr;
}
//分组列表
public function GroupList()
{
$this->pdo = new PDO(DB_BASIC, DB_USER, DB_PSWD);
$cmd = "SELECT * FROM extension_group";
$rs = $this->pdo->query($cmd);
$arr = $rs->fetchAll();
$this->pdo = null;
return $arr;
}
}
?>
BLL
业务层调用DAL，并为UI提供服务
代码<?php
/************************************************************
BLL
吴剑 2010-01-19
************************************************************/
require "dal.php";
class BLL
{
private static $myDAL;
//构造函数
public function __construct()
{
$this->myDAL = new DAL();
}
//判断分组是否存在
public function GroupExist($grpid)
{
return $this->myDAL->GroupExist($grpid);
}
//判断分机是否存在
public function ExtensionExist($etn)
{
return $this->myDAL->ExtensionExist($etn);
}
//添加分机(分机号，EMAIL，名称，备注)
public function ExtensionAdd($etn, $grpid, $email, $name, $desc)
{
return $this->myDAL->ExtensionAdd($etn, $grpid, $email, $name, $desc);
}
//更新分机(分机号，分组ID，EMAIL，名称，备注)
public function ExtensionEdit($etn, $grpid, $email, $name, $desc)
{
return $this->myDAL->ExtensionEdit($etn, $grpid, $email, $name, $desc);
}
//激活分机
public function ExtensionAct($etn, $state)
{
return $this->myDAL->ExtensionAct($etn, $state);
}
//分机列表
public function ExtensionList($grpid)
{
return $this->myDAL->ExtensionList($grpid);
}
//分组列表
public function GroupList()
{
return $this->myDAL->GroupList();
}
}
?>
/************************************************************
BLL
吴剑 2010-01-19
************************************************************/
require "dal.php";
class BLL
{
private static $myDAL;
//构造函数
public function __construct()
{
$this->myDAL = new DAL();
}
//判断分组是否存在
public function GroupExist($grpid)
{
return $this->myDAL->GroupExist($grpid);
}
//判断分机是否存在
public function ExtensionExist($etn)
{
return $this->myDAL->ExtensionExist($etn);
}
//添加分机(分机号，EMAIL，名称，备注)
public function ExtensionAdd($etn, $grpid, $email, $name, $desc)
{
return $this->myDAL->ExtensionAdd($etn, $grpid, $email, $name, $desc);
}
//更新分机(分机号，分组ID，EMAIL，名称，备注)
public function ExtensionEdit($etn, $grpid, $email, $name, $desc)
{
return $this->myDAL->ExtensionEdit($etn, $grpid, $email, $name, $desc);
}
//激活分机
public function ExtensionAct($etn, $state)
{
return $this->myDAL->ExtensionAct($etn, $state);
}
//分机列表
public function ExtensionList($grpid)
{
return $this->myDAL->ExtensionList($grpid);
}
//分组列表
public function GroupList()
{
return $this->myDAL->GroupList();
}
}
?>
UI
虽然在PHP中用类似CodeBehind的方式没有事件与页面控件的关联，没有Class与Page间的对象继承关系，但还是觉得这样分离逻辑会更清晰，也许长期用.Net的惯性思维，不喜欢将逻辑代码嵌套在页面中。
extension_add.php
<?php
require "extension_add.class.php";
?>
require "extension_add.class.php";
?>
extension_edit.class.php
代码<?php
/************************************************************
添加分机
吴剑 2010-01-19
************************************************************/
//加载公共类
require "class/common.php";
//加载业务类
require "class/bll.php";
define("AUTH_KEY", "test");
class ExtensionAdd
{
//页面初始化
static function pageLoad()
{
$guidID = "";
//0：成功 1：密钥无效 2：提交数据格式有误 3：分机号已存在 4：分组不存在 9：接口异常
$result = 9;
if(isset($_POST["data"]))
{
try
{
$doc = new DOMDocument();
$doc->loadXML($_POST["data"]);
$root = simplexml_import_dom($doc);
$the_authKey = $root->head->authKey;
$the_guidID = $root->head->guidID;
$the_extension = $root->body->extension;
$the_groupID = $root->body->groupID;
$the_email = $root->body->email;
$the_name = $root->body->name;
$the_desc = $root->body->desc;
$guidID = $the_guidID;
//数据格式验证
if(Common::IsExtension($the_extension) && Common::IsInt($the_groupID) && Common::IsEmail($the_email))
{
//密钥验证
if($the_authKey == AUTH_KEY)
{
//创建业务对象
$myBLL = new BLL();
//分机是否存在
if($myBLL->ExtensionExist($the_extension))
{
$result = 3;
}
else
{
//分组是否存在
if($myBLL->GroupExist($the_groupID))
{
if($myBLL->ExtensionAdd($the_extension, $the_groupID, $the_email, $the_name, $the_desc))
{
$result = 0;
}
}
else
{
$result = 4;
}
}
}
else
{
//密钥无效
$result = 1;
}
}
else
{
//数据格式有误
$result = 2;
}
}
catch(Exception $e)
{
//数据格式有误
$result = 2;
}
}
else
{
//提交数据格式有误
$result = 2;
}
$xml = "<?xml version='1.0' encoding='utf-8' ?>";
$xml = $xml . "<output>";
$xml = $xml . "<head>";
$xml = $xml . "<guidID>" . $guidID . "</guidID>";
$xml = $xml . "</head>";
$xml = $xml . "<body>";
$xml = $xml . "<result>" . $result . "</result>";
$xml = $xml . "</body>";
$xml = $xml . "</output>";
//指定页面编码
header("content-type:text/xml; charset=utf-8");
echo($xml);
}
}
ExtensionAdd::pageLoad();
?>
/************************************************************
添加分机
吴剑 2010-01-19
************************************************************/
//加载公共类
require "class/common.php";
//加载业务类
require "class/bll.php";
define("AUTH_KEY", "test");
class ExtensionAdd
{
//页面初始化
static function pageLoad()
{
$guidID = "";
//0：成功 1：密钥无效 2：提交数据格式有误 3：分机号已存在 4：分组不存在 9：接口异常
$result = 9;
if(isset($_POST["data"]))
{
try
{
$doc = new DOMDocument();
$doc->loadXML($_POST["data"]);
$root = simplexml_import_dom($doc);
$the_authKey = $root->head->authKey;
$the_guidID = $root->head->guidID;
$the_extension = $root->body->extension;
$the_groupID = $root->body->groupID;
$the_email = $root->body->email;
$the_name = $root->body->name;
$the_desc = $root->body->desc;
$guidID = $the_guidID;
//数据格式验证
if(Common::IsExtension($the_extension) && Common::IsInt($the_groupID) && Common::IsEmail($the_email))
{
//密钥验证
if($the_authKey == AUTH_KEY)
{
//创建业务对象
$myBLL = new BLL();
//分机是否存在
if($myBLL->ExtensionExist($the_extension))
{
$result = 3;
}
else
{
//分组是否存在
if($myBLL->GroupExist($the_groupID))
{
if($myBLL->ExtensionAdd($the_extension, $the_groupID, $the_email, $the_name, $the_desc))
{
$result = 0;
}
}
else
{
$result = 4;
}
}
}
else
{
//密钥无效
$result = 1;
}
}
else
{
//数据格式有误
$result = 2;
}
}
catch(Exception $e)
{
//数据格式有误
$result = 2;
}
}
else
{
//提交数据格式有误
$result = 2;
}
$xml = "<?xml version='1.0' encoding='utf-8' ?>";
$xml = $xml . "<output>";
$xml = $xml . "<head>";
$xml = $xml . "<guidID>" . $guidID . "</guidID>";
$xml = $xml . "</head>";
$xml = $xml . "<body>";
$xml = $xml . "<result>" . $result . "</result>";
$xml = $xml . "</body>";
$xml = $xml . "</output>";
//指定页面编码
header("content-type:text/xml; charset=utf-8");
echo($xml);
}
}
ExtensionAdd::pageLoad();
?>
extension_list.class.php
代码<?php
/************************************************************
分机列表
吴剑 2010-01-19
************************************************************/
//加载业务类
require "class/bll.php";
define("AUTH_KEY", "test");
class ExtensionList
{
//页面初始化
static function pageLoad()
{
$guidID = "";
//0：成功 1：密钥无效 2：提交数据格式有误 3：分机号已存在 4：分组不存在 9：接口异常
$etn = "";
if(isset($_POST["data"]))
{
try
{
$doc = new DOMDocument();
$doc->loadXML($_POST["data"]);
$root = simplexml_import_dom($doc);
$the_authKey = $root->head->authKey;
$the_guidID = $root->head->guidID;
$the_groupID = $root->body->groupID;
$guidID = $the_guidID;
//密钥验证
if($the_authKey == AUTH_KEY)
{
//创建业务对象
$myBLL = new BLL();
$arr = $myBLL->ExtensionList($the_groupID);
foreach($arr as $row)
{
$etn = $etn . "<extension>";
$etn = $etn . "<extensionNumber>".$row["etn"]."</extensionNumber>";
$etn = $etn . "<groupID>".$row["grp_id"]."</groupID>";
$etn = $etn . "<email>".$row["email"]."</email>";
$etn = $etn . "<name>".$row["nm"]."</name>";
$etn = $etn . "<desc><![CDATA[".$row["desc"]."]]></desc>";
$etn = $etn . "<state>".$row["state"]."</state>";
$etn = $etn . "<regTime>".$row["reg_time"]."</regTime>";
$etn = $etn . "</extension>";
}
}
}
catch(Exception $e)
{
//
}
}
$xml = "<?xml version='1.0' encoding='utf-8' ?>";
$xml = $xml . "<output>";
$xml = $xml . "<head>";
$xml = $xml . "<guidID>" . $guidID . "</guidID>";
$xml = $xml . "</head>";
$xml = $xml . "<body>".$etn."</body>";
$xml = $xml . "</output>";
//指定页面编码
header("content-type:text/xml; charset=utf-8");
echo($xml);
}
}
ExtensionList::pageLoad();
?>
/************************************************************
分机列表
吴剑 2010-01-19
************************************************************/
//加载业务类
require "class/bll.php";
define("AUTH_KEY", "test");
class ExtensionList
{
//页面初始化
static function pageLoad()
{
$guidID = "";
//0：成功 1：密钥无效 2：提交数据格式有误 3：分机号已存在 4：分组不存在 9：接口异常
$etn = "";
if(isset($_POST["data"]))
{
try
{
$doc = new DOMDocument();
$doc->loadXML($_POST["data"]);
$root = simplexml_import_dom($doc);
$the_authKey = $root->head->authKey;
$the_guidID = $root->head->guidID;
$the_groupID = $root->body->groupID;
$guidID = $the_guidID;
//密钥验证
if($the_authKey == AUTH_KEY)
{
//创建业务对象
$myBLL = new BLL();
$arr = $myBLL->ExtensionList($the_groupID);
foreach($arr as $row)
{
$etn = $etn . "<extension>";
$etn = $etn . "<extensionNumber>".$row["etn"]."</extensionNumber>";
$etn = $etn . "<groupID>".$row["grp_id"]."</groupID>";
$etn = $etn . "<email>".$row["email"]."</email>";
$etn = $etn . "<name>".$row["nm"]."</name>";
$etn = $etn . "<desc><![CDATA[".$row["desc"]."]]></desc>";
$etn = $etn . "<state>".$row["state"]."</state>";
$etn = $etn . "<regTime>".$row["reg_time"]."</regTime>";
$etn = $etn . "</extension>";
}
}
}
catch(Exception $e)
{
//
}
}
$xml = "<?xml version='1.0' encoding='utf-8' ?>";
$xml = $xml . "<output>";
$xml = $xml . "<head>";
$xml = $xml . "<guidID>" . $guidID . "</guidID>";
$xml = $xml . "</head>";
$xml = $xml . "<body>".$etn."</body>";
$xml = $xml . "</output>";
//指定页面编码
header("content-type:text/xml; charset=utf-8");
echo($xml);
}
}
ExtensionList::pageLoad();
?>
Common
主要应用了正则表达式
代码<?php
/************************************************************
公共
吴剑 2010-01-19
************************************************************/
class Common
{
//非空验证
static function IsNon($str)
{
return true;
}
//正整数验证
static function IsInt($str)
{
$reg = "^[0-9]+$";
if(ereg($reg, $str))
{
return true;
}
else
{
return false;
}
}
//分机号格式验证
static function IsExtension($str)
{
$reg = "^[0-9]+$";
if(ereg($reg, $str))
{
return true;
}
else
{
return false;
}
}
//Email格式验证
static function IsEmail($str)
{
$reg = "^([_a-zA-Z0-9+\.]+@([_a-zA-Z0-9]+\.)+[a-zA-Z0-9]{2,4})?$";
if(ereg($reg, $str))
{
return true;
}
else
{
return false;
}
}
}
?>
/************************************************************
公共
吴剑 2010-01-19
************************************************************/
class Common
{
//非空验证
static function IsNon($str)
{
return true;
}
//正整数验证
static function IsInt($str)
{
$reg = "^[0-9]+$";
if(ereg($reg, $str))
{
return true;
}
else
{
return false;
}
}
//分机号格式验证
static function IsExtension($str)
{
$reg = "^[0-9]+$";
if(ereg($reg, $str))
{
return true;
}
else
{
return false;
}
}
//Email格式验证
static function IsEmail($str)
{
$reg = "^([_a-zA-Z0-9+\.]+@([_a-zA-Z0-9]+\.)+[a-zA-Z0-9]{2,4})?$";
if(ereg($reg, $str))
{
return true;
}
else
{
return false;
}
}
}
?>
