Dependent dropdown using ajax

-
index.php



    <!DOCTYPE html>
    <html>
    <head>
        <title></title>

        <link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.min.css">
    </head>
    <body>
    <div class="container" style="margin-top: 70px;">

    <div class="row">
    <div class="col-md-3"></div>
    <div class="col-md-6">
                    <form  action="insert.php" method="post">

                    <div class="form-group">
    <label for="exampleInputEmail1">Department</label>
    <input type="text" name="department" class="form-control" placeholder="Department">
  </div>
  <div class="form-group">
    <label for="exampleInputPassword1">Subject</label>
        <input type="text" name="subject" class="form-control" placeholder="Subject">

  </div>

  <input type="submit" class="btn btn-primary" name="submit" value="Submit">

                    </form>
<br><br>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
  $("select.c").change(function(){
        var s = $(".c option:selected").val();
       
        $.ajax({
            type: "POST",
            url: "process.php",
            data: { c : s  }
        }).done(function(data){
            $("#sub").html(data);
        });
    });
});
</script>


<select class="c form-control" name="state">
                <option >Select Department</option>
                <?php
                    $con = mysqli_connect("localhost","root","root","drop") or die(mysqli_error());
                    $query = mysqli_query($con,"select DISTINCT department from form1") or die(mysqli_error($con));
                    while($row=mysqli_fetch_assoc($query)){
                        extract($row);

                        echo "<option value='$department'>$department</option>";
                    }


                ?>

            </select><br>

            <select class="form-control" id="sub" name="crop">
                <option>Select Subject</option>

            </select>




                    </div>
                    <div class="col-md-3"></div>




                    </div>
<br><br>


                    <script type="text/javascript" src="bootstrap/js/bootstrap.min.js"></script>
    </body>
    </html>








process.php

<?php
if(isset($_POST["c"])){
    // Capture selected country
   // $type= $_POST["c"];
     $str = $_POST['c'];
               
     $con = mysqli_connect("localhost","root","root","drop") or die("Some error occurred during connection " . mysqli_error($con)); 


      ?>
     
      <?php   
      //@mysqli_query($con,"SET NAMES 'utf8'",$id);
      $sql='select DISTINCT subject from form1 where department="'.$str.'"';
       $select=mysqli_query($con,$sql);
     while($sele=mysqli_fetch_array($select))
{
    echo"<option value=\"{$sele['subject']}\">{$sele['subject']}</option>";


    }   
       
}


?>
insert.php

<?php
$con = mysqli_connect("localhost","root","root","drop") or die(mysqli_error());


if(isset($_POST['submit'])){


    extract($_POST);

    $query = mysqli_query($con,"insert into form1(department,subject) values('$department','$subject') ") or die(mysqli_error($con));

    if($query){

    echo "<script>

        alert('Data inserted successfully');
        window.location.href='index.php';

    </script>";
    }
    else
    {
        echo "<script>

        alert('Data  not inserted ');
        window.location.href='index.php';

    </script>";
    }
}



 ?>

Comments

Post a Comment

Popular posts from this blog

How to Delete record using PHP Ajax

-
index.php ?   01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 <!DOCTYPE html> <html> <head>      <title></title> </head> <body>   <?php        $connection = mysqli_connect( "localhost" , "root" , "" , "db_2018" ) or die (mysqli_error());        $ReadSql = "SELECT * FROM `crud`" ;      $res = mysqli_query( $connection , $ReadSql );   ?>     <table>      <tr>          <th>name</th>          <th>Last Name</th>          <th>email id</th>     ...
Read more

How to seperate character from string in php

-
?   1 2 3 4 5 6 7 8 9 $string = "abcdef" ; $result =[]; $strlen = strlen ( $string ); for ( $i =0; $i < $strlen ; $i ++) {      $result [ $i ]= $string [ $i ];   } print_r( $result );     $string = "abcdef"; $result=[]; $strlen = strlen($string); for($i=0;$i<$strlen;$i++) { $result[$i]=$string[$i]; } print_r($result);
Read more
-
 <?php function numberToWords($num) {     $ones = array(         0 => "zero",         1 => "one",         2 => "two",         3 => "three",         4 => "four",         5 => "five",         6 => "six",         7 => "seven",         8 => "eight",         9 => "nine",         10 => "ten",         11 => "eleven",         12 => "twelve",         13 => "thirteen",         14 => "fourteen",         15 => "fifteen",         16 => "sixteen",         17 => "seventeen",         18 => "eighteen",         19 => "nineteen"   ...
Read more