cde4php - Cross Database Engine for PHP Icon

cde4php - Cross Database Engine for PHP

Uniform Database Abstraction for PHP Development

4.0 Stars (4)
4 Downloads (This Week)
Last Update:
Download cdesimple.2.1.zip
Browse All Files
Windows Mac Linux

Screenshots

Description

CDE is a PHP class which implements the general database functions in PHP and provides a common SQL platform for php development where developers change their databases but not their code. Supports Firebird, MySQL,Oracle,SQLite, MSSQL(both drivers),CUBRID,ODBC. CDE now supports date uniformity, param passing & BLOB handling across all the databases supported.

CDE is not a replacement for PDO, in fact we may implement PDO in CDE to standardize PDO results and calls. Some PDO drivers are still regarded as EXPERIMENTAL on PHP website, so use with caution.

Feel free to suggest any features you wish to be added or submit a bug report with the tracker

cde4php - Cross Database Engine for PHP Web Site

Features

  • Write code in PHP once for any database platform
  • Support all PHP database connectivity (If not supported please request)
  • One set of database functions connects to any database (What order does the db handle fall in ibase_connect and mysql_connect?)
  • Make PHP database development simple
  • Unified Blob support for all databases - no hassle reading and writing BLOBS
  • Less Code Overall - Remove 2 to 3 Lines per database transaction
  • Automatic PDF reporting from SQL statement using fpdf
  • Generate Automatic SQL statements from Form request variables - see Readme
  • Full metadata extraction of database using get_database()
  • Execute more than one SQL script at a time with ; delimiter
  • SMALL!!! Just one include for all database formats supported.
  • Uniform date format, specify return date format of fields.
  • Parameter passing with ? for all database drivers in exec statement
  • HTML5 inputs, selects by calling input / select method.
  • Create Image thumbnails from BLOB
  • Safe Javascript output

Update Notifications





User Ratings

★★★★★
★★★★
★★★
★★
3
0
0
0
1
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
Write a Review

User Reviews

  • toughy
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Nice project, but I also think php already has an uniform interface for connecting and accessing databases: PDO (php data objects). You should use that, and than make sure the parsesql() function knows to translate SQL to the right database type by some other means. Actually, the operating system also has an uniform interface for connecting and accessing databases: ODBC. Can you include support for ODBC in the project ? That will also make it easier for me to add my own database type.. Anyway, great job !

    Posted 04/27/2012
  • oid-3727219
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Actually this is not the proper method to interface with databases from php - PDO should be used, see these links for more information: http://php.net/manual/en/book.pdo.php http://net.tutsplus.com/tutorials/php/why-you-should-be-using-phps-pdo-for-database-access/

    Posted 02/08/2012
  • anelklynsmith
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    I would recommend this to all developers to use. This is a great and effective project.

    Posted 03/11/2010
  • andrevanzuydam
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    I would recommend this to all developers who want to write their code once and port to other databases. Effectively all database functions are merged into 3 to 4 basic functions so the end result is less code to do the same thing from a database function perspective. Blobs for instance are retrieved (optional) by default when a row is retrieved.

    Posted 03/09/2010
Read more reviews

Additional Project Details

Intended Audience

Developers, Education, End Users/Desktop, Information Technology

Programming Language

ASP.NET, BASIC, C#, PHP

Registered

2006-08-17
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.