dbConnect

[Ralf Hertsch]

The purpose of dbConnect is to provide you with an easy to use and secure class with all basic database functions you need.

Features:

• easily define, create and delete tables
• insert, update, delete and select records
• insert and remove WebsiteBaker Search Feature
• execute SQL statements
• prevents SQL injections
• safety error handling prevents nasty surprises
• in case of error return detailed messages
• check SQL statements
• switch to simulate mode for testing purposes

Requirements:

• dbConnect make use of the PHP 5 OOP features as well as exception handling and is not compatible to PHP 4

Documentation:

• dbConnect comes with a installable sample module (in /sample) and sample sources
• online documention (german only)

Any kind of improvement, critics, recommands, code clean-up and grumble
are always welcome.

Regards
Ralf

[Ralf Hertsch]

I have just released dbConnect 0.26.

Changed:

• dbConnect now make use of MySQLi and no longer impelements WB class.database.php for database connection.
• therefore it is possible to use dbConnect also outside of WB

Any kind of improvement, critics, recommands, code clean-up and grumble
are always welcome.

Regards
Ralf

[Ralf Hertsch]

I have released dbConnect 0.29.

Added:

• the new functions: sqlFieldExists(), sqlAlterTableAddFie ld(), sqlAlterTableChange Field(), sqlAlterTableDropFi eld()
• allow easy handling of changed databases while upgrading a module

Any kind of improvement, critics, recommands, code clean-up and grumble
are always welcome.

Please use this download link to get latest release of dbConnect

Regards
Ralf

[lawalty]

I installed this module "bdConnect" because i am seeking a better way of viewing all my form submissions than what wb does.  But, I tried to install it, the instillation goes well, - no one can view my website.  It becomes a blank page, until i uninstall the module.

[Ralf Hertsch]

Hello,

Please give me some informations:

• WB Version
• dbConnect Version
• installed addons with version

thank you!

Regards
Ralf

[lawalty]

Okay,

Here is the requested list.

• WB Version:  wb2.8 (latest) - which i also tried on wb2.7
• dbConnect Version:  0.33
• installed addons:  CSV Export, Download Gallery 2, Event Calendar, Feedback, MPForm, Shoutbox, User Statistics

Now i didn't try dbConnect on a fresh install of WB.

I have about three different form pages that do different things and collect different type of data that use the MPForm module.  I am looking for a database module that can display the MYSQL form-data on a simple table like spreadsheet like CSV. 

See my other post here:

https://forum.WebsiteBaker.org/index.php/topic,14953.msg95369.html#msg95369