Guest User

Untitled

a guest
Jun 20th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. <?php
  2. $conn = mysqli_connect("localhost", "root", "", "iraa");
  3. ?>
  4. Category :
  5. <select id="category_id" name="cat_id" required="" class="form-control" tabindex="2" onselect ="getSubcat()">
  6. <option value="">-- Select --</option>
  7. <?php
  8. $sql = "SELECT category_id,category_name FROM categories_master";
  9. $result = mysqli_query($conn, $sql);
  10. while ($data=mysqli_fetch_array($result)) {
  11. ?>
  12. <option value="<?php echo $data['category_id'] ?>"><?php echo $data['category_name'] ?></option>
  13. <?php } ?>
  14. </select>
  15.  
  16. Sub Category :
  17. <select id="sub_cat_id" required name="sub_cat_id" class="form-control " tabindex="2">
  18. <option value="">-- Select --</option>
  19. </select>
  20.  
  21. <script src="js/jquery-1.12.4.js"></script>
  22. <script src="//rawgithub.com/indrimuska/jquery-editable-select/master/dist/jquery-editable-select.min.js"></script>
  23. <link href="//rawgithub.com/indrimuska/jquery-editable-select/master/dist/jquery-editable-select.min.css" rel="stylesheet">
  24. <script type="text/javascript">
  25. $('#category_id').editableSelect();
  26. function getSubcat() {
  27. var category_id=$("#category_id").val();
  28. alert(category_id);
  29. $.ajax({
  30. url: 'get_subcategory.php',
  31. type: 'POST',
  32. data: {category_id: category_id},
  33. })
  34. .done(function(response) {
  35. $('#sub_cat_id').html(response);
  36. });
  37. }
  38. </script>
  39.  
  40. <?php
  41. $conn = mysqli_connect("localhost", "root", "", "iraa");
  42. $sql = "SELECT sub_category_id,sub_category_name FROM sub_categories_master WHERE category_id='$_POST[category_id]'";
  43. $result = mysqli_query($conn, $sql);
  44. while ($data=mysqli_fetch_array($result)) {
  45. ?>
  46. <option value="<?php echo $data['sub_category_id'] ?>"><?php echo $data['sub_category_name'] ?></option>
Add Comment
Please, Sign In to add comment