ActionScript 3.0 :: Flash Refreshing The Php / MySQL Results
Jan 21, 2011
I have a very simple panel for adding some data to MySQL db using php scripts. The main view of that panel is a list of the collected data and a button to add a row at the end of the current db records. Here's the work flow:
- I click the button to add a record
- Fill out the form
- Hit the submit button
- The record has been added to the db
- The form disapears and the list of the records is displayed again
The problem is: - The list with the records doesn't include just added record To solve that problem I came up with an idea to put all the elements within the MovieClip "list", and try to remove this MovieClip from memmory and redo whole script again. Submit button of the form has the code to trigger the php script adding the records and tells the timeline to gotoAndPlay(2) which the code you'll find below. Unfortunately, that seems to not working.
[Code]...
View 2 Replies
Similar Posts:
Dec 18, 2003
is it possible to get data from mysql database and post it to a flash movie dynamically without refreshing browser?
View 6 Replies
Feb 18, 2011
i am using Flash CS4 (AS3) + AMFPHP + MySQL to do own flash frontend for Wordpress CMS. Everything is going fine but i`ve got one problem. Problem with properly display of result of query in AS3 by using ArrayCollection.
When i check my service in "amfphp/browser/" in web browser i`ve got this (with all needed data):
...
(mx.collections::ArrayCollection)#0
filterFunction = (null)
length = 2
[Code].....
I know that "result" is an ArrayCollection type but i don`t know how to get rows and columns from this. I know that my data is there but i have no idea how to get it.
how to get to Arrays and simple data variables which are in ArrayCollection.
P.S. I tried also change query type in service.PHP for mysql_fetch_query but in that case i`ve got only one row (not all data).
View 3 Replies
Nov 28, 2010
I'm trying to develop a simple as3 flash program that passes a collection a variables and returns a result based on the filtered results of a mysql table. Here is my as3 file:
[Code]...
No value is returned. If I replace with '$test4' and '$test5' with numbers such as 1 and 17, a value is returned. Where am I making a mistake?
View 1 Replies
Feb 9, 2011
This is more of a database design issue but almost everybody here uses database integration with their apps so I feel it is important. I am integrating AS3 + mysql + php and need to clear up the database design for multiple students results in various activities. Developing an online e-learning course with a "dashboard" or teacher control panel with all kids results in each activity. I have read the database design rules by Codd etc... understand the need for parent and child tables so information is relational and not duplicated etc... BUT I am not sure how to design the results part. Various students do various lessons with 10 activities which each give a mark out of ten. The table would be updating every few seconds as 10,000 users would be online at the same time
1. Would I create a results table with all the students results going in the same table ie: Tom would be the first row
[Code]....
View 5 Replies
Jul 8, 2010
I am refactoring some code. I have a PHP page that contains a MySQL query and stores the result in a PHP variable $my_result. This result is then echoed to a Flash SWF during embedding with SWFObject. I now want to call this PHP page that makes the query from a javascript function like so - one change I have made to the PHP is that instead of storing the result in a variable $my_result I am echoing the result. Javascript function to call the PHP page and make the database query
[Code]....
View 2 Replies
Sep 30, 2009
I have a flash file that has frame 1, 2, 3. And below that is a Continuous Layer that has an OK button. (If I go to frame 1/2/3 the button is still there)This button calls a javascript
PHP Code:
on (release) {
getURL("javascript:command('check',1)","_self");
[code].....
View 2 Replies
Apr 16, 2007
The questions I posted last week dealt with XML and localConnection. Basically I had 2 swfs on a page. The main swf has the ability to modify some XML data (via an ASP script and database.) The second swf includes content populated by some of that XML data. When the data is modified, the first swf sends a call to the second (via localConnection) to refresh that data. I had everything working perfectly Saturday afternoon until I tested it in IE7 (on Win XP Home.) Older versions of IE, Firefox and Safari all showed no problems, but when the data should have been modified nothing seemed to happen. Nothing updated, etc.
I was able to confirm in the database that the update was actually happening, just not appearing. At first I thought IE7 wasn't playing nice with localConnection, but I eventually determined that IE7 wasn't playing nice with XML since it would happen in swfs that didn't use localConnection at all. localConnection was running and acting as it should, but IE7 was caching the XML feed even though the only component ever making a call to the XML was the swf. The XML was getting cached in IE and IE wouldn't let go (the only way to see updated data was closing and reopening the browser,or going into 7's new browsing history to delete the cache.)
The work-around I used was to add a querystring variable to URL for the XML feed. Every time the swf looks for it, it uses getTime to add a number of milliseconds to the end of the string so IE thinks it's getting a new file:
Code:
currentDate = new Date();
currentTime = currentDate.getTime();[code]....
I've been testing it on and off since Saturday evening and it seems to work without issue.
View 2 Replies
Feb 2, 2011
I have a typical Flex-based application that was written to use a Java/Hibernate/MySQL backend. The client changed the requirements - now they want to distribute it on a CD where the user can just run the app without any installation or a network connection.
To do this, I certainly need to eliminate the web server and the database server and adapt my application (with as few changes as possible, of course) to a stand-alone application that will fit on a CD/DVD. I've managed to export the data to XML and read it into Flex, but I'm wondering if there's a way to recreate the Hibernate data structures in Flex so I could change as little code as possible. Failing that, is there any way to keep the existing Java/Hibernate external to the Flex code but retrievable without installing Apache Tomcat or MySQL?
View 3 Replies
Jan 13, 2010
I have a Flex application which manage a database composed by 7 tables.I have created the insert form and all work great. Now I wanto to improve the Form performances; the idea is to replace the TextInput of the Form with ComboBoxes which are provided by the DataBase tables
View 1 Replies
May 25, 2010
I have downloaded MySQL JDBC driver from [URL]... How do I configure it?
View 1 Replies
Sep 3, 2009
I'm creating a whole website with one .fla file. I'll attach the flash file to a html page in dreamweaver and that'll be that. But something has occured to me and that is if anyone presses the refresh button, the whole site will jump to the frame just after the preloader. Which would be fine under a normal circumstance if the main page were on that frame but in this website there is a movieclip on that frame which forms into the main page on the frame after.
So how do get it to refresh onto the main page?
View 0 Replies
Jan 4, 2010
i'm sending flash vars to php, but the .swf refresh when the fuction "send" is call.
fo exemple:
var myFlashVars:LoadVars = new LoadVars();
myFlashVars.cor="Blue";
myFlashVars.send("http://urlpage.php","_self");
when this happen, the page refresh and also the .swf
View 3 Replies
Dec 2, 2010
[URL]
Code:
import flash.events.ProgressEvent;
stop();
function update(e:ProgressEvent):void {
var percent:Number = Math.floor((e.bytesLoaded*100)/e.bytesTotal);
preloader_mc.preloaderBar_mc.scaleX = percent/100;
[Code] .....
View 3 Replies
Oct 22, 2011
In my table the Collation is:latin1_swedish_ci (but i tried UTF8_unicode too).In my flex application when it shows the table,it displays it correct,with all accent and pointing correct,but in the table is like :
View 1 Replies
Nov 1, 2010
I built this simple form basically following a template.Everything is working fine but I'm not receiving any results. write the code so that the results will be sent to my email adress .(My site is hosted by FatCow).
send_btn.addEventListener(MouseEvent.CLICK, fl_MouseClickHandler_7);function fl_MouseClickHandler_7(event:MouseEvent):void{ var allVars:URLVariables=new URLVariables(); allVars.name=theName.text; allVars.email=theEmail.text; allVars.message=theMessage.text; var mailAddress:URLRequest = new URLRequest("http://www.fatcow.com/scripts/formemail.bml"); trace(theName.text); trace(theEmail.text);[code]...
View 1 Replies
Nov 27, 2010
would go about setting up flash to display results returned by a SQL query one at a time.I can work out the query and PHP, but want I want to know is how to make flash take each one and animate it, including pausing and clearing the screen when full, then continuing on a 'new' screen. It's basically for displaying a list of events in a database.
Blank screen
Event 1 (pause)
Event 2 (pause)
[code].....
View 1 Replies
Dec 15, 2009
I have been looking for a tutorial that shows or explains how to display the contents of a search engine like 'Google' or 'Youtube' inside Flash. No luck so far...
View 1 Replies
Jan 18, 2010
I am working in Flash 8 and using AS 2.0 coding. I am working with page flipping application. Here I have an option "search". I will tell you the scenario. Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages. How this functionality has to done. How to search the jpg's with a given string?
View 1 Replies
Jul 29, 2009
i can find and cant get this to send a email.here is the code i have:
Flash/AS3:
stop();
submit_btn.addEventListener(MouseEvent.CLICK, sendInfo);
var emailfrom:String = "someone@somewhere.com";var emailto:String = "someone@somewhere.com";var emailsubject:String = "test
[code]....
Nothing happens when i hit the send button can anyone tell why.... I just got off phone with web host provider and they do support asp and i do have the correct SMTP
View 32 Replies
Dec 1, 2009
I am kind of new to flash and I want my flash site to get the best results from search engines.So I found SWFOBJECT is this the way to go? Also how do I use it? Is there any learning videos out on the web.
View 9 Replies
Jan 17, 2010
I am working in Flash 8 and using AS 2.0 coding.
I am working with page flipping application. Here i have an option "search". I will tell you the scenario.
Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages.
How this functionality has to done. How to search the jpg's with a given string ?
View 1 Replies
Mar 15, 2012
Using Flash CS3, having issues getting flash to send quiz results to a LMS. Using the Flash quiz templates, exporting with SCORM 1.2 compliance. The LMS is able to track times attempted and if the lesson was complete or not, however the quiz results don't reach the LMS.
I think this can be resolved in the actionscript or the javascript that gets exported with the HTML file Apparently you can control the javascript functions with FScommands from actionscript Something like fscommand ("LMSSetValue","cmi.core.score.raw" + "," + integer); I don't know where in the actionscript this should be triggered from.
View 1 Replies
Apr 19, 2010
Basically an array if fed to callThumbs() which iterates through it and compares the entries with preloaded XML _my_images. If match is found, it's sent to processXML which loads all relevant info and loads a .jpg thumbnail. All this is then fed to createCell which creates a specific cell with position values depending on x_counter and y_counter values (4 cells in a row) and adds the cell into a container _container_mc.
The Problem: This all works fine and looks fine, the problem is that the cells within the container do not display in descending order. They are in random order, probably because some of the .jpg's takes longer to load etc. How do I easily organise the cells within the container in descending order by the XML .id value? Or how do I tell Flash to wait till the thumbnail and data is loaded and the cell created and added?
//Flash (AS3)
function callThumbs(_my_results:Array):void { // selector = 1 for specific items, 2 for search items
var _thumb_url:XML;
[code]....
View 1 Replies
Apr 23, 2010
I've made a query in PHP, and I'm trying to send the results back into Flash via AS3, but it's throwing up this error...
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.
at Error$/throwError()
at flash.net::URLVariables/decode()
at flash.net::URLVariables()
at flash.net::URLLoader/onComplete()
Here is the relevant part of the PHP and AS3 code, including the query. The Flash variable rssAdd is passed over to the PHP which is using it in the PHP query accordingly.
$url = $_POST['rssAdd'];
$query= SELECT title
FROM Feed
WHERE category = (SELECT category
FROM Feed
WHERE url =$url) AND url!=$url;
$result = mysql_query($query);
echo $query;
Here is the AS3 code I've done so far.
function recommendation(){
var request:URLRequest = new URLRequest("url");
request.method = URLRequestMethod.POST
var recVars:URLVariables = new URLVariables();
[Code] .....
View 2 Replies
Apr 5, 2011
I've got a suite of unit tests for my project (pure AS3), and they all work brilliantly outputting standard JUnit XML to the trace output window. However, when I tried to get my test suite running on our continuous integration server I ran up against a wall.Flash is a sandboxed beast, isolated from the file system. I can't see an intuitive way to get this generated JUnit XML in to our CI software so it can be verified as passing.
I've taken a shot at implementing the approach shown in Continuous Integration with Flex,but it relies on reading trace output logged to flashlog.txt that is prone to failure on many fronts (debug player must be installed, flashlog.txt must be created, mm.cfg file must be configured properly). Also, I find that some of the time it fails to find the results in the flashlog and the build fails despite all the tests passing. This could be because I have too many tests and some are being pushed out of the log file.
View 3 Replies
Jan 18, 2010
I am working in Flash 8 and using AS 2.0 coding. I am working with page flipping application. Here i have an option "search". I will tell you the scenario. Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages. How this functionality has to done. How to search the jpg's with a given string?
View 0 Replies
Jul 27, 2009
Without too many details, I have a flash project that has a MOUSE_OVER function that works perfectly when I test the movie within flash and even when I play the swf in flash player. However, when open it in firefox, my mouse over doesn't work properly. Instead of it execution the function on mouse over it executes on mouse down.
Are there any known differences between a web browser and flash player that may cause this to happen.
View 2 Replies
Feb 14, 2012
I have about 10 checkboxes in frame 1. After i choose some of them i have my results in the next frame (frame 2). My results are labels(with some information) and buttons that if you are click on them you see an image in your browser. Now my problem is, my results sometime are too many (labels and buttons) and i can not see them all. I want a simple scroller down and up (using mouseover or scrollbar i have no problem with that, whatever..) so i can see them all.
View 5 Replies
Jan 25, 2010
I'm creating a Flash banner ad that has two buttons as part of a survey, "yes" and "no". I need to export the total number of Yes and No clicks to a separate html document that will display the results of the survey as they stand at that moment.
View 1 Replies
