I'm working on my first module and having got the admin section working fine am now working on the front end. A user does a search and finds data in my module, clicks on the link and is directed to a normal XOOPS page called viewrecord.php

The top part of this file is like this:

<?php

include XOOPS_ROOT_PATH.'/mainfile.php';
include XOOPS_ROOT_PATH.'/header.php';
include XOOPS_ROOT_PATH.'/class/database/database.php';

function getAnyRecordViewTemplateId($idtable)
{
$db = &Database::getInstance();

// BLAH BLAH BLAH - SNIPPED

return $data['id'];
}

$idtemplate = getAnyRecordViewTemplateId($_REQUEST['idtable']);


Really the problem is in the first few lines - it gets as far as setting $db, but returns the error: Fatal error: Undefined class name 'database' in C:\dev\tool\sokkit\site\xoops\modules\directory\viewrecord.php on line 9

Its almost like its ignoring the database.php include ? I've tried typing in junk in the include line there and it doesn't error either?!!?

Please help, confused

Matt

1. You don't need to include the database class files - that's done via the inclusion of mainfile.php

2. $db =& XoopsDatabaseFactory::getDatabaseConnection(); is the correct way to retrieve the database object.

Thanks, but the error persists on the same line except now in the form of:

Fatal error: Undefined class name 'xoopsdatabasefactory'

I really think that it seems to be ignoring the include statement...

Sussed it.

It was a directory issue - I changed the includes to remove the constant XOOPS_ROOT_PATH - it's actually blatently obvious what the problem is but has only struck me now because it was v hard to pin down where it was actually going wrong - it doesn't seem to error properly if mainfile.php isn't included.

XOOPS_ROOT_PATH is actually set when mainfile.php is included (no I don't know how I thought it was some kind of global constant before either). Removed now and it works fine.

Phew, that only wasted 4 hours - at least I'll know for next time.