Class flDbMySQL

flDbMySQL Class

Driver for MySQL database.

flDb

Extended by

flDbMySQL

Package: fusionLib
Copyright: Copyright (c) 2007 - 2013 fusionLib. All rights reserved.
Located at system/libs/Db/flDbMySQL.php

Methods summary

`public`	# `__construct( array $master, string $slave )` Initialise the MySQL driver. Initialise the MySQL driver. Parameters `$master` Array of the DSN parts for the master. `$slave` The slave database DSN or null if not used. Throws `flDbException`
`public`	# `__destruct( )` Close the database. Close the database.
`public mixed`	# `_escape( mixed $value )` Escape a value in the driver. Escape a value in the driver. Parameters `$value` The value to escape. Returns mixed The escaped value.
`public flDbResult`	# `_query( string $query )` Perform the SQL query in the driver. Perform the SQL query in the driver. Parameters `$query` The query string. Returns `flDbResult` The result object or boolean result.
`public integer`	# `insertID( )` Return the id generated by the last insert operation. Return the id generated by the last insert operation. Returns integer The id.
`public integer`	# `affectedRows( )` Get the number of rows affected by the previous operation. Get the number of rows affected by the previous operation. Returns integer The number of rows affected.
`public array`	# `fetchTables( )` Get the list of tables in the database. Get the list of tables in the database. Returns array The list of tables in the database.
`public array`	# `fetchFields( string $table )` Get the names of all fields in a table. Get the names of all fields in a table. Parameters `$table` The table to query. Returns array An array holding the names of all fields.
`public string`	# `_maintain( boolean $repair, string $table )` Optimize or repair tables within the database. Optimize or repair tables within the database. Parameters `$repair` true to perform a repair or false to optimize. `$table` The name of the table to operate on. Returns string Result of operation.
`public string`	# `errorString( )` The error for the previous operation. The error for the previous operation. Returns string The error string.
`public string`	# `version( )` The database server version. The database server version. Returns string The version string.

Methods inherited from flDb

connect(), delete(), escape(), fetchAll(), fetchOne(), fetchRow(), getQueryCount(), insert(), lastQuery(), maintain(), query(), replace(), update()

Properties summary

Properties inherited from flDb

$lastQuery, $queryCount