MySQL database connection (old MYSQL versions).
MySQL database connection (old MYSQL versions).
This backend uses the older PHP MySQL extension (not MySQLi). Specify mysql-old as the connection type when setting up the connection using AnewtDatabase::setup_connection().
For newer MySQL versions you should use the AnewtDatabaseConnectionMySQL backend instead.
hostname The hostnameusername The usernamepassword The passworddatabase The name of the databaseencoding The character encoding (optional, defaults to UTF8) __construct($settings) ¶Create a new connection instance (internal use only).
Do not call this method directly; it is for internal use only. See the AnewtDatabase documentation on how to setup and obtain AnewtDatabaseConnection instances.
$settingsAssociative array with connection settings.
is_connected() ¶Check whether the connection is currently open.
True if the connection is open, false otherwise.
last_insert_id($options=null) ¶Get the last insert id for this connection.
The $options parameter is database backend specific. For most backends this value is not needed. At least PostgreSQL needs a sequence name. See the backend documentation for more information.
$optionsBackend-specific value.
real_execute_sql($sql) ¶Execute SQL and create an AnewtDatabaseResultSet for a query.
This method is for internal use only and is backend-specific.
$sqlThe SQL query to execute.
escape_string($value) ¶Escape a string for use in SQL queries.
$valueThe value to escape
The escaped value
escape_table_name($value) ¶Escape a table name for use in SQL queries.
$valueThe value to escape
The escaped value
escape_column_name($value) ¶Escape a column name for use in SQL queries.
$valueThe value to escape
The escaped value
real_connect() [protected] ¶Establish a database connection.
real_disconnect() [protected] ¶Disconnect the database connection.
AnewtDatabaseConnection::prepare_executev_fetch_all()AnewtDatabaseConnection::transaction_begin()AnewtDatabaseConnection::transaction_commit()AnewtDatabaseConnection::escape_date()AnewtDatabaseConnection::prepare_execute_fetch_one()AnewtDatabaseConnection::disconnect()AnewtDatabaseConnection::prepare_executev_fetch_one()AnewtDatabaseConnection::prepare()AnewtDatabaseConnection::transaction_rollback()AnewtDatabaseConnection::$queries_executedAnewtDatabaseConnection::$connection_handleAnewtDatabaseConnection::$settingsAnewtDatabaseConnection::prepare_executev()AnewtDatabaseConnection::prepare_execute_fetch_all()AnewtDatabaseConnection::escape_time()AnewtDatabaseConnection::prepare_execute()AnewtDatabaseConnection::escape_boolean()AnewtDatabaseConnection::create_sql_template()AnewtDatabaseConnection::connect()AnewtDatabaseConnection::escape_datetime()AnewtDatabaseConnection::$n_queries_executed