javascript - 动态表单并通过jquery和ajax发送到mysql

Question

我已经问过一些关于这个的问题，我得到了帮助，但是他们说只有在表单正常的情况下才有效，输入名称为“这里的东西”，我的表单只有一个输入“文本”名称“table”要放置的表号，表格的其余部分来自 mysql ajax。我的问题是如何将此表单传递到数据库，因为它是动态的？我的代码如下。

我的表格

<div class="well">


                <!-- left -->
                <div id="theproducts" class="col-sm-5">
                </div>
                <!-- left -->
                <form method="post" action="relatorio.php" id="formRel">
                <span>Mesa</span>
         <input type="text" id="numero_mesa" name="numero_mesa">
                <input type="text" id="theinputsum">

                <!-- right -->
                <div id="thetotal" class="col-sm-7">
                   <h1 id="total"></h1>
                   <button type="submit" class="btn btn-lg btn-success btn-block"><i class="fa fa-shopping-cart" aria-hidden="true"></i> Finalizar Pedido</button>
                </form>
                </div>
               <!-- right -->


            </div>

以及 JavaScript 代码。

<script>
$('#formRel').submit(function(event){
        event.preventDefault();
        var formDados = new FormData($(this)[0]);
$.ajax({
  method: "POST",
  url: "relatorio.php",
  data: $("#formRel").serialize(),
  dataType : "html"
})
};
 </script>

插入查询是这样的。

<?php
error_reporting(-1);
ini_set('display_errors', 'On');


//Criar a conexao
$link = new mysqli ("localhost", "root", "", "restaurant");
if($link->connect_errno){
     echo"Nossas falhas local experiência ..";
     exit();
}
//echo "<pre>"; print_r($_POST); exit;
$mesa = $_POST['numero_mesa'];
$pedido = $_POST['products'];
$preco = $_POST['products'];


$sql = "INSERT INTO spedido ('pedido','preco','numero_mesa') VALUES ('$mesa','$pedido','$preco')";

$link->query($sql);





?>

enter image description here

Answer 1

<script>
$(document).on('submit', '#formRel', function(event) {
    event.preventDefault();
    var numero_mesa = $('#numero_mesa').val();
    $.ajax({
        type: "POST",
        url: "relatorio.php?",
        data: "numero_mesa="+ numero_mesa+
        "&products="+ products,
        success: function (data) {
            alert(data) // this will send you a message that might help you see whats going on in your php file
        });
    })
};
</script>