Full index

Package indexes

• db_MySQL

$AdminEmail

db_MySQL::$AdminEmail in mysqldb_class.php

$appname

db_MySQL::$appname in mysqldb_class.php

AffectedRows

db_MySQL::AffectedRows() in mysqldb_class.php

Returns count of affected rows by last DML operation.

$characterset

db_MySQL::$characterset in mysqldb_class.php

$classversion

db_MySQL::$classversion in mysqldb_class.php

$currentQuery

db_MySQL::$currentQuery in mysqldb_class.php

checkSock

db_MySQL::checkSock() in mysqldb_class.php

Checks if we are already connected to our database.

Commit

db_MySQL::Commit() in mysqldb_class.php

Commits current transaction.

Connect

db_MySQL::Connect() in mysqldb_class.php

Performs the connection to MySQL.

ConvertMySQLDate

db_MySQL::ConvertMySQLDate() in mysqldb_class.php

Converts a MySQL default Datestring (YYYY-MM-DD HH:MI:SS) into a strftime() compatible format.

connect.php

connect.php in connect.php

$database

db_MySQL::$database in mysqldb_class.php

$debug

db_MySQL::$debug in mysqldb_class.php

dbdefs.inc.php

dbdefs.inc.php in dbdefs.inc.php

DBFooter

DBFooter() in functions.inc.php

Prints out the amount of queries and the time required to process them.

DBOF_DEBUGFILE

DBOF_DEBUGFILE in mysqldb_class.php

DEBUG: Debug to error_log()

DBOF_DEBUGOFF

DBOF_DEBUGOFF in mysqldb_class.php

DEBUG: No Debug Info

DBOF_DEBUGSCREEN

DBOF_DEBUGSCREEN in mysqldb_class.php

DEBUG: Debug on-screen

DBOF_MYSQL_COLFLAGS

DBOF_MYSQL_COLFLAGS in mysqldb_class.php

These defines are used in DescTable().

DBOF_MYSQL_COLNAME

DBOF_MYSQL_COLNAME in mysqldb_class.php

These defines are used in DescTable().

DBOF_MYSQL_COLSIZE

DBOF_MYSQL_COLSIZE in mysqldb_class.php

These defines are used in DescTable().

DBOF_MYSQL_COLTYPE

DBOF_MYSQL_COLTYPE in mysqldb_class.php

These defines are used in DescTable().

DBOF_RETURN_ALL_ERRORS

DBOF_RETURN_ALL_ERRORS in mysqldb_class.php

Connect and error handling (V0.28+).

DBOF_SHOW_ALL_ERRORS

DBOF_SHOW_ALL_ERRORS in mysqldb_class.php

Connect and error handling (V0.28+).

DBOF_SHOW_NO_ERRORS

DBOF_SHOW_NO_ERRORS in mysqldb_class.php

Connect and error handling (V0.28+).

DB_ERRORMODE

DB_ERRORMODE in dbdefs.inc.php

Modify default error handling mode if you wish.

DB_HOST

DB_HOST in ddl_dml.php

Database hostname (can be empty, localhost is then assumed)

db_MySQL

db_MySQL::db_MySQL() in mysqldb_class.php

Constructor of this class.

db_MySQL

db_MySQL in mysqldb_class.php

Main class definition.

DB_NAME

DB_NAME in ddl_dml.php

Database schema name

DB_PASS

DB_PASS in ddl_dml.php

Database user password

DB_PORT

DB_PORT in ddl_dml.php

Database TCP port number to use, defaults to 3306

DB_USER

DB_USER in ddl_dml.php

Database user name

DescTable

db_MySQL::DescTable() in mysqldb_class.php

Returns the description for a given table.

Disconnect

db_MySQL::Disconnect() in mysqldb_class.php

Disconnects from MySQL.

dbdefs.inc.php

dbdefs.inc.php in dbdefs.inc.php

ddl_dml.php

ddl_dml.php in ddl_dml.php

desc_tables.php

desc_tables.php in desc_tables.php

EscapeString

db_MySQL::EscapeString() in mysqldb_class.php

Escapes a given string with the 'mysql_real_escape_string' method.

functions.inc.php

functions.inc.php in functions.inc.php

FetchResult

db_MySQL::FetchResult() in mysqldb_class.php

Fetches next row from result handle.

FreeResult

db_MySQL::FreeResult() in mysqldb_class.php

Frees result returned by QueryResult().

GetClassVersion

db_MySQL::GetClassVersion() in mysqldb_class.php

Returns version of this class.

GetConnectionHandle

db_MySQL::GetConnectionHandle() in mysqldb_class.php

Returns current connection handle.

GetDebug

db_MySQL::GetDebug() in mysqldb_class.php

Returns the current debug setting.

GetErrno

db_MySQL::GetErrno() in mysqldb_class.php

Retrieve last mysql error number.

GetErrorText

db_MySQL::GetErrorText() in mysqldb_class.php

Retrieve last mysql error description.

getmicrotime

db_MySQL::getmicrotime() in mysqldb_class.php

Returns microtime in format s.mmmmm.

GetQueryCount

db_MySQL::GetQueryCount() in mysqldb_class.php

Returns amount of queries executed by this class.

GetQueryTime

db_MySQL::GetQueryTime() in mysqldb_class.php

Returns amount of time spend on queries executed by this class.

get_CharSet

db_MySQL::get_CharSet() in mysqldb_class.php

