Forum:

Populate company details after click subcategory

Greenhorn

Posts: 2

posted 8 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Marshal

Posts: 6037

429

I like...

posted 8 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Do you have a question?

Tim Driven Development | Test until the fear goes away

Jesper de Jong

Java Cowboy

Posts: 16084

I like...

posted 8 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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 8 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Don't count your weasels before they've popped. And now for a mulberry bush related tiny ad:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders