/**
* Will make a query with the mysql server
* @param string $query
* @return mixed return query result
*/
function query($query)
{
$this->lastquery = $query;
$this->query_cache[] = $query;
$this->querys += 1;
$res = new db_result($this->CLASS);
$res->setQuery($query);
$res->setResult(sqlite_query($query, $this->connection));
if ($res->getResult() === false) {
$this->CLASS['error']->log("ERROR IN QUERY: \"{$query}\"", 1, sqlite_errno() . ":" . sqlite_errno());
}
return $res;
}
/**
* Will make a query with the mysql server
* @param string $query
* @return mixed return query result
*/
function query($query)
{
$this->lastquery = $query;
$this->query_cache[] = $query;
$this->querys += 1;
$res = new db_result($this->CLASS);
$res->setQuery($query);
$res->setResult($this->connection->query($query));
if ($res->getResult() === false) {
echo "#" . $query . "#";
$this->CLASS['error']->log("ERROR IN QUERY: \"{$query}\"", 1, $this->connection->lastErrorMsg() . ":" . $this->connection->lastErrorCode());
}
return $res;
}
/**
* Will make a query with the server
* @param string $query
* @return resource return query result
*/
function query($query)
{
$this->lastquery = $query;
$this->query_cache[] = $query;
$this->querys += 1;
$res = new db_result($this->CLASS);
$res->setQuery($query);
$res->setResult($this->mdb2->query($query));
// if error in query
if (PEAR::isError($res->getResult())) {
$this->CLASS['error']->log("ERROR IN QUERY: \"{$query}\"", 1, $res->getResult()->getMessage());
}
return $res;
}
/**
* Will make a query with the oracle server
* @param string $query
* @return mixed return query result
*/
function query($query)
{
$this->lastquery = $query;
$this->query_cache[] = $query;
$this->querys += 1;
$res = new db_result($this->CLASS);
$res->setQuery($query);
$res->setResult(oci_parse($this->connection, $query));
oci_execute($res->getResult());
// if error in query
if ($res->getResult() === false) {
//$this->CLASS['error']->log("ERROR IN QUERY: \"$query\"",1,oci_last_error($this->connection));
}
return $res;
}
/**
* Will make a query with the postgresql server
* @param string $query
* @return mixed return query result
*/
function query($query)
{
$this->lastquery = $query;
$this->query_cache[] = $query;
$this->querys += 1;
$res = new db_result($this->CLASS);
$res->setQuery($query);
$res->setResult(pg_query($this->connection, $query));
// if error in query
if ($res->getResult() === false) {
$this->CLASS['error']->log("ERROR IN QUERY: \"{$query}\"", 1, pg_last_error($this->connection));
}
return $res;
}
