[Trellis-developers] new database abstraction class

[Shaddy Zeineddine]

= TrellisDB =

== Public Methods ==

__construct       - define the host, or write host
read_hosts        - define read hosts
connect           - connect to host(s)
close             - disconnect from host(s)
select_db         - change database (cannot use "USE")

select_rows       - select multiple rows as an array of arrays
select_row        - select one row as an array
select_column     - select multiple rows of 1 or 2 fields as an array
select_field      - select a single value
select_prepared   - create a statement object for use in selects
select            - perform a select returning the result object

next_row          - grabs the next row from a result object
next_field        - grabs the first field of the next row from a result

free              - deprecated (use $result->close())

exists            - checks if at least one row matches, returns bool
count             - returns the count of the rows

affect            - used to perform queries that modify data
affect_prepared   - create a statement object for affect queries

last_insert_id    - grab the id created on the last insert

start_transaction - begins a set of queries that can be rolled back
rollback          - roll back the previous queries and end transaction
commit            - apply the queries and end transaction

report            - returns a string with total queries and time

error             - returns the last mysqli error

escape_string     - escapes a string properly (will be linked to
escape_string function)


== Public Properties ==

affected_rows     - numbers of rows affected by last affect query
selected_rows     - number of rows selected by last select query

query_count       - number of queries made
last_query_time   - time it took to perform the last query
total_query_time  - total time of all queries