public function execute($bindValues = array(), $additionalParameters = array(), $query = null)
{
$query = $this->getQuery();
if (!empty($this->binaries)) {
for ($i = 0, $c = count($this->binaries); $i < $c; $i++) {
$query = str_replace("__sbl_binary" . ($i + 1), $this->binaries[$i]->getData(), $query);
}
}
$result = parent::execute($bindValues, $additionalParameters, $query);
if (!$this->isSelect() || empty($result)) {
return $result;
}
$binaryColumns = array();
foreach ($this->metadata->getColumns() as $column) {
if ($column->isBinary()) {
$binaryColumns[] = $column->name;
}
}
if (!empty($binaryColumns)) {
foreach ($result as &$row) {
foreach ($binaryColumns as $colName) {
if (isset($row[$colName])) {
$row[$colName] = pg_unescape_bytea($row[$colName]);
}
}
}
}
return $result;
}
public function execute($bindValues = array(), $additionalParameters = array(), $query = null)
{
$query = $this->getQuery();
if (!empty($this->binaries)) {
for ($i = 0, $c = count($this->binaries); $i < $c; $i++) {
$query = str_replace("__sbl_binary" . ($i + 1), $this->binaries[$i]->getData(), $query);
}
}
return parent::execute($bindValues, $additionalParameters, $query);
}
public function execute($bindValues = array(), $additionalParameters = array(), $query = null)
{
$query = $this->getQuery();
$blobs = $this->blobs;
if (!empty($blobs)) {
$cols = array();
$hlds = array();
foreach (array_keys($blobs) as $column) {
$cols[] = $column;
$hlds[] = ":" . $column;
}
$query .= " RETURNING " . implode(", ", $cols) . " INTO " . implode(", ", $hlds);
}
$additionalParameters["blob"] = $blobs;
return parent::execute($bindValues, $additionalParameters, $query);
}
public function execute($bindValues = array(), $additionalParameters = array())
{
$this->query = preg_replace('/@([a-zA-Z0-9_]+)@/', ':$1', $this->getQuery());
if (empty($bindValues)) {
if (empty($this->bindValues)) {
$bindValues = array();
} else {
$bindValues = $this->escape($this->bindValues);
foreach ($bindValues as $k => $v) {
$bindValues[":{$k}"] = $v;
unset($bindValues[$k]);
}
}
}
return parent::execute($bindValues, $additionalParameters);
}
public function execute($bindValues = array(), $additionalParameters = array())
{
$result = parent::execute($bindValues);
if (!$this->isSelect() || empty($result) || !extension_loaded("mbstring")) {
return $result;
}
$fromEnc = defined("SDB_MSSQL_ENCODING") ? SDB_MSSQL_ENCODING : "SJIS";
$toEnc = mb_internal_encoding();
$columns = $this->metadata->getColumns();
foreach ($result as &$row) {
foreach ($columns as $name => $column) {
if (isset($row[$name]) && ($column->isString() || $column->isText())) {
$row[$name] = mb_convert_encoding($row[$name], $toEnc, $fromEnc);
}
}
}
return $result;
}
public function execute($bindValues = array(), $additionalParameters = array())
{
$result = parent::execute($bindValues, $additionalParameters);
if (!$this->isSelect() || empty($result)) {
return $result;
}
$binaryColumns = array();
foreach ($this->metadata->getColumns() as $column) {
if ($column->isBinary()) {
$binaryColumns[] = $column->name;
}
}
if (!empty($binaryColumns)) {
foreach ($result as &$row) {
foreach ($binaryColumns as $colName) {
if (isset($row[$colName])) {
$row[$colName] = pg_unescape_bytea($row[$colName]);
}
}
}
}
return $result;
}
public function execute($bindValues = array(), $additionalParameters = array(), $query = null)
{
$query = preg_replace('/@([a-zA-Z0-9_]+)@/', ':$1', $this->getQuery());
return parent::execute($bindValues, $additionalParameters, $query);
}
