PHP - Dynamic Dropdown Menu!

Hi,

I am hoping someone can help me out with a slight issue I have with php and mySQL.

I have an ajax-powered form with a select (dropdown) field populated through a php function. Based on the user-selected values in this field, data is displayed on the webpage; i.e. selected value 1 returns values x and y on the page. I am now trying to call additional data (value z) from a different table in the same database, and as before, use the selected values from the dropdown to display the data.

For some reason, value z is not changing according to the user-selected value.

This is my code:

[The function to populate the select field]

Code: [Select]
function kfl_get_funds_names()
{
$result = array();
$result['CDF'] = 'Crosby Dragon Fund';
$result['CPF'] = 'Crosby Phoenix Fund';
$result['AMZPIF'] = 'AMZ Plus Income Fund';
$result['KASBIIF'] = 'KASB Islamic Income Opportunity';
$result['KASBCPGF'] = 'KASB Capital Protected Gold Fund';
$result['KASBLF'] = 'KASB Income Opportunity Fund';
$result['KASBCF'] = 'KASB Cash Fund';
$result['KASBBF'] = 'KASB Asset Allocation Fund';
$result['KASBSMF'] = 'KASB Stock Market Fund';

return $result;
}
[the code calling and using the function to interact with the database]

Code: [Select]
$funds_to_display = kfl_get_funds_names();
$current_symbol = key( $funds_to_display );
$current_nav_rates = kfl_get_latest_rates( $current_symbol );
[the code calling additional data, value z, from the database, and using the info in the select field to filter it]
Code: [Select]
$cutoff = kfl_cutoff( $current_symbol );
The display of each of these items is as follows:

Code: [Select]
<?php echo $current_nav_rates['nav_date']; ?>
<?php echo $funds_to_display[$current_symbol]; ?>
<?php echo $cutoff['cutoff']; ?>
I can't get the $cutoff code to display the correct values. It picks up the first symbol to display and doesn't change with user selection. The code for the selection box, by the way:

Code: [Select]
<select id="dailynav-funds" autocomplete="off" name="dnf">
<?php
foreach ($funds_to_display as $fund_symbol => $fund_name)
{
echo '<option';
if( $fund_symbol == $current_symbol ) {
echo ' selected="selected"';
}
echo ' value="' . $fund_symbol . '">';
echo $fund_name;
echo '</option>';
}
?>
</select>
I've tried to get data using $_GET['dnf'] into the cutoff code, but that throws up parse errors. What am I doing wrong, and how can I resolve this issue?

Thanks in advance!

Hi all, here's my code:

Code: [Select]
<?php
foreach ($_SESSION['topping'] as $value) {
    echo "<tr><td width='30%'>Topping</td><td width='50%'>$value</td><td width='20%'><select name='notopping'>";
foreach ($_SESSION['cupcake'] as $number) { '<option name="notoppings[]" value="'.$number.'">".$number."</option>'; }
echo "</select></td></tr>";
}
?>

$_SESSION['cupcake'] is a value from either 6, 12, 24 or 36.  What I want to do is put them into a drop down box (second foreach) as the value and the displayed value - counting up from 1 (so 1,2,3,4,5,6 or up to 12,24 etc).

Also by creating this as an array, does this mean than for each topping (say Vanilla and Chocolate) the value dynamically created can be used on the next page by using $_POST['notoppings'] to display each type (two different numbers - one for Vanilla and one for Chocolate).  Does that make sense?

Thanks!

Jason

So i have a <drop down> menu, and a <nav> menu on my left side of the page. I have a problem when i click at the first column of my drop down menu and it explores submenu, the submenu mixes with the nav menu that is under the drop down menu on the left. i could solve it with margin-top of the nav menu but i don't like the empty space beetwen them. I tried with putting overflow:visible; in CSS of my dropdown menu but it is still the same. drop down menu is seen but there is stil seen nav menu under and they are mixed. So basicly i want my dropdown menu to be priority,  so when i clicks on my first column (only first column is problem because there under is nav menu the other are open nice) it will explore submenu and the part of nav menu that covers the submenu will be hidden.   Here is the screen shot:     Here is the code of head <dropdown> menu if someone finds the problem.

#menu, #menu ul {
	 
    margin: 0;
    padding: 0;
    list-style: none;
}

#menu {
	 
    width: 900px;
	margin-top:20px;
    margin-left:auto;
	margin-right:auto;
    border: 1px solid #222;
    background-color: #111;
    background-image: linear-gradient(#444, #111);
    border-radius: 6px;
    box-shadow: 0 1px 1px #777;
}

#menu:before,
#menu:after {
    content: "";
    display: table;
}

#menu:after {
    clear: both;
}

#menu {
    zoom:1;
}

