Guest User

Untitled

a guest
Feb 22nd, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. <form method="post">
  2.  
  3. <select id="cat_sub_cat">
  4.  
  5. <?php
  6. $data=mysqli_query($con,"SELECT * FROM category");
  7. while($row=mysqli_fetch_array($data))
  8. {
  9. echo "<option value=".$row['cid'].">".$row['category']."</option>";
  10. }
  11.  
  12. ?>
  13.  
  14. </select><br><br>
  15.  
  16. <h3>Add Sub Categories</h3><br>
  17.  
  18. <input type="text" name="sub_cat"><br><br>
  19. <input type="submit" name="submit" value="Insert" id="sub_cat_btn">
  20. </form>
  21.  
  22. $(document).on('click','#sub_cat_btn', function(event){
  23. event.preventDefault();
  24.  
  25. $.ajax({
  26. url:"sub_cat_add_back.php",
  27. method:"post",
  28. data:$('form').serialize(),
  29. dataType:"html",
  30. success:function(strMsg){
  31. $("#cat_sub_msg").html(strMsg);
  32.  
  33. }
  34.  
  35. })
  36.  
  37. <?php
  38.  
  39. include "../includes/config.php";
  40.  
  41.  
  42. $name=$_POST['sub_cat'];
  43. $cid=$_POST['cat_sub_cat'];
  44.  
  45.  
  46. $data=mysqli_query($con,"INSERT INTO subcategory (name,cid) VALUES ('$name','$cid')");
  47. if($data=="true")
  48. {
  49. echo "Successfully Inserted";
  50. }
  51. else
  52. {
  53. echo "Error";
  54. }
  55.  
  56.  
  57. ?>
Add Comment
Please, Sign In to add comment