public function GET__PDO() { try { $coPDO = new PDO("mysql:host={$this->Host};dbname={$this->Schema};charset=UTF8", $this->UserName, $this->Password); $coPDO->query("SET NAMES 'utf8'"); $coPDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { ccGeneral::EXCEPTION___Process($e, debug_backtrace()); } return $coPDO; }
public static function RUN__Query__INSERT($Queries, $PDO) { $bSuccess = true; try { $PDO->beginTransaction(); foreach ($Queries as $Query) { $PDO->exec($Query); } $PDO->commit(); } catch (Exception $e) { $PDO->rollBack(); $bSuccess = $e; ccGeneral::EXCEPTION___Process($e, debug_backtrace()); } return $bSuccess; }
public static function vwNews($Inputs) { $PDO = ccPDO::___GET("lbxxdb50", false); $Query = "CALL vwNews(:inUser__Id);"; try { $SP = $PDO->prepare($Query); $SP->bindValue(':inUser__Id', $Inputs['Id'], PDO::PARAM_INT); $SP->execute(); $ResultsSets = array(); while ($SP->columnCount() > 0) { $Response = $SP->fetchAll(PDO::FETCH_ASSOC); $ResultsSets[] = $Response; $SP->nextRowset(); } } catch (Exception $e) { ccGeneral::EXCEPTION___Process($e, debug_backtrace()); } return $ResultsSets; }
public static function MYSQL___Mirror($Function__Name, $Inputs) { $Remote = new stdClass(); $Local = new stdClass(); try { $Remote->PDO = ccPDO::___GET("lbxxdb50", false, "www.loopbill.com"); $Remote->PDO->setAttribute(PDO::ATTR_AUTOCOMMIT, 0); $Remote->PDO->beginTransaction(); $Remote->Results = call_user_func($Function__Name, $Remote->PDO, $Inputs); $Local->PDO = ccPDO::___GET("lbxxdb50", false, "localhost"); $Local->PDO->setAttribute(PDO::ATTR_AUTOCOMMIT, 0); $Local->PDO->beginTransaction(); $Local->Results = call_user_func($Function__Name, $Local->PDO, $Inputs); $Remote->PDO->commit(); $Local->PDO->commit(); } catch (Exception $e) { $Remote->PDO->rollBack(); $Local->PDO->rollBack(); echo "ERROR: An error occured while executing, please review."; ccGeneral::EXCEPTION___Process($e, debug_backtrace()); } // return $Remote->Results; return $Local->Results; }
public static function vwAdmin_Main__WIP() { global $PDO; $Query = "CALL vwAdmin_Main__WIP();"; try { $SP = $PDO->prepare($Query); $SP->execute(); $Result = $SP->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { ccGeneral::EXCEPTION___Process($e, debug_backtrace()); } return $Result; }