Search code examples
javascriptphpriot-games-api

How to use php inside of javascript?

I am using javascript to retrieve a bunch of values from the Riot API, however I want to store them in my own database using php. For example, I'm trying to store the gameID and this is what I'm trying right now.

      <?php
        $insrt = "INSERT INTO game (gameId)
        VALUES (".<script>b.gameId</script>.")";
        mysqli_query($dbc, $insrt);
        ?>

I'm pretty sure that I'm not even close to correct but I'm not sure how to do this.

Solution

  • You need to take a different approach. You can make an ajax call to a php script to do this for you. But the initiator will be javascript from the client side. Using jQuery(let me know if you can't), you can do

    $.ajax({url: "insert_game_id.php", data: {gameId :b.gameId} });

    and your php script

    <?php
        $gameId = $_POST['gameId'];
        $insrt = "INSERT INTO game (gameId)
        VALUES ($gameId)";
        mysqli_query($dbc, $insrt);
?>

    See jQuery Ajax POST example with PHP