how to insert javascript variable into mysql database?

Question

I cant seem to work out how to simply add a javascript variable into a mySQL table!

I have a html code which is just making a canvas for my game. I then have a javascript file doing all the game proccess and here is the code i am using to send the javascript variable to a php file:

 var uiStats = $("#gameStats");
var uiHealth = $(".gameHealth");

var health = 10;

$.post('http:/localhost/basic_structure/game.php', { "health" : health});

Then here is the php file to insert the data into the database:

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';

$conn = mysql_connect($dbhost, $dbuser, $dbpass)
    or die
('Error connecting to mysql');

$dbname = 'game';
mysql_select_db($dbname, $conn);

$health = $_POST['health'];

mysql_query("INSERT INTO game_table (health)
VALUES ('$health')");

mysql_close($con);

I simply just want to save the health of the player in my game for later uses.

Any help is appreciated

Thanks

You are using an obsolete database API and should use a modern replacement. You are also vulnerable to SQL injection attacks that a modern API would make it easier to defend yourself from. — Quentin
– Quentin, Commented Nov 15, 2012 at 17:29
thanks for letting me know, this is just on a test environment on my local pc at the moment so this shouldnt cause much problems yet? — Tom Burman
– Tom Burman, Commented Nov 15, 2012 at 17:39

Casey Foster · Accepted Answer · 2012-11-15 17:30:23Z

1

If you copy/pasted this from your actual code,

'http:/localhost/basic_structure/game.php'

should be

'http://localhost/basic_structure/game.php'

answered Nov 15, 2012 at 17:30

Casey Foster

6,0402 gold badges29 silver badges27 bronze badges

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

1 Comment

Tom Burman Over a year ago

Also the variable health which i use to also post to the html document doesnt display the integer anymore? thanks

Greeso · Accepted Answer · 2012-11-15 17:33:48Z

0

Your URL is incorrect in the post call

Also, use PDO or mysqli_ instead of mysql_ because mysql_ is deprecated.

A third suggestion is you should have a callback in your post (from php to javascript) to allow you to check that the process succeeded/failed and inform the user accordingly.

answered Nov 15, 2012 at 17:33

Greeso

8,42915 gold badges58 silver badges86 bronze badges

9 Comments

Tom Burman Over a year ago

Thanks but this still didnt work? the variable contents have also stop being visible in my html doc?

Greeso Over a year ago

What do you mean by that? Does not display variable contents?

Tom Burman Over a year ago

Ok ill try to explain better. I have a div in my html which is empty call uiHealth. The javascript file uses that div to show the players health elsewhere in the code. When i corrected my mistake you pointed out, the javascript failed to post the variable health into my html div, as well as not insert it into the database

Greeso Over a year ago

OK, you have to first check that you are sending the health variable to php correctly. So, in your php, just do the following: <?php echo $_POST["health"]; ?> Now if this works, we know that the value is being sent correctly.

Tom Burman Over a year ago

Ok i tried that, but no luck so i guess thats where the problem lies?

|

Collectives™ on Stack Overflow

how to insert javascript variable into mysql database?

2 Answers 2

1 Comment

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related