Sending data to mysql using AJAX and PHP

Question

I am newbie to web programming. I would like to insert data into MySQL DB, for that I am using PHP and this data is coming from a form in a Bootstrap Modal. When I click the Savebutton, nothing is happening. I been following a this tutorial and I have done exactly that tutor is doing. What went wrong with my code?

HTML Code and JavaScript:

 <body>
<p><br/></p>
<div class="container">
  <p></p>
   <button class="btn btn-primary" data-toggle="modal" data-target="#addData">Insert data</button>

   <!-- Modal -->
      <div class="modal fade" id="addData" tabindex="-1" role="dialog" aria-labelledby="addLabel">
        <div class="modal-dialog" role="document">
          <div class="modal-content">
            <div class="modal-header">
              <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
              <h4 class="modal-title" id="addlLabel">Insert Data</h4>
            </div>
            <form>
            <div class="modal-body">

            <div class="form-group">
                <label for="nm">Name</label>
                <input type="text" class="form-control" id="nm" placeholder="Name here">
              </div>
              <div class="form-group">
                <label for="em">Email</label>
                <input type="email" class="form-control" id="em" placeholder="Email">
              </div>
              <div class="form-group">
                <label for="hp">Hone Number</label>
                <input type="number" class="form-control" id="hp" placeholder="Your Phone">
              </div>
              <div class="form-group">
                <label for="al">Address</label>
                <textarea class="form-control" id="al" placeholder="Your address"></textarea>
              </div>

            </div>
            <div class="modal-footer">
              <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
              <button type="submit" onclick="saveData()"class="btn btn-primary">Save</button>
            </div>
            </form>
          </div>
        </div>
      </div>
</div>

<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="js/jquery-3.1.1.min.js"></script>
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="js/bootstrap.min.js"></script>
<script>
  function saveData(){
    var name=$('#nm').val();
    var email=$('#em').val();
    var phone=$('#hp').val();
    var address=$('#al').val();

    $.aja({
       type:"post",
       url:"server.php?p=add",
       data:"nm="+name+"&em="+email+"&hp="+phone+"&al="+address,
       success: function(msg){
        alert('Success Insert data');
       }
    });

  }
</script>

PHP Code:

<?php 
$db=new PDO('mysql:host=localhost;dbname=ajax','root','');
$page=isset($_GET['p'])?$_GET['p']:'';

if($page=='add'){
 $name=$_POST['nm'];
 $email=$_POST['em'];
 $phone=$_POST['hp'];
 $address=$_POST['al'];
 $stmt=$db->prepare("insert into users values('',?,?,?,?)");
 $stmt->bindParam(1,$name);
 $stmt->bindParam(2,$email);
 $stmt->bindParam(3,$phone);
 $stmt->bindParam(4,$address);

 if ($stmt->execute()) {
    echo "Success";
 }else{
    echo "Fail".mysqli_error();
 }
}else if($page=='edit'){

}if($page=='del'){

}else{

 }
?>

I have used the development in Chrome, no error is being shown.

@Naincy I tried ` print_r($_POST);` it showed nothing that's why I realised the data was not being sent...but thanks for the tip. — CN1002
– CN1002, Commented Feb 19, 2017 at 10:02

Hikmat Sijapati · Accepted Answer · 2017-02-19 10:03:35Z

2

Typo error.You have $.ajx({}).It must be $.ajax({}).Also send your data in object format.like this..

 $.ajax({
       type:"post",
       url:"server.php?p=add",
       data:{nm:name,em:email,hp:phone,al:address},
       success: function(msg){
        alert('Success Insert data');
       }
    });

edited Feb 19, 2017 at 10:03

answered Feb 19, 2017 at 9:56

Hikmat Sijapati

6,9691 gold badge11 silver badges19 bronze badges

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

3 Comments

CN1002 Over a year ago

Why does the dev tools not complain or show it? Thanks that was the error. It is now working, will accept your answer

Hikmat Sijapati Over a year ago

See error on console tab.Sure there must be an error.

CN1002 Over a year ago

I agree it must show and error but when I putajx console shows nothing other than a a blue >

Collectives™ on Stack Overflow

Sending data to mysql using AJAX and PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related