/** * Execute Query * @param $Connection * @param bool|false $Return * @param bool|false $Multiple * @return mixed */ public function executePDO($Connection, $Return = false, $Multiple = false) { $Statement = $Connection->prepare($this->FinalQuery); foreach ($this->Where as $Condition => $Item) { $Statement->bindParam($Condition, $this->Relations[$Condition]); } $Statement->execute(); if ($Return) { if ($Multiple) { if (Database::isEmpty($Statement)) { return false; } else { return $Statement->fetchAll(\PDO::FETCH_ASSOC); } } else { if (Database::isEmpty($Statement)) { return false; } else { return $Statement->fetch(\PDO::FETCH_ASSOC); } } } else { return true; } }
/** * Execute Plain Query With No Paramaters and PDO Object * @param $PDO * @param $Query * @param bool|false $Return * @param bool|false $Multiple * @return array|bool|mixed */ public static function plainSQLPDO(PDO $PDO, $Query, $Return = false, $Multiple = false) { try { $Statement = $PDO->prepare($Query); $Statement->execute(); if ($Return == true) { if (Database::isEmpty($Statement)) { return false; } else { if ($Multiple == false) { return $Statement->fetch(PDO::FETCH_ASSOC); } else { return $Statement->fetchAll(PDO::FETCH_ASSOC); } } } } catch (PDOException $e) { $Message = Database::PDOExceptionMessage($e); die($Message); } }