When sending data via POST does not insert in the database

Question

When sending data via POST does not insert in the database

Navigation

#1 by (1 votes)

0

I have this form and script on a page:

<section class="hide-section" id="produto_1"> 
<form class="form-validate" id="feedback_form">
    <div class="campo">
        <fieldset> 
            <h1>
                <legend>
                    <center>
                        <strong>Produtos de Higiene</strong>
            </center>
        </h1><br> 
        </div>
        <fieldset class="grupo">
    <div class="campo">
            <strong><label for="Nome do Produto">Nome do Produto</label></strong> 
            <input type="text" id="DescricaoProd" name="DescricaoProd" required="" style="width:350px">
        </div>
    <div class="campo"> 
        <strong><label for="Unidade">Unidade</label></strong> 
            <input type="text" id="DescricaoUnid" name="DescricaoUnid" style="width:160px" required="" size="120">
        </div>
        </fieldset>
        <button class="btn btn-success btn_contact" type="button">Registo</button>
</form>
</section> 

<script type="text/javascript"> 
$(".btn_contact").click(function () {

                $.ajax({
                    type: "POST",
                    url: "./inserir",
                    data: $("#feedback_form").serialize(), // serializes the form's elements.
                    success: function (data)
                    {
                        if ($.trim(data) == 'true') {
                            $("#feedback_form").find('input').val(''); //clear text
                            $(".success_messages").removeClass('hide'); // success message
                        } else {
                            $(".error_message").removeClass('hide'); // error message
                        }
                    }
                });

            });
</script>

On the insert page I have this php code:

$name = isset($_POST["DescricaoProd"]) ? $_POST["DescricaoProd"] : '';
$unid = isset($_POST["DescricaoUnid"]) ? $_POST["DescricaoUnid"] : '';
if (!empty($name) && !empty($unid)) {  
    echo 'true';
} else {
    echo 'false';
}    

$sql = "INSERT INTO ProdHigieneteste (DescricaoProd,DescricaoUnid) 
VALUES ('$name','$unid')";
if ($conn->query($sql)) { // check for === TRUE is not necessary
   // either put the second query in here, or just enjoy the success
} else {
   // get the error, throw a message...
}
$sql1 = "INSERT INTO StockHigieneteste (DescricaoProd,DescricaoUnid) 
VALUES ('$name','$unid')";
if ($conn->query($sql1) === TRUE) {
    //Count total number of rows
    $rowCount = $query->num_rows;
} else {
    // get the error, throw a message...
}
$conn->close();

I was inserting into the database table and stopped inserting, but it also does not give any errors in the console. Can anyone help identify the problem?

php mysql html ajax wordpress

asked by anonymous 24.05.2018 / 17:55

1 answer

Parking class in Python Upload with jQuery

score 1 · Accepted Answer

I made some changes to your code

Script - I added dataType: "json",

$(".btn_contact").click(function () {

  $.ajax({
  type: "POST",
  url: "./inserir",
  data: $("#feedback_form").serialize(), // serializes the form's elements.
  dataType: "json",
      success: function (data)
      {
         if ($.trim(data) == 'true') {
           $("#feedback_form").find('input').val(''); //clear text
           $("#success_messages").removeClass('hide'); // success message
         } else {
           $("#error_message").removeClass('hide'); // error message
         }
      }
  });

});

In HTML - to show message

<div id="success_messages" class="hide">sucessso</div>
<div id="error_message" class="hide">erro</div>

CSS

.hide {
     display: none;
}

Insert page

$name = isset($_POST["DescricaoProd"]) ? $_POST["DescricaoProd"] : '';
$unid = isset($_POST["DescricaoUnid"]) ? $_POST["DescricaoUnid"] : '';

if (!empty($name) && !empty($unid)) {  
   echo json_encode("true");
} else {
    echo json_encode("false");
}

$conn = new mysqli ("localhost", "USUARIO", "SENHA", "nome_DB");

$sql = "INSERT INTO ProdHigieneteste (DescricaoProd,DescricaoUnid) 
VALUES ('$name','$unid')";
if ($conn->query($sql)) { // check for === TRUE is not necessary
   // either put the second query in here, or just enjoy the success
} else {
   // get the error, throw a message...
}

$sql1 = "INSERT INTO StockHigieneteste (DescricaoProd,DescricaoUnid) 
VALUES ('$name','$unid')";

$query = mysqli_query($conn, "SELECT * FROM StockHigieneteste");

if ($conn->query($sql1) === TRUE) {
    //Count total number of rows
    $rowCount = $query->num_rows;
} else {
    // get the error, throw a message...
}


$conn->close();

OBS: In the insert page you forgot to make a SELECT to be able to return the total number of lines

If with the above fixes continues to give problems, and since it is a local server, your problem may be in the mysql workbench. Restart the mysql workbench.