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