4.0.5

in reference to #154

bug fixes, various refactoring, code cleanup

• improved query method
• improved/bug fix query_prepared method
• updated register_error to display errors directly, if show_error is on

Calling queryResult now correctly returns last result objects under all SQL driver vendors

4.0.2: rework bug fix, `debug` call working correctly with `prepareOn`

• added general secureSetup and secureReset methods for secure SQL connections, still work in progress
• removed string passing option from where clause shortcut method, accept array format only
• bug fix #153
• updated the docs

4.0.0

This version 4 has many modern programming practices in which will break users of Version 3.

• This version require PHP 7.0
• Added Database class, responsible for class instances, it an combination of Factory Pattern and with an Dependency_injection container.
• Added additional interfaces.
• All methods properties public access has been removed. use get{property}, set{property} methods instead.
• Class and File names changed.
• Following PSR-2, PSR-4, PSR-11 conventions, and PSR-1 as a work in progress.
• Updated documentation in reference to #142

See read-me for proper installation and usage.

3.1.2

• added create_cache method will be used if cache is on, and directory doesn't exits. set directory with setCache_Dir(path); default is 'tmp/ez_cache'
• changed some ez_sql_core.php properties to protected and added general __call method for access: get{property}, set{property}.
• various bug fixes, #150

Note: This is last release under the branch, will only receive bug fixes when reported. Next version master will carry is 4. https://github.com/ezSQL/ezSQL/tree/v4

Bug fixes, additional methods, secure connections, `create` table and schema shortcuts.

• additional create, drop, database schema maker helper methods.
  $database->create($table, ...$schema) where $schema is:

array( column, datatype, ...value/options arguments ) // calls create_schema() 
// datatype are global CONSTANTS and can be written out like:    VARCHAR, 32, notNULL, PRIMARY, AUTO, ....
// AUTO constant will replaced with the proper auto sequence for the SQL driver

Method shortcuts...

column( column, datatype, ...value/options arguments ) // returns string
primary( primary_key_label, ...primaryKeys) // returns string
foreign( foreign_key_label, ...foreignKeys) // returns string
unique( unique_key_label, ...uniqueKeys) // returns string
index(indexName, ...indexKeys)

See source comments/docblocks for more usage help.

For secure connections call securePDO('mysqli' or 'pgsql' or 'sqlserver', $key, $cert, $ca, $path);

• Only mysqli has been tested. Needs to be called at least once just before for actual connection.

• If no $key, $cert, $ca, $path is passed, an self signed certificate is created.

• Feature requested, and bug fixes in reference to: #148, #149

3.0.9

This version require PHP 5.6 or higher.

Installation

composer require ezsql/ezsql
require 'vendor/autoload.php';

Manually after extraction:
composer install

Change log same as v3.0.8

ezSQL v3

3.08 - Merged fork https://github.com/sjstoelting/ezSQL3 to be current with this repo.

• Added/Updated PHPunit tests, some marked as incomplete or not fully implemented, SQL drivers not loaded will be skipped.
• Refactor class code to use spl_autoload_register.
  Simply using require_once "ez_sql_loader.php"; then $database = new database_driver_class;. This will allow multi SQLdb to be loaded if need be.
• Added methods create_select, insert_select, update, insert, replace, delete, and selecting an alias for select.
  These are part of the new ezQuery SQL builder class. They are shortcut calls, these new methods will create proper SQL statements, from supplied arguments variable or array, prevent injections, then execute guery, in case of selecting execute get_results.
• Added many additional functions to support ezQuery builder and to easily process SQL prepare statements. Supplied arguments will be replace with necessary placeholder and values added to parameter array.
• All new methods has been fully PHPunit tested under current supported database systems, and should be able to handle most use cases as is.

Using Composer?
After downloading this release use: composer install
Auto installer: composer require jv2222/ezsql:v3.x-dev
Add to your source code: require 'vendor/autoload.php';

Todo: Implement WHERE IN sub query SELECT and shortcut method calls for the remainder of SQL standard statements.

