Looking for the latest version? Download cdesimple2.2.zip (459.3 kB)
Home / cdesimple v 1.9
Name Modified Size Downloads / Week Status
Parent folder
Readme.txt 2012-11-15 2.5 kB 0
cdesimple.1.9.zip 2012-11-15 31.6 kB 0
Totals: 2 Items   34.1 kB
Cross Database Engine Installation Copy cdeclass.php & cdesimple.php into your development folder or includes folder. Getting Started I normally create a connection.php to be included where neccessary. You can do the same in your projects, here is a sample of code: require_once ("cdesimple.php"); global $DB; $CDE = new CDESimple ($_CDE_DATABASE, $_CDE_USERNAME, $_CDE_PASSWORD, "firebird", $debug=false, "dd/mm/YYYY"); //date format can be YYYY-mm-dd or mm/dd/YYYY for example Example of getting records $cars = $CDE->get_row ("select * from tblcar"); //The above will be an object array of cars foreach ($cars as $id => $record) { echo "$record->NAME $record->MODEL"; } Example of fetching one record $cars = $CDE->get_value (0, "select * from tblcar"); And if you really want to see whats happening, pop the hood open on cdesimple, here is a short list of cool functions: function last_error() - returns last error message function connect ($dbpath="", $username="", $password="", $dbtype="sqlite") - connects to a database and creates a database handle function close () - close the database connection - more needed for sqlite and mysql function set_database () - probably going to be for mysql function exec ($sql="", $params...) - execute sql and pass params - see the documentation for cdeclass it works the same function commit() - commits data - more for transaction driven databases like oracle & firebird function get_error() - works with last error function get_row ($sql="", $rowtype=0) - get records into an array - $rowtype = 0 - Object, 1 - Array, 2 - Array Indexed by Field Name function get_value ($id=0, $sql="", $rowtype=0) - gets a single record out of the array if possible function get_field_info ($sql=""); - very cool if you want to do dynamic record iteration function get_affected_rows ($sql="") - count of records in the result set function get_next_id ($tablename="", $fieldname="") - if you dont have generators like in firebird, mysql or don't want to use generators then use this Please enjoy using the Cross Database Engine, it is not going to go away and we intend to keep updating it. Spiceware Software uses it as a production library so you can be sure it is tested every day. Yours sincerely Andre van Zuydam Feel free to email me if you want to take part or want to ask questions: andre at spiceware dot co dot za
Source: Readme.txt, updated 2012-11-15

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies
X

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

No, thanks