Pasted

/*@Author: quocvuongdn
*@Twitter: quocvuongdn
*@Site: quocvuongdn.com
*/
class DBMSSQL{
    //Default CardAssociation
     protected $server= 'ip:port'; 
     protected $account= ''; 
     protected $password= '';
     protected $database_name= '';
     protected $conn;
 
    function __construct(){
        $this->connect();
    }
     
    //connect to db
    public function connect(){
        //connect to server
        $this->conn = mssql_connect($this->server,$this->account,$this->password) or die(mssql_get_last_message());
        mssql_select_db($this->database_name) or die(mssql_get_last_message());
    }
    public function call_prcNoParam($spName){
        $stmt = mssql_init($spName);
        $prc_results = mssql_execute($stmt) or die(mssql_get_last_message());
        mssql_free_statement($stmt);
        return $this->processRowSet($prc_results, true);
    }
 
    public function processRowSet($prc_results, $singleRow = false){
        $resultArray = array();
        while($row = mssql_fetch_assoc($prc_results)){
            array_push($resultArray, $row);
        }
        if($singleRow){
            return $resultArray[0];
        }
        return $resultArray;
    }
 
 
    //demo call sp on mssql
    public function call_prcByDate($spName, $fromDate = null, $endDate = null, $flag = 1){
        $stmt = mssql_init($spName);
        if(isset($fromDate) && isset($endDate)){
            mssql_bind($stmt, '@Flag', $flag, SQLINT1);
            mssql_bind($stmt, '@FromDate', $fromDate, SQLVARCHAR);
            mssql_bind($stmt, '@EndDate', $endDate, SQLVARCHAR);
        }
        $prc_results = mssql_execute($stmt) or die(mssql_get_last_message());
        mssql_free_statement($stmt);
        return $this->processRowSet($prc_results, false);
    }
}