Insert data through ajax into mysql database

by

Try this:

  $(document).on('click','#save',function(e) {
  var data = $("#form-search").serialize();
  $.ajax({
         data: data,
         type: "post",
         url: "insertmail.php",
         success: function(data){
              alert("Data Save: " + data);
         }
});
 });

and in insertmail.php:

<?php 
if(isset($_REQUEST))
{
        mysql_connect("localhost","root","");
mysql_select_db("eciticket_db");
error_reporting(E_ALL && ~E_NOTICE);

$email=$_POST['email'];
$sql="INSERT INTO newsletter_email(email) VALUES ('$email')";
$result=mysql_query($sql);
if($result){
echo "You have been successfully subscribed.";
}
}
?>

Don’t use mysql_ it’s deprecated.

another method:

Actually if your problem is null value inserted into the database then try this and here no need of ajax. 

<?php
if($_POST['email']!="")
{
    mysql_connect("localhost","root","");
    mysql_select_db("eciticket_db");
    error_reporting(E_ALL && ~E_NOTICE);
    $email=$_POST['email'];
    $sql="INSERT INTO newsletter_email(email) VALUES ('$email')";
    $result=mysql_query($sql);
    if($result){
    //echo "You have been successfully subscribed.";
              setcookie("msg","You have been successfully subscribed.",time()+5,"https://stackoverflow.com/");
              header("location:yourphppage.php");
    }
     if(!$sql)
    die(mysql_error());
    mysql_close();
}
?>
    <?php if(isset($_COOKIE['msg'])){?>
       <span><?php echo $_COOKIE['msg'];setcookie("msg","",time()-5,"https://stackoverflow.com/");?></span> 
    <?php }?>
<form id="form-search" method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
    <span><span class="style2">Enter you email here</span>:</span>
    <input name="email" type="email" id="email" required/>
    <input type="submit" value="subscribe" class="submit"/>
</form>

More Related Contents:

  1. I want to use jquery nested sortable plugin with drag and drop in codeigniter using mysqli
  2. how to send data from html form to php using ajax using upload also
  3. Calling a php script at the end of a js script
  4. How do I close a connection early?
  5. Simple jQuery, PHP and JSONP example?
  6. Passing JavaScript array to PHP through jQuery $.ajax
  7. How to show Ajax requests in URL?
  8. Prevent Direct Access To File Called By ajax Function [duplicate]
  9. Login without HTTPS, how to secure?
  10. jQuery – Call ajax every 10 seconds
  11. Creating jQuery AJAX requests to a PHP function
  12. Best way to transfer an array between PHP and Javascript [duplicate]
  13. Scaling a chat app – short polling vs. long polling (AJAX, PHP)
  14. Does php execution stop after a user leaves the page?
  15. Redirect with PHP after ajax call
  16. Download CSV file using “AJAX”
  17. jquery using ajax to send data and save in php [duplicate]
  18. laravel TokenMismatchException in ajax request
  19. Sending multiple data parameters with jQuery AJAX
  20. Refresh a table with jQuery/Ajax every 5 seconds
  21. How to make a Cascading Drop Down List in PHP using jQuery
  22. uploading a file via ajax with php
  23. allow cross domain ajax requests
  24. How to keep form values after post [duplicate]
  25. Setting a cookie in an AJAX request?
  26. Writing JSON object to .json file on server
  27. refresh a part of webpage in php [closed]
  28. Detect Ajax calling URL
  29. Add a quantity field to Ajax add to cart button on WooCommerce shop page
  30. PHP – Flushing While Loop Data with Ajax

Leave a Comment