Home
Name Modified Size InfoDownloads / Week
examples 2014-08-10
class 2014-08-10
readme.txt 2014-08-10 3.8 kB
sqlclassphp.zip 2014-08-10 28.0 kB
Totals: 4 Items   31.8 kB 0
-------------------------------------------------------------------------------
Revision: 6
Author: seimour_birkoff
Date: 10 august 2014 22:21:13
Message:
- rename sql class from SQL_DB to sqltype_DB (where sqltype is MYSQL or MYSQLI or SQLITE2 or SQLITE3 or MSSQL)
(this is required if you want to use 2 different sql databases)
(Note: after update to this revision you need to initialize class with specific name, see examples)
- corrected a bug on mysql/mysqli class (bug sql port if is different from 3306)
- add $this->sql_query_monitor (use to monitor query)
(Note: before this revision if you use $this->sql_tracer you get all log from class, include filters and other data and now with $this->sql_query_monitor you can see now only executed queries)
- corrected a bug on all classes on log 
(before this update if is to many queries you get an memory error, and now you can avoid this problem by using $this-sql_debug = false;)
- add $this->query_log() (protected function - use $this->sql_query_log instead)
- corrected a bug on $this->real_escape() function
- corrected a bug on $this->free_result() function
- add example_2_db.php (example for using 2 databases of same type)
- add example_from_mysqli_to_sqlite3.php (example for 2 different databases)
- update example.php
----
Modified : /example.php
Added : /example_2_db.php
Added : /example_from_mysqli_to_sqlite3.php
Modified : /example_mysql_php4x-5x.php
Modified : /example_mysqli_php5x.php
Modified : /mssql.inc.php
Modified : /mysql.inc.php
Modified : /mysqli.inc.php
Modified : /sqlite2.inc.php
Modified : /sqlite3.inc.php
-------------------------------------------------------------------------------
Revision: 5
Author: seimour_birkoff
Date: 31 ianuarie 2014 20:11:01
Message:
- added mysqli class (for php 5)
- rewrite mysql.inc.php for php 5 standards
- added new mysql and mysqli examples (create table, select, insert, delete, drop)
----
Modified : /example.php
Added : /example_mysql_php4x-5x.php
Added : /example_mysqli_php5x.php
Modified : /mysql.inc.php
Added : /mysqli.inc.php
-------------------------------------------------------------------------------
Revision: 4
Author: seimour_birkoff
Date: 9 februarie 2012 19:44:03
Message:
- added new function for mysql::set_time_zone
----
Modified : /mssql.inc.php
Modified : /mysql.inc.php
Modified : /sqlite2.inc.php
Modified : /sqlite3.inc.php
-------------------------------------------------------------------------------
Revision: 3
Author: seimour_birkoff
Date: 23 octombrie 2011 19:38:11
Message:
- code review (set all messages and comments on english language)
- bug fixed on MSSQL::real_escape
- added new function array_sqlfilter() (improvement)
----
Modified : /mssql.inc.php
Modified : /mysql.inc.php
Modified : /sqlite2.inc.php
Modified : /sqlite3.inc.php
-------------------------------------------------------------------------------
Revision: 2
Author: seimour_birkoff
Date: 7 august 2011 21:13:17
Message:
- change function name from real_escape_string to real_escape
- change function name from sql_prepare_data to prepare_data
- corect bug on real_escape function
- corect bug on prepare_data function
----
Modified : /example.php
Modified : /mssql.inc.php
Modified : /mysql.inc.php
Modified : /sqlite2.inc.php
Modified : /sqlite3.inc.php
-------------------------------------------------------------------------------
Revision: 1
Author: seimour_birkoff
Date: 4 mai 2011 23:31:25
Message:
The first working version. Read the instructions in example.php
----
Added : /example.php
Added : /mssql.inc.php
Added : /mysql.inc.php
Added : /sqlite2.inc.php
Added : /sqlite3.inc.php
-------------------------------------------------------------------------------
Source: readme.txt, updated 2014-08-10