Method to return the current MySQL setting for the character_set variables.

get_TimeNames

db_MySQL::get_TimeNames() in mysqldb_class.php

Method to return the current MySQL setting for the lc_time_names variable.

$host

db_MySQL::$host in mysqldb_class.php

IsQueryWithResult

db_MySQL::IsQueryWithResult() in mysqldb_class.php

Private function checks if a given query is not a DML command.

$locale

db_MySQL::$locale in mysqldb_class.php

locale.php

locale.php in locale.php

LastInsertId

db_MySQL::LastInsertId() in mysqldb_class.php

Returns last used auto_increment id.

$myErrno

db_MySQL::$myErrno in mysqldb_class.php

$myErrStr

db_MySQL::$myErrStr in mysqldb_class.php

MYSQLAPPNAME

MYSQLAPPNAME in dbdefs.inc.php

Name of application using this class (used in error.log etc.).

MYSQLDB_ADMINEMAIL

MYSQLDB_ADMINEMAIL in dbdefs.inc.php

Set address to be shown in case of an error.

MYSQLDB_CHARACTERSET

MYSQLDB_CHARACTERSET in dbdefs.inc.php

You can set here the character set used when connecting.

mysqldb_class.php

mysqldb_class.php in mysqldb_class.php

MYSQLDB_DATABASE

MYSQLDB_DATABASE in dbdefs.inc.php

Database schema to use after connecting.

MYSQLDB_HOST

MYSQLDB_HOST in dbdefs.inc.php

Hostname/IP address of database server.

MYSQLDB_NEW_LINK

MYSQLDB_NEW_LINK in dbdefs.inc.php

If you need NEW connections when supplying identical credentials but using a different DB on the same server, set this define to TRUE. Default value is FALSE, this is also used by all previous releases of this class.

MYSQLDB_PASS

MYSQLDB_PASS in dbdefs.inc.php

Password to authenticate.

MYSQLDB_SENTMAILONERROR

MYSQLDB_SENTMAILONERROR in dbdefs.inc.php

Set this define to 1 if you want auto-emails to be sent whenever an error occures. Default is 0 (disabled).

MYSQLDB_TIME_NAMES

MYSQLDB_TIME_NAMES in dbdefs.inc.php

To have Day and month names returned in a specific locale, define here a valid countrycode.

MYSQLDB_USER

MYSQLDB_USER in dbdefs.inc.php

Username to connect to database.

MYSQLDB_USE_PCONNECT

MYSQLDB_USE_PCONNECT in dbdefs.inc.php

Set this define to 1 if you want to use persistant connections as default connection.

$new_link

db_MySQL::$new_link in mysqldb_class.php

$num_rows

db_MySQL::$num_rows in mysqldb_class.php

new_insert.php

new_insert.php in new_insert.php

NumRows

db_MySQL::NumRows() in mysqldb_class.php

Returns the number of rows in the result set.

$pass

db_MySQL::$pass in mysqldb_class.php

$port

db_MySQL::$port in mysqldb_class.php

PerformNewInsert

db_MySQL::PerformNewInsert() in mysqldb_class.php

Function performs an insert statement from a given variable list.

PrintDebug

db_MySQL::PrintDebug() in mysqldb_class.php

Handles output according to internal debug flag.

Print_Error

db_MySQL::Print_Error() in mysqldb_class.php

Prints out MySQL Error in own <div> container and exits.

$querycounter

db_MySQL::$querycounter in mysqldb_class.php

$querytime

db_MySQL::$querytime in mysqldb_class.php

queries.php

queries.php in queries.php

Query

db_MySQL::Query() in mysqldb_class.php

Performs a single row query.

QueryResult

db_MySQL::QueryResult() in mysqldb_class.php

Performs a multi-row query and returns result identifier.

Rollback

db_MySQL::Rollback() in mysqldb_class.php

Rollback current transaction.

$SAPI_type

db_MySQL::$SAPI_type in mysqldb_class.php

$showError

db_MySQL::$showError in mysqldb_class.php

$sock

db_MySQL::$sock in mysqldb_class.php

SendMailOnError

db_MySQL::SendMailOnError() in mysqldb_class.php

Send error email if programmer has defined a valid email address and enabled it with the define MYSQLDB_SENTMAILONERROR.

SetConnectionHandle

db_MySQL::SetConnectionHandle() in mysqldb_class.php

Allows to set internal socket to external value.

SetDebug

db_MySQL::SetDebug() in mysqldb_class.php

Function allows debugging of SQL Queries.

setErrorHandling

db_MySQL::setErrorHandling() in mysqldb_class.php

Allows to set the handling of errors.

setPConnect

db_MySQL::setPConnect() in mysqldb_class.php

Sets connection behavour.

set_CharSet

db_MySQL::set_CharSet() in mysqldb_class.php

Method to set the character set of the current connection.

set_TimeNames

db_MySQL::set_TimeNames() in mysqldb_class.php

Method to set the time_names setting of the MySQL Server.

t_num_rows.php

t_num_rows.php in t_num_rows.php

$usePConnect

db_MySQL::$usePConnect in mysqldb_class.php

$user

db_MySQL::$user in mysqldb_class.php

Version

db_MySQL::Version() in mysqldb_class.php

Returns MySQL Server Version.

WhichBR

WhichBR() in functions.inc.php

Returns an associative array with sapi-type name and required line break char.