"TYPO3 4.0.1: tx_dbal_handler_rawmysql Class Reference", "datetime" => "Sat Dec 2 19:27:06 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

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: