-
datagrid populated from mysql via php -
Hi
Hi - I have traced the data via php from mysql in actionscript but the datagrid doesn't show it. Here is my code. So it is there BUT why doesn't the datagrid show it.
import fl.controls.DataGrid;
import fl.controls.dataGridClasses.DataGridColumn;
import fl.data.DataProvider;
import fl.controls.ScrollPolicy;
import fl.managers.StyleManager; //needed to format text in cells
import flash.display.MovieClip;
import flash.net.URLRequest;
import flash.events.Event;
import flash.events.MouseEvent;
import flash.net.URLLoader;
import flash.net.URLVariables;
import flash.net.URLRequestMethod;
import flash.net.URLLoaderDataFormat;
// Create a new DataGrid component instance.
var aDgataGrid = new DataGrid();
var myDp:Array = new Array();
var myData:URLRequest = new URLRequest("http://www.cambridgekids.es/kglad/php/getUsers.php");
myData.method = URLRequestMethod.POST;
var loader:URLLoader = new URLLoader();
loader.dataFormat = URLLoaderDataFormat.VARIABLES;
loader.addEventListener(Event.COMPLETE, dataOnLoad);
loader.load(myData);
function dataOnLoad(evt:Event) {
for (var i:uint=0; i<evt.target.data.cant; i++) {
myDp.push({Nombre:evt.target.data["firstname"+i],
Apellido:evt.target.data["lastname"+i]});
//trace(evt.target.data["firstname"+i]);[/INDENT]
}
myDp.dataProvider = new DataProvider(myDp);
}
aDg.dataProvider = new DataProvider(myDp);
aDg.columns = ["Nombre", "Apellido" ];
aDg.setSize(800,300);
aDg.move(150,200);
aDg.rowHeight = 40;// Allows for 2 lines of text at default text size.
aDg.columns[0].width = 80;
aDg.columns[1].width = 30;
aDg.resizableColumns = true;
aDg.verticalScrollPolicy = ScrollPolicy.AUTO;
addChild(aDg);
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|