Learn VBA & Macros in 1 Week!

PHP - Moved: Two Dependent Select Menus

Full Excel VBA Course - Beginner to Expert

Moved: Two Dependent Select Menus	View Content

This topic has been moved to JavaScript Help.

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

Full Excel VBA Course - Beginner to Expert

Help With Dependent Select Lists

Similar Tutorials

View Content

Thanks in advance for any help that you may be able to provide. I'm a graphic designer with VERY limited knowledge of php, javascript, etc. I'm trying to create a form on my company's website that will allow customers to view specifications for particular products. I'm trying to use selection boxes to narrow the customer's search, with the selection from the second box dependent on the first, and the resulting information displayed dependent on the choice from the second list.

So far, I've only been able to adapt some code I found in a tutorial to display the data in the first selection box. No matter what I've tried, I can't seem to get any information to display in the second box, let alone information that is dependent on the first selection. I am brand new to php and javascript, and I didn't even know AJAX, JSON, or JQuery even existed until only a few days ago. Below is the three php files I'm using to try and make this work. If someone could point out what is wrong with it, I would be eternally grateful.

Here is the code from db.php, the file I'm using to connect to my database:

Code: [Select]
<?php
/*changing "db_username" to "root", changing "db_password" to "xxXXXX", changing "database" to "trailers" */
mysql_connect("localhost", "root", "xxXXXX") or die(mysql_error());
mysql_select_db("trailers") or die(mysql_error());
?>
Here is the code from func.php, the file with all the functions and database queries:

Code: [Select]
<?php
//**************************************
//     Page load dropdown results - changing tier_one to tnttrailer_brand, changing two_drops to trailerquote, changing 'tier_one' to 'tnttrailer_brand'     //
//**************************************
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT tnttrailer_brand FROM trailerquote")
or die(mysql_error());

  while($tier = mysql_fetch_array( $result ))

{
   echo '<option value="'.$tier['tnttrailer_brand'].'">'.$tier['tnttrailer_brand'].'</option>';
}

}

//**************************************
//     First selection results - changing two_drops to trailerquote, changing tier_one to tnttrailer_brand, changing 'tier_two' to 'trailer_description',     //
//**************************************
if($_GET['func'] == "drop_1" && isset($_GET['func'])) {
   drop_1($_GET['drop_var']);
}

function drop_1($drop_var)
{
    include_once('db.php');
$result = mysql_query("SELECT trailer_description FROM trailerquote WHERE tnttrailer_brand='$drop_var'")
or die(mysql_error());

echo '<select name="tier_two" id="tier_two">
      <option value=" " disabled="disabled" selected="selected">Choose one</option>';

   while($drop_2 = mysql_fetch_array( $result ))
{
  echo '<option value="'.$drop_2['trailer_description'].'">'.$drop_2['trailer_description'].'</option>';
}

echo '</select> ';
    echo '<input type="submit" name="submit" value="Submit" />';
}
?>
Finally, this is the code from index.php, the file with the form, javascript and the AJAX:

Code: [Select]
<?php
  include('db.php');
  include('func.php');
?><!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>Chained Select Boxes using PHP, MySQL and jQuery</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>

<script type="text/javascript">
$(document).ready(function() {
$('#wait_1').hide();
$('#drop_1').change(function(){
$('#wait_1').show();
$('#result_1').hide();
$.get("func.php", {
func: "drop_1",
drop_var: $('#drop_1').val()
}, function(response){
$('#result_1').fadeOut();
setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
});
return false;
});
});

function finishAjax(id, response) {
$('#wait_1').hide();
$('#'+id).html(unescape(response));
$('#'+id).fadeIn();
}
</script>
</head>

<body>
<p>
<form action="" method="post">

<select name="drop_1" id="drop_1">

<option value="" selected="selected" disabled="disabled">Select a Category</option>

<?php getTierOne(); ?>

</select>

<span id="wait_1" style="display: none;">
<img alt="Please Wait" src="ajax-loader.gif"/>
</span>
<span id="result_1" style="display: none;"></span>

</form>
</p>
<p>
<?php if(isset($_POST['submit'])){
$drop = $_POST['drop_1'];
$tier_two = $_POST['trailer_description'];
echo "You selected ";
echo $drop." & ".$tier_two;
}
/* changed 'tier_two' to 'trailer_description' */
?>
</body>
</html>
Here's the page on my website. I'm using Joomla for my website, and the above php is loaded into a module at the bottom of the page:

