Forum:

Populate company details after click subcategory

Greenhorn

Posts: 2

posted 3 years ago

index.php

<?php
include("Config.php");
$sql = "SELECT * FROM category ORDER BY CategoryDetails ASC";
$countries = $dbo->query($sql);
?>

<!DOCTYPE html>
<html lang="en">
   <head>
      <meta charset="UTF-8">
      <title>Dropdown list example</title>
      <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
      <link rel="stylesheet" href="style.css">
      <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
      <script>
         function getStates(CategoryID){
            $("#state").show();
            $("#stateDropdown").html('<option>Loading...</option>');
            $.ajax({
               method: "POST",
               url: "getStates.php",
               dataType: "html",
               data: {category: CategoryID}
            })
               .done(function(data){
               $("#stateDropdown").html(data);
            });
         }  
         
      </script>
   </head>
   <body>
       <style>#state {
   display: none;
}</style>
      <div class="container">
         <form class="form-horizontal">
            <div class="form-group">
               <label for="category" class="col-sm-2 control-label">Category:</label>
               <div class="col-sm-4">
                  <select class="form-control" id="category" onChange="getStates(this.value)">
                     <option value="">Select Category</option>
                     <?php
                     foreach($countries as $category){
                        echo "<option value='" . $category['CategoryID'] . "'>" . $category['CategoryDetails'] . "</option>";
                     }
                     ?>
                  </select>
               </div>
            </div>
            <div class="form-group" id="state">
               <label for="state" class="col-sm-2 control-label">Sub Category:</label>
               <div class="col-sm-4">               
                  <select class="form-control" id="stateDropdown">
                  </select>
               </div>
            </div>
         </form>
      </div>
   </body>
</html>

getstates.php

config.php

sample-page.jpg

Tim Cooke

Sheriff

Posts: 4860

317

I like...

posted 3 years ago

Do you have a question?

Tim Driven Development

JUnit 5 (verified skill)
Skill verified by Campbell Ritchie

Java 8 (verified skill)
Skill verified by Tim Cooke

Jesper de Jong

Java Cowboy

Posts: 16084

I like...

posted 3 years ago

Welcome to the Ranch.

Please explain what exactly your question is - you've posted some code, but from just a bunch of code and a few words it's hard to understand why you are posting this and what you exactly want to know.

Jesper's Blog - Pluralsight Author Page

Gautam Bose

Greenhorn

Posts: 2

posted 3 years ago

I already populate category and subcategory drop down. Now what i want when I click on subcategory corresponding company details will come from company database.I enclosed one image.like that table I want a company details after click subcategory

F is for finger. Can you stick your finger in your nose? Doesn't that feel nice? Now try this tiny ad:

Thread Boost feature

https://coderanch.com/t/674455/Thread-Boost-feature