tx_dbal_handler_rawmysql Class Reference

Inheritance diagram for tx_dbal_handler_rawmysql:

[legend]Collaboration diagram for tx_dbal_handler_rawmysql:

[legend]List of all members.

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 t3lib_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 t3lib_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 t3lib_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 t3lib_sqlengine.

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

References 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 t3lib_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 t3lib_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.

Returns:

object Result object

Reimplemented from t3lib_sqlengine.

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

References $GLOBALS, $res, and t3lib_div::makeInstance().

tx_dbal_handler_rawmysql::exec_UPDATEquery	(	$	table,
		$	where,
		$	fields_values
	)

Execute UPDATE query

Parameters:

	string	Table name
	string	WHERE clause
	array	Field=>Value array

Returns:

boolean True on success

Reimplemented from t3lib_sqlengine.

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

References $GLOBALS.

tx_dbal_handler_rawmysql::init	(	$	config,
		&$	pObj
	)

Initialize. For MySQL we will have to connect to the database and select the database.

Parameters:

	array	Configuration array from handler
	object	Parent object.

Returns:

boolean True if connection and database selection worked out well.

Reimplemented from t3lib_sqlengine.

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

References $config, and $pObj.

tx_dbal_handler_rawmysql::quoteStr

(

$

str

)

Escape quotes in strings

Parameters:

string

Input string

Returns:

string Output string

Reimplemented from t3lib_sqlengine.

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

tx_dbal_handler_rawmysql::sql_affected_rows

(

)

mysql_affected_rows() wrapper

Returns:

integer mysql_affected_rows()

Reimplemented from t3lib_sqlengine.

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

tx_dbal_handler_rawmysql::sql_error

(

)

mysql_error() wrapper

Returns:

string mysql_error()

Reimplemented from t3lib_sqlengine.

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

tx_dbal_handler_rawmysql::sql_insert_id

(

)

mysql_insert_id() wrapper

Returns:

integer mysql_insert_id();

Reimplemented from t3lib_sqlengine.

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

tx_dbal_handler_rawmysql::sql_query

(

$

query

)

mysql_query() wrapper

Parameters:

string

Query string

Returns:

object Result object

Reimplemented from t3lib_sqlengine.

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

References $res, and t3lib_div::makeInstance().

Referenced by admin_query().

---

Member Data Documentation

tx_dbal_handler_rawmysql::$config = array()

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

Referenced by init().

tx_dbal_handler_rawmysql::$link

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

tx_dbal_handler_rawmysql::$pObj

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

Referenced by init().

---

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

• typo3/sysext/dbal/handlers/class.tx_dbal_handler_rawmysql.php

---