#menu li {
	 
    float: left;
    border-right: 1px solid #222;
    box-shadow: 1px 0 0 #444;
    position: relative;
}

#menu a {
	 
    float: left;
    padding: 12px 30px;
    color: #999;
    text-transform: uppercase;
    font: bold 12px Arial, Helvetica;
    text-decoration: none;
    text-shadow: 0 1px 0 #000;
}

#menu li:hover > a {
    color: #fafafa;
}

*html #menu li a:hover { /* IE6 only */
    color: #fafafa;
}

#menu ul {
	
    margin: 20px 0 0 0;
    _margin: 0; /*IE6 only*/
    opacity: 0;
    visibility: hidden;
    position: absolute;
    top: 38px;
    left: 0;
    z-index: 1;    
    background: #444;   
    background: linear-gradient(#444, #111);
    box-shadow: 0 -1px 0 rgba(255,255,255,.3);  
    border-radius: 3px;
    transition: all .2s ease-in-out;
}

#menu li:hover > ul {
	
    opacity: 1;
    visibility: visible;
    margin: 0;
}

#menu ul ul {
	 
    top: 0;
    left: 150px;
    margin: 0 0 0 20px;
    _margin: 0; /*IE6 only*/
    box-shadow: -1px 0 0 rgba(255,255,255,.3);      
}

#menu ul li {
	 
    float: none;
    display: block;
    border: 0;
    _line-height: 0; /*IE6 only*/
    box-shadow: 0 1px 0 #111, 0 2px 0 #666;
}

#menu ul li:last-child {  
  
    box-shadow: none;    
}

#menu ul a { 
    
    padding: 10px;
    width: 130px;
    _height: 10px; /*IE6 only*/
    display: block;
    white-space: nowrap;
    float: none;
    text-transform: none;
}

#menu ul a:hover {
    background-color: #0186ba;
    background-image: linear-gradient(#04acec, #0186ba);
}

#menu ul li:first-child > a {
    border-radius: 3px 3px 0 0;
}

#menu ul li:first-child > a:after {
	 
    content: '';
    position: absolute;
    left: 40px;
    top: -6px;
    border-left: 6px solid transparent;
    border-right: 6px solid transparent;
    border-bottom: 6px solid #444;
}

#menu ul ul li:first-child a:after {
	 
    left: -6px;
    top: 50%;
    margin-top: -6px;
    border-left: 0; 
    border-bottom: 6px solid transparent;
    border-top: 6px solid transparent;
    border-right: 6px solid #3b3b3b;
}

#menu ul li:first-child a:hover:after {
    border-bottom-color: #04acec; 
}

#menu ul ul li:first-child a:hover:after {
    border-right-color: #0299d3; 
    border-bottom-color: transparent;   
}

#menu ul li:last-child > a {
    border-radius: 0 0 3px 3px;
}

Here is the code of <nav> menu if someone finds the problem.

