Sending a matrix from PHP to AS3

[Grobi93]

Hello!
I have a little problem. I am trying to send a two dimensional array/matrix from a PHP code to an AS3 code. My solution simply isn't working. Here is my code which reffers to the sending:

The kerdesvalasz table has the questions and answers in it, exactlye 17 rows and 6 columns + 1column is the PRIMARY KEY which is named id.

//Kerdes is quesiton, adatok is data, helyes means correct and valasz is answer in English.

AS3:

var loader:URLLoader=new URLLoader();
loader.dataFormat=URLLoaderDataFormat.VARIABLES;
request.method=URLRequestMethod.POST;

start_btn.addEventListener(MouseEvent.CLICK,startquiz);

var adatok:Array = [];
var i:int = 0;
var j:int = 0;

for(i=0;i<17;i++)
{
    adatok[i] = [];  ///defining a matrix??
}

function startquiz(e:MouseEvent):void
{
var request:URLRequest=new URLRequest("adatatvitel.php");
var loader:URLLoader=URLLoader(e.target);
var vars:URLVariables=new URLVariables(loader.data);
for(i=0;i<17;i++)
 {
 for(j=0;j<5;j++)
  {
      adatok[i][j] = vars.adatok;
  }
  i++;
 }  
}

PHP:

PHP Code:

<?php

require("db.php");

$sql = "SELECT * FROM kerdesvalasz";
$result = mysql_query($sql) or die(mysql_error());

$adatok = array
 (
  "kerdes" => array
  (
  ),
  "valasz1" => array
  (
  ),
  "valasz2" => array
  (
  ),
  "valasz3" => array
  (
  ),
  "valasz4" => array
  (
  ),
  "helyes" => array
  (
  )
 );
 
$i=0;
while($row = mysql_fetch_array($result))
{
  $adatok['kerdes'][$i] = $row ['kerdes'];
  $adatok['valasz1'][$i] = $row ['valasz1'];
  $adatok['valasz2'][$i] = $row ['valasz2'];
  $adatok['valasz3'][$i] = $row ['valasz3'];
  $adatok['valasz4'][$i] = $row ['valasz4'];
  $adatok['helyes'][$i] = $row ['helyes'];
  $i++;  
}

echo "adatok=$adatok";
?>

Thanks in advance!

[ASWC]

Use XML or Json to pass your data back to your app (amf is another option). Anything else is just a pain and not professional.

[Grobi93]

Thanks for the advice, but I don't have enough time to learn another language's basics. I need to finish this project in 3 days.

[lordofduct]

they're not really languages...

they're more like mark-up styling for serializing data.

And most languages have frameworks to deal with them. AS3 has a set of classes for easily manipulating XML. And I believe there are libraries out there for Json.

And AMF is built right into Flash... it's Action Message Format, it's Adobe's serialization technique for sending messages between things like Flash and Flash Media Server.




If you want to do web coding... serializing data is something you're going to NEED to learn! DOn't worry, it's not hard. 3rd party formats and tools exist so that 1) there are standards, and 2) they're easy to learn and use. This is why ASWC said "Anything else is just a pain and not professional"... standards are a good thing.

[Grobi93]

I understand but I just don't have the time right now.

[jsprclimber123]

Then you have a problem. Not taking the time to do things right so it's done quicker is, to rightly quote ASWC, "a pain and not professional".

To help along with pushing this to XML, I'd suggest echoing each row as an XML node. So you could do something like this:

<rows>
<?php
while($row = mysql_fetch_assoc($result)){
echo '<row>';
echo '<kerdes>'.$row['kerdes'].'</kerdes>';
echo '<valasz1>'.$row['valasz1'].'</valasz1>';
echo '<valasz2>'.$row['valasz2'].'</valasz2>';
echo '<valasz3>'.$row['valasz3'].'</valasz3>';
echo '<valasz4>'.$row['valasz4'].'</valasz4>';
echo '<helyes>'.$row['helyes'].'</helyes>';
echo '</row>';
}
?>
</rows>

will result in:

<rows>
<row>
<kerdes>kerdes from row 1</kerdes>
<valasz1>valasz1 from row 1</valasz1>
<valasz2>valasz2 from row 1</valasz2>
<valasz3>valasz3 from row 1</valasz3>
<valasz4>valasz4 from row 1</valasz4>
<helyes>helyes from row 1</helyes>
</row>

etc...
</rows>

From there, you can parse the XML in flash as needed. Best of luck with your project.

[Grobi93]

Thank you! I have changed my mind and started watching some tut videos thanks for the code

[ASWC]

Originally Posted by lordofduct

And I believe there are libraries out there for Json.

There is now a JSON class built-in in FP11.

[ASWC]

You can use my DatabaseConnect PHP class (attached) which outputs xml. You use it that way:

PHP Code:

require('DatabaseConnect.php');
$dbconnect = new DatabaseConnect('yourdbserver', 'yourusername', 'yourpassword');
$dbconnect->init();
$dbconnect->selectDB('yourdbname');
$yourquery = 'SELECT * FROM kerdesvalasz';
$mydata = $dbconnect->getQuery($yourquery, "root");
print($mydata->asXML());