MDB2 loadmodule extended

Codewalkers Forums Sponsor:

April 12th, 2007, 05:37 PM

wputler

Join Date: Apr 2007

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

MDB2 loadmodule extended

Hi - just trying my first MDB2 and having trouble already.

This works, so I know I've got the right dsn and it's finding MDB2.

php Code:

Original - php Code

 
    // Data Source Name: This is the universal connection string
    $dsn = 'mysql://' . $user . ':' . $pass . '@' . $host . '/' . $mdb2_name;
    
    $mdb2 =& MDB2::factory($dsn);
 
    $mdb2->loadModule('Extended', null, false);
 
    if (PEAR::isError($mdb2)) {
        echo ($mdb2->getMessage().' - '.$mdb2->getUserinfo());
    }
 
$query ='SELECT * FROM mytable';
 
// run the query and get a result handler
$result = $mdb2->query($query);
 
// check if the query was executed properly
if (PEAR::isError($result)) {
    echo ($result->getMessage().' - '.$result->getUserinfo());
    exit();
}
 
// lets just get row:0 and free the result
$array = $result->fetchRow();
$result->free();
var_dump($array);

So far, so good. Now I want to retrieve all the rows. So I decide getAssoc would be the perfect thing. But if I try to use getAssoc, I get the following error:

Call to undefined function: getassoc() in /blah/blah....

Here is my code for getting the Assoc array:

php Code:

Original - php Code
$sql = 'SELECT DISTINCT category FROM nrg_categories ORDER BY category'; $arr_categories = & $mdb2->getAssoc($sql);

 
$sql = 'SELECT DISTINCT category FROM nrg_categories ORDER BY category';
$arr_categories = & $mdb2->getAssoc($sql);

This has to be easier than I'm making it. Why won't it load the Extended class and why doesn't it give me an error - or am I referencing getAssoc in the wrong way?

April 12th, 2007, 05:58 PM

wiesemann

Contributing User

Join Date: Apr 2007

Posts: 153

Time spent in forums: 14 h 29 m 35 sec
Reputation Power: 2

RE: MDB2 loadmodule extended

I'm too lazy to check whether getAssoc() is a method of the extended module, but I guess so. Your way of using getAssoc() should work on PHP 5. On PHP 4, you need to write $mdb2->extended->getAssoc($sql);

April 12th, 2007, 06:35 PM

wputler

Join Date: Apr 2007

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

RE: MDB2 loadmodule extended

THANK YOU!! I hadn't found that reference anywhere!

I changed the code to:

php Code:

Original - php Code
$sql = 'SELECT category_id, category FROM nrg_categories ORDER BY category'; $arr_categories = & $mdb2->extended->getAssoc($sql);

 
$sql = 'SELECT category_id, category FROM nrg_categories ORDER BY category';
$arr_categories = & $mdb2->extended->getAssoc($sql);

And it works! I did have to add another field - it requires 2 (duh - because it wants to return an associative array).

April 12th, 2007, 06:37 PM

wiesemann

Contributing User

Join Date: Apr 2007

Posts: 153

Time spent in forums: 14 h 29 m 35 sec
Reputation Power: 2

RE: MDB2 loadmodule extended

Nice to hear that it works now.

If the "->extended" thing isn't mentioned in the manual, then please report a bug.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: