Advertisement
Guest User

Untitled

a guest
Jan 19th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.78 KB | None | 0 0
  1. <form class="form-horizontal" method= "POST">
  2. <div class="control-group">
  3. <div class="inc">
  4. <div class="controls">
  5. <button style="margin-left: 50px" class="btn btn-info" type="submit" id="append" name="append">
  6. Add Textbox</button>
  7. <br>
  8. <br>
  9. </div>
  10. </div>
  11. <input type="submit" class="btn btn-info" name="submit" value="submit"/>
  12. </div>
  13. <?php
  14. $host = "localhost";
  15. $dbname = "lala";
  16. $user = "root";
  17. $pass = "";
  18. $conn = new PDO("mysql:host=$host; dbname=$dbname", $user, $pass);
  19. if (isset($_POST['submit'])) {
  20.  
  21.  
  22. $color = $_POST['color'];
  23. $price = $_POST['price'];
  24. $size = $_POST['size'];
  25. $quantity = $_POST['quantity'];
  26. foreach ($color as $colors ) {
  27. foreach ($price as $prices ) {
  28. foreach ($size as $sizes ) {
  29. foreach ($quantity as $quantities ) {
  30. $sql = "INSERT into sasa (color,price,size,quantity) values('$colors','$prices','$sizes','$quantities)";
  31. echo $sql . "<br>";
  32. $q = $conn->query($sql);
  33. }
  34. }
  35. }
  36. }
  37.  
  38. }
  39.  
  40. ?>
  41.  
  42. <script type="text/javascript">
  43. $(document).ready(function () {
  44.  
  45. $("#append").click(function (e) {
  46. e.preventDefault();
  47. var textboxes = $(".textbox").length;
  48. if (textboxes < 5) {
  49. $(".inc").append("<div class='controls'><input class='textbox form-control' type='text' name='color[]'><input class='textbox form-control' type='text' name='price[]' ><input class='textbox form-control' type='text' name='size[]'><input class='textbox form-control' type='text' name='quantity[]'><a href='#' class='remove_this btn btn-danger'>remove</a> </div>");
  50. }
  51. });
  52.  
  53. $(document).on('click', '.remove_this', function (e) {
  54. e.preventDefault();
  55. $(this).parent().remove();
  56. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement