how to access adodb object in recursive function of php

[neovantage]

Hi Geeks,
I am using adodb for accessing my records from MYSQL Database.

I define an object of adodb "$db" which is used for executing queries in my configuration file which is accessible in each and every page of the application.

Now when i try to access $db object in a function it says

Fatal error: Call to a member function Execute() on a non-object

I try to google my problem. There i find a solution that i must pass the adodb object $db in that function. As my function is recursive for getting categories from category table then i need to call the function again if it has child in it. Now again when i tried to pass that $db object in my function recursive function it behave abnormally. The recursive function getting the reference of that adodb object not the actual object. so how can i pass that object again in my recursive function.

Here is code of my function.

Function calling

<div class="suckerdiv">
    <ul id="suckertree1">
    <?php createMenu(0, $db);?>
    </ul>
</div>
 

Recursive function

<?php
function createMenu($parId, &$db){
    $q="select cat_id, parent_id, cat_name from ".CATEGORY." where parent_id='$parId'";
    $rs = $db->Execute($q);
    if($rs->RecordCount()>0){
        while(!$rs->EOF){
            $q="select cat_id, cat_name from ".CATEGORY." where parent_id=".$rs->fields('cat_id')."";
            $rs = $db->Execute($q);
            $noRows=$rs->RecordCount();
            if($noRows > 0){
                ?>
                <li><a href="products/<?php echo $rs->fields('cat_id');?>"><?php echo $rs->fields('cat_name');?></a>
                    <ul>
                       <?php createMenu($row_cat['cat_id'],$db);?>
                    </ul>
                </li>
            <?php }else{?>
                <li><a href="products/<?php echo $rs->fields('cat_id');?>"><?php echo $rs->fields('cat_name');?></a></li><? 
            }
        }
    }//end while
}?>
 

[neovantage]

I have fixed it. The problem was when i call the function again in recursion i am passing parameter $db which must be &$db.

Secondly i was not fetching the record properly. The exact format is

<?php
function createMenu($parId, &$db){
    $q="select cat_id, parent_id, cat_name from ".CATEGORY." where parent_id='$parId'";
    $rs = $db->Execute($q);
    if($rs->RecordCount()>0){
        while(!$rs->EOF){
            $q_s="select cat_id from ".CATEGORY." where parent_id='".$rs->fields('cat_id')."'";
            $rsTotal = $db->Execute($q_s);
            $noRows = $rsTotal->RecordCount();
            if($noRows > 0){
            ?>
            <li><a href="products/<?php echo $rs->fields('cat_id');?>"><?php echo $rs->fields('cat_name');?></a>
                <ul><?php createMenu($rs->fields('cat_id'),&$db);?></ul>
            </li>
            <?
            }else{
                echo '<li><a href="products/'.$rs->fields('cat_id').'">'.$rs->fields('cat_name').'</a></li>';
            }
            $rs->MoveNext();
        }
    }//end while
}?>
 

I am posting my exact code that it may be helpful for those who want to use recursive function with adodb object.

Thanks

[Dormilich]

you can optimise your code by using Prepared Statements. that means that you can create one query and pass this query around (not the ADOdb base object) instead of creating the same query over and over again.