My First Time For PHP

前言

第一次接觸PHP，功能需求很簡單：負責提供WEB介面，接收資料，然後與資料庫互動，最終響應XML結果。過程中接觸了PHP的很多常用文法和功能，比如PDO對資料庫的操作、XML操作、物件導向、Regex、輸出輸出......等等。基本是上網搜尋樣本，然後自己摸索著寫代碼，因為N年來一直寫的是.Net，所以項目過程中受到.Net很大影響，用了三層構架，甚至為每個PHP介面寫了一個類似CodeBehind的Class，沒有時間瞭解PHP下的開發架構，完全按自己的想法搭建的項目。在此篇隨筆記錄，以便以後備忘查詢，也希望得到PHP專業人士的指點。

DAL

原本是想封裝個DBUtility的類，但幾天時間無法對PDO瞭解的全面和應用自如，只得把資料庫相關操作混合在DAL中。

代碼

/* ***********************************************************
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提供服務

代碼

/* ***********************************************************
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

require " extension_add.class.php " ;
?>

extension_edit.class.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 = $xml . " " ;
$xml = $xml . " " ;
$xml = $xml . " " . $guidID . " " ;
$xml = $xml . " " ;
$xml = $xml . " " ;
$xml = $xml . " " . $result . " " ;
$xml = $xml . " " ;
$xml = $xml . " " ;

// 指定頁面編碼
header ( " content-type:text/xml; charset=utf-8 " );
echo ( $xml );
}
}

ExtensionAdd :: pageLoad();

?>

extension_list.class.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 . " " ;
$etn = $etn . " " . $row [ " etn " ] . " " ;
$etn = $etn . " " . $row [ " grp_id " ] . " " ;
$etn = $etn . " " . $row [ " email " ] . " " ;
$etn = $etn . " " . $row [ " nm " ] . " " ;
$etn = $etn . " " . $row [ " desc " ] . " " ;
$etn = $etn . " " . $row [ " state " ] . " " ;
$etn = $etn . " " . $row [ " reg_time " ] . " " ;
$etn = $etn . " " ;
}
}
}
catch ( Exception $e )
{
//
}
}

$xml = " " ;
$xml = $xml . " " ;
$xml = $xml . " " ;
$xml = $xml . " " . $guidID . " " ;
$xml = $xml . " " ;
$xml = $xml . " " . $etn . " " ;
$xml = $xml . " " ;

// 指定頁面編碼
header ( " content-type:text/xml; charset=utf-8 " );
echo ( $xml );
}
}

ExtensionList :: pageLoad();

?>

Common

主要應用了Regex

代碼

/* ***********************************************************
公用
吳劍 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 ;
}
}
}

?>