#cssmenu {
	
	
	width:15%;
  padding: 0;
  margin-top: 50px;
  margin-left:auto;
  margin right:auto;
  float:left;
  border: 0;
  line-height: 1;
}
#cssmenu ul,
#cssmenu ul li,
#cssmenu ul ul {
  list-style: none;
  margin: 0;
  padding: 0;
}
#cssmenu ul {
  position: relative;
  z-index: 597;
  float: left;
}
#cssmenu ul li {
  float: left;
  min-height: 1px;
  line-height: 1em;
  vertical-align: middle;
  position: relative;
}
#cssmenu ul li.hover,
#cssmenu ul li:hover {
  position: relative;
  z-index: 599;
  cursor: default;
}
#cssmenu ul ul {
  visibility: hidden;
  position: absolute;
  top: 100%;
  left: 0px;
  z-index: 598;
  width: 100%;
}
#cssmenu ul ul li {
  float: none;
}
#cssmenu ul ul ul {
  top: -2px;
  right: 0;
}
#cssmenu ul li:hover > ul {
  visibility: visible;
}
#cssmenu ul ul {
  top: 1px;
  left: 99%;
}
#cssmenu ul li {
  float: none;
}
#cssmenu ul ul {
  margin-top: 1px;
}
#cssmenu ul ul li {
  font-weight: normal;
}
/* Custom CSS Styles */
#cssmenu {
  width: 200px;
  background: #333333;
  font-family: 'Oxygen Mono', Tahoma, Arial, sans-serif;
  zoom: 1;
  font-size: 12px;
}
#cssmenu:before {
  content: '';
  display: block;
}
#cssmenu:after {
  content: '';
  display: table;
  clear: both;
}
#cssmenu a {
  display: block;
  padding: 15px 20px;
  color: #ffffff;
  text-decoration: none;
  text-transform: uppercase;
}
#cssmenu > ul {
  width: 200px;
}
#cssmenu ul ul {
  width: 200px;
}
#cssmenu > ul > li > a {
  border-right: 4px solid #1b9bff;
  color: #ffffff;
}
#cssmenu > ul > li > a:hover {
  color: #ffffff;
}
#cssmenu > ul > li.active a {
  background: #1b9bff;
}
#cssmenu > ul > li a:hover,
#cssmenu > ul > li:hover a {
  background: #1b9bff;
}
#cssmenu li {
  position: relative;
}
#cssmenu ul li.has-sub > a:after {
  content: '+';
  position: absolute;
  top: 50%;
  right: 15px;
  margin-top: -6px;
}
#cssmenu ul ul li.first {
  -webkit-border-radius: 0 3px 0 0;
  -moz-border-radius: 0 3px 0 0;
  border-radius: 0 3px 0 0;
}
#cssmenu ul ul li.last {
  -webkit-border-radius: 0 0 3px 0;
  -moz-border-radius: 0 0 3px 0;
  border-radius: 0 0 3px 0;
  border-bottom: 0;
}
#cssmenu ul ul {
  -webkit-border-radius: 0 3px 3px 0;
  -moz-border-radius: 0 3px 3px 0;
  border-radius: 0 3px 3px 0;
}
#cssmenu ul ul {
  border: 1px solid #0082e7;
}
#cssmenu ul ul a {
  font-size: 12px;
  color: #ffffff;
}
#cssmenu ul ul a:hover {
  color: #ffffff;
}
#cssmenu ul ul li {
  border-bottom: 1px solid #0082e7;
}
#cssmenu ul ul li:hover > a {
  background: #4eb1ff;
  color: #ffffff;
}
#cssmenu.align-right > ul > li > a {
  border-left: 4px solid #1b9bff;
  border-right: none;
}
#cssmenu.align-right {
  float: right;
}
#cssmenu.align-right li {
  text-align: right;
}
#cssmenu.align-right ul li.has-sub > a:before {
  content: '+';
  position: absolute;
  top: 50%;
  left: 15px;
  margin-top: -6px;
}
#cssmenu.align-right ul li.has-sub > a:after {
  content: none;
}
#cssmenu.align-right ul ul {
  visibility: hidden;
  position: absolute;
  top: 0;
  left: -100%;
  z-index: 598;
  width: 100%;
}
#cssmenu.align-right ul ul li.first {
  -webkit-border-radius: 3px 0 0 0;
  -moz-border-radius: 3px 0 0 0;
  border-radius: 3px 0 0 0;
}
#cssmenu.align-right ul ul li.last {
  -webkit-border-radius: 0 0 0 3px;
  -moz-border-radius: 0 0 0 3px;
  border-radius: 0 0 0 3px;
}
#cssmenu.align-right ul ul {
  -webkit-border-radius: 3px 0 0 3px;
  -moz-border-radius: 3px 0 0 3px;
  border-radius: 3px 0 0 3px;
}

Edited by Dorkmind, 26 November 2014 - 05:00 PM.

Hi all, I was wondering if someone knows a clean way to make a dropdown menu using just php and html with the following functionality. If someone selects a value from the dropdown options it should be visible on refresh.
So in case a have a dropdown menu with: oranges, apples, grapes and someone selects grapes and submits it, grapes should be selected.

I have made someonthing but it looks redundant. I think there should be something with a foreach loop or something but i can't figure it out yet.

Thanks in advance,
cheers!!

Hi i have a online/offline script that works great no issues at all. In order to change the html, php file to display when offline I need to point it to that file via input field. What i would like is to change the input filed and have a dropdown that list all the folders and subfolders within the the directory where all the templates are located. I have found a php snippet on the forum that does exactly what i want. The issue is now is to remove the input filed in the script and insert the snippet found here and thats where the issue comes. I'm hoping some guru here can easily help me out . please see below for the code

online/offline code ( input filed i would like to replace with dropdown selector <input type="text" name="txttemplate" value="%s" id="txttemplate" />)
Code: [Select]
<?php 
session_start();
$page_offline  = TRUE;
$page_offline_title  = " ";
$page_offline_message  = " Offline";
$admin_ip = "1.1.1.1";
$admin_password = "*****************";
$page_offline_template  = "template/path/index.php";
$page_offline_foradmin = TRUE;
ini_set("display_errors", "0");
error_reporting(E_COMPILE_ERROR|E_ERROR|E_CORE_ERROR);
$page = strstr($_SERVER['PHP_SELF'], "off.php") ? "admin" : "website";

// Try login
$login_error = FALSE;
if(isset($_POST['txtpassword'])){
if(md5($_POST['txtpassword']) == $admin_password){
$_SESSION['offline_admin'] = TRUE;
}else{
$login_error = TRUE;
}
}

