Class MagratheaDatabase

This class will provide a layer for connecting with mysql

Located at MagratheaDatabase.php

Methods summary

`public static MagratheaDatabase`	# `Instance( )` This is a singleton! Instance loader This is a singleton! Instance loader Returns `MagratheaDatabase` Instance of the object
`public`	# `MagratheaDatabase( )` This is a singleton! Should be called by private method Instance. Don't implement new ones This is a singleton! Should be called by private method Instance. Don't implement new ones
`public itself`	# `SetConnectionArray( array $dsn_arr )` Sets the connection array object Sets the connection array object Parameters `$dsn_arr` array with connection data, as the sample: array( 'hostspec' => $host, 'database' => $database, 'username' => $username, 'password' => $password, ); Returns itself
`public itself`	# `SetConnection( string $host, string $database, string $username, string $password, $port = null )` Setups connection Setups connection Parameters `$host` host address for connection `$database` database name `$username` username for connection `$password` password for connection `$port` Returns itself
`public itself`	# `SetFetchMode( string $fetch )` Sets fetchmode, according with MDB2 values. Default mode: assoc. Sets fetchmode, according with MDB2 values. Default mode: assoc. Parameters `$fetch` fetchmode for SQL returns options available: assoc: array with keys as the column names object: object with columns as properties if anything different from those values is sent, "assoc" is used Returns itself
`public boolean`	# `OpenConnectionPlease( )` Open connection, please. Please! 0=) Open connection, please. Please! 0=) Returns boolean true or false, if connection succedded Throws MagratheaDbException
`public`	# `CloseConnectionThanks( )` Already uses you.. Bye. Already uses you.. Bye.
`public object`	# `Query( string $sql )` executes the query and returns the full data executes the query and returns the full data Parameters `$sql` Query to be executed Returns object $result Result of the query
`public array`	# `QueryAll( string $sql )` executes the query and returns the full data in an array executes the query and returns the full data in an array Parameters `$sql` Query to be executed Returns array $result Result of the query (one row for line result)
`public object`	# `QueryRow( string $sql )` executes the query and returns only the first row of the result executes the query and returns only the first row of the result Parameters `$sql` Query to be executed Returns object $result First line of the query
`public object`	# `QueryOne( string $sql )` executes the query and returns only the first value of the first row of the result executes the query and returns only the first value of the first row of the result Parameters `$sql` Query to be executed Returns object $result First value of the first line
`public`	# `QueryTransaction( array $query_array )` receives an array of queries and executes them all receives an array of queries and executes them all Parameters `$query_array` Array of queries to be executed Throws `MagratheaDBException` Todo confirms if this is working properly
`public`	# `PrepareAndExecute( string $query, array $arrTypes, array $arrValues )` Prepares and execute a query and returns the inserted id (if any) Prepares and execute a query and returns the inserted id (if any) Parameters `$query` Query to be executed `$arrTypes` Array of types from the values to be inserted `$arrValues` Array of values to be inserted Todo validates types and avoids injection. Does it?

Magic methods summary

Constants summary

`integer`	`FETCH_ASSOC`	# `1`
`integer`	`FETCH_OBJECT`	# `2`
`integer`	`FETCH_NUM`	# `3`
`integer`	`FETCH_ARRAY`	# `4`

Properties summary

`protected static`	`$inst`	# `null`