MySQLiDBConnection Class Reference

MySQLi Database connection object. More...

Inheritance diagram for MySQLiDBConnection:

Public Member Functions
	connect_server ($host='localhost', $login='', $pwd='', $driver='')
	disconnect_server ()
	get_serverVersion ()
	select_database ($name)
	create_database ($name, $charset='utf8')
	database_exists ($name)
	dump_database ($file=false)
	get_databaseSize ()
	get_databaseSummary ()
	get_tableList ()
	create_table ($name, $fields, $charset='utf8', $autoId=true, $primaryKeys=array('id'))
	execute_query ($sql='', $resName='defaultRes')
	execute_multiQueries ($sql='', $resName='defaultRes')
	get_queryGeneratedId ($resName='defaultRes')
	get_queryDataLine ($resName='defaultRes')
	get_queryNumDataLine ($resName='defaultRes')
	get_queryError ($resName='defaultRes')
	get_queryAffectedRows ($resName='defaultRes')
	get_queryFieldCount ($resName='defaultRes')
	get_queryFieldType ($fIndex=0, $resName='defaultRes')
	close_ressource ($resName='defaultRes')
	escape_string ($string)
Public Member Functions inherited from CDBConnection
	__construct ()
	is_connectionActive ()
	check_status ($name)
	get_insertExtra ()

Private Member Functions
	get_compatibleType ($type=1)

Additional Inherited Members
Protected Member Functions inherited from CDBConnection
	get_resName ()
Protected Attributes inherited from CDBConnection
	$active = false
	CDBConnection status. More...
	$connection = null
	CDBConnection database ressource. More...
	$queryRes = array()
	Query ressources. More...
	$dbName = null
	Name of the database. More...

Detailed Description

MySQLi Database connection object.

Engine / Object Library

Author

CaMykS Team camyk.nosp@m.s.co.nosp@m.ntact.nosp@m.@gma.nosp@m.il.co.nosp@m.m

Version

1.0.1.6

Date

Creation: Sep 2014

Modification: Nov 2023

Copyright

2014 - 2023 CaMykS Team

Note

This program is distributed as is - WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. MySQLiDBConnection class.

Member Function Documentation

connect_server()

MySQLiDBConnection::connect_server	(		$host = 'localhost',
			$login = '',
			$pwd = '',
			$driver = ''
	)

Connect to server.

Parameters

string	$host
string	$login
string	$pwd
string	$driver

Returns

boolean success

Reimplemented from CDBConnection.

disconnect_server()

MySQLiDBConnection::disconnect_server

(

)

Close server connection.

Returns

boolean success

Reimplemented from CDBConnection.

get_serverVersion()

MySQLiDBConnection::get_serverVersion

(

)

Return database engine version.

Returns

string

Reimplemented from CDBConnection.

select_database()

MySQLiDBConnection::select_database

(

$name

)

Select database.

Parameters

string

$name

the database name

Returns

boolean

Reimplemented from CDBConnection.

create_database()

MySQLiDBConnection::create_database	(		$name,
			$charset = 'utf8'
	)

Create a database.

Parameters

string	$name
string	$charset

Returns

boolean

Reimplemented from CDBConnection.

database_exists()

MySQLiDBConnection::database_exists

(

$name

)

Check if a base exists.

Parameters

string

$name

Returns

boolean

Reimplemented from CDBConnection.

dump_database()

MySQLiDBConnection::dump_database

(

$file = false

)

Dump database.

Parameters

mixed

$file

Returns

mixed

Reimplemented from CDBConnection.

get_databaseSize()

MySQLiDBConnection::get_databaseSize

(

)

Return database size.

Returns

integer

Reimplemented from CDBConnection.

get_databaseSummary()

MySQLiDBConnection::get_databaseSummary

(

)

Return database information summary.

Returns

array

Reimplemented from CDBConnection.

get_tableList()

MySQLiDBConnection::get_tableList

(

)

Return available table list.

Returns

array

Reimplemented from CDBConnection.

create_table()

MySQLiDBConnection::create_table	(		$name,
			$fields,
			$charset = 'utf8',
			$autoId = true,
			$primaryKeys = array('id')
	)

Create a table in the database.

Parameters

string	$name
array	$fields
string	$charset
boolean	$autoId
array	$primaryKeys

Returns

boolean success

Reimplemented from CDBConnection.

execute_query()

MySQLiDBConnection::execute_query	(		$sql = '',
			$resName = 'defaultRes'
	)

Execute query.

Parameters

string	$sql
string	$resName

Returns

boolean success

Reimplemented from CDBConnection.

execute_multiQueries()

MySQLiDBConnection::execute_multiQueries	(		$sql = '',
			$resName = 'defaultRes'
	)

Execute multiple queries at once.

Parameters

string	$sql
string	$resName

Returns

boolean success

Reimplemented from CDBConnection.

get_queryGeneratedId()

MySQLiDBConnection::get_queryGeneratedId

(

$resName = 'defaultRes'

)

Return id generated by last query.

Parameters

string

$resName

Returns

integer

Reimplemented from CDBConnection.

get_queryDataLine()

MySQLiDBConnection::get_queryDataLine

(

$resName = 'defaultRes'

)

Return next query data line.

Parameters

string

$resName

Returns

array

Reimplemented from CDBConnection.

get_queryNumDataLine()

MySQLiDBConnection::get_queryNumDataLine

(

$resName = 'defaultRes'

)

Return next query data line with numeric indexes.

Parameters

string

$resName

Returns

array

Reimplemented from CDBConnection.

get_queryError()

MySQLiDBConnection::get_queryError

(

$resName = 'defaultRes'

)

Return latest query error.

Parameters

string

$resName

Returns

string

Reimplemented from CDBConnection.

get_queryAffectedRows()

MySQLiDBConnection::get_queryAffectedRows

(

$resName = 'defaultRes'

)

Return latest query affected rows.

Parameters

string

$resName

Returns

integer

Reimplemented from CDBConnection.

get_queryFieldCount()

MySQLiDBConnection::get_queryFieldCount

(

$resName = 'defaultRes'

)

Return latest query field count.

Parameters

string

$resName

Returns

integer

Reimplemented from CDBConnection.

get_queryFieldType()

MySQLiDBConnection::get_queryFieldType	(		$fIndex = 0,
			$resName = 'defaultRes'
	)

Return latest query field type.

Parameters

integer	$fIndex
string	$resName

Returns

string

Reimplemented from CDBConnection.

close_ressource()

MySQLiDBConnection::close_ressource

(

$resName = 'defaultRes'

)

Close ressource.

Parameters

string

$resName

Returns

boolean result

Reimplemented from CDBConnection.

escape_string()

MySQLiDBConnection::escape_string

(

$string

)

Return escaped string.

Parameters

string

$string

Returns

string

Reimplemented from CDBConnection.

get_compatibleType()

MySQLiDBConnection::get_compatibleType (   $type = 1 )

private

Return mysql compatible type from given type.

Parameters

integer

$type

Returns

string

---

The documentation for this class was generated from the following file:

• CaMykS/engine/lib/object/MySQLiDBConnection.php.inc