Insert data through ajax into mysql database

Question

Newsletter    lt form id  form-search  method  post  action   lt  php echo   SERVER  PHP SELF     gt   gt       lt span gt  lt span class  style2  gt Enter you email here lt  span gt   lt  span gt       lt input name  email  type  email  id  email  required  gt     lt input type  submit  value  subscribe  class  submit  onclick  return fun      gt                           lt  form gt                           lt  php mysql connect  localhost          mysql select db      error reporting E ALL  amp  amp   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       if   sql  die mysql error      mysql close       gt    But I want to insert my E-Mail to database through Ajax  I don t want my page to get redirected  because every time the page got refreshed  null value got inserted to the database     I just want my E-mail got inserted to database through Ajax  and after that the email box i e    lt input name  email  type  email  id  email  required  gt     lt input type  submit  value  subscribe  class  submit  onclick  return fun      gt    should get disappeared and there should be the line  you ve been successfully subscribed       Any brief code will be very useful   thank u in advance

User · Answer

The ajax is going to be a javascript snippet that passes information to a small php file that does what you want. So in your page, instead of all that php, you want a little javascript, preferable jquery:

function fun()
{
    $.get('\addEmail.php', {email : $(this).val()}, function(data) {
        //here you would write the "you ve been successfully subscribed" div
    });
}

also you input would have to be:

<input type="button" value="subscribe" class="submit" onclick="fun();" />

last the file addEmail.php should look something like:

mysql_connect("localhost","root","");
mysql_select_db("eciticket_db");

error_reporting(E_ALL && ~E_NOTICE);

$email=mysql_real_escape_string($_GET['email']);
$sql="INSERT INTO newsletter_email(email) VALUES ('$email')";
$result=mysql_query($sql);
if($result){
echo "You have been successfully subscribed.";
}
 if(!$sql)
die(mysql_error());

mysql_close();

Also sergey is right, you should use mysqli. That's not everything, but enough to get you started.

User · Answer

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    lt  php  if isset   REQUEST             mysql connect  localhost   root       mysql select db  eciticket db    error reporting E ALL  amp  amp   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          gt    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     lt  php if   POST  email              mysql connect  localhost   root           mysql select db  eciticket db        error reporting E ALL  amp  amp   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                     header  location yourphppage php               if   sql      die mysql error         mysql close        gt       lt  php if isset   COOKIE  msg       gt          lt span gt  lt  php echo   COOKIE  msg   setcookie  msg     time  -5        gt  lt  span gt        lt  php    gt   lt form id  form-search  method  post  action   lt  php echo   SERVER  PHP SELF     gt   gt       lt span gt  lt span class  style2  gt Enter you email here lt  span gt   lt  span gt       lt input name  email  type  email  id  email  required  gt       lt input type  submit  value  subscribe  class  submit   gt   lt  form gt

User · Answer

Why use normal jquery ajax feature  Why not use jquery ajax form plugin  which post the form data by ajax to the form action link    Check it here    http   malsup com jquery form  getting-started   It is very easy to use and support several data formats including json  html xml etc  Checkout the example and you will find it very easy to use   Thank you

User · Answer

The available answers led to the fact that I entered empty values into the database  I corrected this error by replacing the serialize    function with the following code     document  ready function        When click the button      button   click function             Assigning Variables to Form Fields     var email       email   val            Send the form data using the ajax method       ajax           data   email     email          type   post           url   your file php           success  function data               alert  Data Save      data

User · Answer

ajax     document  on  click    mv secure page  function e        var data       m form1   serialize          ajax           data  data          type   post           url   adapter php           success  function data           alert  Data      data                           php code    lt  php        Created by PhpStorm     User  Engg Amjad    Date  11 9 16    Time  1 28 PM       if isset   REQUEST        include once  inc system php          full name   POST  full name         business name   POST  business name         email   POST  email         phone   POST  phone         message   POST  message          sql  INSERT INTO mars  f n b n em p n msg  values   full name    business name    email    phone    message            sql result mysqli query  con  sql       if  sql result          echo  inserted successfully        else          echo  Query failed  mysqli error  con             gt

User · Answer

I will tell you steps how you can insert data in ajax using PHP  AJAX Code   lt script type  text javascript  gt  function insertData     var student name     student name   val    var student roll no     student roll no   val    var student class     student class   val         AJAX code to send data to php file        ajax           type   POST           url   insert-data php           data   student name student name student roll no student roll no student class s          tudent class           dataType   JSON           success  function data                 message   html data              p   addClass  alert alert-success                       error  function err            alert err                           lt  script gt    PHP Code    lt  php  include  db php     student name   POST  student name     student roll no   POST  student roll no     student class   POST  student class      stmt    DBcon- gt prepare  INSERT INTO  student student name student roll no student class   VALUES  student name   student roll no  student class        stmt- gt bindparam   student name    student name     stmt- gt bindparam   student roll no    student roll no     stmt- gt bindparam   student class    student class    if  stmt- gt execute          res  Data Inserted Successfully      echo json encode  res         else      error  Not Inserted Some Probelm occur      echo json encode  error              gt    You can customize it according to your needs  you can also check complete steps of AJAX Insert Data PHP

[php] Insert data through ajax into mysql database

Examples related to php

Examples related to ajax