Database_Query_mysql Class Reference
Detailed Description
The basic MySQL database query type./*
Definition at line 35 of file Query/mysql.php.
Public Member Functions | |
| execute () | |
| Executes the query that was previously passed to the constructor. | |
| fetch_col () | |
| The following routines basically replicate the mysql functions built into php. | |
| fetch_row () | |
| Fetch a single row. | |
| fetch_assoc () | |
| Fetch a single assoc row. | |
| fetch_array ($result_type=MYSQL_BOTH) | |
| Fetch a single row as an array containing both numeric and assoc fields. | |
| fetch_object () | |
| Fetch a single row as an object. | |
| data_seek ($row_number) | |
| http://www.php.net/manual/en/function.mysql-data-seek.php | |
| num_rows () | |
| http://www.php.net/manual/en/function.mysql-num-rows.php | |
| affected_rows () | |
| http://www.php.net/manual/en/function.mysql-data-seek.php | |
| insert_id () | |
| http://www.php.net/manual/en/function.mysql-insert-id.php | |
| finish () | |
| For anal people like me who like to free up memory manually /*. | |
Member Function Documentation
| Database_Query_mysql::execute | ( | ) |
Executes the query that was previously passed to the constructor.
- Parameters:
-
mixed $arg Query arguments to escape and insert at ? placeholders in $query mixed ... Additional arguments /*
Definition at line 43 of file Query/mysql.php.
| Database_Query_mysql::fetch_col | ( | ) |
The following routines basically replicate the mysql functions built into php.
The only difference is that the resource handle gets passed-in automatically. eg.
mysql_fetch_row($result); -> $sh->fetch_row(); mysql_affected_rows($dbh); -> $sh->affected_rows(); /* Fetch a single column
- Returns:
- mixed /*
Definition at line 102 of file Query/mysql.php.
| Database_Query_mysql::fetch_row | ( | ) |
| Database_Query_mysql::fetch_assoc | ( | ) |
| Database_Query_mysql::fetch_array | ( | $ | result_type = MYSQL_BOTH |
) |
Fetch a single row as an array containing both numeric and assoc fields.
Definition at line 133 of file Query/mysql.php.
| Database_Query_mysql::fetch_object | ( | ) |
| Database_Query_mysql::data_seek | ( | $ | row_number | ) |
http://www.php.net/manual/en/function.mysql-data-seek.php
- Returns:
- bool /*
Definition at line 151 of file Query/mysql.php.
| Database_Query_mysql::num_rows | ( | ) |
http://www.php.net/manual/en/function.mysql-num-rows.php
- Returns:
- int /*
Definition at line 159 of file Query/mysql.php.
| Database_Query_mysql::affected_rows | ( | ) |
http://www.php.net/manual/en/function.mysql-data-seek.php
- Returns:
- int /*
Definition at line 167 of file Query/mysql.php.
| Database_Query_mysql::insert_id | ( | ) |
http://www.php.net/manual/en/function.mysql-insert-id.php
- Returns:
- int /*
Definition at line 175 of file Query/mysql.php.
| Database_Query_mysql::finish | ( | ) |
For anal people like me who like to free up memory manually /*.
Definition at line 182 of file Query/mysql.php.
The documentation for this class was generated from the following file:
