PHP sqlite_last_error函数代码示例

 function _catch($msg = "")
 {
     if (!($this->error = sqlite_error_string(sqlite_last_error($this->conn)))) {
         return true;
     }
     $this->error($msg . "<br>{$this->query}\n {$this->error}");
 }

 protected function _set_stmt_error($state = null, $mode = PDO::ERRMODE_SILENT, $func = '')
 {
     $errno = sqlite_last_error($this->_link);
     if ($state === null) {
         $state = 'HY000';
     }
     $this->_set_error($errno, sqlite_error_string($errno), $state, $mode, $func);
 }

 public function real_execute_sql($sql)
 {
     $result_set_handle = sqlite_query($this->connection_handle, $sql);
     if (!$result_set_handle) {
         throw new AnewtDatabaseQueryException('SQLite error: %s', sqlite_error_string(sqlite_last_error($this->connection_handle)));
     }
     return new AnewtDatabaseResultSetSQLite($sql, $this->connection_handle, $result_set_handle);
 }

 /**
  * Constructs a new SqliteResultSet
  *
  * \param $sql
  *   The sql query to execute.
  *
  * \param $backend
  *   A reference to the used backend.
  */
 function SqliteResultSet($sql, &$backend)
 {
     assert('is_string($sql)');
     $this->sql = $sql;
     $this->backend =& $backend;
     $this->rs = sqlite_query($this->backend->handle, $sql) or trigger_error(sprintf('Query failed (%s)', sqlite_error_string(sqlite_last_error($this->backend->handle))), E_USER_ERROR);
     $this->rows_affected = sqlite_changes($this->backend->handle);
 }

 function _error_handler(array $errarray, $query = '')
 {
     $err = sprintf('%s on line %d.', $errarray[0], $errarray[1]);
     $errno = sqlite_last_error($this->con);
     if (defined('DEBUG') && DEBUG) {
         $err .= sprintf(PHP_EOL . "Description: #%d: %s" . PHP_EOL . "SQL: %s", $errno, sqlite_error_string($errno), $query);
     }
     throw new RuntimeException($err, $errno);
 }

 /**
  * query 
  * 
  * @param mixed $query 
  * @access public
  * @return mixed
  * @throws AdapterException
  */
 public function query($query)
 {
     $handle = @sqlite_query($query, $this->_dbHandle);
     if (!$handle) {
         $errorCode = sqlite_last_error($this->_dbHandle);
         throw new AdapterException(sqlite_error_string($errorCode), $errorCode);
     }
     return $handle;
 }

 public function query($sql)
 {
     LogMaster::log($sql);
     $res = sqlite_query($this->connection, $sql);
     if ($res === false) {
         throw new Exception("SQLLite - sql execution failed\n" . sqlite_error_string(sqlite_last_error($this->connection)));
     }
     return $res;
 }

 /**
  * 执行数据库查询
  *
  * @param string $query
  * @param mixed $handle
  * @param int $op
  * @param null $action
  * @return resource|SQLiteResult
  * @throws Typecho_Db_Query_Exception
  */
 public function query($query, $handle, $op = Typecho_Db::READ, $action = NULL)
 {
     if ($resource = @sqlite_query($query instanceof Typecho_Db_Query ? $query->__toString() : $query, $handle)) {
         return $resource;
     }
     /** 数据库异常 */
     $errorCode = sqlite_last_error($this->_dbHandle);
     throw new Typecho_Db_Query_Exception(sqlite_error_string($errorCode), $errorCode);
 }

 /**
  * This function initializes the class.
  *
  * @access public
  * @override
  * @param DB_Connection_Driver $connection  the connection to be used
  * @param string $sql                       the SQL statement to be queried
  * @param integer $mode                     the execution mode to be used
  * @throws Throwable_SQL_Exception          indicates that the query failed
  */
 public function __construct(DB_Connection_Driver $connection, $sql, $mode = NULL)
 {
     $resource = $connection->get_resource();
     $command = @sqlite_query($resource, $sql);
     if ($command === FALSE) {
         throw new Throwable_SQL_Exception('Message: Failed to query SQL statement. Reason: :reason', array(':reason' => sqlite_error_string(sqlite_last_error($resource))));
     }
     $this->command = $command;
     $this->record = FALSE;
 }

function safe_query($query)
{
    $res = sqlite_query($query, sqlite_r);
    if (!$res) {
        $err_code = sqlite_last_error(sqlite_r);
        printf("Query Failed %d:%s\n", $err_code, sqlite_error_string($err_code));
        exit;
    }
    return $res;
}

 function query($sql)
 {
     global $page;
     if (!($this->result = sqlite_query($this->dbres, $sql))) {
         print "Query failed, <span style=\"color: blue;\"><pre>{$sql}</pre></style>\n";
         print sqlite_error_string(sqlite_last_error($this->dbres));
         $page->footer();
         exit;
     }
 }

function DriverSqliteExec($conn, $sql, $check_result = true)
{
    if ($check_result) {
        if (!($result = sqlite_query($conn, $sql))) {
            throw new lmbDbException('SQLite error happened: ' . sqlite_error_string(sqlite_last_error($conn)));
        }
    } else {
        $result = @sqlite_query($conn, $sql);
    }
    return $result;
}

 public function error($status = '')
 {
     $error = sqlite_last_error($this->connection);
     if ($status = 'show') {
         return sqlite_error_string($error);
     } elseif ($error != 0) {
         return true;
     } else {
         return false;
     }
 }

 function getError($errorCode = null)
 {
     if (!$this->error) {
         $this->error = sqlite_last_error($this->connId);
     }
     if ($errorCode == null) {
         $errorCode = $this->error;
     }
     $this->errorMessage = sqlite_error_string($errorCode);
     return $this->errorMessage;
 }

 /**
  * @throws SQLException
  * @return void
  */
 protected function initTables()
 {
     include_once 'creole/drivers/sqlite/metadata/SQLiteTableInfo.php';
     $sql = "SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE type='table' ORDER BY name;";
     $result = sqlite_query($this->dblink, $sql);
     if (!$result) {
         throw new SQLException("Could not list tables", sqlite_last_error($this->dblink));
     }
     while ($row = sqlite_fetch_array($result)) {
         $this->tables[strtoupper($row[0])] = new SQLiteTableInfo($this, $row[0]);
     }
 }