WebsiteBaker Community Forum

WebsiteBaker Support (2.8.x) => Droplets & Snippets => Topic started by: Ralf Hertsch on October 03, 2008, 02:57:01 PM

Title: dbConnect
Post by: Ralf Hertsch on October 03, 2008, 02:57:01 PM

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 (http://phpmanufaktur.de/pages/dbconnect.php) (german only)

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

Regards
Ralf

Title: Re: dbConnect
Post by: Ralf Hertsch on October 17, 2008, 10:37:29 AM

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

Title: Re: dbConnect
Post by: Ralf Hertsch on December 11, 2008, 07:47:11 AM

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 (http://phpmanufaktur.de/modules/download_gallery/dlc.php?file=31)

Regards
Ralf

Title: Re: dbConnect
Post by: lawalty on August 20, 2009, 10:46:52 PM

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.

:?

Title: Re: dbConnect
Post by: Ralf Hertsch on August 21, 2009, 02:17:27 AM

Hello,

Please give me some informations:

• WB Version
• dbConnect Version
• installed addons with version

thank you!

Regards
Ralf

Title: Re: dbConnect
Post by: lawalty on August 21, 2009, 02:59:51 AM

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