Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Maybe it would be better to use an array to stock your results and encode your array to json and parse it in as3.<br/><br/>Ex:</p> <pre><code>$result = mysqli_query($con,$sql); // create your output array $output = array(); // fetch your results while( $row = mysqli_fetch_assoc($result) !== false ) { // add result row to your output's next index $output[] = $row; } // echo the json encoded object echo json_encode( $output ); </code></pre> <p>In your AS3 code you can get the object from the json string like this:</p> <pre><code>// retrieve data from php call var resultString:String = yourLoader.data; // parse result string as json object var resultObject:Object = JSON.parse( resultString ); </code></pre> <p>In this case your resultObject should be an array containing all your rows.</p> <pre><code>// retrieve data from php call var resultString :String = yourLoader.data; // parse result string as json object and cast it to array var resultArray :Array = JSON.parse( resultString ) as Array; // get the length of the result set var len:int = resultArray.length; // loop the result array for( var i:int = 0; i&lt;len; ++i ) { // trace nobed value trace( resultArray[i].nobed ); } </code></pre> <p>[EDIT]<br/> If you want to name each array part you can do this:<br/><br/> PHP:</p> <pre><code>$result = mysqli_query($con,$sql); // create your outputs array $nobed = array(); $zip = array(); $Location1 = array(); $price1 = array(); // create all you want // fetch your results while( $row = mysqli_fetch_assoc($result) !== false ) { // add result row to your output's next index $nobed[] = $row['nobed']; $zip[] = $row['zip']; $Location1[] = $row ['Location']; // you forgot the [] here meaning add to the end of the array $price1[] = $row ['price']; // you forgot the [] here meaning add to the end of the array //... } // echo the json encoded object echo json_encode( array('nobed'=&gt;$nobed, 'zip'=&gt;$zip, 'Location'=&gt;$Location1, 'price'=&gt;$price1) ); </code></pre> <p>AS3:</p> <pre><code>function Asandler(event:Event):void { // trace your recived data so you can see it before any parsing error trace( event.target.data ); var resultString :String = event.target.data; // parse result string as json object var resultObject :Object = JSON.parse( resultString ); // loop all keys in the object for( var s:String in resultObject ) { // you cannot do this as nobed and Location object don't exists i think, you can trace string or properties maybe trace( 'nobed', resultObject[s] ) but as s is not nobed all the time it's not correct //trace( nobed, resultObject[s] ); //trace( Location, resultObject[s] ); // so maybe add a switch case to make specific operation in function of the key // with switch case you can make a specific code block for a specific value of the variable passed in the switch switch(s) { // if( s == 'nobed' ) case 'nobed' trace( 'nobed', resultObject[s] ); // do what you want with your nobed array break; // if( s == 'zip' ) case 'zip' trace( 'zip', resultObject[s] ); // do what you want with your zip array break; // if( s == 'Location' ) case 'Location' trace( 'Location', resultObject[s] ); // do what you want with your Location array break; // if( s == 'price' ) case 'price' trace( 'price', resultObject[s] ); // do what you want with your price array break; } } } </code></pre> <p>try with a simple php script like this:</p> <pre><code>&lt;?php $row = array(); for( $i=0; $i&lt;10; $i++ ) { $row[] = array('nobed'=&gt;'nobed'.$i, 'zip'=&gt;$i, 'Location'=&gt;$i, 'price'=&gt;$i); } // create your output array $nobed1 = array(); $zip1 = array(); $Location1 = array(); $price1 = array(); // fetch your results for( $i=0; $i&lt;10; $i++ ) { // add result to your output next index $nobed[] = $row[$i]['nobed']; $zip[] = $row[$i]['zip']; $Location1[] = $row ['Location']; // you forgot the [] here meaning add to the end of the array $price1[] = $row ['price']; // you forgot the [] here meaning add to the end of the array } echo json_encode( array('nobed'=&gt;$nobed, 'zip'=&gt;$zip,'Location'=&gt;$Location1,'price'=&gt;$price1) ); ?&gt; </code></pre> <p>I think you have a server configuration problem</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to separate the ending and starting of a php Array Loop for AS3
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBenjamin BOUFFIER
    1. USBenjamin BOUFFIER
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to separate the ending and starting of a php Array Loop for AS3
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, but just wondering does that mean, i can't assign a name to each array part? like "nobed=" "&zip=" etc? Cos i will have to parse that separate the Array inside AS3 and place them accordingly
      singulars
      1. PO
      1. USBenyaman
    2. COthe problem is if you have more than one nobed or zip or other value how can you get them, you will get just one. Or you want to group them like nobed=result1,result2,result3... ? In all case my preference is for json encoded object than URLLvariables, and you can have the result nobed=result1,result2,result3 easyly too
      singulars
      1. PO
      1. USBenjamin BOUFFIER
    3. COok sweet, i just got home from work. I will give that a try in a little. And yer i will have a few results from each one, so i assume i will have to return it like nobed=result 1,result2,result3... Because before they were in 1 long chain, nobed=result1&location=result1 and looped etc
      singulars
      1. PO
      1. USBenyaman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload