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; }
<?php $Path_Root = ccGeneral::GET___Path__Root(); require_once $Path_Root . '/Admin/PHP/Models/TXT.Types.php'; class ccPhrase__Custom { public $iPhrases = array(); public $Value; // <editor-fold defaultstate="collapsed" desc="CONSTRUCT"> public static function __NEW_AFTER___N(ccTXT__Phrases__Facts $Phrases, $A_Phrase, $N_Phrases) { $Phrase_Custom = new ccPhrase__Custom(); $iPhrase_Frst = $Phrases->Retained->GET__iPhrase__Max() + $A_Phrase; $iPhrase_Last = $Phrases->Retained->GET__iPhrase__Max() + $N_Phrases; for ($iPhrase_C = $iPhrase_Frst; $iPhrase_C <= $iPhrase_Last; $iPhrase_C++) { $Phrase_C = $Phrases->__slice($iPhrase_C); $Phrase_Custom->ADD___After($iPhrase_C, $Phrase_C); } return $Phrase_Custom; } public static function __NEW_AFTER___N_whLine(ccTXT__Phrases__Facts $Phrases, $A_Phrase_Frst, $N_Lines) { $Phrase_Custom = new self(); $iPhrase_Frst = $Phrases->Retained->GET__iPhrase__Max() + $A_Phrase_Frst; $iLine_Frst = $Phrases->iLines[$iPhrase_Frst][0]; for ($iPhrase_C = $iPhrase_Frst; $iPhrase_C < count($Phrases->Values); $iPhrase_C++) { $Phrase_C = $Phrases->__slice($iPhrase_C); if ($Phrase_C->Status === 0) { break; } $Line_Count = $Phrase_C->iLine - $iLine_Frst;
public static function MOVE__Files($Files__Names, $From, $To) { $Path__Root = ccGeneral::GET___Path__Root(); foreach ($Files__Names as $File__Name) { $Path__From = $Path__Root . '/Tickets/' . $From . '/Originals/' . $File__Name; $Path__To = $Path__Root . '/Tickets/' . $To . '/Originals/' . $File__Name; rename($Path__From, $Path__To); $Path__From = $Path__Root . '/Tickets/' . $From . '/Thumbnails/' . $File__Name; $Path__To = $Path__Root . '/Tickets/' . $To . '/Thumbnails/' . $File__Name; rename($Path__From, $Path__To); $File_TXT = pathinfo($File__Name, PATHINFO_FILENAME) . '.txt'; $Path__From = $Path__Root . '/Tickets/' . $From . '/TXT/' . $File_TXT; if (file_exists($Path__From) === true) { $Path__To = $Path__Root . '/Tickets/' . $To . '/TXT/' . $File_TXT; rename($Path__From, $Path__To); } } $bSuccess = true; return $bSuccess; }