• 3.07 - Added the new class ezSQL_mysql to use mysqli. To update existing projects, just change the class you are using from ezSQL_mysql to ezSQL_mysqli. This class is downward compatible to ezSQL_mysql, but is able to use prepared statements.
• 3.06 - Extended ezSQL_mysql method quick_connect with a charset parameter
• 3.05 - Extended ez_sql_oracleTNS class, that does now support client site connection pooling
• 3.04 - Added a new class for Oracle database connection to get rid of TNSNAMES.ORA configuration files
• 3.03 - Changed error messages, wrong classname used in a messages
• 3.02 - Improved ezSQL_recordset, array results of rows are faster
• 3.01 - Added a class for query result handling. The ezSQL_recordset contains methods that behave like fetch_assoc, fetch_row, and fetch_object
• 3.00 - Changed the code to PHP5, added PHPDoc tags, and added unit tests

ezSQL v2

2.17 - Updates to ezSQL_postgresql (thx Stefanie Janine Stoelting)

2.16 - Added profiling functions to mySQL version & added fix to stop mySQL hanging on very long runnign scripts

2.15 - Fixed long standing bug with $db->rows_affected (thx Pere Pasqual)

2.14 - Added sybase connector by Muhammad Iyas

2.13 - Support for transations. See: http://stackoverflow.com/questions/8754215/ezsql-with-multiple-queries/8781798

2.12 - Added $db->get_set() - Creates a SET nvp sql string from an associative array (and escapes all values)

2.11 - Fixed $db->insert_id in postgress version

2.10 - Added isset($this->dbh) check to orcale version

2.09 - Fixed issues with mysql_real_escape_string not woirkign if no connection
(Thanks to Nicolas Vannier)

2.08 - Re-added timer functions that seemed to have disappeared

2.07 - Used mysql_real_escape_string instead of mysql_escape_string

2.02 - Please note, this change log is no longer being used
please see change_log.htm for changes later than
2.02

2.01 - Added Disk Caching & Multiple DB connection support

2.00 - Re-factored ezSQL for Oracle, mySQL & SQLite

    - DB Object is no longer initialized by default
      (makes it easier to use multiple connections)

    - Core ezSQL functions have been separated from DB
      specific functions (makes it easier to add new databases)

    - Errors are being piped through trigger_error
      (using standard PHP error logging)

	- Abstracted error messages (enabling future translation)

	- Upgraded $db->query error return functionality

	- Added $db->systdate function to abstract mySQL NOW()
	  and Oracle SYSDATE

	Note: For other DB Types please use version 1.26

1.26 - Update (All)

    - Fixed the pesky regular expression that tests for
      an insert/update etc. Now it works even for the most
      weirdly formatted queries! (thx dille)

1.25 - Update (mySQL/Oracle)

    - Optimised $db->query function in both mySQL and Oracle versions.
      Now the return value is working 'as expected' in ALL cases so you
      are always safe using:

      if ( $db->query("some query") )

      No matter if an insert or a select.

      In the case of insert/update the return value is based on the
      number of rows affected (used to be insert id which is
      not valid for an update)

      In the case of select the return value is based on number of
      rows returned.

      Thx Bill Bruggemeyer :)

1.24 - Update (Docs)

    - Now includes tutorial for using EZ Results with Smarty
      templating engine - thx Steve Warwick

1.23 - Update (All PHP versions)

    - Fixed the age old problem of returning false on
      successful insert. $db->query()now returns the insert_id
      if there was a successful insert or false if not. Sorry
      that this took so long to fix!

      Version Affected: mySQL/Porgress/ms-sql/sqlite

    - Added new variable $db->debug_all

      By default it is set to false but if you change it
      to true. i.e.

      include_once "ez_sql.php";
      $db->debug_all = true;

      Then it will print out each and every query and all
      of the results that your script creates.

      Very useful if you want to follow the entire logic
      path of what ALL your queries are doing, but can't
      be bothered to put $db->debug() statements all over
      the place!

    Update (Postgress SQL Version)

     - Our old friend Tom De Bruyne as updated the postgress
       version.

       1) It now works without throwing errors (also thanks Geert Nijpels)

       2) It now, in theory, returns $this->insert_id after an insert.

1.22 - Update (All PHP versions)

      - Added new variable $db->num_queries it keeps track
        of exactly how many 'real' (not cached) queries were
        executed (using ezSQL) during the lifetime of one script.
        Useful for debugging and optimizing.

      - Put a white table behind the vardump output so that
        it doesn't get lost on dark websites.

1.21 - Update (All Versions)

	- Now 'replace' really does return an insert id..
	  (the 1.19 fix did not complete the job. Doh!)