http://www.tnttrailer.com/index.php/dimensions.html

Dynamic Dependent Select Box With One Table

Similar Tutorials

View Content

I have a table in a database that I need to filter upon using dependent select boxes. The database was poorly designed and would be difficult to break into separate tables without affecting code written in other places. I have found some good code and understanding of how to implement the dependent select boxes if you have two tables with one column functioning as a lookup value between the two.

I have provided a short bit of sql of what the table looks like with some column names changed. I would need to first sort by lastname and have firstname dependent on the selection of lastname. Any help would be greatly appreciated.

Code: [Select]
create table `user` (
`id` int(3) Not Null Auto_increment,
`firstname` varchar (60),
`lastname` varchar (24),
`age` double ,
`hometown` varchar (75),
`job` varchar (75),
`birthdate` date
);
insert into `user` (`id`, `firstname`, `lastname`, `age`, `hometown`, `job`, `birthdate`) values
('1','Peter','Griffin','41','Quahog','Brewery','1960-01-01'),
('2','Lois','Griffin','40','Newport','Piano Teacher','1961-08-11'),
('3','Joseph','Swanson','39','Quahog','Police Officer','1962-07-23'),
('4','Glenn','Quagmire','41','Quahog','Pilot','1960-02-28'),
('5','Megan','Griffin','16','Quahog','Student','1984-04-24'),
('6','Stewie','Griffin','2','Quahog','Dictator','2008-03-03');

[help] Dynamic Dependent Select Boxes

Similar Tutorials

View Content

Brand new to the forum, and have only been working with HTML, PHP, & MySQL for about 3 months.

I've run into an issue I can't seem to figure out how to work around. I want to have two select boxes, that are dependent on one another.

For Example:

First box lists types of games:

RPG
LARP
Board Game
Miniatures
CCG

The second box displays game names of the type selected above.

I have a MySQL table setup for the second box. To be honest I kinda already have it working... with one small but MAJOR glitch.

I select the first box and the page submits using onchange='this.form.submit()'. When the page reloads the first select box reverts back to it's default setting, but the second box does correctly filter & show the content based on the selection that was made in the first box.

My Question:

How do I set this up so that the first box displays the user selected setting while also passing the $_POST information to the second box?

My Code:

<table>
<tr>
<td width=50%>
Game Type:
</td>
<td width=50%>
<form name='game_type' action='event_submit.php' method='post'>
<select name='game_type' align=center onchange='this.form.submit()' style="width:150px;margin:5px 0 5px 0;">
<option value=''>Chose a Game Type</option>
<option value='RPG'>RPG</option>
<option value='LARP'>LARP</option>
<option value='Board Game'>Board Game</option>
<option value='CCG'>Collectable Cards & Games</option>
<option value='Miniatures'>Miniatures</option>
</select>
</form>
</td>
</tr>
<tr>
<td width=50%>
Game System:
</td>
<td width=50%>

   <?php


   $game_type = $_POST['game_type'];

   echo "$game_type";

      if (!$con)
        {
        die('Could not connect: ' . mysql_error());
        }

      mysql_select_db("DrowCon", $con);

      $result = mysql_query("SELECT * FROM Games WHERE Type='$game_type' ORDER BY System ASC");



     echo "<form name='game_system' action='event_submit_form.php' method='post'>";
      echo "<select name='game_system' align=center style='width:150px;margin:5px 0 5px 0;'>";
      echo "<option value=''>Chose a Game System</option>";
      while($row_game = mysql_fetch_array($result))
        {
        echo "<option value=''>".$row_game['System']."</option>";
        }
      echo "</form>";

      mysql_close($con);
   ?>
</td>
</tr>
</table>

Dynamic Dependent Select Boxes With Php & Mysql

Similar Tutorials

View Content

Dear Support,

Here is my code:

