Debby has replaced CDE in the Tina4Stack,
you may want to check it out at http://tina4.com

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

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

Project Samples

Project Activity

See All Activity >

License

GNU General Public License version 2.0 (GPLv2)

Follow cde4php - Cross Database Engine for PHP

cde4php - Cross Database Engine for PHP Web Site

Other Useful Business Software
Enterprise and Small Business CRM Solution | Clear C2 C2CRM Icon
Enterprise and Small Business CRM Solution | Clear C2 C2CRM

Voted Best CRM System with Top Ranked Customer Support. CRM Management includes Sales, Marketing, Relationship Management, and Help Desk.

C2CRM consists of four modules that integrate to provide a comprehensive CRM solution: Relationship Management, Sales Automation, Marketing Automation, and Customer Service. Only buy what each user needs.
Rate This Project
Login To Rate This Project

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

User Reviews

  • 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 !
  • 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/
  • I would recommend this to all developers to use. This is a great and effective project.
  • 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.
Read more reviews >

Additional Project Details

Operating Systems

Windows

Intended Audience

Information Technology, Education, Developers, End Users/Desktop

Programming Language

C#, PHP, BASIC, ASP.NET

Database Environment

Project is a database abstraction layer (API), SQL-based, ADO.NET

Related Categories

C# Database Engines Servers, C# School Management Software, C# Libraries, PHP Database Engines Servers, PHP School Management Software, PHP Libraries, BASIC Database Engines Servers, BASIC School Management Software, BASIC Libraries, ASP.NET Database Engines Servers, ASP.NET School Management Software, ASP.NET Libraries

Registered

2006-08-17