Ajax Handler v1.2
The Ajax Handler is a CakePHP Component that processes and handles AJAX requests. It determines what action should be dealt as an AJAX call, applies the appropriate filters, prepares the data for a response and responds with the appropriate headers.
Recent Thoughts
- Twitter feed is currently unavailable. View my Twitter
Databasic Version Logs
Package: MySQL Database Handler
Category: PHP & MySQL
Below is a list of all files and every available version for the Databasic script.
Each file is accompanied by a change log. Be cautious in using older versions, they may buggy.
Version: 2.3.2
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Tue, Dec 1st 2009, 22:08
- Fixed a problem with __formatType() not returning the correct type and causing major problems
- Fixed store() referencing the wrong property
- Fixed the regex that attempts to locate MySQL functions
- Fixed the limit not working on update()
Version: 2.3
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Tue, Aug 18th 2009, 13:01
- Skipped version 2.2 release because of bugs
- The following operators within conditions are now available: LIKE, NOT LIKE, IS NULL, IS NOT NULL, IN, NOT IN
- You may now pass the value as an array for IN operators to automatically build the list
- Fixed a problem with nested arrays not being parsed into conditions correctly
- Fixed a problem with conditions not being parsed correctly
- Fixed a problem with a method using the wrong name
- Fixed a bug with the __buildConditions() regex
- Added the addBind() method to properly store binds for statements
- Rewrote __buildConditions() to work with the new operators
- Rewrote bind(), update(), delete(), insert(), select(), __formatType() to use the new binds system
Version: 2.1
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Tue, Jul 28th 2009, 22:34
- Added support for AND/OR operators within conditions, in turn added the __formatConditions() method
- Added more support for MySQL functions
- Added the __encode() and __encodeMethod() methods
- Added RAND() support for ordering within select()
- Added a $persistent property so that you may use mysql_pconnect() instead of mysql_connect()
- Rewrote create() to work more efficiently and added a "collate" setting
- Rewrote bind to work correctly with MySQL functions
- Rewrote delete(), insert() and update() to not run actions when execute is $false (optimized)
- Rewrote __buildConditions() to support AND/OR operators, as well as the new format for value operations
- Rewrote how operators (!=, <=, etc) are used in conditions
- Optimized all methods to run faster and be cleaner
Version: 2.0
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Thu, Mar 12th 2009, 22:01
- Added support for multiple databases
- Added the store() method to store database connection information
- Removed the database connection constants
- Removed the $limit and $offset arguments for select(), they are now an index in the $options array
- Fixed select()'s count return not working when being an object
- Removed logic from __construct(), connecting is now done within getInstance(); changed for multiple db support
- Added methods for drop(), truncate() and describe()
- Rebuilt the optimize() method
- Added a create() method that takes a schema array and creates database table
Version: 1.10.3
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Sun, Mar 1st 2009, 18:07
- Fixed the insert() method (left comments/debug code in during testing)
- Fixed the 'group' option in select(), should properly GROUP BY now
- Fixed a problem when setting a column as NULL
Version: 1.10.2
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Fri, Feb 13th 2009, 12:50
- Fixed a bug with the $dataBit argument not working correctly on execute()
- Fixed the execution times when calling execute() stand alone
Version: 1.10.1
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Fri, Feb 13th 2009, 00:03
- Added an "execution time" for queries in debug mode
- Added the number of affected rows for queries in debug mode
- Added a getAffected() method
- Added a version number property
- Fixed a bug in binds that caused an error when no binds were present
- Fixed a problem with MySQL functions like NOW(), MD5(), etc (will need further testing)
- Removed the $asObject argument from fetch() and fetchAll() but instead made a $asObject property in the class
- Rebuilt the __formatColumnType() method
- Added the __startLoadTime() and __endLoadTime methods for calculating load/process/execution times
Version: 1.10
Requires: PHP 5
Tested On: PHP 5.2.5
Uploaded On: Mon, Feb 9th 2009, 17:05
- First initial release of Databasic
Random Scripts
- Databasic // MySQL Database Handler
- Ajax Handler // Component
- Commentia // Behavior
- Auto Login // Component
- Compression // CSS Builder & Parser
Topics
- CakePHP (41)
- Entertainment (2)
- Gaming (4)
- HTML & CSS (1)
- Javascript (6)
- jQuery (6)
- Other (8)
- Personal (10)
- PHP & MySQL (18)
- Plugins (3)
- Programming (8)
- Resources (13)
- Reviews (1)
- Scripts (14)
- Tutorials (41)