// Save config settings
$offline  = $page_offline ? 'checked="checked"' : "";
$title  = $page_offline_title;
$message  = $page_offline_message;
$saved  = FALSE;
$template = $page_offline_template;
$adminoffline  = $page_offline_foradmin ? 'checked="checked"' : "";

if(isset($_POST['btnsave']) && $_SESSION['offline_admin']){
$val_offline  = isset($_POST['chkoffline']) && ($_POST['chkoffline'] == "true") ? TRUE : FALSE;
$val_title  = htmlspecialchars($_POST['txttitle']);
$val_message  = htmlspecialchars($_POST['txtmessage']);
$val_template  = htmlspecialchars($_POST['txttemplate']);
$val_password  = htmlspecialchars($_POST['txtpassword']);
$val_adminoffline  = isset($_POST['chkconstruct']) && ($_POST['chkconstruct'] == "true") ? TRUE : FALSE;

$offline  = $val_offline ? 'checked="checked"' : "";
$title  = $val_title;
$message  = $val_message;
$template = $val_template;
$adminoffline  = $val_adminoffline ? 'checked="checked"' : "";

if(empty($val_password)){
page_offline_save($val_offline, $val_title, $val_message, $val_template, $adminoffline);
}else{
page_offline_save($val_offline, $val_title, $val_message, $val_template, $adminoffline, $val_password);
}

$saved = TRUE;
}

// Templates
$admin_style_tpl = <<<ADMINSTYLETPL
body{
font-family:Arial, Helvetica, sans-serif;
font-size:11px; 
text-align: center;
background-color:#F9F9F9;
color:#555555;
}
#wrapper{
width:400px;
padding:20px;
margin: 0 auto;
border:1px solid #DADADA;
background-color: #FFF;
text-align: left;
}
h2{
margin: 0px 0px 10px 0px;
padding: 0px;
font-size: 24px;
color:#464646;
font-family:Georgia,"Times New Roman",Times,serif;
font-style: italic;
font-weight: normal;
}
label{
display: block;
width: 150px;
font-weight: bold;
padding: 14px 0px 3px 0px;
}
input{
-moz-border-radius-bottomleft:3px;
-moz-border-radius-bottomright:3px;
-moz-border-radius-topleft:3px;
-moz-border-radius-topright:3px;
width: 300px;
background:#F5F5F5 none repeat scroll 0 0;
border:1px solid #CCCCCC;
color:#666666;
padding: 4px 8px;
}
#chkoffline, #chkconstruct{
width: 20px;
}
.error{
border: solid 1px #CC0000;
}

ADMINSTYLETPL;

$admin_login_tpl = <<<ADMINLOGINTEMPLATE
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Login</title>
<style>
%s
</style>
</head>

<body>
<div id="wrapper">
<h2>Login</h2>
<form id="form1" name="form1" method="post" action="">
<label for="txtpassword">Password</label>
   <input type="password" name="txtpassword" %s id="txtpassword" /><br /><br />
   <input name="btnlogin" type="submit" value="Login" />
   </form>
</div>
</body>
</html>

ADMINLOGINTEMPLATE;

$admin_config_tpl = <<<ADMINCONFIGTEMPLATE
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style>
%s
</style>
</head>

<body>
<div id="wrapper">
<h2></h2>
<form id="frmadmin" name="frmadmin" method="post" action="">
    <label for="chkoffline">Offline</label>
    <input name="chkoffline" id="chkoffline" %s type="checkbox" value="true" />
<label for="chkconstruct">Show offline to admin</label>
    <input name="chkconstruct" id="chkconstruct" %s type="checkbox" value="true" />
<label for="txttitle">Title</label>
   <input type="text" name="txttitle" value="%s" id="txttitle" />
        <label for="txtmessage">Message</label>
   <input type="text" name="txtmessage" value="%s" id="txtmessage" />
<label for="txttemplate">Template</label>
   <input type="text" name="txttemplate" value="%s" id="txttemplate" />
        <label for="txtpassword">Admin password</label>
   <input type="password" name="txtpassword" id="txtpassword" />
   <br /> Leave this field empty if you don't want to change the admin password.
<br /><br />
   <input name="btnsave" type="submit" value="Save" />
   </form>
</div>
</body>
</html>

ADMINCONFIGTEMPLATE;

$admin_saved_tpl = <<<ADMINSAVEDTEMPLATE
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Offline Admin</title>
<style>
%s
</style>
</head>

<body>
<div id="wrapper">
<h2>Configuration saved</h2>
The configuration is saved succesfully. You can continue to <a href="off.php">config</a> or go to your <a href="../">Homepage</a> or back to <a href="index.php">admin panel</a>.
</div>
</body>
</html>

ADMINSAVEDTEMPLATE;

