Inheritance diagram for tx_dbal_handler_rawmysql:

Collaboration diagram for tx_dbal_handler_rawmysql:

Public Member Functions
	init ($config, &$pObj)
	exec_INSERTquery ($table, $fields_values)
	exec_UPDATEquery ($table, $where, $fields_values)
	exec_DELETEquery ($table, $where)
	exec_SELECTquery ($select_fields, $from_table, $where_clause, $groupBy, $orderBy, $limit)
	sql_error ()
	sql_insert_id ()
	sql_affected_rows ()
	sql_query ($query)
	quoteStr ($str)
	admin_get_tables ()
	admin_get_fields ($tableName)
	admin_get_keys ($tableName)
	admin_query ($query)
Public Attributes
	$config = array()
	$link
	$pObj

Detailed Description

Definition at line 86 of file class.tx_dbal_handler_rawmysql.php.

Member Function Documentation

tx_dbal_handler_rawmysql::admin_get_fields ( $ tableName )

Returns information about each field in the $table, quering MySQL for it.

Parameters:

string Table name

Returns:: array Field information in an associative array with fieldname => field row

Reimplemented from tx_dbal_sqlengine.

Definition at line 256 of file class.tx_dbal_handler_rawmysql.php.

tx_dbal_handler_rawmysql::admin_get_keys ( $ tableName )

Returns information about each index key in the $table, quering MySQL for it.

Parameters:

string Table name

Returns:: array Key information in a numeric array

Reimplemented from tx_dbal_sqlengine.

Definition at line 274 of file class.tx_dbal_handler_rawmysql.php.

tx_dbal_handler_rawmysql::admin_get_tables ( )

Returns the list of tables from the database, quering MySQL for it.

Returns:: array Tables in an array (tablename is in both key and value)

Todo:: Should return table details in value! see t3lib_db::admin_get_tables()

Reimplemented from tx_dbal_sqlengine.

Definition at line 239 of file class.tx_dbal_handler_rawmysql.php.

tx_dbal_handler_rawmysql::admin_query ( $ query )

mysql() wrapper function, used by the Install Tool and EM for all queries regarding management of the database!

Parameters:

string Query to execute

Returns:: pointer Result pointer

Reimplemented from tx_dbal_sqlengine.

Definition at line 292 of file class.tx_dbal_handler_rawmysql.php.

References $query, and sql_query().

tx_dbal_handler_rawmysql::exec_DELETEquery	(	$	table,
		$	where
	)

Execute DELETE query

Parameters:

string	Table name
string	WHERE clause

Returns:: boolean True on success

Reimplemented from tx_dbal_sqlengine.

Definition at line 147 of file class.tx_dbal_handler_rawmysql.php.

References $GLOBALS.

tx_dbal_handler_rawmysql::exec_INSERTquery	(	$	table,
		$	fields_values
	)

Execute INSERT query

Parameters:

string	Table name
array	Field=>Value array

Returns:: boolean True on success

Reimplemented from tx_dbal_sqlengine.

Definition at line 124 of file class.tx_dbal_handler_rawmysql.php.

References $GLOBALS.

tx_dbal_handler_rawmysql::exec_SELECTquery	(	$	select_fields,
		$	from_table,
		$	where_clause,
		$	groupBy,
		$	orderBy,
		$	limit
	)

Execute SELECT query

Parameters:

string	List of fields to select from the table. This is what comes right after "SELECT ...". Required value.
string	Table(s) from which to select. This is what comes right after "FROM ...". Required value.
string	Optional additional WHERE clauses put in the end of the query. NOTICE: You must escape values with addslashes() first
string	Optional GROUP BY field(s), if none, supply blank string.
string	Optional ORDER BY field(s), if none, supply blank string.
string	Optional LIMIT value ([begin,]max), if none, supply blank string.