mysql - Submitting scores from AS3 to PHP/SQL - #Error 2101 -

mysql - Submitting scores from AS3 to PHP/SQL - #Error 2101 -

i having problems posting scores flash cc as3 game php page sql database. receiving error #2101 messages in output window. after lot of time searching problem advised check if php problem.

i have created simple flash file, code (i have replaced actual site address below) :

import flash.events.mouseevent; import flash.net.urlrequest; import flash.net.urlvariables; import flash.net.urlloader; import flash.events.event; var username = "jamie"; var newscore = 1300123; btn_submit.addeventlistener(mouseevent.click, submitted); function submitted(e:mouseevent) { var myrequest:urlrequest = new urlrequest("http://mysiteaddresshere.com/test_scores.php"); myrequest.method = urlrequestmethod.post; var variables:urlvariables = new urlvariables(); variables.player = username; variables.score = newscore; var loader:urlloader = new urlloader(); loader.dataformat = urlloaderdataformat.variables; loader.addeventlistener(event.complete, dataonload); loader.load(myrequest); } function dataonload(evt:event) { mc_success.alpha = 100; }

the php code follows:

<?php include("db.php"); // connect mysql server $link = mysql_connect($host, $user, $pass); if(!$link) { die('failed connect server.'.mysql_error()); } $db = mysql_select_db($database); if(!$db) { die("unable select database"); } $gamename = "ietul"; $employeeid = 123456; $player = $_post['username']; $score = $_post['newscore']; //create insert query $qry = "insert highscore (gamename,employeeid,player,score) values('$gamename','$employeeid','$player','$score')"; $result = @mysql_query($qry); echo "writing = ok"; exit(); mysql_close(); ?>

the include includes connection , table details database. game should include gamename , employeeid variables, sake of testing have hardcoded them here. upload game, html , related files same site , when play it, database updates adding in gamename , employeeid details, player , score fields blank.

i have tried different versions of this, using method get, info format text among others.

i have been staring @ , researching issue on 1 week now... if out there can tell me i'm doing wrong delighted hear !

i'm relatively new combinging flash, php , sql please excuse me if i'm missing glaringly obvious !

thanks again, jay

try :

as3 code:

btn_submit.addeventlistener(mouseevent.click, submit_on_press) function submit_on_press(e:mouseevent) { var variables:urlvariables = new urlvariables() variables.player = 'player_name' variables.score = 1526 var request:urlrequest = new urlrequest('http://127.0.0.1/score/score.php') request.method = urlrequestmethod.post request.data = variables var loader:urlloader = new urlloader() loader.dataformat = urlloaderdataformat.variables loader.addeventlistener(event.complete, data_on_load) loader.load(request) } function data_on_load(e:event) { trace(e.target.data.writing) }

php code:

<?php if(count($_post) != 2) die(); $player = trim($_post['player']); $score = intval($_post['score']); $link = mysqli_connect('127.0.0.1', 'root', '', 'test') or die('error ' . mysqli_error($link)); $query = "insert test(player, score) values('".$player."', ".$score.")"; $result = $link->query($query); $link->close(); echo 'writing='.($result ? 'ok' : 'error'); ?>

for php, recommand utilize mysqli because mysql deprecated.

php mysql actionscript-3 flash leaderboard