ActionScript 3.0 :: Get The Data From Php Sql Query Into The Array?
Jan 27, 2011
Did not know what forum to post this in as it covers different platforms and I am not requesting with specific code, but I have lost my way with a project and cannot get back on track. I am building a booking system (ar'nt we all) and it's turned into a puzzle that I can't piece together.
I have a MySQL DB with some php pages ( sql queries contained in the php to get the data) and I have some AS3 code that draws a illustration to the screen of the booking data. At the moment the illustration is drawn from data that I have put into an array. The bit I cant figure out is how do I get the data from my php sql query into the array in AS3?
View 5 Replies
Similar Posts:
Jul 22, 2010
I am building an application in Flex Builder 3. Yes, I know that it has an auto-magic feature to build datasheet, but that will not work. I see many Flex controls, such as combo box, can take an array as a data source.
My question, therefore, is (1) How do I send the request from my action script to my PHP form to request a record set. (2) Presuming that my dataset is in a PHP assoc array, how do I format it to send it back to Action Script. (3) How do I take the data received from the recordset, and put it inot an actionscript array, suitable for use as a data source.
I can connect to my database in PHP, and query it just fine, so I don't need help with that. For consistency, and humor, lets presume that I have the following data in an assoc array that I pulled from a database.
[Code]...
View 2 Replies
Sep 5, 2006
We have implemented a Flash photo slideshow on our site and it works just fine for most of our users. Whenever the xml.load(success) returns false I have the Flash email me a debug report. For the life of me I can not find a common thread between all of these people having problems with the Flash. I don't think it's a cross-domain issue because it works for most people, and I have the crossdomain.xml files where they should be.
[Code]...
View 1 Replies
Feb 11, 2010
how getting data back from a php script which query a DB?
View 1 Replies
Apr 27, 2010
I have been reading this page about passing a query string to a flash file and I have it all set up using Javascript.URL...My next question that the page doesnt seem to cover is how do you then get flash to manipulate the data from the query string?So say I pass example.swf?testtype=1, I want flash to grab the value of testtype.
View 2 Replies
Oct 30, 2009
I want to pass through an array from php (which queries a MySQL database) to flash.
[Code]....
Can I not use any form of array in php when I sendandload to it from Flash? If so I'm going to be typing a lot of code in the next few days.
View 1 Replies
May 30, 2007
I need to run a query and convert the results to an XML string. I *think* I need to do all of this in PHP but I wanted to get some guidance as sometimes I make things more difficult than necessary.
Do I have 2 scripts... one to query and one to process the results to XML? Or can I put them both in the same script. To do the latter is not proper OOP practice, correct?
Once that is done, I can get the data into Flash. I need it to be XML though because the same data is being used elsewhere outside of Flash.
Is this the proper, most efficient way of handling this task?
View 4 Replies
Aug 11, 2010
I'm working on a movie that needs to get the query string data, but I can't just pass it in, as I don't have access to the embedding page, and can't get the author to edit the embedding options. I need to do it all within the movie.
I've seen examples of as 2 using ExternalInterface.call("window.location.href.toStr ing"); but I can't get it to work. Is there another way in as3?
View 1 Replies
Mar 24, 2011
Why flash don't display my data query send from a php file that use the $_GET to retrive the information and run a query to display the result back to flash.but when I change the $_GET variable in the php file for a static value let's say (2), flash display the data that was requested in the php query..with $_GET I get in flash undefined with "2".I get in flash the data requested...
View 12 Replies
Mar 5, 2012
I'm populating a datagrid with some JSON data that came from a mysql query.I was wondering if it's possible to tell a piece of JSON data to go to a column other than the name it has?My JSON data comes in with abbreviated names...
[{"gID":"Rock","vID":"Darby's Pub","gRec":"Yes"}]
and I load it into my dataGrid's data provider...
myDG.dataProvider = new DataProvider(myJSON);
Currently, my columns have to be named...
gID, vID, and gRec
for the above data to be populated.Is it possible to have more meaningful column names, while keeping the abbrieviated form in the JSON data? eg...
GIG STYLE, VENUE, CAN BE RECORDED
or do I have no choice but to make the full names a part of the JSON like...
[{"GIG STYLE":"Rock","VENUE":"Darby's Pub","CAN BE RECORDED":"Yes"}]
View 5 Replies
Feb 12, 2010
I'm trying to display query data into multiple TextInput Fields in Flex.
<mx:TextInput id="stagInput" text="{acContacts}" width="170" x="120" y="74"/>
This is what I'm trying but all that displays is [object Object]
I think I need to define the database field I'm wanting to display, but I'm unsure how to do this as TextInput fields don't support dataField or labelField properties. Is there another property I don't know about? How do i go about fixing this?
View 3 Replies
Dec 5, 2010
I need to send an array of objects from Flex to a Ruby Web service, but sending them as parameters is not getting through since they seen to come through as Objects instead of readable data.
Sending it as raw XML or JSON didn't work either so the last resort might be to send everything in a HTTP query. However, I'm not sure how to do this since the array contains objects, all of which have 4 or 5 properties, and I don't know what the right format would be.
View 1 Replies
Jul 4, 2010
I have a Facebook application that has a picture gallery. It's build in Flex 4. I want to allow users to link to a specific image. How can that be done?
The only way I see this being done is adding a GET var like &my_picture=asd.jpg in the Facebook page URL, but I don't know how to read that from the iFrame.
View 2 Replies
Apr 16, 2010
I'm trying to run a sqlite query in flex to count the total number of records I believe its working fine but I just can't figure out how to display the results - all I get back is [object Object].
private function overviewOne():void{
var stmt:SQLStatement = new SQLStatement();
stmt.sqlConnection = sqlConn;
stmt.text = "SELECT COUNT(user_id) FROM tbl_user WHERE status_status ='Away'";
[code]....
So how do I make a reference to the COUNT(user_id)?
(flash.data::SQLResult)#0
complete = true
data = (Array)#1
[code]....
View 1 Replies
Aug 26, 2010
I am successfully Passing HTTP Query String to Flash Query String.
Resuming:
inside html
Code:
' <EMBED src="Film1.swf'+document.location.search+'"
'+
inside as3
[Code].....
Then Film1.swf can't grab no more the userName parameter.
View 4 Replies
Aug 26, 2010
I am successfully Passing HTTP Query String to Flash Query String.Resuming:inside html
HTML Code:
' <EMBED src="Film1.swf'+document.location.search+'"
'+
[code].....
View 1 Replies
Oct 15, 2009
I have an xml file (externally saved) that is similar to the following:
[root]
[main]
[title]...[/title]
[Code]....
What I like to do is to get what's in [title] tag using HTTPservice, import it into Flex, and save it as array objects, and do the same thing for [content]. This way I can later refer the array object saying title[0] or content[2].
View 1 Replies
Dec 13, 2010
I have bought Learning AS 3.0 (O'Reilly) but I have been having difficulty getting one of the tutorials to run. The tutorial shows how to record data from a microphone to a byte array, playback the saved data and save as a WAV file. For some reason, I can't get this working. When the swf runs, the Flash Settings screen doesn't pop up to request permission to access the microphone but I can still trace properties such as gain.
I've uploaded a zip containing all the classes and an FLA - just use RecordMicrophone_Example.as file as the document class. Here is the problematic area of the code:
[Code]....
View 0 Replies
Jul 20, 2006
I have No problems inserting data from flash to PHP into MySQL,it's sendind them back properlly.All I'd like to see happen is for one row of data to be inserted into a dynamic text field. here's what i've got if i access this php file, it prints out a vertical list from
a single MySQL row,I was happy.
$query = "select row from table";
$result = mysql_query($query, $db);
while($row = mysql_fetch_row($result))[code]...
and Instead of the vertical list (which i would love to see)i get an unparsed data array.
View 2 Replies
Oct 7, 2010
My data grid is displaying stale data, rather than the real time data available in it's data provider (array collection). I've tried refeshing the data in the collection, but that has no effect. Below is my code, does anyone see what could be the problem?
<mx:Accordion/>
<fx:Script>
<![CDATA[[code].....
View 4 Replies
Nov 9, 2006
I have this code inside my flash to name my navigation menu. Now I want to put this outside flash and load it via XML. How do save my different arrays into a variable for later use in my code?
In my nav fla (what i want to load from XML):
Code:
// MAIN MENU ARRAY
var mm_array:Array = ["MAIN1", "MAIN2", "MAIN3", "MAIN4"];
// SUB MENU ARRAY
[Code]...
View 9 Replies
Oct 9, 2010
I have an array collection of strings and integers (which I have displayed in a data grid) and I am wondering if it is possible to export the array collection into an html table? or even a text file for the user to download
I found some pages that had an export to .xls files but I want to stray away from that for now.
View 1 Replies
Feb 5, 2007
Let's say you have the following xml document. Now how do I access the name thumb here is my loop. Also I want to store the value in an array but I don't want the xml tags to be stored in there as well. How do I get rid of the xml tags with assigning the data to an array.
View 1 Replies
Mar 25, 2009
I feel like this should be really easy, but I don't get what I need to do.I have a value bgW[j] stored in "j" equaling a number.But I can't seem to get it to register as a number.What commonly needs to happen to convert this value into a numeric datatype?I've tried a bunch of stuff: eval, parseInt, multiplying it by 1.
View 2 Replies
Jun 5, 2009
I am working on a project in which I am suppose to matain an array of movieclips, and I can also convert the movieclips into bitmap data. so I would like to know which one is the best to use either maintaing movieclip array or bitmap data array.
View 2 Replies
Jan 20, 2007
I have successfully loaded an external XML data file into mymovie. Now I would like to save the node values into an array so ican manipulate and call as required...Is this possible or is there
View 2 Replies
Jul 10, 2009
how do i add data from an array under my first label in an accordion component?
View 2 Replies
Oct 16, 2008
This is probably a VERY basic question, but I have been struggling with it for a while. I have a gallery that loads random images from an XML files. I am trying to get the XML data into an array, but I must be
missing something.
[Code]...
View 8 Replies
Jan 25, 2011
I have a flex webapp that retrieves some names & addresses from a database. Project works fine but I'd like to make it faster. Instead of making a call to the database for each name request, I could pre-load all names into an array & filter the array when the user makes a request. Before I go down this route though I wanted to check if it is even feasible to have an application w/ 50,000 or 1 million elements in an array? What is the limit b/f it slows down the app? (I anticipate that it will have a lot to do w/ what else is going on in my app but for this sake lets just assume the app ONLY consists of this huge array).
View 3 Replies
Mar 7, 2006
This is the meat of my XML file
[Code]...
What i am unsure of is what is the best way to extract this from the XML and put it into a usable flash variables form so that i can get the data for any particular node using only an id? i have my for loop set up, and i know how to access the data ... i just dont know what to put it in! A multidimensional array? A class (i have no idea about that)? An object? heres the loop i have set up it shows how i access the XML....
[Code]...
View 8 Replies
