Retour à Forum de programmation

mis requête à l'intérieur d'une fonction en PHP

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

Message Avril 26th, 2010, 3:46 pm

Salut à essayer de mettre une requête dans une fonction ne sais pas son possible de le faire en PHP. Peut-on faire dans ColdFusion.
Fondamentalement, je veux appeler une requête récursive qui est sélectionnable via une pièce d'identité.

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);


Sa me disant que je ne peux pas faire cela dans une fonction.

Avertissement: mysql_select_db (): argument fourni n'est pas une ressource valide MySQL-Link Library....

Comment pourrais-je y parvenir? Peut-être dans une classe?

Toute aide Merci

Andi
  • Anonymous
  • Bot
  • No Avatar
  • Inscription: 25 Feb 2008
  • Messages: ?
  • Loc: Ozzuland
  • Status: Online

Message Avril 26th, 2010, 3:46 pm

  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Inscription: Fév 10, 2004
  • Messages: 13455
  • Loc: Florida
  • Status: Offline

Message Avril 26th, 2010, 3:52 pm

Vous devez utiliser le "global" mot-clé pour rendre le database_eggbox $ et d'autres variables pertinentes visible à l'intérieur de la fonction.

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


Ou bien, passez les variables pertinentes comme arguments dans la fonction.

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

Message Avril 26th, 2010, 11:41 pm

Bien sûr, maintenant.... Got it travail...

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.     }


Juste besoin d'un peu plus de code pour faire fonctionner de manière récursive maintenant; o)

Merci pour votre aide
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Inscription: Fév 10, 2004
  • Messages: 13455
  • Loc: Florida
  • Status: Offline

Message Avril 27th, 2010, 8:47 am

Maintenant que la question est résolue, je devrais probablement mentionner que l'aide d'une requête récursive est généralement pas une bonne chose à faire.

Il semble que vous êtes la construction d'une hiérarchie, ce qui peut être fait avec une requête et deux boucles, si vous utilisez un item_id pour vos clés du tableau et des références à son tour un tableau à une dimension dans un tableau virtuel multi-dimensionnelle.

Ceci est pris d'un autre site si sa ne va pas correspondre avec votre code, mais j'espère que le concept est facile à voir. :)

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
  • Inscription: Nov 14, 2006
  • Messages: 58
  • Loc: Chertsey, UK
  • Status: Offline

Message Avril 27th, 2010, 10:35 am

Salut là quand je voulais dire récursif que je voulais dire comme ceci.... ; O)

de haut niveau
niveau sous-
sous sous niveau
niveau sous-
de haut niveau

Cela fonctionne même si je ne sais pas si c'est le moyen le plus efficace de le faire.


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


Merci de votre compréhension si...
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Inscription: Fév 10, 2004
  • Messages: 13455
  • Loc: Florida
  • Status: Offline

Message Avril 27th, 2010, 11:38 am

Ouais, je vois ce que vous faites. Vous semblez être sur une sorte de délai mais, ce qui signifie que vous n'avez pas le temps de retravailler rien, alors je ne vais pas perdre une ou l'autre de notre temps à parler dans une oreille et sort par l'autre. :)
Strong with this one, the sudo is.
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Inscription: Nov 14, 2006
  • Messages: 58
  • Loc: Chertsey, UK
  • Status: Offline

Message Avril 28th, 2010, 12:43 pm

Non pas sur un délai juste essayer de faire les choses à travailler bien...
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Inscription: Fév 10, 2004
  • Messages: 13455
  • Loc: Florida
  • Status: Offline

Message Avril 28th, 2010, 2:29 pm

Pourquoi êtes-vous brosser ce que j'ai à dire hors?

Quote:
Merci de votre compréhension si...


Quels sont les points de suspension pour remplacer?

Quote:
Merci de votre compréhension si, [crétin]

Quote:
Merci de votre compréhension bien, [mais je ne comprends pas quelque chose]

Quote:
Merci de votre compréhension si, [permet de voir combien de temps je peux vous troll]


Quelles sont vos intentions!
Strong with this one, the sudo is.
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Inscription: Nov 14, 2006
  • Messages: 58
  • Loc: Chertsey, UK
  • Status: Offline

Message Avril 29th, 2010, 1:34 am

Salut à tous,

Im un développeur coldsufion si mes compétences PHP sont devenus un peu ropey Im peur...
Ma première question était de savoir comment mettre une requête dans une fonction. Vous avez bien voulu me montrait comment faire alors Merci.

Quote:
Pourquoi êtes-vous brosser ce que j'ai à dire hors?

Désolé Im pas le brossage de ce que vous dites. J'étais mearly vous remercier. Je vois ce que vous faisiez ce qui est utile que je peut essayer ..

Quote:
Quels sont les points de suspension pour remplacer?

Ill après l'ensemble du code plus tard si vous pouvez le voir. Ne pas l'avoir avec moi en ce moment, et Im travaille toujours...J'ai maintenant de faire le menu rétractable et extensible qui est la prochaine chose délicate.

Je suis le crétin oui...: O)
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Inscription: Nov 14, 2006
  • Messages: 58
  • Loc: Chertsey, UK
  • Status: Offline

Message Mai 1st, 2010, 2:24 am

Ok Baby Cakes je vous ai promis le code, mais le haut débit a diminué. Mais voici tout ce que finalement...Tout système récursif menu pliant. Si vous pensez que je peux l'améliorer alors s'il vous plaît faites le moi savoir que je pense toujours qu'il ya une meilleure façon de le faire. Mes compétences en PHP sont encore assez ropey que je viens d'un milieu FC...mais ho hum c'est ici...

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 sur 1

Afficher de l'information

  • Total des messages de ce sujet: 10 messages
  • Utilisateurs parcourant ce forum: Aucun utilisateur enregistré et 133 invités
  • Vous ne pouvez pas poster de nouveaux sujets
  • Vous ne pouvez pas répondre aux sujets
  • Vous ne pouvez pas éditer vos messages
  • Vous ne pouvez pas supprimer vos messages
  • Vous ne pouvez pas joindre des fichiers
 
 

© 2011 Unmelted, LLC. Ozzu® est une marque déposée de Unmelted, LLC