Back To Programming / Scripting / Coding Forum

put query inside a function in php

  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Nov 14, 2006
  • Posts: 58
  • Loc: Chertsey, UK
  • Status: Offline

Post April 26th, 2010, 3:46 pm

Hi there trying to put a query inside a function not sure its possible to do this in php. Can do it in coldfusion.
Basically I want to call a recursive query that is selectable via some id.

Code: [ Select ]
function getmenu($menu_id){
    /* get the top most level menu */
    mysql_select_db($database_eggbox, $eggbox);
    $query_top_menu = "select * from menu where menu_parent_menu_id = $menu_id";
    $top_menu = mysql_query($query_top_menu, $eggbox) or die(mysql_error());
    $row_top_menu = mysql_fetch_assoc($top_menu);
    $totalRows_top_menu = mysql_num_rows($top_menu);

    /* loop and echo */

}

getmenu(0);
  1. function getmenu($menu_id){
  2.     /* get the top most level menu */
  3.     mysql_select_db($database_eggbox, $eggbox);
  4.     $query_top_menu = "select * from menu where menu_parent_menu_id = $menu_id";
  5.     $top_menu = mysql_query($query_top_menu, $eggbox) or die(mysql_error());
  6.     $row_top_menu = mysql_fetch_assoc($top_menu);
  7.     $totalRows_top_menu = mysql_num_rows($top_menu);
  9.     /* loop and echo */
  11. }
  13. getmenu(0);


Its telling me that I can't do this inside a function.

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in Library....

How would I be able to achieve this? Maybe in a class?

Any help thanks

Andi
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post April 26th, 2010, 3:46 pm

  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Joined: Feb 10, 2004
  • Posts: 13455
  • Loc: Florida
  • Status: Offline

Post April 26th, 2010, 3:52 pm

You need to use the "global" keyword to make the $database_eggbox and other relevant variables visible inside the function.

PHP Code: [ Select ]
function getmenu($menu_id)
{
  global $database_eggbox, $eggbox;
  // ...
}
  1. function getmenu($menu_id)
  2. {
  3.   global $database_eggbox, $eggbox;
  4.   // ...
  5. }


Or, pass the relevant variables as arguments in the function.

PHP Code: [ Select ]
function getmenu($menu_id, $database_eggbox, $eggbox){}
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Nov 14, 2006
  • Posts: 58
  • Loc: Chertsey, UK
  • Status: Offline

Post April 26th, 2010, 11:41 pm

Of course now.... Got it working...

Code: [ Select ]
    mysql_select_db($database_eggbox, $eggbox);
        
        
    

    
    function getmenu($menu_id){
        
        
        /* get the top most level menu */
        global $database_eggbox, $eggbox;
        $query_top_menu = "select * from menu where menu_parent_menu_id = $menu_id";
        $top_menu = mysql_query($query_top_menu, $eggbox) or die(mysql_error());
        $row_top_menu = mysql_fetch_assoc($top_menu);
        $totalRows_top_menu = mysql_num_rows($top_menu);
        
        
        
        do {
          echo $row_top_menu['menu_text'];
        } while ($row_top_menu = mysql_fetch_assoc($top_menu));

    }
  1.     mysql_select_db($database_eggbox, $eggbox);
  2.         
  3.         
  4.     
  6.     
  7.     function getmenu($menu_id){
  8.         
  9.         
  10.         /* get the top most level menu */
  11.         global $database_eggbox, $eggbox;
  12.         $query_top_menu = "select * from menu where menu_parent_menu_id = $menu_id";
  13.         $top_menu = mysql_query($query_top_menu, $eggbox) or die(mysql_error());
  14.         $row_top_menu = mysql_fetch_assoc($top_menu);
  15.         $totalRows_top_menu = mysql_num_rows($top_menu);
  16.         
  17.         
  18.         
  19.         do {
  20.           echo $row_top_menu['menu_text'];
  21.         } while ($row_top_menu = mysql_fetch_assoc($top_menu));
  23.     }


Just need a bit more code to get it working recursively now ;o)

Thanks for your help
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Joined: Feb 10, 2004
  • Posts: 13455
  • Loc: Florida
  • Status: Offline

Post April 27th, 2010, 8:47 am

Now that the question is answered, I should probably mention that using a query recursively isn't usually a good thing to do.

It looks like you're building a hierarchy, which can be done with one query and two loops, if you use an item_id for your array keys and references to turn a single-dimensional array into a virtual multi-dimensional array.

This is taken from another site so it's not going to match up with your code, but hopefully the concept here is easy to see. :)

PHP Code: [ Select ]
$category_lineage = array();
 
$result = $db->query('SELECT category_id, parent_id, label FROM ' . CATEGORIES_TABLE, MYSQLI_USE_RESULT);
while($row = $result->fetch_object())
{
   $row->sub_categories = array();
   $category_lineage[$row->category_id] = $row;
}
$result->close();
 
foreach($category_lineage as $key => $val)
{
   if($val->parent_id)
   {
      $category_lineage[$val->parent_id]->sub_categories[$key] =& $category_lineage[$key];
   }
}
  1. $category_lineage = array();
  2.  
  3. $result = $db->query('SELECT category_id, parent_id, label FROM ' . CATEGORIES_TABLE, MYSQLI_USE_RESULT);
  4. while($row = $result->fetch_object())
  5. {
  6.    $row->sub_categories = array();
  7.    $category_lineage[$row->category_id] = $row;
  8. }
  9. $result->close();
  10.  
  11. foreach($category_lineage as $key => $val)
  12. {
  13.    if($val->parent_id)
  14.    {
  15.       $category_lineage[$val->parent_id]->sub_categories[$key] =& $category_lineage[$key];
  16.    }
  17. }
Strong with this one, the sudo is.
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Nov 14, 2006
  • Posts: 58
  • Loc: Chertsey, UK
  • Status: Offline

Post April 27th, 2010, 10:35 am

Hi There when I meant recursive I meant like this.... ;o)

top level
sub level
sub sub level
sub level
top level

This works although I do not know if it is the most efficient way of doing it.


Code: [ Select ]

function getmenu($menu_level){
        
        /* get the top most level menu */
        global $database_eggbox, $eggbox;
        $query_top_menu = "select * from menu where menu_parent_menu_id = 0 order by menu_display_order";
        $top_menu = mysql_query($query_top_menu, $eggbox) or die(mysql_error());
        $row_top_menu = mysql_fetch_assoc($top_menu);
        $totalRows_top_menu = mysql_num_rows($top_menu);
    
        if ($menu_level <> 0) {
                            
            echo "<ul>";
                             
            do {
             
              echo "<li><a href='index.php?' title='opens in same window' target='_self' >" . $row_top_menu['menu_text'] . "</a>";
                $menuid = $row_top_menu['menu_id'];
                $query_has_children = "select * from menu where menu_parent_menu_id = $menuid order by menu_display_order";
                $has_children = mysql_query($query_has_children, $eggbox) or die(mysql_error());
                $row_has_children = mysql_fetch_assoc($has_children);
                $totalRows_has_children = mysql_num_rows($has_children);
                if($totalRows_has_children > 0){
                    
                    getchildren($menuid,0);     
             
                  } else {
                    echo "</li>";
                }
            } while ($row_top_menu = mysql_fetch_assoc($top_menu));
                
                
            echo "</ul>";
        
        } elseif ($menu_level == 0) {
                        
            echo "<ul>";
                             
            do {
             
              echo "<li><a href='index.php?' title='opens in same window' target='_self' >" . $row_top_menu['menu_text'] . "</a></li>";
            
            } while ($row_top_menu = mysql_fetch_assoc($top_menu));
            
            echo "</ul>";
        }

    } // End Function


    function getchildren ($menuid,$count) {
                    
        /* get the next level menu */
        global $database_eggbox, $eggbox;
        $query_child_menu = "select * from menu where menu_parent_menu_id = $menuid order by menu_display_order";
        $child_menu = mysql_query($query_child_menu, $eggbox) or die(mysql_error());
        $row_child_menu = mysql_fetch_assoc($child_menu);
        $totalRows_child_menu = mysql_num_rows($child_menu);      
                        
        
        do {
        
            if($count == 0) {
                echo "<ul>";
            }
        
            echo "<li><a href='index.php?' title='opens in same window' target='_self' >" . $row_child_menu['menu_text'] . "</a>";
            $menuidd = $row_child_menu['menu_id'];
            $query_has_childrens = "select * from menu where menu_parent_menu_id = $menuidd order by menu_display_order";
            $has_childrens = mysql_query($query_has_childrens, $eggbox) or die(mysql_error());
            $row_has_childrens = mysql_fetch_assoc($has_childrens);
            $totalRows_has_childrens = mysql_num_rows($has_childrens);
                
            if($totalRows_has_childrens > 0){
                    
                    getchildren($menuidd,0);
                
            } else {
                "</li>";
            }            
    
            if($count+1 == $totalRows_child_menu) {
                echo "</ul>";
            }
        
            $count += 1;        
        } while ($row_child_menu = mysql_fetch_assoc($child_menu));        
                        
    } // end function
  2. function getmenu($menu_level){
  3.         
  4.         /* get the top most level menu */
  5.         global $database_eggbox, $eggbox;
  6.         $query_top_menu = "select * from menu where menu_parent_menu_id = 0 order by menu_display_order";
  7.         $top_menu = mysql_query($query_top_menu, $eggbox) or die(mysql_error());
  8.         $row_top_menu = mysql_fetch_assoc($top_menu);
  9.         $totalRows_top_menu = mysql_num_rows($top_menu);
  10.     
  11.         if ($menu_level <> 0) {
  12.                             
  13.             echo "<ul>";
  14.                              
  15.             do {
  16.              
  17.               echo "<li><a href='index.php?' title='opens in same window' target='_self' >" . $row_top_menu['menu_text'] . "</a>";
  18.                 $menuid = $row_top_menu['menu_id'];
  19.                 $query_has_children = "select * from menu where menu_parent_menu_id = $menuid order by menu_display_order";
  20.                 $has_children = mysql_query($query_has_children, $eggbox) or die(mysql_error());
  21.                 $row_has_children = mysql_fetch_assoc($has_children);
  22.                 $totalRows_has_children = mysql_num_rows($has_children);
  23.                 if($totalRows_has_children > 0){
  24.                     
  25.                     getchildren($menuid,0);     
  26.              
  27.                   } else {
  28.                     echo "</li>";
  29.                 }
  30.             } while ($row_top_menu = mysql_fetch_assoc($top_menu));
  31.                 
  32.                 
  33.             echo "</ul>";
  34.         
  35.         } elseif ($menu_level == 0) {
  36.                         
  37.             echo "<ul>";
  38.                              
  39.             do {
  40.              
  41.               echo "<li><a href='index.php?' title='opens in same window' target='_self' >" . $row_top_menu['menu_text'] . "</a></li>";
  42.             
  43.             } while ($row_top_menu = mysql_fetch_assoc($top_menu));
  44.             
  45.             echo "</ul>";
  46.         }
  48.     } // End Function
  51.     function getchildren ($menuid,$count) {
  52.                     
  53.         /* get the next level menu */
  54.         global $database_eggbox, $eggbox;
  55.         $query_child_menu = "select * from menu where menu_parent_menu_id = $menuid order by menu_display_order";
  56.         $child_menu = mysql_query($query_child_menu, $eggbox) or die(mysql_error());
  57.         $row_child_menu = mysql_fetch_assoc($child_menu);
  58.         $totalRows_child_menu = mysql_num_rows($child_menu);      
  59.                         
  60.         
  61.         do {
  62.         
  63.             if($count == 0) {
  64.                 echo "<ul>";
  65.             }
  66.         
  67.             echo "<li><a href='index.php?' title='opens in same window' target='_self' >" . $row_child_menu['menu_text'] . "</a>";
  68.             $menuidd = $row_child_menu['menu_id'];
  69.             $query_has_childrens = "select * from menu where menu_parent_menu_id = $menuidd order by menu_display_order";
  70.             $has_childrens = mysql_query($query_has_childrens, $eggbox) or die(mysql_error());
  71.             $row_has_childrens = mysql_fetch_assoc($has_childrens);
  72.             $totalRows_has_childrens = mysql_num_rows($has_childrens);
  73.                 
  74.             if($totalRows_has_childrens > 0){
  75.                     
  76.                     getchildren($menuidd,0);
  77.                 
  78.             } else {
  79.                 "</li>";
  80.             }            
  81.     
  82.             if($count+1 == $totalRows_child_menu) {
  83.                 echo "</ul>";
  84.             }
  85.         
  86.             $count += 1;        
  87.         } while ($row_child_menu = mysql_fetch_assoc($child_menu));        
  88.                         
  89.     } // end function


