Volver al Programación / Codificación foro

puesto de consulta dentro de una función en php

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

Nota Abril 26th, 2010, 3:46 pm

Hola tratando de poner una consulta dentro de una función no está seguro de su posible hacer esto en php. ¿Puede hacerlo en ColdFusion.
Básicamente quiero llamar a una consulta recursiva que se puede seleccionar a través de un documento de identidad.

Código: [ 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);


Su diciéndome que no puedo hacer esto dentro de una función.

Advertencia: mysql_select_db (): suministrado no es argumento válido un recurso de MySQL-Link en la Biblioteca....

¿Cómo voy a ser capaz de lograr esto? Tal vez en una clase?

Cualquier ayuda, gracias

Andi
  • Anonymous
  • Bot
  • No Avatar
  • Registrado: 25 Feb 2008
  • Mensajes: ?
  • Loc: Ozzuland
  • Status: Online

Nota Abril 26th, 2010, 3:46 pm

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

Nota Abril 26th, 2010, 3:52 pm

Usted necesidad de utilizar el "global" palabra clave para que el database_eggbox $ y otras variables relevantes visibles dentro de la función.

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


O bien, pasar las variables relevantes como argumentos en la función.

PHP Código: [ Select ]
function getmenu($menu_id, $database_eggbox, $eggbox){}
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Registrado: Nov 14, 2006
  • Mensajes: 58
  • Loc: Chertsey, UK
  • Status: Offline

Nota Abril 26th, 2010, 11:41 pm

Por supuesto, ahora.... Entendido de trabajo...

Código: [ 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.     }


Sólo necesito un poco más el código para que funcione de forma recursiva ahora; o)

Gracias por su ayuda
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Registrado: Feb 10, 2004
  • Mensajes: 13455
  • Loc: Florida
  • Status: Offline

Nota Abril 27th, 2010, 8:47 am

Ahora que la pregunta se responde, debo mencionar que mediante una consulta recursiva no es generalmente una buena cosa que hacer.

Parece que usted está construyendo una jerarquía, que se puede hacer con una consulta y dos bucles, si utiliza una de sus llaves en item_id matriz y las referencias a su vez un arreglo unidimensional en una matriz virtual multi-dimensional.

Esto está tomado de otro sitio para su no ir a coincidir con su código, pero espero que el concepto aquí es fácil de ver. :)

PHP Código: [ 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
  • Registrado: Nov 14, 2006
  • Mensajes: 58
  • Loc: Chertsey, UK
  • Status: Offline

Nota Abril 27th, 2010, 10:35 am

Hola No quise decir cuando me refería recursivas como ésta.... ; O)

de nivel superior
nivel sub-
sub sub nivel
nivel sub-
de nivel superior

Esto funciona aunque no sé si es la forma más eficiente de hacerlo.


Código: [ 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


Gracias por su perspicacia aunque...
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Registrado: Feb 10, 2004
  • Mensajes: 13455
  • Loc: Florida
  • Status: Offline

Nota Abril 27th, 2010, 11:38 am

Sí, veo lo que está haciendo. Usted parece estar en algún tipo de plazo, sin embargo, lo que significa que no tienen tiempo para nada repetición del trabajo, así que no perderá ninguno de nuestro tiempo hablando por un oído y sale por el otro. :)
Strong with this one, the sudo is.
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Registrado: Nov 14, 2006
  • Mensajes: 58
  • Loc: Chertsey, UK
  • Status: Offline

Nota Abril 28th, 2010, 12:43 pm

NO no en un plazo tratando de conseguir que las cosas funcionarán bien...
  • joebert
  • Sledgehammer
  • Genius
  • No Avatar
  • Registrado: Feb 10, 2004
  • Mensajes: 13455
  • Loc: Florida
  • Status: Offline

Nota Abril 28th, 2010, 2:29 pm

¿Por qué el cepillado lo que tengo que decir que fuera?

Quote:
Gracias por su perspicacia aunque...


¿Cuáles son los puntos suspensivos para sustituir?

Quote:
Gracias por su comprensión, sin embargo, [imbécil]

Quote:
Gracias por su comprensión, sin embargo, [pero no entiendo algo]

Quote:
Gracias por su comprensión, sin embargo, [vamos a ver cuánto tiempo puedo troll]


¿Cuáles son sus intenciones!
Strong with this one, the sudo is.
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Registrado: Nov 14, 2006
  • Mensajes: 58
  • Loc: Chertsey, UK
  • Status: Offline

Nota Abril 29th, 2010, 1:34 am

Hola,

Soy un desarrollador coldsufion para mis habilidades se han convertido en un php ropey poco tengo miedo...
Mi pregunta original era cómo poner una consulta dentro de una función. Usted amablemente me enseño como hacer eso así que gracias.

Quote:
¿Por qué el cepillado lo que tengo que decir que fuera?

Lo sentimos, no estoy cepillando lo que dijiste. Me mearly te agradece. Puedo ver lo que estaba haciendo y que es útil como yo puede intentar que ..

Quote:
¿Cuáles son los puntos suspensivos para sustituir?

La enfermedad publicar el código en su totalidad más adelante para que pueda ver. No lo tengo conmigo ahora mismo, y estoy todavía trabajando en ello...Ahora tengo que hacer que el menú colapsable y expandible que es lo complicado que viene.

Yo soy el idiota sí...: O)
  • northstjarna
  • Beginner
  • Beginner
  • No Avatar
  • Registrado: Nov 14, 2006
  • Mensajes: 58
  • Loc: Chertsey, UK
  • Status: Offline

Nota Mayo 1st, 2010, 2:24 am

Ok bebé pasteles que te prometí, pero el código de la banda ancha se redujo. Pero aquí es todo lo que finalmente...Sistema totalmente recursivo menú colapsable. Si crees que puede mejorar en él, por favor hágamelo saber que yo todavía creo que hay una mejor manera de hacerlo. Mis conocimientos de php son aún bastante fibroso ya que vengo de un fondo CF...Pero Ho hum aquí está...

Código: [ 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);

Página 1 de 1

Publicar Información

  • Total de mensajes en este tema: 10 mensajes
  • Usuarios navegando por este Foro: No hay usuarios registrados visitando el Foro y 319 invitados
  • No puede abrir nuevos temas en este Foro
  • No puede responder a temas en este Foro
  • No puede editar sus mensajes en este Foro
  • No puede borrar sus mensajes en este Foro
  • No puede enviar adjuntos en este Foro
 
 

© 2011 Unmelted, LLC. Ozzu® es una marca registrada de Unmelted, LLC