if($page == "admin"){

// If user not is loggedin then show login screen
if(!isset($_SESSION['offline_admin']) || !$_SESSION['offline_admin']){
echo sprintf($admin_login_tpl, $admin_style_tpl, ($login_error) ? 'class="error"' : '');
}else{
if(!$saved){
echo sprintf($admin_config_tpl, $admin_style_tpl, $offline, $adminoffline, $title, $message, $template);
}else{
echo sprintf($admin_saved_tpl, $admin_style_tpl);
}
}
exit();

}else{

if($page_offline && (($_SERVER['REMOTE_ADDR'] != $admin_ip) || $page_offline_foradmin)){

ob_start();
include($page_offline_template);
$template = ob_get_contents();
ob_end_clean();

// Replace variables
$template = str_replace(array("{TITLE}", "{MESSAGE}"), array($page_offline_title, $page_offline_message), $template);

// Show template
echo $template;
exit();
}

}

// Write settings to file
function page_offline_save($offline, $title, $message, $template, $adminoffline, $password=""){
$lines = explode("\n", file_get_contents("offline.php"));

// Set configuration
$offline_state = ($offline) ? "TRUE" : "FALSE";
$lines[2] = '$page_offline  = ' . $offline_state . ';';
$lines[3] = '$page_offline_title  = "' . $title . '";';
$lines[4] = '$page_offline_message  = "' . $message . '";';
$lines[5] = '$admin_ip = "' . $_SERVER['REMOTE_ADDR'] . '";';
$lines[7] = '$page_offline_template  = "' . $template . '";';
$adminoffline_state = ($adminoffline) ? "TRUE" : "FALSE";
$lines[8] = '$page_offline_foradmin = ' . $adminoffline_state . ';';
if(!empty($password)){
$lines[6] = '$admin_password = "' . md5($password) . '";';
}

// Save to file
file_put_contents("off.php", implode("\n", $lines));
}
?>

snippet found here on the forum
Code: [Select]
<?php 

$parent_directory = 'path/to/directory';
$file_types = 'html,htm,php,etc';

//===================================================//
// FUNCTION: directoryToArray                        //
//                                                   //
// Parameters:                                       //
//  - $root: The directory to process                //
//  - $to_return: f=files, d=directories, b=both     //
//  - $file_types: the extensions of file types to   //
//                 to return if files selected       //
//===================================================//
function directoryToArray($root, $to_return='b', $file_types=false) {
  $array_items = array();
  if ($file_types) { $file_types=explode(',',$file_types); }
  if ($handle = opendir($root)) {
    while (false !== ($file = readdir($handle))) {
      if ($file != "." && $file != "..") {

        $add_item = false;
        $type = (is_dir($root. "/" . $file))?'d':'f';
        $name = preg_replace("/\/\//si", "/", $file);

        if ($type=='d' && ($to_return=='b' || $to_return=='d') ) {
          $add_item = true;
        }

        if ($type=='f' && ($to_return=='b' || $to_return=='f') ) {
          $ext = end(explode('.',$name));
          if ( !$file_types || in_array($ext, $file_types) ) {
            $add_item = true;
          }
        }

        if ($add_item) {
          $array_items[] = array ( 'name'=>$name, 'type'=>$type, 'root'=>$root);
        }
      }
    } // End While
    closedir($handle);
  } // End If
  return $array_items;
}



if (isset($_POST[pickfile])) {

  // User has selected a file take whatever action you want based
  // upon the values for folder and file

} else {

    echo '
<html>
<head>
  <script type="text/javascript">
    function changeFolder(folder) {
      document.pickFile.submit();
    }
  </script>
</head>

<body>';


echo "<form name=\"pickFile\" method=\"POST\">\n";

$directoryList = directoryToArray($parent_directory,'d');

echo "<select name=\"folder\" onchange=\"changeFolder(this.value);\">\n";
foreach ($directoryList as $folder) {
  $selected = ($_POST[folder]==$folder[name])? 'selected' : '';
  echo "<option value=\"$folder[name]\" $selected>$folder[name]</option>\n"; 
}
echo '</select><br><br>';

$working_folder = ($_POST[folder]) ? $_POST[folder] : $directoryList[0][name];

$fileList = directoryToArray($parent_directory.'/'.$working_folder,'f',$file_types);

echo "<select name=\"file\">\n";
foreach ($fileList as $file) {
  echo "<option value=\"$file[name]\">$file[name]</option>\n"; 
}
echo '</select><br><br>';

echo "<button type=\"submit\" name=\"pickfile\">Submit</button>\n";

echo "</form>\n";
echo "</body>\n";
echo "</html>\n";

}
?>
Thank you in advance for any help...

I'm trying to make my menu dynamic for example I will have a menu with it's submenus and when the user logs on the submenu account will then be shown where it wasn't shown before the user logged on.