Thanks for your insight though...
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Joined: Feb 10, 2004
  • Posts: 13455
  • Loc: Florida
  • Status: Offline

Post April 27th, 2010, 11:38 am

Yeah, I see what you're doing. You seem to be on some sort of deadline though, meaning you don't have time to rework anything, so I wont waste either of our time talking into one ear and out the other. :)
Strong with this one, the sudo is.
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Nov 14, 2006
  • Posts: 58
  • Loc: Chertsey, UK
  • Status: Offline

Post April 28th, 2010, 12:43 pm

NO not on a deadline just trying to get things to work nicely...
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Joined: Feb 10, 2004
  • Posts: 13455
  • Loc: Florida
  • Status: Offline

Post April 28th, 2010, 2:29 pm

Why are you brushing what I have to say off ?

Quote:
Thanks for your insight though...


What are the ellipsis in to substitute for ?

Quote:
Thanks for your insight though, [you moron]

Quote:
Thanks for your insight though, [but I don't understand something]

Quote:
Thanks for your insight though, [lets see how long I can troll you]


What are your intentions !
Strong with this one, the sudo is.
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Nov 14, 2006
  • Posts: 58
  • Loc: Chertsey, UK
  • Status: Offline

Post April 29th, 2010, 1:34 am

Hi there,

I'm a coldsufion developer so my php skills have become a bit ropey I'm afraid...
My original question was how to put a query inside a function. You kindly showed me how to do that so thanks.

Quote:
Why are you brushing what I have to say off ?

Sorry I'm not brushing off what you said. I was mearly thanking you. I can see what you were doing and that is helpful as I may try that..

Quote:
What are the ellipsis in to substitute for ?

I'll post the whole code up later so you can see. Don't have it with me right now, and I'm still working on it... I now have to make the menu collapsable and expandable which is the next tricky thing.

I am the moron yes... :O)
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Nov 14, 2006
  • Posts: 58
  • Loc: Chertsey, UK
  • Status: Offline

