Submit ajax form without page refresh php

Question

I have this form and ajax call in my index.php-

 <form method='post' id='saleForm' >
    <input type='text' name='addCustomer' class='addInput' id='adlastname' placeholder='customer last name'>
    <input type='text' name='addYear' class='addInput'  id='adYear' placeholder='year'>
    <input type='text' name='addMake' class='addInput'  id='adMake' placeholder='make'>
    <input type='text' name='addModel' class='addInput'  id='adModel' placeholder='model'>
    <input type='text' name='addGross' class='addInput'  id='adGross' placeholder='front gross'>
    <input type='hidden' name='Id' value='<?php echo $id;?>'>
    <input type='submit' name='subSale'  id='subSale' value='Save' >
</form>

<script>
    $("form").submit(function(e) {
    var url = "add.php"; // the script where you handle the form input.

$.ajax({
       type: "POST",
       url: url,
       data: $("form").serialize(), // serializes the form's elements.
       success: function(data)
       {
           alert(data); // show response from the php script.
       }
     });

e.preventDefault(); // avoid to execute the actual submit of the form.
});
</script>

I am trying to submit it to the DB using add.php -

$cust = $_POST['addCustomer'];
$addMake = $_POST['addMake'];
$addModel = $_POST['addModel'];
$addYear = $_POST['addYear'];
$addGross = $_POST['addGross'];
$subSale = $_POST['subSale'];
$soldDate = date('m/d/yy');

if(isset($subSale)){
    $sql = "INSERT INTO `$sold_table` ( `Id`,`Customer`, `Year`, `Make`, `Model`, `FrontGross`, `SoldDate` ) VALUES (NULL,'$cust', '$addYear', '$addMake', '$addModel', '$addGross', '$soldDate')";
    if (mysqli_query($conn, $sql)) {
        echo 'success!';
    } else {
       echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
}

When I click the Save button it shows the empty alert and the data isnt getting pushed for some reason.. Any idea where I am going wrong here? i know the Insert is correct as it works when I dont use the ajax call and just use the form action..

Well, what did you expect the output to be? You're not echo-ing anything on success. So, does the data arrive in the database? — Digitalis
– Digitalis, Commented Nov 24, 2016 at 19:21
Also, I wouldn't pass an Id to an insert query, but instead have MySQL do an auto_increment. — Digitalis
– Digitalis, Commented Nov 24, 2016 at 19:22
I see the problem. The Ajax request doesn't use the subsale button. Since it is submitted by jQuery. — Digitalis
– Digitalis, Commented Nov 24, 2016 at 19:39

Digitalis · Accepted Answer · 2016-11-24 19:43:18Z

1

When using jQuery to submit the form, the submit button isn't used. Therefore it will turn up empty once PHP receives the posted data. Your script is checking $subSale to perform the query, which now fails.

Try to supply a hidden input with the name SubSale and it wil work again. Another solution is to remove this entire if statement, as per your own suggestion.

if(isset($subSale)){

answered Nov 24, 2016 at 19:43

Digitalis

5702 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Submit ajax form without page refresh php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related