libraries/drivers/Database/Mysql – Kohana API 2.3 Documentation

system/libraries/drivers/Database/Mysql.php

Class: Database_Mysql_Driver

class Database_Mysql_Driver extends Database_Driver

MySQL Database Driver

Methods

Database_Mysql_Driver -> __construct

public function __construct

Sets the config for the class.

Parameters:

array config
database configuration

Database_Mysql_Driver -> __destruct

public function __destruct

Closes the database connection.

Database_Mysql_Driver -> connect

public function connect

Database_Mysql_Driver -> query

public function query

Parameters:

sql

Database_Mysql_Driver -> set_charset

public function set_charset

Parameters:

charset

Database_Mysql_Driver -> escape_table

public function escape_table

Parameters:

table

Database_Mysql_Driver -> escape_column

public function escape_column

Parameters:

column

Database_Mysql_Driver -> regex

public function regex

Parameters:

field
match
type
num_regexs

Database_Mysql_Driver -> notregex

public function notregex

Parameters:

field
match
type
num_regexs

Database_Mysql_Driver -> merge

public function merge

Parameters:

table
keys
values

Database_Mysql_Driver -> limit

public function limit

Parameters:

limit
offset
(int 0)

Database_Mysql_Driver -> compile_select

public function compile_select

Parameters:

database

Database_Mysql_Driver -> escape_str

public function escape_str

Parameters:

str

Database_Mysql_Driver -> list_tables

public function list_tables

Database_Mysql_Driver -> show_error

public function show_error

Database_Mysql_Driver -> list_fields

public function list_fields

Parameters:

table

Database_Mysql_Driver -> field_data

public function field_data

Parameters:

table

Database_Mysql_Driver -> delete

public function delete

Builds a DELETE query.

Parameters:

string table
table name
array where
where clause

Return: string

Database_Mysql_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_Mysql_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_Mysql_Driver -> like

public function like

Builds a LIKE portion of a query.

Parameters:

mixed field
field name
string match
value to match with field
boolean auto
add wildcards before and after the match
string type
clause type (AND or OR)
int num_likes
number of likes

Return: string

Database_Mysql_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 auto
clause type (AND or OR)
int type
number of likes
num_likes

Return: string

Database_Mysql_Driver -> insert

public function insert

Builds an INSERT query.

Parameters:

string table
table name
array keys
keys
array values
values

Return: string

Database_Mysql_Driver -> stmt_prepare

public function stmt_prepare

Creates a prepared statement.

Parameters:

string sql
(string ) SQL query

Return: Database_Stmt

Database_Mysql_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_Mysql_Driver -> escape

public function escape

Escapes any input value.

Parameters:

mixed value
value to escape

Return: string

Database_Mysql_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_Mysql_Driver -> clear_cache

public function clear_cache

Clears the internal query cache.

Parameters:

string sql
(NULL) SQL query

Database_Mysql_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: Mysql_Result

class Mysql_Result extends Database_Result implements Countable, Traversable, Iterator, ArrayAccess

MySQL Result

Methods

Mysql_Result -> __construct

public function __construct

Sets up the result variables.

Parameters:

resource result
query result
resource link
database link
boolean object
return objects or arrays
string sql
SQL query that was run

Mysql_Result -> __destruct

public function __destruct

Destruct, the cleanup crew!

Mysql_Result -> result

public function result

Parameters:

object
(TRUE)
type
(int 1)

Mysql_Result -> as_array

public function as_array

Parameters:

object
(NULL)
type
(int 1)

Mysql_Result -> result_array

public function result_array

Parameters:

object
(NULL)
type
(int 1)

Mysql_Result -> list_fields

public function list_fields

Mysql_Result -> seek

public function seek

Parameters:

offset

Mysql_Result -> sql

public function sql

Returns the SQL used to fetch the result.

Return: string

Mysql_Result -> insert_id

public function insert_id

Returns the insert id from the result.

Return: mixed

Mysql_Result -> count

public function count

Countable: count

Mysql_Result -> offsetExists

public function offsetExists

ArrayAccess: offsetExists

Parameters:

offset

Mysql_Result -> offsetGet

public function offsetGet

ArrayAccess: offsetGet

Parameters:

offset

Mysql_Result -> offsetSet

final public function offsetSet

ArrayAccess: offsetSet

Parameters:

offset
value

Throws: Kohana_Database_Exception

Mysql_Result -> offsetUnset

final public function offsetUnset

ArrayAccess: offsetUnset

Parameters:

offset

Throws: Kohana_Database_Exception

Mysql_Result -> current

public function current

Iterator: current

Mysql_Result -> key

public function key

Iterator: key

Mysql_Result -> next

public function next

Iterator: next

Mysql_Result -> prev

public function prev

Iterator: prev

Mysql_Result -> rewind

public function rewind

Iterator: rewind

Mysql_Result -> valid

public function valid

Iterator: valid