APPLICATION=MySQL DB Class
V0.39:
07-Aug-2010 - Next public release
- Upd: Updated docs and examples, made class ready for release.
22-Apr-2010 - Fix: Major bug in IsQueryWithResult() found which may result
in wrong return values. This can lead to very serious
problems if the application relies on these return values.
V0.38:
23-Jan-2010 - Next public release.
18-Nov-2009 - Add: Public method "NumRows()" which returns the rows returned
by a previous SELECT or SHOW statement.
Requested by Andreas B.
- Add: Private method "IsQueryWithResult()" added which checks
if a given query could return an result at all. Currently
checks for the following known commands:
SELECT,SHOW,EXPLAIN,DESCRIBE,OPTIMIZE,ANALYZE,CHECK
27-Oct-2009 - Upd: Method "PerformNewInsert()" supports now both INSERT
and REPLACE commands. 3rd parameter with default value
of "INSERT" added, pass REPLACE if you want to use
the REPLACE functionality. No other value is allowed.
03-Oct-2009 - Add: New method "PerformNewInsert()" which takes an associative
array together with a table name and auto-generates from
these data INSERT statements with MySQL's NEW INSERT
method. This allows to add multiple values in one query
reducing the round-trip times between server and client.
This method takes the "max_allowed_packet" value from
MySQL into account and creates NEW INSERT statements
up to the max_allowed_packet size.
02-Oct-2009 - Add: New define "MYSQLDB_NEW_LINK" allows to modify the
"new_link" parameter for mysql_connect(). Until now
this value was always set to FALSE, which is still
the default value if you do not set this define to
TRUE. See docs for further details about this define.
V0.37:
11-Jul-2009 - Next public release.
- Add: New method "checkSock()" to test if class is connected
to an database, calls print_error() if no connection exist.
- Add: New method "DescTable()" which describes a given table.
Also new example "desc_tables.php" added to the examples.
Requested by PauliOpa.
- Fix: The defines with prefix DBOF_* are checked first if they
already exist before calling the define(). It can give
problems if you use both the mysql class together with
the OCI8 class for example, as both are using the same
defines and therefor PHP stops execution when trying to
double define them.
30-May-2009 - Add: Method setErrorHandling() returns now the previous
value before setting the new one.
27-Apr-2009 - Fix: PHP Warning when running class under CLI sapi.
- Fix: When using an IP address / hostname with a different
port than the default (3306) it was not possible to
use that port at all during a wrong string concat.
V0.36:
29-Nov-2008 - Next public release.
- Added new example script "ddl_dml.php" which demonstrates
DDL (CREATE,DROP) and DML (INSERT,UPDATE) SQL commands.
21-Sep-2008 - Added new example script "locale.php" which demonstrates the new
functions for locale/characterset support.
- Added four new methods: set_CharSet() / get_Charset() to retrieve
and change the character set of the current mysql connection
and get_TimeNames() / set_TimeNames() to change the locale
settings for the date_format() output.
- Added support for the time names to return as localized text.
An additional define called 'MYSQLDB_TIME_NAMES' is added which
should be set to i.e. 'de_DE' to have german support.
See dbdefs.inc.php file or the README for further details.
16-Sep-2008 - Added possibility to change the default characterset of
a MySQL connection. Simply set the define MYSQLDB_CHARACTERSET
to i.e. 'utf8' and the class performs a 'SET NAMES 'utf8'; call
after successfully connecting to the target database.
V0.35:
28-Jul-2008 - Public release.
- Prepared all scripts for public release and updated examples
to use same functionality as the OCI8 examples (SAPI detection etc.).
07-Jul-2008 - Updated EscapeString() method to check if $db->sock is really
a mysql resource, else it will fall back to mysql_escape_string().
25-May-2008 - Added method "EscapeString()" which allows to escape a given
string with "mysql_real_escape_string()". It also supports
the get_magic_quotes_gpc() settings and calls stripslashes()
first before escaping the string.
16-Mar-2008 - Added possibility to change the TCP portnumber used to connect
to the MySQL server. Defaults to 3306. Setable both via the
connect() method or via dbdefs.inc.php/MYSQLDB_PORT define.
13-Mar-2008 - Added method GetDebug() which returns current debug setting of class.
- Removed a typo in Print_Error().
- Constructor now require_once() the dbdefs.inc.php file instead
of include() it as this file is required for operation of this class.
04-Nov-2007 - Print_Error() method now always adds a line to PHP error.log
21-Jul-2007 - Added Querycounter to Print_Error() method.
- Removed a double warning if DBOF_SHOW_ALL_ERRORS was not set.
28-Feb-2007 - Fixed a bug when calling methods "Commit()" or "Rollback()",
both would produce a fatal error during wrong pointer usage :|
01-Nov-2006 - Added support for persistant connections. This can be globally
activated via new config define "MYSQLDB_USE_PCONNECT", if set
to 1 persistant connections are used, else standard connects.
You can set this state also via new method "setPConnect()"
Set it to TRUE for persistant or false for standard connections.
V0.34:
18-Jun-2006 - Public release.
- Added support for additional parameter MYSQLDB_MAIL_EXTRAARGS
which can be used to pass additional parameter to the mail()
command in SendMailOnError(). Suggested by Byteandi. Updated
docs accordingly.
V0.33:
11-Jun-2006 - Added new methods GetErrno() and GetErrorText() to retrieve
mysql_errno() and mysql_error().
V0.32:
10-Jun-2006 - Added new functions GetConnectionHandle(), SetConnectionHandle()
and SendMailOnError() from OCI8 class. GetConnectionHandle()
returns the currently used connection pointer, setConnectionHandle()
allows to set it from an external variable and SendMailOnError()
is used to send out an email in case of an error.
V0.31:
26-Feb-2006 - Added support for admin email (see dbdefs.inc.php) and detection
of PHP SAPI type. If running as cli no html is generated, this gives
much better error reportings.
V0.30:
21-Jan-2006 - Mktime() call in ConvertMySQLDate() now protected with intval()
castings, this avoids warnings when wrong data is supplied.
V0.29:
07-Jun-2005 - Changed all defines to have MYSQL in front of them, this is
neccessary to allow both OCI8 AND MySQL classes to be used
in parallel - Same changes will be done on OCI8 class of course.
05-Jun-2005 - Fixed some "NOTICE" logs from PHP if error_mode is set
to E_ALL.
- Added missing internal variable debug
V0.28:
18-Apr-2005 - Added new defines DBOF_SHOW_ALL_ERRORS, DBOF_SHOW_NO_ERRORS
and DBOF_RETURN_ALL_ERRORS which allow together with new
function setErrorHandling() to define how the class should
react in case of errors. If DBOF_SHOW_ALL_ERRORS is set the
class lists as much error informations as possible, which is
a major security problem when running your site in a productive
environment. To avoid this the class runs now per DEFAULT in
mode DBOF_SHOW_NO_ERRORS, in which errors are still listed but
no query or variable dumps are shown to the user.
If you want to manage the complete error handling yourself set
DBOF_RETURN_ALL_ERRORS and the class will return the
mysql_Errno() code whenever an error occures.
- Added BSD license hint to header of files. The class is now
licensed under BSD.
16-Apr-2005 - Finished phpDocumentor compatible sourcecode description and
checked into CVS repository.
18-Mar-2005 - Added Query execution time measurement and new function called
GetQueryTime() to retrieve that value.
- Added CHECK, ANALYZE and OPTIMIZE to list of filter for Query().
Whenever the query starts with one of these keywords the Query()
function automatically returns the corresponding resultrow
instead of the result value.
- Added function ConvertMySQLDate() which allows to convert
default datestrings into a freely formatable string by
utilizing strftime.
15-Mar-2005 - Updated Class docs to be phpdoc compatible.
-----------------------------------------------------------------------------
$Id: CHANGELOG,v 1.22 2010/08/07 08:16:14 siegel Exp $
Documentation generated on Sat, 07 Aug 2010 10:18:03 +0200 by phpDocumentor 1.4.3