Post May 1st, 2010, 2:24 am

Ok Baby Cakes I promised you the code but the broadband went down. But here is everything finally... Fully recursive collapsable menu system. If you think I can improve on it then please let me know as I still think there is a better way to do it. My php skills are still pretty ropey as I come from a CF background... but ho hum here it is...

Code: [ Select ]
mysql_select_db($database_eggbox, $eggbox);

/* get the home page at start*/
$query_default_url = "select * from menu where menu_text = 'Home' order by menu_display_order";
$default_url = mysql_query($query_default_url, $eggbox) or die(mysql_error());
$row_default_url = mysql_fetch_assoc($default_url);
$totalRows_default_url = mysql_num_rows($default_url);

if (isset($_GET['menu_id'])) {
    $urlmenu_id = $_GET['menu_id'];
} else {
    $urlmenu_id = $row_default_url['menu_id'];
}



///////////////////////////////////////////////////////////////
/////////////////////* functions */////////////////////////////
///////////////////////////////////////////////////////////////

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
 $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

 $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 switch ($theType) {
  case "text":
   $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
   break;  
  case "long":
  case "int":
   $theValue = ($theValue != "") ? intval($theValue) : "NULL";
   break;
  case "double":
   $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
   break;
  case "date":
   $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
   break;
  case "defined":
   $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
   break;
 }
 return $theValue;
}
}

/* get breadcrumb function */
function getbreadcrumb($arraycount,$parentmenuid){
    
    /* get the current level menu */
    global $database_eggbox, $eggbox, $urlmenu_id, $array_menu;
    $query_last_breadcrumb = "select * from menu where menu_id = $parentmenuid order by menu_display_order";
    $last_breadcrumb = mysql_query($query_last_breadcrumb, $eggbox) or die(mysql_error());
    $row_last_breadcrumb = mysql_fetch_assoc($last_breadcrumb);
    $totalRows_last_breadcrumb = mysql_num_rows($last_breadcrumb);
    
    $array_menu[$arraycount][0] = $row_last_breadcrumb['menu_id'];
    $array_menu[$arraycount][1] = $row_last_breadcrumb['page_id'];
    $array_menu[$arraycount][2] = $row_last_breadcrumb['menu_text'];
    $array_menu[$arraycount][3] = $row_last_breadcrumb['menu_parent_menu_id'];
    
    if($array_menu[$arraycount][0] != "") {
        getbreadcrumb($arraycount+1,$array_menu[$arraycount][3]);
    }
    
    if($arraycount == count){
        echo $array_menu[$arraycount][2];
    } else {
        $menuid = $array_menu[$arraycount][0];
        echo "<li><a href='index.php?menu_id=$menuid' title='opens in same window' target='_self' >" . $array_menu[$arraycount][2] . "</a> : </li>";
    }
    mysql_free_result($last_breadcrumb);
} // end function


/* get menu functions */
function getmenu($menu_level,$menuid){
        
    /* get the top most level menu */
    global $database_eggbox, $eggbox, $urlmenu_id, $array_menu;
    $query_top_menu = "select * from menu where menu_parent_menu_id = $menuid and menu_display = 1 order by menu_display_order";
    $top_menu = mysql_query($query_top_menu, $eggbox) or die(mysql_error());
    $row_top_menu = mysql_fetch_assoc($top_menu);
    $totalRows_top_menu = mysql_num_rows($top_menu);
    
    
    if ($menu_level == 0) { // Top menu for nav bar only
                    
        echo "<ul>";
                         
        do {
              $menuid = $row_top_menu['menu_id'];
            if($urlmenu_id == $menuid) {
                $selectedclass = "class='selected'";
            } else {
                $selectedclass = "";
            }
            
              if($row_top_menu['menu_alt_location'] != "") {
                // Alternative location like google
                  if(substr($row_top_menu['menu_alt_location'],0,4) == "http") { $menuurl = $row_top_menu['menu_alt_location']; } else { $menuurl = "http://" . $row_top_menu['menu_alt_location'];}
                  $title = "opens in new window";
                $target = "_blank";                
              } else {
                  // site menu
                $menuurl = "index.php?menu_id=$menuid";
                  $title = "opens in same window";
                $target = "_self";
            } // End if
            
            echo "<li><a href='$menuurl' title='$target' target='$target' $selectedclass >" . $row_top_menu['menu_text'] . "</a></li>";
            
        } while ($row_top_menu = mysql_fetch_assoc($top_menu));
        
        echo "</ul>";
    
    
    } elseif ($menu_level == 1) {
            
            if($totalRows_top_menu > 0) { // full side menu and you don't want a top menu
                    
                echo "<ul>";
                $count = 0;    
                
                do {
                  $menuid = $row_top_menu['menu_id'];
                  if($urlmenu_id == $menuid) {
                        $selectedclass = "class='selected'";
                    } else {
                        $selectedclass = "";
                    }
                 
                  if($row_top_menu['menu_alt_location'] != "") {
                        // Alternative location like google
                        if(substr($row_top_menu['menu_alt_location'],0,4) == "http") { $menuurl = $row_top_menu['menu_alt_location']; } else { $menuurl = "http://" . $row_top_menu['menu_alt_location'];}
                        $title = "opens in new window";
                        $target = "_blank";                
                    } else {
                        // Site menu
                        $menuurl = "index.php?menu_id=$menuid";
                        $title = "opens in same window";
                        $target = "_self";
                    } // End if
                 
                  echo "<li><a href='$menuurl' title='$title' target='$target' >" . $row_top_menu['menu_text'] . "</a>";
                    
                    $query_has_children = "select * from menu where menu_parent_menu_id = $menuid and menu_display = 1 order by menu_display_order";
                    $has_children = mysql_query($query_has_children, $eggbox) or die(mysql_error());
                    $row_has_children = mysql_fetch_assoc($has_children);
                    $totalRows_has_children = mysql_num_rows($has_children);
                    
                    if($totalRows_has_children > 0 && $array_menu[sizeof($array_menu)-2][0] == $menuid){
                        getchildren($menuid,0,3);
                        echo "</li>";      
                    } else {
                        echo "</li>";
                    }
                    
                    $count += 1;        
                } while ($row_top_menu = mysql_fetch_assoc($top_menu));
                
                echo "</ul>";
                
                
            } // End if
    
            mysql_free_result($has_children);
    } elseif ($menu_level == 2) { // Second level menu based on top level menu
        
        if($totalRows_top_menu > 0) {
                    
                $count = 0;    
                
                do {
                      $menuid = $row_top_menu['menu_id'];
                      $query_has_children = "select * from menu where menu_parent_menu_id = $menuid and menu_display = 1 order by menu_display_order";
                    $has_children = mysql_query($query_has_children, $eggbox) or die(mysql_error());
                    $row_has_children = mysql_fetch_assoc($has_children);
                    $totalRows_has_children = mysql_num_rows($has_children);
                    
                    if($totalRows_has_children > 0 && $array_menu[sizeof($array_menu)-2][0] == $menuid){
                        getchildren($menuid,0,3);
                        
                    }
                    
                        
                    $count += 1;        
                } while ($row_top_menu = mysql_fetch_assoc($top_menu));
                        
        } // End if
        mysql_free_result($has_children);
    } // End if function for menu levels        
    
    mysql_free_result($top_menu);
} // End Function


function getchildren ($menuid,$count,$count_level) {
                
    /* get the next level menu */
    global $database_eggbox, $eggbox, $urlmenu_id, $array_menu;
    $query_child_menu = "select * from menu where menu_parent_menu_id = $menuid and menu_display = 1 order by menu_display_order";
    $child_menu = mysql_query($query_child_menu, $eggbox) or die(mysql_error());
    $row_child_menu = mysql_fetch_assoc($child_menu);
    $totalRows_child_menu = mysql_num_rows($child_menu);      
        
    
    do {
        
        if($count == 0) {
            echo "<ul>";
        }
        
        $menuidd = $row_child_menu['menu_id'];
        if($urlmenu_id == $menuidd) {
            $selectedclass = "class='selected'";
        } else {
            $selectedclass = "";
        }
        
        if($row_child_menu['menu_alt_location'] != "") {
            // Alternative location like google
            if(substr($row_child_menu['menu_alt_location'],0,4) == "http") { $menuurl = $row_child_menu['menu_alt_location']; } else { $menuurl = "http://" . $row_child_menu['menu_alt_location'];}
            $title = "opens in new window";
            $target = "_blank";                
        } else {
            // site menu
            $menuurl = "index.php?menu_id=$menuidd";
            $title = "opens in same window";
            $target = "_self";
        } // End if
        
        echo "<li><a href='$menuurl' title='$title' target='$target' $selectedclass >" . $row_child_menu['menu_text'] . "</a>";
        
        $query_has_childrens = "select * from menu where menu_parent_menu_id = $menuidd and menu_display = 1 order by menu_display_order";
        $has_childrens = mysql_query($query_has_childrens, $eggbox) or die(mysql_error());
        $row_has_childrens = mysql_fetch_assoc($has_childrens);
        $totalRows_has_childrens = mysql_num_rows($has_childrens);
            
        if($totalRows_has_childrens > 0 && $array_menu[sizeof($array_menu)-$count_level][0] == $menuidd){
                
                getchildren($menuidd,0,$count_level+1);
                echo "</li>";
        } else {
                echo "</li>";
        }
                
        if($count+1 == $totalRows_child_menu) {
            echo "</ul>";
        }
    
        $count += 1;
                
    } while ($row_child_menu = mysql_fetch_assoc($child_menu));
    mysql_free_result($has_childrens);
    mysql_free_result($child_menu);
} // end function


