Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form class="form-horizontal" method= "POST">
- <div class="control-group">
- <div class="inc">
- <div class="controls">
- <button style="margin-left: 50px" class="btn btn-info" type="submit" id="append" name="append">
- Add Textbox</button>
- <br>
- <br>
- </div>
- </div>
- <input type="submit" class="btn btn-info" name="submit" value="submit"/>
- </div>
- <?php
- $host = "localhost";
- $dbname = "lala";
- $user = "root";
- $pass = "";
- $conn = new PDO("mysql:host=$host; dbname=$dbname", $user, $pass);
- if (isset($_POST['submit'])) {
- $color = $_POST['color'];
- $price = $_POST['price'];
- $size = $_POST['size'];
- $quantity = $_POST['quantity'];
- foreach ($color as $colors ) {
- foreach ($price as $prices ) {
- foreach ($size as $sizes ) {
- foreach ($quantity as $quantities ) {
- $sql = "INSERT into sasa (color,price,size,quantity) values('$colors','$prices','$sizes','$quantities)";
- echo $sql . "<br>";
- $q = $conn->query($sql);
- }
- }
- }
- }
- }
- ?>
- <script type="text/javascript">
- $(document).ready(function () {
- $("#append").click(function (e) {
- e.preventDefault();
- var textboxes = $(".textbox").length;
- if (textboxes < 5) {
- $(".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>");
- }
- });
- $(document).on('click', '.remove_this', function (e) {
- e.preventDefault();
- $(this).parent().remove();
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement