Class cDbDriverMysql

This class contains functions for database interaction based on MySQL in CONTENIDO.

Configurable via global $cfg['db']['connection'] configuration as follows:

- host      (string)  Hostname or ip (with port, e. g. "example.com:3307")
- database  (string)  Database name
- user      (string)  User name
- password  (string)  User password
- charset   (string)  Optional, connection charset
see http://php.net/manual/en/function.mysql-connect.php

cDbDriverAbstract

cDbDriverMysql

Package: Core\Database
Copyright: four for business AG <www.4fb.de>
License: http://www.contenido.org/license/LIZENZ.txt
Author: Dominik Ziegler
Located at classes/db/class.db.driver.mysql.php

Methods summary
`public boolean`	# `check( )` Returns `boolean` See `cDbDriverAbstract::check()`
`public object\|resource\|integer\|null`	# `connect( )` Returns `object\|resource\|integer\|null` Connection handler. Return value depends on used driver and is null in case of an error. See `cDbDriverAbstract::connect()`
`public string`	# `buildInsert( string $tableName, array $fields )` Parameters `$tableName` `string` $tableName The table name `$fields` `array` $fields Associative array of fields to insert Returns `string` The INSERT SQL query See `cDbDriverAbstract::buildInsert()`
`public string`	# `buildUpdate( string $tableName, array $fields, array $whereClauses )` Parameters `$tableName` `string` $tableName The table name `$fields` `array` $fields Assoziative array of fields to update `$whereClauses` `array` $whereClauses Assoziative array of field in where clause. Multiple entries will be concatenated with AND Returns `string` The UPDATE query See `cDbDriverAbstract::buildUpdate()`
`public`	# `query( string $query )` Parameters `$query` `string` $statement The query to execute See `cDbDriverAbstract::query()`
`public integer`	# `nextRecord( )` Returns `integer` Flag about move status 1 on success or 0 See `cDbDriverAbstract::nextRecord()`
`public object`	# `getResultObject( mixed $className = NULL )` Returns `object` See `cDbDriverAbstract::getResultObject()`
`public integer`	# `affectedRows( )` Returns `integer` Number of affected rows See `cDbDriverAbstract::affectedRows()`
`public integer`	# `numRows( )` Returns `integer` The number of rows from last select query result See `cDbDriverAbstract::numRows()`
`public integer`	# `numFields( )` Returns `integer` Number of fields See `cDbDriverAbstract::numFields()`
`public integer`	# `free( )` Returns `integer` See `cDbDriverAbstract::free()`
`public string`	# `escape( string $string )` Parameters `$string` `string` $string The string to escape Returns `string` Escaped string See `cDbDriverAbstract::escape()`
`public`	# `seek( integer $pos = 0 )` Parameters `$pos` `integer` $iPos The positon to move to inside the current result set See `cDbDriverAbstract::seek()`
`public array`	# `getMetaData( string $tableName, boolean $full = false )` Parameters `$tableName` `string` $tableName The table to get metadata or empty string to retrieve metadata of all tables `$full` `boolean` $full Flag to load full metadata Returns `array` Depends on used database and on parameter $full See `cDbDriverAbstract::getMetaData()`
`public array`	# `getTableNames( )` Returns `array` See `cDbDriverAbstract::getTableNames()`
`public array`	# `getServerInfo( )` Returns `array` See `cDbDriverAbstract::getServerInfo()`
`public integer`	# `getErrorNumber( )` Returns `integer` See `cDbDriverAbstract::getErrorNumber()`
`public string`	# `getErrorMessage( )` Returns `string` See `cDbDriverAbstract::getErrorMessage()`
`public`	# `disconnect( )` See `cDbDriverAbstract::disconnect()`

Methods inherited from cDbDriverAbstract
`__construct(), getHandler(), setHandler()`

Properties inherited from cDbDriverAbstract
`$_dbCfg, $_handler`

Packages

Classes

Exceptions

Class cDbDriverMysql

Returns

See

Returns

See

Parameters

Returns

See

Parameters

Returns

See

Parameters

See

Returns

See

Returns

See

Returns

See

Returns

See

Returns

See

Returns

See

Parameters

Returns

See

Parameters

See

Parameters

Returns

See

Returns

See

Returns

See

Returns

See

Returns

See

See