/** * Set string param * * @param String $value value to set */ public function set($value) { $transaction = Transaction::getCurrentTransaction(); if (!$transaction) { $connection = new Connection(); } else { $connection = $transaction->getConnection(); } $connection->escapestring($value); $this->params[$this->idx++] = "'" . $value . "'"; }
private static function executeQuery($sqlQuery) { self::$transaction = Transaction::getCurrentTransaction(); self::$connection = self::getConnection(); $query = $sqlQuery->getQuery(); self::$connection->executeQuery("SET NAMES 'utf8'"); $result = self::$connection->executeQuery($query); if (!$result) { throw new Exception("SQL Error: -->" . $query . "<--" . mysql_error()); } return $result; }
/** * Wykonaniew zapytania do bazy * * @param sqlQuery obiekt typu SqlQuery * @return wynik zapytania */ public static function queryForString($sqlQuery){ $transaction = Transaction::getCurrentTransaction(); if(!$transaction){ $connection = new Connection(); }else{ $connection = $transaction->getConnection(); } $result = $connection->executeQuery($sqlQuery->getQuery()); if(!$result){ throw new Exception(mysql_error()); } $row = mysql_fetch_array($result); return $row[0]; }