database access

[NashBridges]

hi
i've searched the forum but haven't found any solution for this topic.

I want to present database content, which is stored in the same db like cmsms (different prefix) and handling the query results by xajax. i know basically how this can be done.
my question is how to use the database connection of the CMSms and how to send querys to the database using this connection, so that i would not have to connect to the db for every access myself. is ther a tutorial anywhere or could anybody help me out and describe the steps to a solution?

thx
regards
christian

[Ruben_c]

maybe with:  $db = $this->getDb();

[Peciura]

Code: Select all

$db = cmsms()->GetDB();

Here are some links to AdoDB documentation. CMSms is using AdoDB Lite but most things are the same to AdoDB.
http://adodb.sourceforge.net/
http://adodblite.sourceforge.net/datadictionary.php
There is module "Skeleton" it is the reference for module building.

If you will search forum for 'GetDB()' you will find more examples.