Passing variables from PHP to ActionScript

[arctictiger]

Ok I'm new to PHP but I have relative experience with ActionScript.

I've been making a game which at the end sends variables to a PHP file and the PHP file sends the variables to a MySQL database, I have this working perfectly fine and dandy.

However I require the game to display the top 10 scores at the start of the game, I can get the top 10 fine using PHP on its own but when it comes to sending the top10 (or any variable for that matter) to ActionScript I can't seem to get it to work.

I have searched in vein to find tutorials to help me out and I have searched this forum and still I'm no more knowledged than 3 days ago.

Please could someone post a simple PHP script that will pass a single variable to ActionScript and also the ActionScript needed to recieve that variable so I can see how it should be done.

Thanks

[Twister]

Ok you need to make a page for flash to pull in the variable. on this page you'd output your variable like this &name=thomas The source code for that page would be something like echo ("&name=thomas");

Then you use loadVariableNum to load that page. loadVariableNum("variablepage.php",0)

Two things to keep in mind
1) it will load variables into the root level of your file, most likely
2) I wrote that off the top of my head so make sure to check the code.

[CyanBlue]

Quick tutorial can be found here...

http://tutorials.flashvacuum.com/art...0a44705643e5d5

I'd probably use LoadVars object unless you are exporting your movie for F5...

[arctictiger]

Ok, this is what I have going on as a test... (test php file is topten.php)

PHP Code:

<?php
    $testVar = "Success";
    
    echo("Topname=$testVar"); 
?>

then in the ActionScript I have this...

loadVariablesNum("topten.php", 0);

and my Dynamic Text box is assigned the variable _root.Topname

so this should display "Success" in my text box, is this right?

[arctictiger]

Ok, now I have tried a different ActionScript method using the same PHP as follows... (The dynamic textbox intance name is "top_text")

var top_list = new LoadVars();
top_list.onLoad = function(success){
	if (success){
		top_text.text = top_list.Topname;
	}
}
top_list.load("topten.php");

And this doens't work either! Help Please

[ibizconsultants]

This should help

PHP Code

<?
$first="this";
$second = "that";

echo "myfirst=$first&mysecond=$second";
exit;
?>


Flash Actionscript:

var lvSend = new LoadVars();
var lvReceive = new LoadVars();
lvSend.SendAndLoad("www.domain.com/script.php",lvReceive,"POST");

lvReceive.onLoad = function(bSuccess) {
if(bSuccess == true) {
trace(this.myfirst);
trace(this.mysecond);
}
}

Hope this helps

www.ibizconsultants.com

[Dark_Element]

Hi ya. I've made something like this for some1 recently. This piece of php code will deffinitely help you:

PHP Code:

<?php
//just replace the 'host', 'user', 'pass', and 'db' with stuff you have
$connect = @mysql_connect('host','user','pass');
$dbselect = @mysql_select_db('db',$connect);
$query = @mysql_query('SELECT player, score FROM scores ORDER BY score DESC LIMIT 10');
if (!$connect or !$dbselect or !$query) {
  exit('failed=true');
}
$num = 1;
$rows = mysql_num_rows($query);
while ($info = mysql_fetch_assoc($query)) {
  $key = array_keys($info);
  echo($key[0].''.$num.'='.$info['player'].''.($num <= $rows ? '&' : '').''.$key[1].''.$num.'='.$info['score'].($num < $rows ? '&' : ''));
  $num++;
}
mysql_free_result($query);
mysql_close($connect);
?>

PS: that code assumes you have a table in your database called "scores" and in it there should be columns "player" and "scores".

note: it will return variables in this layout:
"player"a increasing number"="name of player"&score"a increasing value equivlent to the one before"="score value

so: if there is a table in MySQL like this:

 
+-------+------+
|player | score |
+-------+------+
| foo   | 100  |
+-------+------+
| bar   | 250  |
+-------+------+
| var   | 90   |
+-------+------+

this will be returned by the PHP code:
player1=bar&score1=250&player2=foo&score2=100&play er3=var&score3=90

Hope that helps

J.W_(Dark_Element)

<C-Stamp> if you need more help you are welcomed to PM me </C-Stamp>

[arctictiger]

Sniper I aren't having any trouble with MySQL but thatnks anyway.

ibizconsultants I have tried your method and this works fine for the second variable only, it seems for some reason I can only recieve the second variable. bloody odd.

[arctictiger]

D'oh! it just needed an & in front. Thanks guys problem solved

[davej]

if you start passing larger and more coplex data you may thing about having you php out put it as a xml doc. then in flash you load the xml. It is much easier for complex data then the above method.