/* get content */
$query_page_info = "select menu_id, pages.* from pages inner join menu on pages.page_id = menu.page_id where menu.menu_id = $urlmenu_id";
$page_info = mysql_query($query_page_info, $eggbox) or die(mysql_error());
$row_page_info = mysql_fetch_assoc($page_info);
$totalRows_page_info = mysql_num_rows($page_info);

function getcontent($content){
    global $row_page_info;
    $content = $row_page_info[$content];
    return $content;
} // End function

function getcolumns() {
    global $database_eggbox, $eggbox, $row_page_info, $urlmenu_id;
        
    $query_top_top_menu = "select * from menu where menu_parent_menu_id = $urlmenu_id and menu_display = 1 order by menu_display_order";
    $top_top_menu = mysql_query($query_top_top_menu, $eggbox) or die(mysql_error());
    $row_top_top_menu = mysql_fetch_assoc($top_top_menu);
    $totalRows_top_top_menu = mysql_num_rows($top_top_menu);
    
    if($row_page_info['page_lhs_content'] == "" && $row_page_info['page_rhs_content'] == "" && $totalRows_top_top_menu == 0) {
        $collhsrhs = "-noLHSRHS";
    } elseif($row_page_info['page_rhs_content'] == "" ) {
        $collhsrhs = "-noRHS";
    } elseif ($row_page_info['page_lhs_content'] == "" || $row_top_top_menu == 0) {
        $collhsrhs = "-noLHS";
    } else {
        $collhsrhs = "";
    }
    
    return $collhsrhs;
}




