Guest User

Untitled

a guest
Jan 21st, 2019
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. <script>
  2.  
  3. $(document).ready(function(){
  4. $.getJSON("getlist.php", function(return_data){
  5.  
  6. return_data.forEach(function(e,i){
  7. $('#catn').append('<option value= "'+e.catname+'">'+e.catname+'</option>');
  8. });
  9.  
  10. });
  11. });
  12.  
  13. $(document).ready(function(){
  14. $.getJSON("list2.php",{'catname':catname},function(return_data){
  15.  
  16. return_data.forEach(function(h,i){
  17. $('#scatn').append('<option value= "'+h.subcatname+'">'+h.subcatname+'</option>');
  18. });
  19.  
  20. });
  21. });
  22.  
  23. <?php
  24. $catname=$_GET['catname'];
  25. $conn =mysqli_connect("localhost", "root", "", "project");
  26.  
  27. $sql = "SELECT * FROM catd where catname='$catname'";
  28. $result = mysqli_query($conn, $sql);
  29.  
  30.  
  31. $scat_arr = array();
  32. while( $row = mysqli_fetch_array($result) )
  33. {
  34. $catid = $row['cid'];
  35. $catname = $row['catname'];
  36. $scat_arr[] = array("cid" => $catid, "catname" => $catname);
  37. }
  38. echo json_encode($scat_arr);
  39. ?>
Add Comment
Please, Sign In to add comment