PHP - Multiple Dynamic Drop Down Menu

I am having a lot of trouble with this code, and I have no clue how to fix it.  Right now, I have a GUI for a fictitious car dealership that has 5 populated drop down menus called Make, Model, Year, Color, and Mileage.  What I want the code to do is read the selections made by the user with the drop down menus once the user hits the submit button and then filter the tables that I have in a mysql database to meets the choice requirements of the user.

The code will bring up the GUI, but once I hit the submit button, I get the following errors

Please if anyone can help me that would be fantastic.  I really have no clue

Hi there.

Im a noob to sql and php not sure if this is right place to post,

Im trying to get a dynamic drop down menu to show the 1st column in my sql database the column is called cat and holds category info ie audio, internet, music ect. ( i have no idea how to do lol )

it has taken me 2 days to find and edit this  the bold and underline'd bit is what im trying to change with the dropdown menu.

Or thinking bout it is there a way to do it with the URL. IE.. page name.php?cat=audio ?
would that be easer ? is there any security issues with doing it that way ?


Code==================================
$db_host = '*******';
$db_user = '******';
$db_pwd = '*****;

$database = 'nbbcj_co_uk';
$table = 'penapps';

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// sending query
$result = mysql_query("SELECT * FROM {$table} WHERE `cat` = 'audio' LIMIT 10 ");
if (!$result) {
    die("Query to show fields from table failed");
}

$fields_num = mysql_num_fields($result);

//echo "<h1>Table: {$table}</h1>";
echo "<table border='1' width='100%'><tr>";
// printing table headers
for($i=0; $i<$fields_num; $i++)
{
    $field = mysql_fetch_field($result);
    //echo "<td>{$field->name}</td>";
}
echo "</tr>\n";
// printing table rows
while($row = mysql_fetch_row($result))
{
    echo "<tr>";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "<td>$cell</td>";

    echo "</tr>\n";
}
mysql_free_result($result);
?>
code end ======================

the test page can been seen here http://www.nbbcj.co.uk/testd/1/test1.php

Any more questions let me know

Thanks for any help you can give, a we all have to start some ware lol

thanks kaine.

I am a beginner. 

How do you capture the selected value in dynamic dropdown and submit it to a different table in mysql

I really can't get my head around this dynamic drop box. What I want is for a drop box to be populated with values in my database.

I have this that connects to my SQL and picks out the table required:

function displayUsers(){
   global $database;
   $q = "SELECT username,"
       ."FROM ".TBL_USERS." ORDER BY userlevel DESC,username";
   $result = $database->query($q);    ...

I then have this to pick out any errors, and also using the num_rows to get the number of rows (values) there a

$num_rows = mysql_numrows($result);
   if(!$result || ($num_rows < 0)){
      echo "Error displaying info";
      return;
   }
   if($num_rows == 0){
      echo "Database table empty";
      return;
   }

From here, I guess I want the num_rows to keep 'adding on' the number of <option value=""> in my selection box according the number of values I have in my database.

At this point, I can pull out the values into a dynamic table ... but I want it into a drop box -- but I'll but up the code for the dynamic table so you can get an idea:


/* Display table contents */
   echo "<table align=\"left\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\">\n";
   echo "<tr><td><b>Username</b></td></tr>\n";
   for($i=0; $i<$num_rows; $i++){
      $uname  = mysql_result($result,$i,"username");
      echo "<tr><td>$uname</td></tr>\n";
   }
   echo "</table><br>\n";
}

I hope you can use the code above to help me develop this darn drop box!

Thanks, Ollie!

Holy smoke, it has been a looooooong time since I have been here. Love the new look of the site btw. Well I am working on a new project for my church. The idea is an email to SMS program. So one use of this would be that if there is a youth activity I could send a message to the entire youth group with one message. I am trying to figure out something specific with it. I need to create a form that grabs info from the database. So more specifically what I need is one drop down that will have "Youth Group", "Parents", "Deacons", etc. now based on what I select I need the second drop down to populate with the corresponding people in that group. Now I want an "All" to be in the drop down to which would let me send the message I type to ALL people in the desired group but to also have the individual names come up just in case I need to do a specific person.

How would I go about doing something like this? I have done much research and cant quite find what I would need to do. Any help would be GREATLY appreciated.

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=306771.0

Hi,

Can anyone point me in the right direction please? I want to have a drop down box which when a user clicks on a category the results on the page have changed to show only the data which is relative to the category chosen by the user. I also need a way so that when they click view all they are able to see all the results again.

Not really sure what to look for or even how hard this might be.

Lee   

Hello,, I have looked for numerous examples, and have only got part of the answer.
I have successfully populated a drop down list by reading the database.
It populates with a list of quest titles. Once the user selects the quest.
I want a textbox to populate with the Quest Description.

