Documentation TYPO3 par Ameos

Disponible dans d'autres versions de TYPO3 -> 3.7.0  3.8.1  4.0.0  4.0.1  4.1.0   <- Available in other TYPO3 versions

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::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::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.

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.

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.

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 t3lib_div::makeInstance().

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_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_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 t3lib_div::makeInstance().

Referenced by admin_query().

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::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)

Reimplemented from t3lib_sqlengine.

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

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 255 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 273 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 291 of file class.tx_dbal_handler_rawmysql.php.

References sql_query().

---

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

• typo3_src-4.1/typo3/sysext/dbal/handlers/class.tx_dbal_handler_rawmysql.php

---