Pass javascript variables into Database with MySQL and PHP [duplicate]

Question

Possible Duplicate:
How to pass a variable / data from javascript to php and vice versa?

I have 3 javascript variables which gives me an id, a name and a surname as such:

    if (!response.error) {

    document.getElementById("meName").innerHTML = response.id 
                                                 + " " + response.name
                                                 + " " + response.surname ;
                        }

Now I want to pass those variables (response.id, response.name and response.surname) into my database.

Something like this:

<?php

    $query = mysql_query("INSERT INTO users (id, name, surname) VALUES 
 ('response.id', 'response.name', 'response.surname')") or die(mysql_error());

$result = mysql_fetch_array($query);
return $result;

?>

How can I do this?

First of all you have to understand the difference between client and server. — Your Common Sense
– Your Common Sense, Commented Mar 11, 2012 at 0:55

jQuerybeast · Accepted Answer · 2012-03-11 03:08:29Z

2

This is what you need:

        if (!response.error) {
                    var uid = response.id;
                var firstname = response.name;  
                    var surname = response.surname  

                    if (window.XMLHttpRequest) {
                        xmlhttp = new XMLHttpRequest();
                    }

                    xmlhttp.open("GET", "ajax.php?uid=" + uid + "&firstname=" + firstname + "&surname=" +  surname , true);
                    xmlhttp.send();

                    return false;

        }

and in your ajax file:

<?php include("YOUR_CONNECTION_FILE.php");


$uid = mysql_real_escape_string($_GET['uid']);
$firstname = mysql_real_escape_string($_GET['firstname']);
$username = mysql_real_escape_string($_GET['surname']);


$query = mysql_query(" YOUR MYSQL QUERY ") or die(mysql_error());  
?>

answered Mar 11, 2012 at 3:08

jQuerybeast

14.6k39 gold badges120 silver badges198 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:17:50Z

1

Well, ajax would be the best choice in your case.

Check my answer here How to send a form without refreshing the page?

Check out some documentation also:

jQuery Documentation

Tutorials

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Mar 11, 2012 at 0:21

Alex

7,70825 gold badges87 silver badges153 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

I'm guessing you're trying to pass the javascript variables to php.

In order to do this you need to use a POST or GET method.

This question's answer will help.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Mar 11, 2012 at 1:19

rks

111 bronze badge

Comments

Amber · Accepted Answer · 2012-03-11 00:21:36Z

0

You'd need to make an AJAX call to a separate PHP script which stores the variables.

Javascript runs browser-side, whereas PHP runs on the server - by the time the browser is running the Javascript code in the page, it has already finished running on the server and thus all of the PHP code has already executed.

answered Mar 11, 2012 at 0:21

Amber

531k89 gold badges643 silver badges558 bronze badges

1 Comment

jQuerybeast Over a year ago

That is why I came here and asked this question otherwise I would just go do it, dont you think? You are answering my question.

Eduardo Lagares · Accepted Answer · 2012-03-11 00:51:49Z

-1

I believe that response is your return via ajax, if so, you should check two things

First, set the ajax dataType to 'json'.

Second, replace

return $result

to

return json_encode($result);

By.

answered Mar 11, 2012 at 0:51

Eduardo Lagares

1166 bronze badges

Collectives™ on Stack Overflow

Pass javascript variables into Database with MySQL and PHP [duplicate]

5 Answers 5

Comments

jQuery Documentation

Tutorials

Comments

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

jQuery Documentation

Tutorials

Comments

Comments

1 Comment

Comments

Linked

Related