system/libraries/drivers/Database/Pdosqlite.php
Class: Database_Pdosqlite_Driver
class Database_Pdosqlite_Driver extends Database_Driver
Database_Pdosqlite_Driver -> __construct
public function __construct
Parameters:
- config
Database_Pdosqlite_Driver -> connect
public function connect
Database_Pdosqlite_Driver -> query
public function query
Parameters:
- sql
Database_Pdosqlite_Driver -> set_charset
public function set_charset
Parameters:
- charset
Database_Pdosqlite_Driver -> escape_table
public function escape_table
Parameters:
- table
Database_Pdosqlite_Driver -> escape_column
public function escape_column
Parameters:
- column
Database_Pdosqlite_Driver -> regex
public function regex
Parameters:
- field
- match
- type
- num_regexs
Database_Pdosqlite_Driver -> notregex
public function notregex
Parameters:
- field
- match
- type
- num_regexs
Database_Pdosqlite_Driver -> merge
public function merge
Parameters:
- table
- keys
- values
Database_Pdosqlite_Driver -> limit
public function limit
Parameters:
- limit
- offset
- (int 0)
Database_Pdosqlite_Driver -> stmt_prepare
public function stmt_prepare
Parameters:
- sql
- (string )
Database_Pdosqlite_Driver -> compile_select
public function compile_select
Parameters:
- database
Database_Pdosqlite_Driver -> escape_str
public function escape_str
Parameters:
- str
Database_Pdosqlite_Driver -> list_tables
public function list_tables
Database_Pdosqlite_Driver -> show_error
public function show_error
Database_Pdosqlite_Driver -> list_fields
public function list_fields
Parameters:
- table
- query
- (FALSE)
Database_Pdosqlite_Driver -> field_data
public function field_data
Parameters:
- table
Database_Pdosqlite_Driver -> version
public function version
Version number query string
Access: public
Return: string
Database_Pdosqlite_Driver -> delete
public function delete
Builds a DELETE query.
Parameters:
- string table
- table name
- array where
- where clause
Return: string
Database_Pdosqlite_Driver -> update
public function update
Builds an UPDATE query.
Parameters:
- string table
- table name
- array values
- key => value pairs
- array where
- where clause
Return: string
Database_Pdosqlite_Driver -> where
public function where
Builds a WHERE portion of a query.
Parameters:
- mixed key
- key
- string value
- value
- string type
- type
- int num_wheres
- number of where clauses
- boolean quote
- escape the value
Return: string
Database_Pdosqlite_Driver -> like
public function like
Builds a LIKE portion of a query.
Parameters:
- mixed field
- field name
- string match
- value to match with field
- string type
- clause type (AND or OR)
- int num_likes
- number of likes
Return: string
Database_Pdosqlite_Driver -> notlike
public function notlike
Builds a NOT LIKE portion of a query.
Parameters:
- mixed field
- field name
- string match
- value to match with field
- string type
- clause type (AND or OR)
- int num_likes
- number of likes
Return: string
Database_Pdosqlite_Driver -> insert
public function insert
Builds an INSERT query.
Parameters:
- string table
- table name
- array keys
- keys
- array values
- values
Return: string
Database_Pdosqlite_Driver -> has_operator
public function has_operator
Determines if the string has an arithmetic operator in it.
Parameters:
- string str
- string to check
Return: boolean
Database_Pdosqlite_Driver -> escape
public function escape
Escapes any input value.
Parameters:
- mixed value
- value to escape
Return: string
Database_Pdosqlite_Driver -> sql_type
protected function sql_type
Fetches SQL type information about a field, in a generic format.
Parameters:
- string str
- field datatype
Return: array
Database_Pdosqlite_Driver -> clear_cache
public function clear_cache
Clears the internal query cache.
Parameters:
- string sql
- (NULL) SQL query
Database_Pdosqlite_Driver -> query_hash
protected function query_hash
Creates a hash for an SQL query string. Replaces newlines with spaces, trims, and hashes.
Parameters:
- string sql
- SQL query
Return: string
Class: Pdosqlite_Result
class Pdosqlite_Result implements Database_Result, ArrayAccess, Iterator, Traversable, Countable
Pdosqlite_Result -> __construct
public function __construct
Parameters:
- result
- link
- object
- sql
Pdosqlite_Result -> sqlite_row_count
private function sqlite_row_count
Pdosqlite_Result -> __destruct
public function __destruct
Pdosqlite_Result -> result
public function result
Parameters:
- object
- (TRUE)
- type
- (int 4)
Pdosqlite_Result -> result_array
public function result_array
Parameters:
- object
- (NULL)
- type
- (int 2)
Pdosqlite_Result -> insert_id
public function insert_id
Pdosqlite_Result -> list_fields
public function list_fields
Pdosqlite_Result -> count
public function count
Pdosqlite_Result -> num_rows
public function num_rows
Pdosqlite_Result -> offsetExists
public function offsetExists
Parameters:
- offset
Pdosqlite_Result -> offsetGet
public function offsetGet
Parameters:
- offset
Pdosqlite_Result -> offsetSet
public function offsetSet
Parameters:
- offset
- value
Pdosqlite_Result -> offsetUnset
public function offsetUnset
Parameters:
- offset
Pdosqlite_Result -> current
public function current
Pdosqlite_Result -> key
public function key
Pdosqlite_Result -> next
public function next
Pdosqlite_Result -> prev
public function prev
Pdosqlite_Result -> rewind
public function rewind
Pdosqlite_Result -> valid
public function valid