updating database with ajax not working

Question

i have little trouble with updating database by ajax , but i couldnt make it to work. i dont know what im doing wrong.

here my php file (sendata.php)

  <?php
       if ( isset($_POST['register']) && $userid != 0) 
         {$register = $_POST['register'] ;

            $sql2 =$db->setQuery("INSERT INTO ....  ");
                   $db->query() ;
           }

   ?>

and here my javascript code

$(document).ready(function() {
    $('#register').click(function() {

        $.ajax({

            url: "sendata.php",
            data: {
                age: $('#age').val()
            },
            type: 'POST',

            success: function(msg) {
                alert("Data has been saved succefully");
                $('#mydata').html("<b> age: </b>" + age);
            }
        });

        return false;
    });
});

what is heppening to me is when register button is clicked i get only the alert , that data is saved succefully but when i go to database and see , there is no record at all there. im doing something wrong ?

EDIT :

this my button

     <input type="submit" id="register" name="register" value="Save my Data" />

Díd you define variable weight anywhere? Díd you check if database connection is correct in your php function? What is your complete query? — Cesar Ortiz
– Cesar Ortiz, Commented Nov 19, 2012 at 20:02

ThiefMaster · Accepted Answer · 2012-11-20 23:45:41Z

1

sendata.php checks to see if 'register' is set: if ( isset($_POST['register']) ...) So you must SET the variable 'register' in your request (I fixed the code - see bold):

$(document).ready(function() {
    $('#register').click(function() {

        $.ajax({

            url: "sendata.php",
            data: {
                age: $('#age').val(),
                register: "register"
            },
            type: 'POST',

            success: function(msg) {
                alert(msg);
                $('#mydata').html("<b> age: </b>" + age);
            }
        });

        return false;
    });
});

sendata.php

if ( isset($_POST['register']) && $userid != 0) 
{
     $register = $_POST['register'] ;
     $sql2 =$db->setQuery("INSERT INTO ....  ");
     $db->query() ;
     echo "SUCCESS";
     exit(0);
 } 
 echo "FAILURE";

edited Nov 20, 2012 at 23:45

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

answered Nov 19, 2012 at 19:58

alanmanderson

8,31012 gold badges56 silver badges89 bronze badges

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

11 Comments

echo_Me Over a year ago

"register=something" ? what something ?this register is submit button , so what can be something pls?

echo_Me Over a year ago

it saids FAILURE the success message. but i have done register : "register" and i dont know what should be there as you mentioned by doing something

alanmanderson Over a year ago

#register might be a submit button, but you are not submitting the form. Ajax is an asynchronous request that runs in javascript before the form is submitted. You are sending a request to "sendata.php" and you are setting all of the data in the data part of the ajax request. However on sendata.php you are checking "isset($_POST["request"]). If you don't set it then isset() will return false. And you can set it to be anything, in my code snippet I put register : "register".

echo_Me Over a year ago

u mean i remove isset($_POST["request"]) from php file ? i dont get really what u want say , anyway i tried by this register : "register" but didnt work . i edited my post and added my button html

alanmanderson Over a year ago

I edited my code to make it more clear. Copy the code above... I added 5 total lines.

|

Jean G.T · Accepted Answer · 2012-11-21 00:40:16Z

Javascript:

                    jQuery(document).ready(function($)
                    {
                    //prevent registering the event more than once 

                    //$('#register').off('click').on('click',(function(e) {

(1.) I would start with:

                    $('form').off('submit').on('submit',(function(e) {

or ..

                        $('input[type="submit"]').off('click').on('click',(function(e) {

then ..

                                $.ajax({
                                              //url to touch
                                            url: "sendata.php",
                                            data: {
                                                age: $('#age').val()
                                            },
                                            type: 'POST',
                                            //on fail
                                                        fail: function(data){
                                                         //regular javascript alert on error
                                                                    alert("Oppps! Data error");
                                                        },
                                            //on success
                                            success: function(data) {
                                                //regular javascript alert on success
                                                alert("Data has been saved succefully");

                                                //assuming this is a div with an id of mydata
                                                $('#mydata').html("<b> Age is: </b>" + data);
                                            }
                                        });

                                //prevents default action as we are not submiting the form but rather making use of AJAX to touch the php file
                                e.preventDefault();

                                });

                    });

sendata.php

                                <?
                $msg= '';

                    if (  isset( $_POST['age'] )  ) 
                    {
                        $age = filter_input(INPUT_POST, "age", FILTER_SANITIZE_STRING); 
                //echo $age;

                //around this check if the insertion is correct and that you can talk to the db
                //db handling, insertion, etc..
                                  // $sql2 =$db->setQuery("INSERT INTO ....  ");
                                  // $db->query();

                        //$msg .= "Epic Win! $age";
                        $msg .= "$age";
                    }
                    else $msg .= 'Error, no age provided :( ';
                        //we are returning the data so we need to echo it as an output here.
                    echo $msg;

                ?>

Collectives™ on Stack Overflow

updating database with ajax not working

2 Answers 2

11 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related