Pass The Container text span id to a PHP Variable

Question

Pass The Container text span id to a PHP Variable

Navigation

#1 by (3 votes)
#2 by (0 votes)

4

I have a Video Game programmed in HTML and JavaScript from which I wish to pass the points obtained to the MySQL Database and I can not find the correct way to achieve it.

JavaScript Code:

function updateScore(){
    var score = (snakeLength - startLength) * 10;
    document.getElementById('score').innerHTML = score;
}

function gameScore() {
    $('#ribbon').addClass('hide');
    var highScore = localStorage.getItem("high-score");
    var score = (snakeLength - startLength) * 10;
    $('.current-score').html(score);
    if (score > highScore) {
        $('#ribbon').removeClass('hide');
        $('.high-score').html(score);
        localStorage.setItem('high-score', score);
    } else {
        $('.high-score').html(highScore);}
        gameMenu();
    }

HTML code (shows the current points of the game):

Puntos: <span id="score">0< /span>

PHP Code:

I need to perform an update of points in my Database but I do not know how to pass the <span id="score"> tag to a PHP variable. For AJAX it would be ideal but it is more difficult for me.

// Necesito El Resultado en Point 
mysql_query("UPDATE game SET point=$VARIABLE_PUNTOS ");

mysql javascript php

asked by Bryan B Weiss 15.01.2016 в 03:20

source

2 answers

0

Very good your answer was doing something similar and it helped me a lot.

Here I leave my code

<script language="JavaScript" type="text/JavaScript">                          
    //Metodo para cargar el formulario **************** AQUI USO ALGO DIFERENTE PARA PODER LEER EL id DEL DIV ******
    $("body").on('submit', '#formOrder', function(event) {
    event.preventDefault()
    if ($('#formOrder').valid()) {
        $.ajax({
        type: "POST",
        url: "imagesOrderProcesar.php",
        dataType: "json",
        data: {
        "Order": $("#output").text()
    },
        success: function(respuesta) {
                    if (respuesta.error == 1) {
                        $('#error1').show();
                        setTimeout(function() {
                        $('#error1').hide();
                        }, 1000);
                        window.location.href='login.php'; 
                    }

                    if (respuesta.exito == 1) {
                        document.getElementById('light').style.display='block';document.getElementById('fade').style.display='block';                       
                    }                       
                }
            });
        }
    }); 

    function Salir() {
        window.location.href="propertylist.php";
    }    
</script>

answered by 13.12.2016 в 23:01

How to access the structure of this Twitter result? Windows 10: Unable to unlink corporate account - delete from registry

score 3 · Accepted Answer

You are trying to avoid using AJAX, however, it is not very difficult to do so. Using jQuery you do the POST with the information of score :

request = $.ajax({
    url: "/score.php",
    type: "post",
    data: {
        "score": $("#score").text()
    }
});
request.done(function(response) {
    console.log("¡Bien!")
});
request.fail(function(response) {
    console.log("¡Error!")
});

In PHP:

...
$score = $_POST['score'];
mysql_query("UPDATE game SET point=$score ");
...

It is better to prevent, it would be better to use mysql_real_escape_string to avoid SQL injection :

...
$score = mysql_real_escape_string($_POST['score']);
mysql_query("UPDATE game SET point=$score ");
...

Since you are using HTML and JavaScript in your game, I would recommend you use a cloud Database Parse . You can save yourself a lot of headaches.

Update

Remember that if the attribute is a class :

<span class="current-score">0</span>

You must use . instead of # , # is for when you use id :

var score = $(".current-score").text();

If you need to pass it to whole and add it you can use parseInt :

var score = parseInt($(".current-score").text()) + 50;