How to use ajax in order to pass variables values to a php script?

Question

I am trying to use ajax and pass varuables from js to php in order to insert them in a mysql table. the code below is successful in calling the php script but not passing the data

i would like to pass "num" from the following js function to "insertRow.php" - the function does activate "insertRow.php" but will not pass the data

function InsertToTable(num){
    var data=num;
    $.ajax({
        url: "insertRow.php",
        data: data,
        type: "POST"
        });

once the data is passed i would like to insert it in to a mysql table, the following will work if i don't use "$num" but just put a value instead

<?php
$num = $_Post['data'];
//print_r($_Post("data"));

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "Schedule";   

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql ="INSERT INTO `temp1` (`column1`) VALUES ('$num')";

$conn->query($sql);     
?>

Please read about SQL injection. Instead of building queries with string concatenation, use prepared statements with bound parameters. See this page and this post for some good examples. — Alex Howansky
– Alex Howansky, Commented Jan 10, 2019 at 15:37
Possible duplicate of Passing variable javascript to PHP using AJAX — law_81
– law_81, Commented Jan 10, 2019 at 15:38
I bet this has been asked and answered tons of time. Give a try to do more searches. (Not my downvote) — Cid
– Cid, Commented Jan 10, 2019 at 15:39

Jay Blanchard · Accepted Answer · 2019-01-10 15:41:30Z

2

You can do this...

data: {data : num},

OR, since you set data = num; you could do this:

data: {data: data},

Where the first data is the identifier and the second is the value.

The will give you access to data in the POST (which is case sensitive) variable:

$_POST['data'] // should be equal to num

edited Jan 10, 2019 at 15:41

answered Jan 10, 2019 at 15:37

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

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

7 Comments

Cid Over a year ago

Althought this is legit, data: {data: data} will be very confusing.

Jay Blanchard Over a year ago

Agreed @Cid, because especially in this case num is already set and does not need to be transfigured into another variable.

Cid Over a year ago

What about var data = { data:num }; so you can type data: { data: data.data } ?

Jay Blanchard Over a year ago

@Cid LOL ¯\_(ツ)_/¯

Cid Over a year ago

¯\_(ツ)_/¯ It works on my computer <- my pre-made comment for some questions

|

Renan Toledo · Accepted Answer · 2019-01-10 15:44:10Z

Seems like a typo,

Insead of

$num = $_Post['data'];

Try

$num = $_POST['data'];

Also, it's good practice to send AJAX a return, so in the end you can use

echo json_encode(true);

Or set it to false in case of an error, with this you can see if the query worked or not in the success clause of AJAX.

Here's an example of a more complex AJAX call.

            $.ajax({
                url: 'scripts/AjaxHandler/Controller.php',
                type: 'POST',
                dataType: 'JSON',
                data: {
                    action: 'doThis',
                    var1: var1,
                    var2: var2
                },
                success: function (data) {
                    if(data == true) {
                        alert('success');
                    }else{
                        alert('failure');
                    }
                },
                error: function (error) {
                    console.log(error);
                }
            });

Collectives™ on Stack Overflow

How to use ajax in order to pass variables values to a php script?

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related