I found an example that uses AJAX/PHP to do this, but it doesn't access a db to read/populate.
The main code is in index.html
The original example you select a country, and it populates a text field with the currency code.
It passes a variable called $country to another file called find_ccode.php.
I changed the first case in find_ccode.php to access my database, and populate the text box with quest description.
Ideally I will like to make this case dynamic based off QuestID, would populate textbox with corresponding Quest Description (QDescrip).
I then tried the other way in index.php
I dynamically populated the dropdown list, and gave the option values the QuestIDs to be passed to $country, but something isn't working.
I have a write files command to let me know what the $country variable is passing, and it never writes. It works in index.html though.
I apologize in advance for my amateurish coding. I still have a lot to learn. I have included the code below, but if you know a more elegant way of doing it. I am creating a role-playing game, as you probably have figured out by now. I hope to one day put it on the web, but right now using it as a way of learning html, and PHP.

I really want to know how to catch the value of the dropdown box. I would like to know what it is before sending over.
also what is this.value. I assume this is what the value of the dropdown box is when you have selected something.

I have been beating my head for days trying to figure this out. Any help is very much appreciated!

Index.html
<html>
<head>
<title>Changing textbox value based on dropdown list using Ajax and PHP</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script>
//  Developed by Roshan Bhattarai
//  Visit http://roshanbh.com.np for this script and more.
//  This notice MUST stay intact for legal use

//fuction to return the xml http object
function getXMLHTTP() {
      var xmlhttp=false;   
      try{
         xmlhttp=new XMLHttpRequest();
      }
      catch(e)   {      
         try{         
            xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
         }
         catch(e){
            try{
            xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
            }
            catch(e1){
               xmlhttp=false;
            }
         }
      }
          
      return xmlhttp;
   }
   
   
   
function getCurrencyCode(strURL)
{      
   var req = getXMLHTTP();      
   if (req)
   {
      //function to be called when state is changed
      req.onreadystatechange = function()
      {
         //when state is completed i.e 4
         if (req.readyState == 4)
         {         
            // only if http status is "OK"
            if (req.status == 200)
            {                  
               document.getElementById('cur_code').value=req.responseText;                  
            }
            else
            {
               alert("There was a problem while using XMLHTTP:\n" + req.statusText);
            }
         }            
       }         
       req.open("GET", strURL, true);
       req.send(null);
   }         
}
</script>




</head>

<body style="font: 12px Verdana, Arial, Helvetica, sans-serif;">

<form style="text-align:center" method="post" action="" name="form1">
<p style="color:#000099 ">When you change the dropdown list, the respective currency code of the country will be displayed in the textbox which is fetched from PHP using Ajax. </p>
<p>Country : <select name="country" onChange="getCurrencyCode('find_ccode.php?country='+this.value)"

<?php

mysql_connect('localhost', '$user', '$password');

mysql_select_db('sok');

$result = mysql_query('select QuestID,QTitle, QDescrip from QuestList');

$options="";

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

    $QuestID=$row["QuestID"];
    $QTitle=$row["QTitle"];
    $options.="<OPTION VALUE=\"$QuestID\">".$QTitle;
}
?>
   <option value="">Select Country</option>
   <option value="1">USA</option>
   <option value="2">UK</option>
   <option value="3">Nepal</option>   
        </select><br/><br/>
 Currency :   <input type="text" name="cur_code" id="cur_code" ></p>
</form>
</body>
</html>

Index.php
<html>
<head>
<title>Changing textbox value based on dropdown list using Ajax and PHP</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script>
//  Developed by Roshan Bhattarai
//  Visit http://roshanbh.com.np for this script and more.
//  This notice MUST stay intact for legal use

//fuction to return the xml http object
function getXMLHTTP() {
      var xmlhttp=false;   
      try{
         xmlhttp=new XMLHttpRequest();
      }
      catch(e)   {      
         try{         
            xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
         }
         catch(e){
            try{
            xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
            }
            catch(e1){
               xmlhttp=false;
            }
         }
      }
          
      return xmlhttp;
   }
   
   
   
function getCurrencyCode(strURL)
{      
   var req = getXMLHTTP();      
   if (req)
   {
      //function to be called when state is changed
      req.onreadystatechange = function()
      {
         //when state is completed i.e 4
         if (req.readyState == 4)
         {         
            // only if http status is "OK"
            if (req.status == 200)
            {                  
               document.getElementById('cur_code').value=req.responseText;                  
            }
            else
            {
               alert("There was a problem while using XMLHTTP:\n" + req.statusText);
            }
         }            
       }         
       req.open("GET", strURL, true);
       req.send(null);
   }         
}
</script>

</head>

<body style="font: 12px Verdana, Arial, Helvetica, sans-serif;">

<form style="text-align:center" method="post" action="" name="form1">
<p style="color:#000099 ">When you change the dropdown list, the respective currency code of the country will be displayed in the textbox which is fetched from PHP using Ajax. </p>
<p>Quest : <select name="country" getCurrencyCode('find_ccode.php?country='+this.value)">'

<?php

mysql_connect('localhost', '$user', '$password');

