CODEWITHSUNDEEP
phphtmlmysqlajax
kancha
kancha

Reputation: 31

dynamic drop-down not working

I am trying to implement a dynamic drop-down list using Ajax and PHP. Based on the index value in the first option list, second one should give me list of names with that id.

select1.php : 

<html>
<head>
<link rel="stylesheet" type="text/css" href="select_style.css">
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">
function fetch_select(val)
{
 $.ajax({
 type: 'post',
 url: 'fetch1.php',
 data: {
  get_option:val
 },
 success: function (response) {
  document.getElementById("new_select").innerHTML=response; 
 }
 });
}

</script>

</head>
<body>
<p id="heading">Dynamic Select Option Menu Using Ajax and PHP</p>
<center>
<div id="select_box">
 <select onchange="fetch_select(this.value);">
  <option>Select ID</option>
  <?php
  $host = 'localhost';
  $user = 'admin';
  $pass = 'admin';
  $dbname='kancha';
  $conn = new mysqli($host, $user, $pass, $dbname);
  // Check connection
  if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
  } 

  $sql = "select distinct id from test";
  $select= $conn->query($sql);
  if ($select->num_rows > 0) {
    while($row = $select->fetch_assoc()) {
        echo "<option value='".$row['id']."'>".$row['id']."</option>";
       //echo "<option value=>".$row['id']."</option>";
    }
  } else {
    echo "0 results";
  }
  ?>
 </select>

 <select id="new_select">
 </select>

</div>     
</center>
</body>
</html>

fetch1.php 

<?php
if(isset($_POST['get_option']))
{
  $host = 'localhost';
  $user = 'admin';
  $pass = 'admin';
  $dbname='kancha';
  $conn = new mysqli($host, $user, $pass, $dbname);
  // Check connection
  if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
  } 

  $id = $_POST['get_option'];
  //echo '$id';
 $sql = "select id, name from test where id='$id'";;
 $find= $conn->query($sql);

 if ($find->num_rows > 0) {
    while($row = $find->fetch_assoc()) {
        //echo "<option>".$row['name']."</option>";
        echo "<option value='".$row['id']."'>".$row['name']."</option>";
    }
  } else {
    echo "0 results";
  }
 exit;
}
?>

My database looks something like this :

SELECT * from test; 
id  name
1   Name1
2   Name2
1   Name3

The first drop down works just fine. However the second drop down isn't working. I have attached the screenshot of it as well. Is there a problem in sending data across the files or what? Not able to figure out where has the code gone wrong.

For the second option list, when I have selected 1, I should be getting Name1 and Name3 as options but I get none. enter image description here

EDIT: Corrected javascript in select1.php

Upvotes: 0

Views: 111

Answers (2)

Karlo Kokkak
Karlo Kokkak

Reputation: 3714

You are setting the content for new_select with the wrong variable.

It should be response rather than val

Change to:

document.getElementById("new_select").innerHTML=response;

And assign value to your return options.

Like:

echo "<option value='".$row['id']."'>".$row['name']."</option>";

And change your sql string to the following for the above to work.

 $sql = "select id, name from test where id='$id'";

And make sure your jquery.js include is being loaded.

Upvotes: 1

Nagesh
Nagesh

Reputation: 437

Add value to the Option in selectbox, right now there is no value passing from the fetch_select()

Upvotes: 0

Related Questions