ActionScript 3.0 :: Way To Periodically Check Database
Nov 23, 2010
I tried to search the forum for this problem but my browser every time got too busy to load the search results, so i thought I'll ask it in a new thread.I've made a Chat in Flash CS4 with AS3 - PHP - MySQL.I set a timer to check if there are new entries in the database once in every second. This way the chat window is refreshed every second. Works fine.But I think, if (let's say) 100 people are chatting, the server is bombed by 200 queries (1 for the message and 1 to find who sent it by userid) a second.Is there a way to periodically check the database if there are new entries without making queries? So Flash will ask for new data only if there IS new data available.
I want to make a small application that reads an RSS feed.However, this will be part of an installation, thus this is supposed to run "forever". Do you think there is another way than using the Timer class, that would check for new posts on the feed every 15 minutes for example? Do you think this will be a reliable and safe approach?[and an extra questionFor that purpose, is it worth to make an AIR app, or just an executable from the flash player? Do I have some pros/cons regarding memory, resources, etc when using AIR?
I have a swf that connects to Flash Media Server. What I am looking to do, is display the connection status via a green (connected) or red (not connected) icon. I need it to check frequently and update the icon according to the connection status.
I have the following code but it does not work. I have a connect/disconnect button which starts/stops my connection to FMS. That works, but when I unplug my internet connection (thereby making it impossible to be connected to FMS), it still says it is.
For example i have this php code to check if the username is already in the mysql database
[Code]....
as you can see if the statement is true, it does nothing. I can't for the life of me figure out how to pass an error message to flash. If it helps, here's my as3 code.
I am using the following code to Pause, Fade-in & Play a streaming Mp3 from an external site:[code]The problem is that this file is never-ending and ultimately slows the computer WAY down. I'm assuming this has to do with the cache filling up with the never-ending Mp3 file.Does anyone know a way to periodically dump the Cache or... limit the amount of the file loaded into the Cache? Say 3-5 SecondsI am assuming a "DO NOT CACHE" code won't work as the Mp3 is streaming and requires a certain amount for uninterrupted play.
I'm using Flash CS4 and Actionscript 2 and would like to know if it's possible to call an external script (php script) or take some kind of action (like update a database, write to a file etc) at regular intervals while a video is playing?
1. Is video playing?
2. If yes and time is more than 5 mins (or some inteval) then call a script
I will be trying to obtain data from a periodically updated xml file. As far as I know, this file will simply continue to have data added to it indefinatly. Is there a way to load only the newly added data to the xml object? As opposed to loading the entire xml file each time I want to update my flash movie with new data added to the xml file?
I run through the process of making code for a whole scene without compiling periodically I overlook where a child is added to and try to remove it from somewhere else. However, I dont believe this to be the case on this occasion. I have only two funcytion that deal with the addition and removeal of the children of the mc that is throwing me errors. If I add the simple:Code: Select allif (holder.contains(thisChild)) {It stops the error but doesn't fix my actual problem...
Code: Select alloverride public function unLoad():void { for (var i:int = 0; i < currentDeck.length; i++) { currentDeck[i].removeEventListener(MouseEvent.CLICK, clicked);
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...
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?
Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything. So, my issue is this. I have a mySQL database hosted I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.Here is my licenseTracker.mxml
I am working on a function to generate a form at runtime in Flex based on a call to the DB. The call to the DB returns the field types, id, tooltips etc as an arraycollection, the arraycollection is then parsed in order to ascertain what control to display based on the type field in the array - this bit works fine.However, i am stuck on trying to save the form fields back to the database using a CFC.my form rendering code is as follows but how do i save values entered back to the database? rendering code..
[Bindable] public var getglobalprofileb:ArrayCollection; public function init(event:ResultEvent):void {[code].......
I have updated the mxml code to only show the needed code for the program to run the update.
I am new to Flex and have an issue I hope you all can help me out with.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything.
So, my issue is this. I have a mySQL database hosted on 000webhost.com, I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.
I am planning on using Flash Builder 4/Flex to write an AIR application which is primarily based around recording, storing and analyzing data.I'll be creating charts etc that need to update in almost real time.It's essential to me that the application be able to function without an internet connection so I need a local database of some variety,but I would also eventually like to build in online synchronization of the data where either database can be update each other based on newer information. Moreover, some type of encryption would definitely be welcome, and speed is a large concern
Synchronization: Primarily updates/additions/deletions will be done on the offline database, but ideally I want to have a web interface that will allow the same updates/additions/deletions and will be synced (beyond that I'm not sure exactly how to do it as I can model that based on what is most achievable).I'm wondering if there's any prebuilt engine that could handle the synchronization of 2 databases. I may end up having the web interface only be for additions, which would be significantly easier to sync.. and I may start that way, but i want to build with technologies that will best allow me to implement full online crud at some point.
Here is the issue: a client wants his entire equipment inventory accessible by persons navigating to his jquery mobile site. The inventory that exists on the desktop site was, as I understood, built with Flex. Is it possible to access this database for the jquery mobile site? I believe it is. I was then given this information from someone in the know:
Is it possible to create a database driven website using these alone? Or do i need to learn any other technology? If i do then what should i learn? I know j2se for the desktop and oracle SQL/MySQL i finally got the feeling that i need to learn PHP anyway along with css and javascript. So it is fine. Also another query. Which CMS should i consider? Wordpress or Joomla?
I am planning to develop a standalone application, which infact will be used for personal purposes. So only single user access may be there. I want to develop it in Flex. Just want some opinions from the gurus over here : Whether i should use Flex or AIR (I know only Flex, AIR i need to start learning)Which database i should use? SQLLite or HSQLDB or some other.
I have a database on a server and I transfer the data from it to a web site. So I need to build a flash grid on this site and to load the data on it. But the problem is that I do not know how to do it. So my question is how to build a dynamic flash grid wich is fill with data from a database? Is there a way to do it with action script only or I must do it another way?
I am writing a large flex app that has to connect to a database many times. I currently am using asp pages to connect, but I would like to use the most efficient option. What do you think is the best way to connect to a database from a flex app?
See [URL] Now there is a button called Answera, which when clicked should have a symbol (movie clip) called Check appear at the cordinated specified. Check exists in the libary (but does not have an instance name) and no where else on the stage. when I run this code I get: 1180: Call to a possibly undefined method Check. -> var rightCheck = new Check(); How is it undefinded if it exists in the libary?
The following is my codes. This is still work in progress; so, you will see some functions with empty contents. Plus, this is my first Flex application; please bear with me. This is a quiz application that gets the questions and answers to each questions from a ColdFusion web service. There are three types of questions, True or False, Multiple Choice with single selection, and Multiple Choice with multiple selections. So, based upon the question type, the application would dynamically generate the appropriate amount of radio buttons or check boxes for the users to select. I got these working. The problem that I am having is, I am not sure how to check what the users have actually selected. In some other forums and posts on other web site, it said that I can use event.currentTarget.selectedValue to get the user selection. But when I actually do it, I got a run-time error saying, "Property selectedValue not found on mx.controls.FormItem and there is no default value." My question is, what do I need to do to capture the user selections?
I want to create a login page in Flash, containing two text fields (username password) and an Enter button. The database I am using is MYSQL where is a table with username and password elements. For the connection I must use ASP.NET and not PHP.
I am wanting to try to use a sqlite database in my project.I have downloaded several sqlite managers from the internet and they all save the database with a sqlite extension.However I see in flash we use the db extension (is this correct?);How can I use the databases I create if they all save with a sqlite extension?
I have a list of items in a database as well as images in a directory folder. I am looking for a flash app that can pull from the database to display the info and also the images and scroll this info vertically with associated links. I need to change this for each client by adding their unique "ID" in the code so their information pulls in correctly.
how to read from the database.as i said, that is only part of the job since it only shows how to read from the database, i also need to send to the database a string of about 7k (more or less 5000 to 700 bytes, in a single string)i would like to do that trough php, since it should use the same php session id. does anyone have references to this? (write to a databse from flash, if possible using php as middle layer)