<?php
    if ( strtolower($_SERVER['REQUEST_METHOD']) === 'post' ) {
        $name = isset($_POST['name]) ? htmlspecialchars($_POST['name']) : "";
$area = isset($_POST['area']) ? htmlspecialchars($_POST['area']) : "";
                $choice = isset($_POST['choice ']) ? htmlspecialchars($_POST['choice ']) : "";

          //Do Others
          }
?>

<form class="customersForm" method="post">
        <div class="">
  <p>Name<br />
       <select style="width:120px;" name="name">
          <?php
                               $sql = "select * from `name_info` order by `name`";
                               $query = mysql_query($sql);
                       $dd = '<option>Name</option>';
                               while($row = mysql_fetch_object($query)) {
                                    $dd .= '<option>'.$row->name.'</option>';
                               }
               echo $dd;
          ?>
      </select>
     </p>
  </div>

             <div class="">
  <p>Area<br />
       <select style="width:120px;" area="area">
          <?php
                               $sql = "select * from `area_info` order by `area`";
                               $query = mysql_query($sql);
                       $dd = '<option>Area</option>';
                               while($row = mysql_fetch_object($query)) {
                                    $dd .= '<option>'.$row->area.'</option>';
                               }
               echo $dd;
          ?>
      </select>
     </p>
  </div>

            <div class="">
  <p>Choice<br />
       <select style="width:120px;" choice="choice">
          <?php
                               $sql = "select * from `choice_info` where `name`='".$name."' and `area`='".$area."' order by `choice`";
                               $query = mysql_query($sql);
                       $dd = '<option>Choice</option>';
                               while($row = mysql_fetch_object($query)) {
                                    $dd .= '<option>'.$row->choice.'</option>';
                               }
               echo $dd;
          ?>
      </select>
     </p>
  </div>

......//Others input fields ...some text fields ...

</ form>

I have the above code, where I would like to show the choice Drop-down box, depends on $name and $area match of the choice_info table. $name field and $area field needs to have any dependency and straight from the MySQL table. But, choice needs to depend on $name & $area. How can I do it without much using Javacript? I do not mind to use JavaScript, but prefer to minimal.

By the way, I will have some other input fields too. It's an input form but, one drop-down box will be depends on two others choice.

Thanks for your help.

Select Menus

Similar Tutorials

View Content

So I have the following code, which is supposed to get the value selected by the user, then on submitting, will use that value in the URL.

Code: [Select]
$durations = array("1", "2", "3", "4", "5", "7", "10", "10000000");

echo "Choose Duration: ";?><form method="post" action=""><select name="duration_chosen">
<?
foreach($durations as $duration){
?><option name="duration_len" value="<?php echo $duration;?>"> <?
if ($duration == "10000000") {
echo "Forever";
} else {
echo "$duration day(s)";
}
?></option><?
}
?>
</select></form><?
$hrs = $_GET['duration_len'] * 24;
$duration_chosen = $_POST['duration_chosen'];
?>
<form method="get" action="index.php">
<input type="hidden" name="duration" value="<? echo $duration_chosen; ?>">
<input type="submit" value="Accept"></form>

For some reason, though, it doesn't work.
Can anyone help me?

Thanks,
Mark

Dynamic Select Menus

Similar Tutorials

View Content

I want to create 2 select menus - one static (Menu 1) and the other (Menu 2) populated according to the selection made in Menu 1.
Data will will be pulled from a CSV file.

Menu 2 will not have any values in it until an option from Menu 1 has been selected. Then, the options available will be limited based on the Item 1 selection.
PHP must be used to read the CSV file and to capture the data (using arrays)

I met this problem before and my approach then was to call a function using the onChange event for Menu1 ...

<script type = "text/javascript">function update_select(obj){
window.location.href="./call_stats_main.php?choice=" + obj.value;}
</script>

onchange="update_select(this)

This would reload the page passing a parameter to the URL (?choice=)

I could then use $_GET['choice'] to capture the selected value and dynamically populate Menu 2 according to this value.

It is the onchange event that triggers the population of menu 2.

I would like to know IF THERE IS A BETTER WAY, other than using ajax ?

Steven M

Moved: <select> Help

Similar Tutorials

View Content

This topic has been moved to Ajax Help.

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

Moved: Select Count

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Help Using Distinct With Select *

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Mysql Select After A Certain Id?

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Select Options

Similar Tutorials

View Content

This topic has been moved to Ajax Help.

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

Moved: Select From 2 Tables? Help.

Similar Tutorials

View Content

This topic is now in MySQL Help.

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

Moved: <select> And Onchange

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

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

Moved: Select By Id And Date?

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Insert Select

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Select Where Id Equals

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Select All Elements Except Some

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

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

Moved: Select All Checkboxes

Similar Tutorials

View Content

This topic has been moved to JavaScript Help.

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

Moved: Using Select Queries Within A Count()

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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

Moved: Select All Records Of A Given Month

Similar Tutorials

View Content

This topic has been moved to MySQL Help.

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