/**
* 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);
}
}
