Passing value from JS to PHP and to SQL?

[WayneISWayne]

I am trying to get a value from a JavaScript variable and add it to a MySQL database using PHP, but my code does not seem to work. I know that this is a PHP forum, but it's kinda hard to ask this anywhere else.

This is my code where I actually pass the value (variable countForPHP) using XHR:

xmlHttp.open("GET", "count.php?r=" + Math.random + "&count=" + countForPHP, async);

Here's how I get the value sent from the XHR:

$counter = $_GET["count"];
$pdo = new PDO('mysql:host=host;dbname=database;', 'username', 'password');
$sql = "UPDATE tbl_click SET click = click + ($counter)";
$pdo->exec($sql);

Does anyone know how to solve this problem?

[criterion9]

I think you might have meant:

$_GET['count'];

[Belrick]

Hi

Sorry for the lecture but here it is anyway.

The key to writing good code is being easily able to debug said code.

Youve provided yourself with zero means to do so, that means every line of code youll ever write will potentially be a huge chore to make work.

You need to be able to know exactly where the code is breaking down.

ANyway, nothing more from me, best of luck.

[WayneISWayne]

I think you might have meant:

$_GET['count'];

Aren't " and ' the same? Maybe my problem is where I add the variable in the SQL Query?

[George88]

Are you receiving any output from the PHP file in question? I.e., is xmlhttp.responseText empty?

Are you certain your file paths are correct? Remember that with AJAX calls you need to make sure the path of the PHP file is relative to the currently active page, not relative to the file on the server.