1.20 - Update (New Version)

	- C++ SQLite version added. Look at ez_demo.cpp.
	  (thanks Brennan Falkner)

1.19 - Update (All Versions)

	- Fixed bug where any string containing the word 'insert',
	  'delete' or 'update' (where those words were not the actual
	  query) was causing unexpected results (thx Simon Willison).

	  The fix was to alter the regular expression to only match
	  queries containing those words at the beginning of the query
	  (with optional whitespace allowed before the words)

	  i.e.

	  THIS:    preg_match("/$word /",strtolower($query))
	  TO THIS: preg_match("/^\\s*$word /",strtolower($query))

	  - Added new sql word 'replace' to the above match pattern
	    so that the $db->insert_id would be also be populated
	    on 'replace' queries (thx Rolf Dahl)

1.18 - Update (All Versions)

	- Added new SQLite version (thanks Brennan Falkner)

	- Fixed new bug that was introduced with bug fix 1.14
	  false was being returned on successful insert update etc.
	  now it is true

1.17 - Update (All Versions)

	- New MS-SQL version added (thanks to Tom De Bruyne)
	- Made the donation request 'less annoying' by making it more subtle!

1.16 - Update (All Versions)

	- Added new function $db->escape()
	  Formats a string correctly to stop accidental
	  mal formed queries under all PHP conditions

1.15 - Bug fixes

	- (Postgress)
	  $this->result = false; was in the wrong place.
	  Fixed! Thanks (Carlos Camiña García)

	- (all versions)
	  Pesky get_var was still returning null instead of 0 in
	  certain cases. Bug fix of !== suggested by Osman

1.14 - Bug fixes

	- (all versions)
	  Added !='' into the conditional return of get_var.
	  because if the result was the number 0 it was not returning anything

	- (mySQL / Interbase / Postgress)
	  Added $this->result = false; if insert / update / delete
	  because it was causing mysql retrieval errors that no one
	  knew about due to the @ signs.

1.13 - Update (All Versions)

	- Swapped 2nd and 3rd argument order.
	- From.. get_row(query, int row offset, output type)
	- To.... get_row(query, output type, int row offset)

1.12 - Update (All Versions)

	- Tweaked the new hide/show error code
	- Made sure the $this->show_errors was always initialised
	- $db->query() function now returns false if there was an SQL error.
	  So that you can now do the following when you hide errors.

	  if ( $db->query("BAD SYNTAX") )
	  {
	  	echo "Bad Query";
	  }

1.11 - Update (All Versions)

	- added $db->hide_errors();
	- added $db->show_errors();
	- added global array $EZSQL_ERROR;

1.10 - Fix (mySQL)

	- Insist that mysql_insert_id(); uses $this->dbh.

1.09 - Bug Fix

	- Oracle version had the wrong number of parameters in the
	  $db = new db(etc,etc,etc,etc) part.

	- Also added var $vardump_called; to all versions.

1.08 - Bug Fix

	- Michael fixed the select function in PostgreSQL version.

1.07 - Bug Fix

	- Added var $debug_called; to all versions.

1.06 - Update

	- Fixed Bug In Oracle Version where an insert was
	  causing an error with OCIFetch
	- New PostgreSQL Version Added by Michael Paesold ([email protected])

1.05 - Bug Fix (mySQL)

	- Removed repeated piece of code.

1.04 - Update

	- $db->num_rows - variable added (All Versions)
	- $db->rows_affected - variable added ( mySQL / Oracle )
	- New InterBase/FireBase Version Added by LLCedar ([email protected])

1.03 - Update (All Versions)

Enhancements to vardump..

	- Added display variable type
	- If no value display No Value / False
	- Added this readme file

1.02 - Update (mySQL version)

Added $db->insert_id to

1.01 - New Version

Oracle 8 Version as below

1.00 - Initial Release

Functions..

	- $db->get_results - get multiple row result set from the database (or previously cached results)
	- $db->get_row -- get one row from the database (or previously cached results)
	- $db->get_col - get one column from query (or previously cached results) based on column offset
	- $db->get_var -- get one variable, from one row, from the database (or previously cached results)
	- $db->query -- send a query to the database (and if any results, cache them)
	- $db->debug - print last sql query and returned results (if any)
	- $db->vardump - print the contents and structure of any variable
	- $db->select -- select a new database to work with
	- $db->get_col_info - get information about one or all columns such as column name or type
	- $db = new db -- Initiate new db object.