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` The table name `$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` The table name `$fields` Assoziative array of fields to update `$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` $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` 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` The string to escape Returns string Escaped string See `cDbDriverAbstract::escape()`
`public`	# `seek( integer $pos = 0 )` Parameters `$pos` $iPos The positon to move to inside the current result set See `cDbDriverAbstract::seek()`
`public array`	# `getMetaData( string $tableName, boolean $full = false )` Parameters `$tableName` The table to get metadata or empty string to retrieve metadata of all tables `$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` List of data types. List of data types.	# `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' )`

Properties inherited from cDbDriverAbstract
`$_dbCfg, $_handler`

Packages

Classes

Interfaces

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