Documentation TYPO3 par Ameos

tx_dbal_handler_rawmysql Class Reference

Inheritance diagram for tx_dbal_handler_rawmysql:

Inheritance graph
[legend]
Collaboration diagram for tx_dbal_handler_rawmysql:

Collaboration graph
[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 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_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_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().

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

Referenced by admin_query().


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


Généré par L'expert TYPO3 avec  doxygen 1.4.6