/**
  *	This function will connect to the database, execute a query and will return the result handle.
  *
  *	@param $sql	The SQL statement to execute.
  *
  *  @returns    Handle to the result of the query. In case of an error, this function triggers an error.
  *
  *	@internal
  */
 function &_connectAndExec($sql)
 {
     // Add the table prefix
     $sql = str_replace(' #_', ' ' . YDConfig::get('YD_DB_TABLEPREFIX', ''), $sql);
     // Update the language placeholders
     $languageIndex = YDConfig::get('YD_DB_LANGUAGE_INDEX', null);
     if (!is_null($languageIndex)) {
         $sql = str_replace('_@', '_' . $languageIndex, $sql);
     }
     // Connect
     $result = $this->connect();
     // Handle errors
     if (!$result && $this->_failOnError === true) {
         $error = ocierror();
         trigger_error($error['message'], YD_ERROR);
     }
     // Record the start time
     $timer = new YDTimer();
     // Create statement
     $stmt = OCIParse($this->_conn, $sql);
     // Handle errors
     if (!$stmt && $this->_failOnError === true) {
         $error = ocierror($stmt);
         trigger_error($error['message'], YD_ERROR);
     }
     // Execute
     $result = @OCIExecute($stmt);
     // Handle errors
     if ($result === false && $this->_failOnError === true) {
         $error = ocierror($stmt);
         if (!empty($error['sqltext'])) {
             $error['message'] .= ' (SQL: ' . $error['sqltext'] . ')';
         }
         echo '<b>Stacktrace:</b> <pre>' . YDDebugUtil::getStackTrace() . '</pre>';
         echo '<b>SQL Statement:</b> <pre>' . $this->formatSql($sql) . '</pre>';
         trigger_error($error['message'], YD_ERROR);
     }
     // Log the statement
     $this->_logSql($sql, $timer->getElapsed());
     // Return the result
     return $stmt;
 }
 /**
  *  This function will connect to the database, execute a query and will return the result handle.
  *
  *  @param $sql The SQL statement to execute.
  *
  *  @returns    Handle to the result of the query.
  *
  *  @internal
  */
 function &_connectAndExec($sql)
 {
     // Add the table prefix
     $sql = str_replace(' #_', ' ' . YDConfig::get('YD_DB_TABLEPREFIX', ''), $sql);
     $sql = str_replace(' `#_', ' `' . YDConfig::get('YD_DB_TABLEPREFIX', ''), $sql);
     // Connect
     $result = $this->connect();
     // Handle errors
     if (!$result && is_null($this->_conn) && $this->_failOnError === true) {
         trigger_error(mysql_error(), YD_ERROR);
     }
     if (!$result && !is_null($this->_conn) && $this->_failOnError === true) {
         trigger_error(mysql_error($this->_conn), YD_ERROR);
     }
     // Record the start time
     $timer = new YDTimer();
     // Execute the query
     $result = @mysql_query($sql, $this->_conn);
     // Handle errors
     if ($result === false && $this->_failOnError === true) {
         YDDebugUtil::error('[' . mysql_errno($this->_conn) . '] ' . mysql_error($this->_conn), $sql);
     }
     // Log the statement
     $this->_logSql($sql, $timer->getElapsed());
     // Return the result
     return $result;
 }
 /**
  *	This function will connect to the database, execute a query and will return the result handle.
  *
  *	@param $sql	The SQL statement to execute.
  *
  *	@returns	Handle to the result of the query.
  *
  *	@internal
  */
 function &_connectAndExec($sql)
 {
     // Add the table prefix
     $sql = str_replace(' #_', ' ' . YDConfig::get('YD_DB_TABLEPREFIX', ''), $sql);
     // Update the language placeholders
     $languageIndex = YDConfig::get('YD_DB_LANGUAGE_INDEX', null);
     if (!is_null($languageIndex)) {
         $sql = str_replace('_@', '_' . $languageIndex, $sql);
     }
     // Connect
     $result = $this->connect();
     // Record the start time
     $timer = new YDTimer();
     // Perform the query
     $result = $this->_conn->queryExec($sql);
     // Handle errors
     if ($result === false && $this->_failOnError === true) {
         echo '<b>Stacktrace:</b> <pre>' . YDDebugUtil::getStackTrace() . '</pre>';
         echo '<b>SQL Statement:</b> <pre>' . $this->formatSql($sql) . '</pre>';
         $msg = $this->_conn->errorInfo();
         trigger_error('<b>SQLite error message: </b>' . $msg[2], YD_ERROR);
     }
     // Log the statement
     $this->_logSql($sql, $timer->getElapsed());
     // Return the result
     return $result;
 }
 /**
  *	This function will connect to the database, execute a query and will return the result handle.
  *
  *	@param $sql	The SQL statement to execute.
  *
  *	@returns	Handle to the result of the query.
  *
  *	@internal
  */
 function &_connectAndExec($sql)
 {
     // Add the table prefix
     $sql = str_replace(' #_', ' ' . YDConfig::get('YD_DB_TABLEPREFIX', ''), $sql);
     // Update the language placeholders
     $languageIndex = YDConfig::get('YD_DB_LANGUAGE_INDEX', null);
     if (!is_null($languageIndex)) {
         $sql = str_replace('_@', '_' . $languageIndex, $sql);
     }
     // Connect to database
     $result = $this->connect();
     // Handle errors
     if (!$result && $this->_failOnError === true) {
         trigger_error($GLOBALS['YD_SQLITE_error'], YD_ERROR);
     }
     // Record the start time
     $timer = new YDTimer();
     // Execute the query
     $result = @sqlite_query($sql, $this->_conn);
     // Handle errors
     if ($result === false && $this->_failOnError === true) {
         echo '<b>Stacktrace:</b> <pre>' . YDDebugUtil::getStackTrace() . '</pre>';
         echo '<b>SQL Statement:</b> <pre>' . $this->formatSql($sql) . '</pre>';
         trigger_error(sqlite_error_string(sqlite_last_error($this->_conn)), YD_ERROR);
     }
     // Log the statement
     $this->_logSql($sql, $timer->getElapsed());
     // Return the result
     return $result;
 }
 /**
  *	This function will connect to the database, execute a query and will return the result handle.
  *
  *	@param $sql	The SQL statement to execute.
  *
  *	@returns	Handle to the result of the query.
  *
  *	@internal
  */
 function &_connectAndExec($sql)
 {
     // Add the table prefix
     $sql = str_replace(' #_', ' ' . YDConfig::get('YD_DB_TABLEPREFIX', ''), $sql);
     // Connect
     $result = $this->connect();
     // Handle errors
     if (!$result && $this->_failOnError === true) {
         trigger_error(pg_last_error(), YD_ERROR);
     }
     // Record the start time
     $timer = new YDTimer();
     // Perform the query
     $result = @pg_query($this->_conn, $sql);
     // Handle errors
     if ($result === false && $this->_failOnError === true) {
         echo '<b>Stacktrace:</b> <pre>' . YDDebugUtil::getStackTrace() . '</pre>';
         echo '<b>SQL Statement:</b> <pre>' . $this->formatSql($sql) . '</pre>';
         trigger_error(pg_last_error($this->conn), YD_ERROR);
     }
     // Log the statement
     $this->_logSql($sql, $timer->getElapsed());
     // Return the result
     return $result;
 }
 /**
  *  This function will connect to the database, execute a query and will return the result handle.
  *
  *  @param $sql The SQL statement to execute.
  *
  *  @returns    Handle to the result of the query.
  *
  *  @internal
  */
 function &_connectAndExec($sql)
 {
     // Add the table prefix
     $sql = str_replace(' #_', ' ' . YDConfig::get('YD_DB_TABLEPREFIX', ''), $sql);
     $sql = str_replace(' `#_', ' `' . YDConfig::get('YD_DB_TABLEPREFIX', ''), $sql);
     // Update the language placeholders
     $languageIndex = YDConfig::get('YD_DB_LANGUAGE_INDEX', null);
     if (!is_null($languageIndex)) {
         $sql = str_replace('_@', '_' . $languageIndex, $sql);
     }
     // Connect
     $result = $this->connect();
     // Handle errors
     if (!$result && is_null($this->_conn) && $this->_failOnError === true) {
         trigger_error(mysql_error(), YD_ERROR);
     }
     if (!$result && !is_null($this->_conn) && $this->_failOnError === true) {
         trigger_error(mysql_error($this->_conn), YD_ERROR);
     }
     // Record the start time
     $timer = new YDTimer();
     // Execute the query
     $result = @mysql_query($sql, $this->_conn);
     // Log the statement
     $this->_logSql($sql, $timer->getElapsed());
     // Handle errors
     if ($result === false) {
         $callback = YDConfig::get('YD_DB_ERROR_CALLBACK');
         // check if we should display the error or execute some callback
         if (is_string($callback) || is_array($callback)) {
             return call_user_func($callback, $sql, mysql_error($this->_conn), mysql_errno($this->_conn));
         } elseif ($callback === false && $this->_failOnError === true) {
             YDDebugUtil::error('[' . mysql_errno($this->_conn) . '] ' . mysql_error($this->_conn), $sql);
         }
     }
     // Return the result
     return $result;
 }