here is my submenu.controller
Code: [Select]
<?php
class submenus_controller extends controller{

protected $_helpers = array('form', 'html');
protected $_observers = array('seo_uris');

public $model='submenus';

public function ajax_set_submenu($submenu_id){

$submenu=$this->_model->get($submenu_id);

$_SESSION['submenu']=$submenu;



}

}
?>

and here is my default page
Code: [Select]
<!doctype html>
<!--[if lt IE 7]> <html class="no-js ie6 oldie" lang="en"> <![endif]-->
<!--[if IE 7]>    <html class="no-js ie7 oldie" lang="en"> <![endif]-->
<!--[if IE 8]>    <html class="no-js ie8 oldie" lang="en"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
<head>

<title><?php echo $this->get_title();?></title>

<meta name="author" content="team digitalpro">
<meta name="viewport" content="width=device-width,initial-scale=1">

<meta name = "Description" content = "<?php echo $this->get_description();?>" />
<meta name = "Keywords" content = "<?php echo $this->get_keywords(); ?>" />

<link rel="stylesheet" href="/css/style.css">
<script src="js/libs/modernizr-2.0.6.min.js"></script>

</head>
<body>
  <div id="container">
<header>
<div class="inhoud">
<div id="logo"><a href="/"><img src="/img/logo.gif" width="306" height="126" border="0" /></a></div>
<nav>
<div class="menu">
<ul>
<?php 
if (isset($this->_params['menus']) && is_array($this->_params['menus'])){
foreach ($this->_params['menus'] as $menu){

if (!empty($menu['submenus.page_id'])){

$uri=$this->get_uri('/pages/view/'.$menu['submenus.page_id']);

}else{

$uri=$this->get_uri("/{$menu['submenus.controller']}/{$menu['submenus.action']}");

}

// p($menu);
?>
<li><a href="<?php echo $uri ?>" onclick="javascript:return setMenu(<?php echo $menu['id'] ?>);"><?php echo strtoupper($menu['name'])?></a></li>
<?php
}
}
?>
</ul>
</div>
</nav>
</div>
</header>
<div id="hero-pic">
<div id="slogans"><img src="../img/slogans.png" width="277" height="214" /></div>
<img src="../img/hero.gif" width="996" height="286" /></div>
<main>
<div id="left">
<div class="inhoud">
<div id="left-nav">
<ul>
<?php 
if (isset($this->_params['submenus']) && is_array($this->_params['submenus'])){

foreach ($this->_params['submenus'] as $submenu){

if (!empty($submenu['page_id'])){

$uri=$this->get_uri('/pages/view/'.$submenu['page_id']);

}else{

$uri=$this->get_uri("/{$submenu['controller']}/{$submenu['action']}");

}
?>
<li<?php if ($_SESSION['submenu']['id'] == $submenu['id']){?> class="active"<?php ;} ?>>
<a href="<?php echo $uri ?>" onclick="javascript:return setSubMenu(<?php echo $submenu['id'] ?>);">
<?php echo strtoupper($submenu['name'])?>
</a>
</li>
<?php
}
}
?>
</ul>
</div>
<form method="post" action="">
<input type="text" id="search" />
<input type="submit" name="button" value="GO" class="go" />
</form>
<div class="sub-links">
<ul>
<li><a href="#">Home</a></li>
<li><a href="#">Contact us</a></li>
<li><a href="#">Sitemap</a></li>
<li><a href="#">Privacy policy</a></li>
</ul>
</div>
</div>
</div>
<div id="right">
<div class="inhoud">
<?php echo $this->page('view') ?>
</div>
</div>
</main>
<footer>
<!-- <div class="inhoud">
<ul>
<li><a href="#">COMPANY </a></li>
<li><a href="#">PRIVATE EQUITY </a></li>
<li><a href="#">CONSULTING </a></li>
<li><a href="#">INVEST </a></li>
<li><a href="#">PARTNERS </a></li>
<li><a href="#">NEWS</a></li>
</ul> -->
<p>&nbsp;</p>
<p>&nbsp;</p>
</div>
</footer>
</div>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
<script>window.jQuery || document.write('<script src="/js/libs/jquery-1.6.2.min.js"><\/script>')</script>
<script defer src="/js/plugins.js"></script>
<script defer src="/js/script.js"></script>
<script>
window._gaq = [['_setAccount','UAXXXXXXXX1'],['_trackPageview'],['_trackPageLoadTime']];
Modernizr.load({
load: ('https:' == location.protocol ? '//ssl' : '//www') + '.google-analytics.com/ga.js'
});

setMenu = function(menu_id){

$.ajax({
url: "/menus/ajax_set_menu/"+menu_id,
type: 'POST',
dataType: "html",
data: {
format: 'JSON',
},
success: function(data) {

}
});
}

