MySQL Class utilizing the MySQLi PHP extension
\
spfalz

dbdefs.inc.php

All configuration defines for the mysqlidb_class.

Configure the database access here together with some other class options.

Constants

MYSQLAPPNAME

MYSQLAPPNAME

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

MYSQLDB_HOST

MYSQLDB_HOST

Hostname/IP address of database.

MYSQLDB_USER

MYSQLDB_USER

Username to access database.

MYSQLDB_PASS

MYSQLDB_PASS

Password to use.

MYSQLDB_DATABASE

MYSQLDB_DATABASE

Database schema to use.

DB_ERRORMODE

DB_ERRORMODE

Modify default error behavour of class.

Default is db_mysqli::DBOF_SHOW_NO_ERRORS if you omit this parameter.

MYSQLDB_SENTMAILONERROR

MYSQLDB_SENTMAILONERROR

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

MYSQLDB_USE_PCONNECT

MYSQLDB_USE_PCONNECT

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

Default is 0, which means that mysql_connect is used instead. (new connections).

MYSQLDB_CHARACTERSET

MYSQLDB_CHARACTERSET

You can set here the character set used when connecting.

This is only performed if this define is set, else no specific character set is set. To get a list of all supported character sets connect to MySQL and issue the following: SHOW CHARACTER SET; The class performs a "SET NAMES 'utf8';" query if you define i.e. 'utf8' as characterset.

MYSQLDB_TIME_NAMES

MYSQLDB_TIME_NAMES

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

Note that this is supported since MySQL 5.0.25 (see http://dev.mysql.com/doc/refman/5.0/en/locale-support.html) If you do not define this value, the class does not set any lc_time_names at all. If a define is given the class performs a "SET lc_time_names = 'de_DE';" query to enable german locale.

MYSQLDB_COMPATIBLE_MODE

MYSQLDB_COMPATIBLE_MODE

If you use this class as replacement for my old class "db_MySQL" set this parameter below to TRUE.

In this case the old defines are defined to match the new class values.