Call PHP file in JavaScript Function for Updating MYSQL Table?

Question

I want to integrate a Java script Slot Machine game into my script.

You can see demo here ; http://odhyan.com/slot/

And also git hub is here ; https://github.com/odhyan/slot you can see all JS files here.

I created a Point Coloumn in User Table that people can play the game with this Point.

I think this JS Function in slot.js checking if user won the game or lose.

function printResult() {
        var res;
        if(win[a.pos] === win[b.pos] && win[a.pos] === win[c.pos]) {
            res = "You Win!";
        } else {
            res = "You Lose";
        }
        $('#result').html(res);
    }

enter image description here

So i want to add +100 Point if user won the bet.

I made this PHP codes Uptading points For userid "1".

<?php

mysql_connect ("localhost","username","password") or die (mysql_error());
mysql_select_db('slot_machine');
$pointsql = mysql_query("SELECT * FROM user WHERE userid = 1");
while ($row = mysql_fetch_array($pointsql))
{
$row['point'] +=100;
$addpoint =  mysql_query("UPDATE user SET point = '{$row['point']}' WHERE userid = 1");
}

?>

So how can i call or excute this PHP Codes in JavaScript function if user Win?

There is no more support for mysql_* functions, they are officially deprecated, no longer maintained and will be removed in the future. You should update your code with PDO or MySQLi to ensure the functionality of your project in the future. — jeremy
– jeremy, Commented Aug 3, 2013 at 4:21

jandersen · Accepted Answer · 2013-08-03 05:02:25Z

2

You'll need to trigger a network request from your javascript code to execute your php script server side. Using jQuery's $.ajax() function is an extremely common way to do this abstracting away various browser differences.

function printResult() {
    var res;
    if(win[a.pos] === win[b.pos] && win[a.pos] === win[c.pos]) {
        res = "You Win!";
        // Assign handlers immediately after making the request,
        // and remember the jqxhr object for this request
        var jqxhr = $.ajax( "path/to/your.php" )
                       .done(function() { alert("success"); })
                       .fail(function() { alert("error"); })
                       .always(function() { alert("complete"); });
    } else {
        res = "You Lose";
    }
    $('#result').html(res);
}

edited Aug 3, 2013 at 5:02

answered Aug 3, 2013 at 4:31

jandersen

3,56124 silver badges23 bronze badges

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

8 Comments

JacKy Over a year ago

i think jQuery is already icluded with this code ; <script src="ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js"></script>

JacKy Over a year ago

But when try with your codes, it gives JS Alert " error " . i.imgur.com/Jie9cQ9.jpg

jandersen Over a year ago

You are correct! (Though it's an older version... might be a good idea to update it as it doesn't look like a huge dependent code base here). Thanks for noting this @JacKy.

jandersen Over a year ago

hmm... did you change "path/to/your.php" to wherever your .php file is hosted? (Otherwise the "error" alert is exactly what I'd expect ;-) ) You may not need the updated jQuery just for this... not sure what might be causing the freeze without looking at the rest of your app in more detail

JacKy Over a year ago

I'm running this on wamp server at my home. So i put .php file into same folder that .js and index file of game. And edit like this ajax( "addpoint.php" ) and try like this "/addpoint.php" but still getting error

|

theftprevention · Accepted Answer · 2013-08-03 04:29:37Z

You can use jQuery's $.post() function to trigger an asynchronous request to your PHP file.

function printResult() {
    var res;
    if(win[a.pos] === win[b.pos] && win[a.pos] === win[c.pos]) {
        res = "You Win!";
        // Here's the line you need.
        $.post('score.php', {userid: 1}, function(data) {
            alert("Score saved.");
        });
    } else {
        res = "You Lose";
    }
    $('#result').html(res);
}

This will send POST data to score.php, or whichever file you want to send the data to. The PHP file can then access the userid sent to it by checking the value of $_POST['userid'].

As mentioned in the documentation, $.post() is a shortcut for jQuery's $.ajax() function that is simplified and has some of its options pre-set. The third argument in $.post() is a callback function, and the variable data will contain whatever is echoed out or printed from score.php by the time it's done executing. So, you could use alert(data) instead, to see what score.php printed out. This is useful for troubleshooting and error handling.

user2640758 · Accepted Answer · 2013-08-03 04:52:01Z

0

try this

$(document).ready(function(){
        setInterval(function() {
        $.get("databaseUpdated.php");//or what ever your php file name is with corrct path
        return false;            
    }, 1000);
    });

hope this will help you use it in your function

function printResult() {
        var res;
        if(win[a.pos] === win[b.pos] && win[a.pos] === win[c.pos]) {
          // if    
            setInterval(function() {
            $.get("databaseUpdated.php");//or what ever your php file name is with corrct path
            return false;            
        }, 1000);

        } else {
            res = "You Lose";
        }
        $('#result').html(res);
    }

edited Aug 3, 2013 at 4:52

answered Aug 3, 2013 at 4:31

user2640758

731 gold badge3 silver badges11 bronze badges

1 Comment

JacKy Over a year ago

where should i add this exactly ?

Collectives™ on Stack Overflow

Call PHP file in JavaScript Function for Updating MYSQL Table?

3 Answers 3

8 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related