mysql_free_result($page_info);
  1. mysql_select_db($database_eggbox, $eggbox);
  3. /* get the home page at start*/
  4. $query_default_url = "select * from menu where menu_text = 'Home' order by menu_display_order";
  5. $default_url = mysql_query($query_default_url, $eggbox) or die(mysql_error());
  6. $row_default_url = mysql_fetch_assoc($default_url);
  7. $totalRows_default_url = mysql_num_rows($default_url);
  9. if (isset($_GET['menu_id'])) {
  10.     $urlmenu_id = $_GET['menu_id'];
  11. } else {
  12.     $urlmenu_id = $row_default_url['menu_id'];
  13. }
  17. ///////////////////////////////////////////////////////////////
  18. /////////////////////* functions */////////////////////////////
  19. ///////////////////////////////////////////////////////////////
  21. if (!function_exists("GetSQLValueString")) {
  22. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
  23. {
  24.  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  26.  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  28.  switch ($theType) {
  29.   case "text":
  30.    $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  31.    break;  
  32.   case "long":
  33.   case "int":
  34.    $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  35.    break;
  36.   case "double":
  37.    $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
  38.    break;
  39.   case "date":
  40.    $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  41.    break;
  42.   case "defined":
  43.    $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  44.    break;
  45.  }
  46.  return $theValue;
  47. }
  48. }
  50. /* get breadcrumb function */
  51. function getbreadcrumb($arraycount,$parentmenuid){
  52.     
  53.     /* get the current level menu */
  54.     global $database_eggbox, $eggbox, $urlmenu_id, $array_menu;
  55.     $query_last_breadcrumb = "select * from menu where menu_id = $parentmenuid order by menu_display_order";
  56.     $last_breadcrumb = mysql_query($query_last_breadcrumb, $eggbox) or die(mysql_error());
  57.     $row_last_breadcrumb = mysql_fetch_assoc($last_breadcrumb);
  58.     $totalRows_last_breadcrumb = mysql_num_rows($last_breadcrumb);
  59.     
  60.     $array_menu[$arraycount][0] = $row_last_breadcrumb['menu_id'];
  61.     $array_menu[$arraycount][1] = $row_last_breadcrumb['page_id'];
  62.     $array_menu[$arraycount][2] = $row_last_breadcrumb['menu_text'];
  63.     $array_menu[$arraycount][3] = $row_last_breadcrumb['menu_parent_menu_id'];
  64.     
  65.     if($array_menu[$arraycount][0] != "") {
  66.         getbreadcrumb($arraycount+1,$array_menu[$arraycount][3]);
  67.     }
  68.     
  69.     if($arraycount == count){
  70.         echo $array_menu[$arraycount][2];
  71.     } else {
  72.         $menuid = $array_menu[$arraycount][0];
  73.         echo "<li><a href='index.php?menu_id=$menuid' title='opens in same window' target='_self' >" . $array_menu[$arraycount][2] . "</a> : </li>";
  74.     }
  75.     mysql_free_result($last_breadcrumb);
  76. } // end function
  79. /* get menu functions */
  80. function getmenu($menu_level,$menuid){
  81.         
  82.     /* get the top most level menu */
  83.     global $database_eggbox, $eggbox, $urlmenu_id, $array_menu;
  84.     $query_top_menu = "select * from menu where menu_parent_menu_id = $menuid and menu_display = 1 order by menu_display_order";
  85.     $top_menu = mysql_query($query_top_menu, $eggbox) or die(mysql_error());
  86.     $row_top_menu = mysql_fetch_assoc($top_menu);
  87.     $totalRows_top_menu = mysql_num_rows($top_menu);
  88.     
  89.     
  90.     if ($menu_level == 0) { // Top menu for nav bar only
  91.                     
  92.         echo "<ul>";
  93.                          
  94.         do {
  95.               $menuid = $row_top_menu['menu_id'];
  96.             if($urlmenu_id == $menuid) {
  97.                 $selectedclass = "class='selected'";
  98.             } else {
  99.                 $selectedclass = "";
  100.             }
  101.             
  102.               if($row_top_menu['menu_alt_location'] != "") {
  103.                 // Alternative location like google
  104.                   if(substr($row_top_menu['menu_alt_location'],0,4) == "http") { $menuurl = $row_top_menu['menu_alt_location']; } else { $menuurl = "http://" . $row_top_menu['menu_alt_location'];}
  105.                   $title = "opens in new window";
  106.                 $target = "_blank";                
  107.               } else {
  108.                   // site menu
  109.                 $menuurl = "index.php?menu_id=$menuid";
  110.                   $title = "opens in same window";
  111.                 $target = "_self";
  112.             } // End if
  113.             
  114.             echo "<li><a href='$menuurl' title='$target' target='$target' $selectedclass >" . $row_top_menu['menu_text'] . "</a></li>";
  115.             
  116.         } while ($row_top_menu = mysql_fetch_assoc($top_menu));
  117.         
  118.         echo "</ul>";
  119.     
  120.     
  121.     } elseif ($menu_level == 1) {
  122.             
  123.             if($totalRows_top_menu > 0) { // full side menu and you don't want a top menu
  124.                     
  125.                 echo "<ul>";
  126.                 $count = 0;    
  127.                 
  128.                 do {
  129.                   $menuid = $row_top_menu['menu_id'];
  130.                   if($urlmenu_id == $menuid) {
  131.                         $selectedclass = "class='selected'";
  132.                     } else {
  133.                         $selectedclass = "";
  134.                     }
  135.                  
  136.                   if($row_top_menu['menu_alt_location'] != "") {
  137.                         // Alternative location like google
  138.                         if(substr($row_top_menu['menu_alt_location'],0,4) == "http") { $menuurl = $row_top_menu['menu_alt_location']; } else { $menuurl = "http://" . $row_top_menu['menu_alt_location'];}
  139.                         $title = "opens in new window";
  140.                         $target = "_blank";                
  141.                     } else {
  142.                         // Site menu
  143.                         $menuurl = "index.php?menu_id=$menuid";
  144.                         $title = "opens in same window";
  145.                         $target = "_self";
  146.                     } // End if
  147.                  
  148.                   echo "<li><a href='$menuurl' title='$title' target='$target' >" . $row_top_menu['menu_text'] . "</a>";
  149.                     
  150.                     $query_has_children = "select * from menu where menu_parent_menu_id = $menuid and menu_display = 1 order by menu_display_order";
  151.                     $has_children = mysql_query($query_has_children, $eggbox) or die(mysql_error());
  152.                     $row_has_children = mysql_fetch_assoc($has_children);
  153.                     $totalRows_has_children = mysql_num_rows($has_children);
  154.                     
  155.                     if($totalRows_has_children > 0 && $array_menu[sizeof($array_menu)-2][0] == $menuid){
  156.                         getchildren($menuid,0,3);
  157.                         echo "</li>";      
  158.                     } else {
  159.                         echo "</li>";
  160.                     }
  161.                     
  162.                     $count += 1;        
  163.                 } while ($row_top_menu = mysql_fetch_assoc($top_menu));
  164.                 
  165.                 echo "</ul>";
  166.                 
  167.                 
  168.             } // End if
  169.     
  170.             mysql_free_result($has_children);
  171.     } elseif ($menu_level == 2) { // Second level menu based on top level menu
  172.         
  173.         if($totalRows_top_menu > 0) {
  174.                     
  175.                 $count = 0;    
  176.                 
  177.                 do {
  178.                       $menuid = $row_top_menu['menu_id'];
  179.                       $query_has_children = "select * from menu where menu_parent_menu_id = $menuid and menu_display = 1 order by menu_display_order";
  180.                     $has_children = mysql_query($query_has_children, $eggbox) or die(mysql_error());
  181.                     $row_has_children = mysql_fetch_assoc($has_children);
  182.                     $totalRows_has_children = mysql_num_rows($has_children);
  183.                     
  184.                     if($totalRows_has_children > 0 && $array_menu[sizeof($array_menu)-2][0] == $menuid){
  185.                         getchildren($menuid,0,3);
  186.                         
  187.                     }
  188.                     
  189.                         
  190.                     $count += 1;        
  191.                 } while ($row_top_menu = mysql_fetch_assoc($top_menu));
  192.                         
  193.         } // End if
  194.         mysql_free_result($has_children);
  195.     } // End if function for menu levels        
  196.     
  197.     mysql_free_result($top_menu);
  198. } // End Function
  201. function getchildren ($menuid,$count,$count_level) {
  202.                 
  203.     /* get the next level menu */
  204.     global $database_eggbox, $eggbox, $urlmenu_id, $array_menu;
  205.     $query_child_menu = "select * from menu where menu_parent_menu_id = $menuid and menu_display = 1 order by menu_display_order";
  206.     $child_menu = mysql_query($query_child_menu, $eggbox) or die(mysql_error());
  207.     $row_child_menu = mysql_fetch_assoc($child_menu);
  208.     $totalRows_child_menu = mysql_num_rows($child_menu);      
  209.         
  210.     
  211.     do {
  212.         
  213.         if($count == 0) {
  214.             echo "<ul>";
  215.         }
  216.         
  217.         $menuidd = $row_child_menu['menu_id'];
  218.         if($urlmenu_id == $menuidd) {
  219.             $selectedclass = "class='selected'";
  220.         } else {
  221.             $selectedclass = "";
  222.         }
  223.         
  224.         if($row_child_menu['menu_alt_location'] != "") {
  225.             // Alternative location like google
  226.             if(substr($row_child_menu['menu_alt_location'],0,4) == "http") { $menuurl = $row_child_menu['menu_alt_location']; } else { $menuurl = "http://" . $row_child_menu['menu_alt_location'];}
  227.             $title = "opens in new window";
  228.             $target = "_blank";                
  229.         } else {
  230.             // site menu
  231.             $menuurl = "index.php?menu_id=$menuidd";
  232.             $title = "opens in same window";
  233.             $target = "_self";
  234.         } // End if
  235.         
  236.         echo "<li><a href='$menuurl' title='$title' target='$target' $selectedclass >" . $row_child_menu['menu_text'] . "</a>";
  237.         
  238.         $query_has_childrens = "select * from menu where menu_parent_menu_id = $menuidd and menu_display = 1 order by menu_display_order";
  239.         $has_childrens = mysql_query($query_has_childrens, $eggbox) or die(mysql_error());
  240.         $row_has_childrens = mysql_fetch_assoc($has_childrens);
  241.         $totalRows_has_childrens = mysql_num_rows($has_childrens);
  242.             
  243.         if($totalRows_has_childrens > 0 && $array_menu[sizeof($array_menu)-$count_level][0] == $menuidd){
  244.                 
  245.                 getchildren($menuidd,0,$count_level+1);
  246.                 echo "</li>";
  247.         } else {
  248.                 echo "</li>";
  249.         }
  250.                 
  251.         if($count+1 == $totalRows_child_menu) {
  252.             echo "</ul>";
  253.         }
  254.     
  255.         $count += 1;
  256.                 
  257.     } while ($row_child_menu = mysql_fetch_assoc($child_menu));
  258.     mysql_free_result($has_childrens);
  259.     mysql_free_result($child_menu);
  260. } // end function
  263. /* get content */
  264. $query_page_info = "select menu_id, pages.* from pages inner join menu on pages.page_id = menu.page_id where menu.menu_id = $urlmenu_id";
  265. $page_info = mysql_query($query_page_info, $eggbox) or die(mysql_error());
  266. $row_page_info = mysql_fetch_assoc($page_info);
  267. $totalRows_page_info = mysql_num_rows($page_info);
  269. function getcontent($content){
  270.     global $row_page_info;
  271.     $content = $row_page_info[$content];
  272.     return $content;
  273. } // End function
  275. function getcolumns() {
  276.     global $database_eggbox, $eggbox, $row_page_info, $urlmenu_id;
  277.         
  278.     $query_top_top_menu = "select * from menu where menu_parent_menu_id = $urlmenu_id and menu_display = 1 order by menu_display_order";
  279.     $top_top_menu = mysql_query($query_top_top_menu, $eggbox) or die(mysql_error());
  280.     $row_top_top_menu = mysql_fetch_assoc($top_top_menu);
  281.     $totalRows_top_top_menu = mysql_num_rows($top_top_menu);
  282.     
  283.     if($row_page_info['page_lhs_content'] == "" && $row_page_info['page_rhs_content'] == "" && $totalRows_top_top_menu == 0) {
  284.         $collhsrhs = "-noLHSRHS";
  285.     } elseif($row_page_info['page_rhs_content'] == "" ) {
  286.         $collhsrhs = "-noRHS";
  287.     } elseif ($row_page_info['page_lhs_content'] == "" || $row_top_top_menu == 0) {
  288.         $collhsrhs = "-noLHS";
  289.     } else {
  290.         $collhsrhs = "";
  291.     }
  292.     
  293.     return $collhsrhs;
  294. }
  299. mysql_free_result($page_info);

Page 1 of 1

Post Information

  • Total Posts in this topic: 10 posts
  • Users browsing this forum: No registered users and 180 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.