setSubMenu = function(submenu_id){

$.ajax({
url: "/submenus/ajax_set_submenu/"+submenu_id,
type: 'POST',
dataType: "html",
data: {
format: 'JSON',
},
success: function(data) {

}
});
}

</script>
<!--[if lt IE 7 ]>
<script src="//ajax.googleapis.com/ajax/libs/chrome-frame/1.0.3/CFInstall.min.js"></script>
<script>window.attachEvent('onload',function(){CFInstall.check({mode:'overlay'})})</script>
<![endif]-->
</body>
</html>

Hi,
I am using php dynamic listing from database. it is working but I wanna integrate to a horizontal css menu how can i integrate my codes to any css horizantal dropdown menu.

thans.

here my dynamic list.

<?php

function sinirsiz_kategori($parent) {

 
    $sql = mysql_query("SELECT * FROM kategoriler ORDER BY id DESC");

 
    while($row = mysql_fetch_array($sql)) {

         $diziler[$row['id']] = array('baslik' => $row['baslik'],'parent' => $row['parent']);

    }

 
    $has_childs = false;

 
    foreach($diziler as $key => $value)  {

            if ($value['parent'] == $parent) {       

 
                    if ($has_childs === false){

                            $has_childs = true;

                            echo "\t<ul>";

                    }

 
                    echo "<li><a href=\"".$value['baslik'].".php\">".$value['baslik']."</a>";

                    sinirsiz_kategori($key);

                    echo "</li>\n";

            }

    }

 
    if ($has_childs === true) echo "</ul>";

 
}

 
 
?>
<?=sinirsiz_kategori(0)?>

hello everybody.. i need help.. i want to make a dropdown menu with php coding that will show the result from my database.. can anyone help me to generate the coding? this is an example form:   <form action="" method="get"><select name="">
  <option value="select">select</option>
  <option value="1">1 </option>
  <option value="2">2</option>
  <option value="3">3</option>
 
</select>
  <label>
  <input type="submit" name="button" id="button" value="Submit" />
  </label>
</form>   if user select 1, the php code will show a list of name by their identification card, if user select 2 the php code will show a list of name by country.

I think after a lot of trouble I've finally managed to get my hierarchical php driven hierarchical dropdown menu working. I now have 1 problem with it which I simply can't figure out. Rather than explain this I think a picture is worth a thousand words so here's the script in action:-

http://www.coolvisiontest.com/garyssite/rhrvouchers/menu4.php

If you notice in that example when you hover over categories then level1a then level2a the menu's and their children appear 1 at a time as they should. However if you hover over level1a then level2b then all at once all of the child categories of 2b and all of their child catagories and their child categories etc appear at once rather than one at a time. You should have to hover over level3e to see level4a and you should have to hover over level4a to see level5a etc.

The code I have is a combination of 2 sets of code I came across to be honest so I'm having trouble figuring it out.


At the moment I only have 3 problems with it:-

1. I only want subcategories to be shown when their parent category is hovered over as explained above
2. I only want the bottom level of categories to act as links e.g. levels 2c 3a 3b 3c 3d and 5a would act as links in this example as they are the last of all the children, the rest of the categories should be plain text. I'm not sure if this is achievable though as I think links are required for the hover functionality.
3. I want some way of indicating to the user that a category has children perhaps by including a little right arrow or plus sign and of course this should only be included for the categories that have children and not the others.

Can anyone help me out with these three things please? Here's my code so far:-



<?php

$link = mysqli_connect('localhost','','');
mysqli_select_db($link,'');

$query = mysqli_query($link,'SELECT * FROM nested_categories');
while ( $row = mysqli_fetch_assoc($query) ){        
$menu_array[$row['id']] = array('id' => $row['id'],'name' => $row['name'],'parent' => $row['parent_id']);
}

function generate_menu($parent){        
$has_childs = false;        

global $menu_array;        

foreach($menu_array as $key => $value){                
if ($value['parent'] == $parent){ 
                              
if ($has_childs === false){                                

$has_childs = true;                                
echo '<ul>';                        
}                        

echo '<li><a href="menu4.php?id='.$value['id'].'">'.$value['name'].'</a>';                        
generate_menu($key);                        

echo '</li>';                
}        
}        
if ($has_childs === true) echo '</ul>';
}

?>

<div id="menu">
<ul>

<li><h2>categories</h2>

<?php generate_menu(0); ?>

</li>

</ul>

</div>




And the Css:-


#menu {
width: 100%;
background: #eee;
float: left;
}
#menu ul {
list-style: none;
margin: 0;
padding: 0;
width: 12em;
float: left;
}


#menu a, #menu h2 {
font: bold 11px/16px arial, helvetica, sans-serif;
display: block;
border-width: 1px;
border-style: solid;
border-color: #ccc #888 #555 #bbb;
margin: 0;
padding: 2px 3px;
}

#menu h2 {
color: #fff;
background: #000;
text-transform: uppercase;
}

#menu a {
color: #000;
background: #efefef;
text-decoration: none;
}

#menu a:hover {
color: #a00;
background: #fff;
}



#menu li {position: relative;}

#menu ul ul {
position: absolute;
z-index: 500;
}

#menu ul ul ul {
top: 0;
left: 100%;
}




div#menu ul ul,
div#menu ul li:hover ul ul,
div#menu ul ul li:hover ul ul
{display: none;}

div#menu ul li:hover ul,
div#menu ul ul li:hover ul,
div#menu ul ul ul li:hover ul
{display: block;}

how do i this? i have no idea....i need to incorporate it on an html form
pleas help?

i will get the data from this line and must be able to select one from the dropdown and get the id/name from the one selected

[COLOR="Red"]$supplier_names = LpmAdnetworkPeer::getByName($catcher_id);[/COLOR]

thank you

Hello,   I'm new to php, I don't really have much experience, just have used it in combination with dreamweaver. I'm tackling a new problem now.   Basically, it's about a dropdown menu with pre-defined values. There are multiple dropdowns, having different value choices. People are supposed to be able to select more than one option and then search for the results. these should then be generated according to the selected values, or if no value is selected, ALL is shown.   When the user clicks on search, the values create a msql query that will then be executed and the results shown on the page.   I've been searching high and low for code ideas, but see different stuff everywhere I look, and none of the code seems to be what i want. Some people are using Javascript, some Ajax, or PHP. ideally, I want to use just php and sql   Can someone point me in the right direction on how to tackle this problem, or maybe someone has some code ideas?   Thanks in advance.   Mio        

Hi, I don't know if this is the right place, but I used a code for a dropdown menu witch works fine on the website (geloven.eu/ABK2021) who uses PHP 7.2.24, but the dropdown does NOT work on another site bijbelkamp.eu/ABK2021 who uses PHP 7.3.28.

The index page just includes the menu.php (here menu.txt) and the css file bootstrap21.css (here bootstrap21.txt).

Can this be some coding issue or does this have nothing to do with the code?

bootstrap21.txt menu.txt

Hi All,

I have a snippet of code (below) which I use to create a dynamic menu from a MySQL database for a community website. Fields used in the database a

ID
parent (what the parent page is)
page_order (what is says on the tin)
short_title (a short title for the page for the URL)
title (the page title - used as the text for the link)
content (the content for the page)

I have got the dynamic list to display fine, but what I would like to be able to do is give each list item a 'class' tag when it has been selected (and thus is the page being shown). Can anyone suggest how to amend the below code to allow this?

Code is:

Code: [Select]
<!-- ##### START LIST_INFO_PAGES ##### -->
<?php
include("../config/config.php");
?>

<?php
$sql = "SELECT * FROM `PCNET_$filename` WHERE parent = 'council' ORDER BY page_order ASC";
$sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql);
while ($row = mysql_fetch_assoc($sql_result)) {
print '';
if ($row["status"]<>'') {
echo '<li><a href="../council-indiv.php?id=';
echo ($row["id"]).'&short_title=';
echo nl2br(stripslashes(utf8_decode($row["short_title"]))).'" title=';
echo nl2br(stripslashes(utf8_decode($row["title"]))).'>';
echo nl2br(stripslashes(utf8_decode($row["title"]))).'</a></li>';
};
};
?>
<!-- ##### END LIST_INFO_PAGES ##### -->
Help will be welcome!
Neil

Hi all, my first post here (except my intro post earlier today).

I looked for this in the Code Snippet section and didn't see it, and honestly I'm very much a noob at this (for now, at least) so I'm not quite sure what I'd look for anyway. I've got a decent grasp on HTML and CSS and very little PHP.

So here's what I need help with:  I wrote a simple PHP include so that all my main pages (including the index file) would all use the same file (navtabs.php) for their navigation tabs. But how do I make the code in navtabs.php dynamic for which button should be highlighted on the proper page?

Here is the code snippet for my navigation:
Code: [Select]
     <nav>
        <ul>
        <li><a href="index.php" class="current">Home</a></li>
          <li><a href="page-two.php" >Page Two</a></li>
          <li><a href="page-three.php">Page Three</a></li>
          <li><a href="page-four.php">Page Four</a></li>
          <li class="last"><a href="page-five.php">Page Five</a></li>
        </ul>
      </nav>
Where class="current" is the highlighting attribute.  All my pages using the same include of this code show the Home tab highlighted?

Hoping someone has a simple fix for me. Thanks!