Class cDbDriverMysqli

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

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

- host (string) Hostname or ip
- database (string) Database name
- user (string) User name
- password (string) User password
- options (array) Optional, MySQLi options array
- socket (int) Optional, socket
- port (int) Optional, port
- flags (int) Optional, flags
- charset (string) Optional, connection charset
see http://www.php.net/manual/en/mysqli.real-connect.php

cDbDriverAbstract

cDbDriverMysqli

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.mysqli.php

Methods summary
`public boolean`	# `check( )` Returns `boolean` See `cDbDriverAbstract::check()`
`public object`	# `connect( )` Returns `object` resource int NULL 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( string $className = NULL )` Parameters `$className` `string` $className 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`	# `free( )` 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 summary
`protected array`	`$_dataTypes`	`array( 0 => 'decimal', 1 => 'tinyint', 2 => 'smallint', 3 => 'int', 4 => 'float', 5 => 'double', 7 => 'timestamp', 8 => 'bigint', 9 => 'mediumint', 10 => 'date', 11 => 'time', 12 => 'datetime', 13 => 'year', 252 => 'blob', // text, blob, tinyblob,mediumblob, etc... 253 => 'string', // varchar and char 254 => 'enum' )`	# List of data types. List of data types.

Properties inherited from cDbDriverAbstract
`$_dbCfg, $_handler`

Packages

Classes

Exceptions

Class cDbDriverMysqli

Returns

See

Returns

See

Parameters

Returns

See

Parameters

Returns

See

Parameters

See

Returns

See

Parameters

Returns

See

Returns

See

Returns

See

Returns

See

See

Parameters

Returns

See

Parameters

See

Parameters

Returns

See

Returns

See

Returns

See

Returns

See

Returns

See

See