Saving data to database using Jquery

Question

I'm creating a browser RPG game. I want to allow a user to save their current stats by updating the mysql db without having to reload the page... So I thought jquery could help.

The user will not be adding their own stats. The stats are generated through user actions, such as solving a challenge. I want the user to be able to save those updated stats to the database whenever they would like.

The issues are:

the jQuery is outputting the echo "saved..." . $stats . ", " . $stats2; before I click the Save button.
When I click save, the database field isn't being updated.

I'm wondering why this isn't working. When I click save, the stats fields shouldn't be 0, but should be the stats that are shown- 11. The database fields should also be updated.

For testing purposes, I've just created js variable var stats that is updated when the arrow keys are pressed.

I call the function updateHUD() to do $('#stats').html(stats); which updates the HTML.

function updateHUD() {  
    $('#stats').html(stats);
}

Then updateHUD is called after arrow key is pressed.

HTML

<div class="span12">
    <button onclick="saveData(stats)" name="input" value="">Save Data</button>
        <br /><span id="output"></span><br />
        <ul>
        <li><b>Stats 1:</b>     <span id="stats"></span>    </li>
        </ul>
</div>

jQuery

//Pass saved data to store in DB
$(document).ready(function() {
    saveData();
});


function saveData() {     
   $.get("php/CRUD.php", {"_input" : $('input[name=input]').val()},
        function(returned_data) {
            $("#output").html(returned_data);
        }
    );
}

PHP

<?php
//store all player data in array and save to/update db
include 'DbConnect.php';
session_start();

$stats = (isset($_GET['_input']) ? ($_GET['_input']) : 0); 

$formvars = array();
array_push($formvars, $stats);      

echo $stats;
echo $_SESSION['username'];


$qry = 'UPDATE users SET stats="'.$stats.'" WHERE username="' . $_SESSION['username'] . '"';    
$mysqli->query($qry) or die(mysqli_error($mysqli));

echo "saved..." . $stats;
mysqli_close($mysqli);
?>

Output

saved...0 //this should be 11
Stats 1: 11

It is outputting it before because you are calling saveData on doucment ready. — epascarello
– epascarello, Commented Jan 2, 2014 at 15:38
I am not sure but if you want to show updated data from db then there must be select query to fetch data from db and show latest status — Nilesh
– Nilesh, Commented Jan 2, 2014 at 15:42
You are trying to get $('input[name=input]').val(), but there is no input at all in your markup. — moonwave99
– moonwave99, Commented Jan 2, 2014 at 15:42
@epascarello okay I've removed document ready which fixes the values being displayed before I click the button, but the stats still aren't being updated in the db nor are they being returned correctly from the jQuery — user3871
– user3871, Commented Jan 2, 2014 at 15:44

TheNiceGuy · Accepted Answer · 2014-01-02 15:44:32Z

4

You do a

$('input[name=input]').val()

but you have named the submit button "input" instead of adding a input box with this name.

But the question is unclear anyways.

You want to give a user the permission to update his stat with the value that he wants? You should update the question to make it more clear since it does not make much sense at the moment.

answered Jan 2, 2014 at 15:44

TheNiceGuy

3,7609 gold badges39 silver badges69 bronze badges

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

22 Comments

user3871 Over a year ago

How do I fix this for my case? And no, I don't want the user to update with the value he wants. The stats are generated automatically

TheNiceGuy Over a year ago

I just edited my answer. Pls update your question, what exactly you want to do. It is unclear.

TheNiceGuy Over a year ago

Where are the stats are stored? There is nothing in the code you posted. Are they in a variable? In a hidden input? Where are they?

Hecksa Over a year ago

I assume you want to pull the data from the <span> element with id "stats", no?

TheNiceGuy Over a year ago

@Growler: Pleas eupdate the wquestion with all the informations and the new code. We want to help you but we don't want to guess what you actually want.

|

photodow · Accepted Answer · 2014-01-02 16:08:53Z

First your selector where you are getting your data from is incorrect. You need to either change your html...

<button name="input"></button>

to an...

<input type="button" name="input" />

or change your jQuery selector...

$('input[name=input]')

to select the correct element

$('button[name=input]')

Second you need to make sure your button's 'value=""' actually has data in it when the ajax function is being called.

<button onclick="saveData(stats)" name="input" value="[Data Value Goes Here]">Save Data</button>

Finally the reason your jQuery is outputting before you click the the save button is because you are executing the function as soon as the document loads.

$(document).ready(function() {
    saveData();
});

Try something more like this:

HTML

<button name="input" value="[data goes here]">Save Data</button>

JavaScript / jQuery

//Pass saved data to store in DB
$('button[name=input]').on('click', saveData);


function saveData() {     
    $.get("php/CRUD.php", {"_input" : $(this).val()},
        function(returned_data) {
            $("#output").html(returned_data);
        }
    );
}

CaptainKnee · Accepted Answer · 2014-01-02 16:15:33Z

0

Also you can try using load:

//Pass saved data to store in DB
$(document).ready(function() {
    saveData();
});


$.fn.saveData=function(){
   $('#divforload').css('display','none');
   $('#divforload').load("php/CRUD.php?stats="+$('#stats').val(),function(){$('#divforload').fadeIn();});
}
//Just call the function onClick...
//Need an input called 'stats'
});

edited Jan 2, 2014 at 16:15

answered Jan 2, 2014 at 15:59

CaptainKnee

1395 bronze badges

Collectives™ on Stack Overflow

Saving data to database using Jquery

3 Answers 3

22 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

22 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related