ActionScript 2.0 :: Make Flash WAIT Until All The Data Has Been Retrieved From The Database
Apr 20, 2010
I am still working to fix a FIRED developers code he left us with. The code in question goes out and request information from a database, places it into arrays and also checks session. THis is what I think it should be doing. I am getting a bunch of undefined returns ( prints out in the assigned text fields). Is there a way to make Flash WAIT until all the data has been retrieved from the database. This is out first theory.
I found at this Adobe tutorial a nice "RemoteService" class that creates a RemoteObject and contains the functions for handling the result and fault events. If I wanted to use this approach, how could I pass the data from the result handler to interfaces that modules from the main application could use?
I could put the RemoteService/RemoteObject in the modules, but (in my opinion- and I could be wrong) the best design seems to be using the remote calls in the main app and passing the data along to the modules.
i want to intertwine php, MySql and flash. so i can make a flash movie display text that is in the sql database and a php script to change the database, php > sql = i can do but sql > flash = i can't do..i want it so the sql data show's in a text box in the flash movie...
The problem is that it executes #Second before #First, which means that the object is not fullly loaded but the code continues nonetheless. Is there a way handle this? I have tried using a while loop, but this is ugly and makes flash crash. Is there any decent way to handle this, does it have to do with better code structure/program flow or is there a technical way to make it wait? Also note: This code is executed on the server side, which means there are no frames involved.
UPDATE:When projects get bigger, this gets very ugly, especially when you are retrieving mulitple things from a server, you have to use very deep nesting, you have to keep repeating the same code, example for buying a serial:
I'm just trying to make a simple function that will return all the data from my SQLITE database as an array. But it looks like when my function is returning the array, the SQL statement is actually still executing... so it's empty... Does anyone have a suggestion? Or am I just going about this whole thing wrong.I know I could just have the event listener functions outside this function, and they could then set the data. But i'm trying to make a AS3 Class that holds all my SQL functions, and It would be nice to have everything for this particular function just in one function, so it can return an array to me.
public function getFavsGamesArray():Array { getFavsArraySql.addEventListener(SQLEvent.RESULT, res);
how to send data from a flash to a database and how the receive it aswell. Im presuming you pass the data from the flash to a php file to the database when sending and call the data using a php file to the database aswell. What im trying to do is just have a button that will increment a number in a database by 1 and then display that information on a different Frame within the flash later.
Basically what i want to do if have a button pressed to increment a number in a database.
I am creating e-learning material that will be accessedonline by students. Is there anyway that Flash can write to adatabase to tell us how long the student was logged in for and how long there were on a page?
I have made a .swf file that scrolls boxes- these boxes willin the end contain products contained in a ASP database. Here isthe problem, I don't know how to get the Flash movie I have made toSince I don't know flash that well, I have made transparentbuttons to go over the scrolling boxes to open a URL with theaction scripting -----on (release) {getURL("http://www.myurl"); } This works finebut I would like the content in the scrolling boxes to changedepending upon items in an ASP database. In the database, there isan area to specify "featured" items, which are dynamically put onthe site in specified areas where tags(anchors) for the "featured"items are placed. What I think I should do is code the tag(anchor) for the"featured" item into my flash movie but I don't know how to dothis.
I am trying to create a 'Password' database with flash to push both to and from an external database, the only problem is that I do not want to have to run IIS or Apache or any other web server. Is there any way to read a non localhost/web based type database within flash? If so can someone point me to a tutorial or at least in the right direction?
Is it possible for flash to accept value from a database?There is a database storing values "postions" and "descriptions" (there are 2 coloumns named so to store the values).In flash I want to accept the values entered in these 2 coloumns. How to go about it? If I create 2 dynamic text boxes with variable names "p" and "d" respectively and an "accept" button on the scene, what script should I add to the button so that these text boxes accept the values?
so my 2 queries are:
1) how do I send the value from the database to flash?
im trying to figure out if there is a way to use flash as a front end for a database. i need flash to be able to search the database for part numbers and match the part number with an excel file and be able to open the excel file from flash.
I am looking for some advice on creating a flash sound game. The visuals are all done as is the animation. I am trying to create a piano, that you can play a tune, somehow (when pressing down a button) 'record' the sound and once you have finished, send the link to the sound you have created to a friend, where it can be played back when they visit the website and see what you did.
getting data from a database and displaying it in a Flex (Flash) swf. Currently I have some C# code that gets the data from the DB and saves it to an XML file on my site. Then the .swf reads that xml file.
I know how to get the data from my database, but i can't seem to figure out how to send data to the database from flash using amfphp! give me an as3 and php service example.
I want to display html(text) data into flash .Is there any way to do this dynamically? I am able to do this by creating an external xml file but how is it possible to do the same job without creating the external xml file using php and database?
I am working on creating a basic message board for my website and I am having difficulty getting things to pass from Flash to Database to Flash. I just checked out the tutorial on this site that shows how to go from Flash to Database. Which is awesome by the way. I was wondering if anyone could help me on how to get the database data back into flash and post in a message board style. In another related note. Through a form set
I have a little application with five text fields and a submit button that i want to put the inputted data from into a database. i have my database done and everything, and here is the code for the PHP file i'm using:
i'm not very good with PHP but after doing some research and reading some tutorials i think that is good to go. my text fields in flash have the variables that i'm using in the POST_VARS commands in PHP and similar instance names. how would i go about writing the actionscript to collect this data and insert it into the database in flash (or make corrections to the PHP i already have if it isn't ready).
What I am trying to do is bring data in from (mysql)PHP into flash 8 (actionscript 2.0). I got part of this to work. I bring in the text and diplays just fine. So the next step was, To set the font size from anothere php loadvars (code below). Flash will not pick up that part of the code, were I set the font size.
Here is the code: onClipEvent (load) { info4 = new LoadVars() lv = new LoadVars();
I am completely new to Flash and actionscript.I have a small project which requires me to submit details into a MS Access Database. I have created an asp scrip to do the same but it doesnt seem to be working. I am posting the code.
I have a quiz game that i have finish. in this game have a finish button. if the finish button clicked the score from the quiz want to insert into mysql database.
I looked at different flash chart software (free and commercial) and could find only one that supports the feature I want: map my dataset on the predefined X axis. Let me give an example.
Let's say my X axis is time. The time is represented in hours. So let's assume my X axis has last 24 hours. Now the data I have in the database contains data coming every 50 minutes. My goal is to have a chart that will show this data. The point on the graph will not correspond to X axis values one to one.
The simple solution (and all charts support this) is to set X axis resolution to 1 minute and only show "ticks" on A axis every hour. Assuming that chart supports "null" values (and most of them are) - it works fine as an idea.
The problem is that in this case (for all of the charts I know) I have to provide XML/json/CSV as a source of data that will contain 24 hours * 60 minutes points of data, with only ~29 (24 hours, every 50min) containing meaningful data. This puts a stress on 1) database, 2) more traffic 3) makes chart less responsive.Are there any flash graphs that will accept a dataset of ~29 values and map into 24 points on X axis.
I have a website in which the content on the index page is controlled by a PHPMyAdmin database. I want a a flash "movie" at the top, that can take the data from the site, and slide-show it until a user clicks on a specific link, in which the movie will direct itself to the clicked event.
The page is for a booking/promotion concert company. They want a "Featured Shows", "Calendar", and flash file that all are interconnected. One page. Does anyone know how to do this, where to find tutorials, or so on? Note, i'm not wanting to WRITE data to the database, I just want to GET data to post on the flash file.