mysql_select_db('sok');

$result = mysql_query('select QuestID,QTitle, QDescrip from QuestList');

$options="";

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

    $QuestID=$row["QuestID"];
    $QTitle=$row["QTitle"];
    $options.="<OPTION VALUE=\"$QuestID\">".$QTitle;
   
}

$myFile = "test_catchoption.txt";
$fh = fopen($myFile, 'w') or die("can't open file");   
fwrite($fh, $options);
fclose($fh);
?>

Choose your Quest
<?=$options?>
</SELECT>
 <br/><br/>
 Quest Description :   <input type="text" name="cur_code" id="cur_code" ></p>
</form>
</body>
</html>


find_ccode.php
<?php
// Developed by Roshan Bhattarai
// Visit http://roshanbh.com.np for this script and more.
// This notice MUST stay intact for legal use
$country=$_REQUEST['country'];
$myFile = "testFilefindcc.txt";
$fh = fopen($myFile, 'w') or die("can't open file");   
fwrite($fh, $country);
fclose($fh);
switch($country)
{
   case "1" :
   mysql_connect('localhost', '$user', '$password');
    mysql_select_db('sok');

$result = mysql_query("select * from QuestList where QuestID = '1'");
$row = mysql_fetch_assoc($result);
        echo $row['QDescrip'];
      break;
   case "2" :   
      echo "GBP";
      break;
   case "3" :   
      echo "NPR";
      break;
}
?>

Hey all,

This question is coming forth of another topic, but since that topic is not really about this issue, I posted this new topic.

Okay, so I made a table, and each row is generated with a WHILE loop.
In this while loop, there's also a form generated for each row/record, for updating them seperately.

I'm having trouble with naming those forms to process them seperately.
I could name them like name="form20110001", with the number being the record's id.
But since there can be gaps between id's, how can I retreive them efficiently?
And I want them to process all on a single process page, obviously.

How can I do this easily?
Can someone give me a concise example?
Would appreciate it a lot.
Thanks

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

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>

I want make the following,
(I have already a database with three tables (Countries, Timeline and Category)).

1: list of countries (drop down menu 1), Timeline of the countries history (drop down 2) and Category (drop down 3).
2: The selected values of the drop down menus must show take the information from the database.

Can any one help me with the coding?

Hello PHPfreaks!

I build a website for a company way back when I was still learning basic PHP! Now unfortunaly the webhost has decided to change their security settings, specifically chaning the allow_url_include and allow_fopen_include to off!

That however breaks the website that I did, since i am using the following code in calling the various menus around the website:
Code: [Select]
include(''$site_url'menu.php?menuid=1');
Now I am well aware that this is not the best way to include a menu! ohhh yeah btw, the code for the menu.php file is:
Code: [Select]
<?php

include('config.php');

$menuid = mysql_real_escape_string($_GET['menuid']);

$menu_categories = mysql_query("SELECT * FROM " .$db_prefix. "menucategories WHERE id='".$menuid."'");

while($menu_cat = mysql_fetch_array($menu_categories))
{
if($menu_cat['display_name'] == "")
{
$menu = mysql_query("SELECT * FROM " .$db_prefix. "menu WHERE cat = ".$menu_cat['id']." ORDER BY placement ASC");

echo "<ul>";


while($menu_rows = mysql_fetch_array($menu))
{
echo "<li><a href='" .$menu_rows['URL']. "' class='".$menu_cat['name']."' >" .$menu_rows['name']. "</a></li>";
}

echo "</ul>";
}
else
{
echo "<h4>" .$menu_cat['display_name']. "</h4>";

$menu = mysql_query("SELECT * FROM " .$db_prefix. "menu WHERE cat = ".$menu_cat['id']." ORDER BY placement ASC");

echo "<ul>";


while($menu_rows = mysql_fetch_array($menu))
{
echo "<li><a href='" .$menu_rows['URL']. "' class='".$menu_cat['name']."' >" .$menu_rows['name']. "</a></li>";
}

echo "</ul>";
}
}
?>

So i build the website so that you call the various menus around in the website using the menu.php include and setting a variable based on a ID (i.e menu.php?menuid=2) and of course using variables in the URL name you need to define a complete URL in the include, which now with the hosting companies new security policy doesn't work!

SO BASICALLY!

What I am trying to ask: Is there any alternative to include menu.php?menuid=XX without using the absolute URL?

Hi guys!

I need a php page that is splitted into 2 screens. One will display the navigation menu and the second one is the iframe.

As for the navigation menu, I am getting the list of all files in the current directory with readdir(). Then I create an array with all of the items that are folders (is_dir() function) and apply the same script on them. My problem is to correctly display all of the information I gather in an adequate manner. Can anyone help me with that? Also if anyone has ready-to-go scripts, I would highly appreciate that too.

Also, once a user choose a file, it should be loaded in the iframe. How do I specify "src" attribute for the iframe, in that case?

Thanks!