im trying to load data from a mysql table to a listbox. ive figured out how to get the data from an XML file using this code:
Code:
var options:XML = new XML();
options.ignoreWhitespace = true;
[code].....
i want to fill a listbox with data from a MySql table. the code ive gotten working is for static data from an xml file. here it is:
var options:XML = new XML();
options.ignoreWhitespace = true;
var loader:URLLoader = new URLLoader(new URLRequest("fillRegions.xml"));
[Code]....
this creates an echod file that looks just like the above xml example. so, how do i change my original AS3 code to pull data from this php file rather then the xml file?
what is the best method for loading external XML (with inherent HTML) content into Flash and into the TextArea component?i have an image loader and a TextArea together on the screen. a "story" is loaded which will present a series of images (in the image loading) associated with a corresponding text (in the TextArea). a "story" has multiple image/text sections that are navigatied through with FRWD/BACK buttons. any given section can also have multiple sub-sections or "frames".
[URL]
below is my proposed sample XML structure. i want Flash to recognize how many sections and frames within sections there are in each story XML document - in order to generate a corresponding navigation structure (a tab for each section). HTML content will be immediate availble to loadinto TextArea as user move forward in sequence with nav. and images references can also be preloaded into available MC containers to be swapped into place as user navigates forward in sequence. also need to read and store attributes for each node in the XML to come up in MCs in sequence. and must also be able to parse XML in a way to place simple HTML formatted content (within XML) into the TextArea.would Arrays be used?
<story title = "Story Title">
<section num = "1" title = "Section One Title" >
<frame image = "1.jpg" caption = "caption text
here"><b>Content</b><br><br>content
[code]....
I am wanting to load a list of names from mysql into a textfield in flash. I also want to load just one image from an image path in mysql. How can this be done easily?EX. SELECT name FROM table WHEREEX. SELECT imagepath FROM images WHERE id=`1
View 1 RepliesI am wanting to load a list of names from mysql into a textfield in flash. I also want to load just one image from an image path in mysql. How can this be done easily?
EX. SELECT name FROM table WHERE
EX. SELECT imagepath FROM images WHERE id=`1`
it took me so long to write this tutorial Well, here I go... Section 1: Introduction So you want dynamic content on your Flash movie. Sounds simple, right? Well let me tell it is, and well, it isn't. This tutorial assumes a basic knowledge of Actionscript, PHP and MySQL. If you have that, it's time to move on. Otherwise, I recommend you do some reading on the subjects... Section 2: Setting up your SWF to receive external data Loading external data into an SWF is a fairly simple task. Although the external text file method is probably the most widely known, it is by far the clumsiest way to get data into your SWF. Of course, this may be your only option of your server doesn't support MySQL/PHP! But for those of us who are fortunate to have these privileges, let me show you how Flash can get external data without having to create additional text files.
Dynamic text fields In order for Flash to get data from an external source, you need to make use of dynamic text fields. Simply place a blank dynamic text field on the stage and make sure you give it a variable name (NB: dynamic text fields have both an instance AND a variable names. In this case we want to focus on the variable name). Note the name you give to the field's variable name, as we'll need it when we write our PHP script. Once you have a text field setup, convert it to a movie clip symbol. Attach the following code to the resulting movie clip:
[Code]...
For various reasons, I would prefer to store binary data like images and videos as BLOBs within a MySQL database and have Flash retrieve that content directly from the database as opposed to getting it from a URL on a fileserver. So, I have written a PHP script that Flash calls which does a database query and returns the bitmap data from the BLOB. I have verified that the image data is being sent from the database through the PHP, but Flash either doesn't display the image or gives me an error saying that it is an unknown type.
[Code]....
Is there a way to get Loader() to accept bitmap image data that is retrieved from a BLOB in a database? Should I try to get PHP to mimic the response from an HTTP server or is there another way to load bitmap data stored as a BLOB into a display object?
I am able to load my XML file into flash and trace results. Want to populate listbox with information from xml file.
[Code].....
I'm populating a listbox like this: dp.addItem( {label:"red dress", data:"OV4MP/23OL.swf"} ); Instead of data:"OV4MP/23OL.swf", I would like to make part of the data file name a variable from a dynamic textbox named centerPt that belongs to the parent movieclip, so I did this: dp.addItem( {label:"red dress", data:"OV4MP/23"+MovieClip(parent.parent).centerPt.text+".swf"} );
[Code]....
Is there a way to organize data into a hierarchy within a listbox?I would like to have a parent-child list with the parent always being bold.I'm not asking someone to do it for me, I would just like to know if it can be done and maybe some direction.
View 1 RepliesIn lee's xml tutorial he uses the list component and the text area component but when he tested the swf he had to select the item befour the text field was populated.
i have set the selectedIndex to 0 but the data still does not load untill an item is selected.
I got a music portfolio web site running PHP, MySQL and Flash. There's a page showing all the artists my client worked for and when you click on a song title, this title is passed as a variable to a PHP page then to a Flash page. The Flash page contains an actionscript music player which then looks for the right audio file in the database and plays the song. Everything works great except for the dynamic text field which displays the song title. If the song title contains an apostrophe or a single quote, the Flash dynamic text field then shows the apostrophe.[code]
View 1 RepliesCan anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 RepliesI would like flash to send and receive data from mysql.
To send data I would like to create 5 input fields, and then use a submit button.
Then to retrieve the data I would like to use the data grid or a dynamic text field.
I'm trying to make a banner which the user can edit his Preferences in a xml file. My xml file looks like below.[code]that means image 1 has three textboxes with fontsize: 14,18,30.now i've the following problem.as you can see i've get function from my billboardData_array i want to call this get function in other classes to get the correct data i need. [code]this function returns the last fontsize but i need to loop through it to display text on the stage.
View 1 RepliesI have the following XML and I need to extract just two values in the <yweather:condition> tag
code=" "
temp=" "
(current values are code="34", temp="73", shown in bold below):
[code].....
I have a flash application which contains a "dynamic text"with a var name "myVar" and an instance name "dt_txt".I have a button to which I attached the code:
____________________________________
on (release) {
var lv = new LoadVars();
lv.load ("[code].............
I make a XML connector component parse a XML document.In a node, there is a "<br />" (return to line in HTML)
<book>
<page>
Here some text and a <br /> here ! the code s broken up here
</page>
</book>
My XML connector considere the <br /> as the beginning or the end of a node !...How to avoid this <br /> or other any HTML element when parsing some XML ?
I am having a problem parsing xml data, I know how to get it into as3, and that is working pretty well after following a brilliant tutorial on kirupa:[URL] But I am having a problem tracing the data that I want. Seemingly it is connecting to the database and is working in that sense but when I try to trace data I am getting a couple problems. The first is that I need to somehow specify a value of a single item to get the rest of the data. Here is the xml:
[Code]....
I'm being passed the following from our ASP developers: Code: DefaultValue1=Photo1.jpg::Taken 2-24-05~Photo2.jpg::Taken 2-24-05 Now I need this obviously to show an image in a placeholder and then Taken 2-24-05 Would be text for a textfield.
View 10 Repliescreating a frontend for a podcasting website. It will basically run from an xml feed produced by podpress. This isn't particularly important.My question is, how do I import xml entries with colons ":" in them. For example the line highlighted below.
Code:
<item>
<title>podcast1</title>
[code].....
ActionScript Code:
//request is made to PHP script
function completor(evt:Event):void {
var getor:URLLoader = URLLoader(evt.target);//works
var vars:URLVariables = new URLVariables(getor.data);//doesn't work!
}
getData.addEventListener(Event.COMPLETE, completor);
The first line outputs something like "&var1=something&var2=something_else". I just can't get why when I try to parse the data from the loader object into variables (second line) Flash simply stops and all the code after doesn't get executed.
I have the following XML and I need to extract just two values in the <yweather:condition> tag
code=" "
temp=" "
(current values are code="34", temp="73", shown in bold below):
[code].....
So I have now tested my file with a test xml and it works just fine, but I need to get the dat from the server so it becomes dynamic. I've gotten some php to generate a xml document, but I can't get it to "be" an xml, it's just formatted like it and it's a String.
Can I somehow convert the String to a XML variable, or will I have to cut up the string and get out the info I need.
In the second case, what would be the best way to parse the data in php (what formatting)?
The xml looks like this:
Code:
<portfolio>
<project title="a name" info="Bla" thumb="files/thumbs/p1.gif">
<file title="a name" info="blabla" thumb="files/thumbs/p1_1.gif"
[Code].....
And with all those < > " = symbols I think I would have a hard time to break it apart. The result should become an Array which contains project Objects with properties and another Array to hold file Objects with their own properties.
But the general question is: String to XML, how? If not possible, how to build this xml shaped String so it can be picked apart easily?
I want to display a list box in a different way. I have uploaded the image as well i.e., what exactly am looking for and how the list box has to look. I am parsing the xml data and it's coming fine in list box. but my requirement is the look n feel of list box.
Flash code :
var xmlLoader:URLLoader = new URLLoader();
var xmlData:XML = new XML();
xmlLoader.addEventListener(Event.COMPLETE, LoadXML);
xmlLoader.load(new URLRequest("news1.xml"));
function LoadXML(e:Event):void {
xmlData = new XML(e.target.data);
ParseNews(xmlData);
[Code] .....
I have intercepted x-amf data being posted to a website from my computer by a flash application. I have the collected POST data in hex form. While some of it has translated directly to text, the rest is showing wierd symbols which probably means they're flash objects. How do I parse this data to get meaningful output outta it?
Basically, I need a script/program/anything that will take in amf data in the hex form, and output text and flash objects...
I have a what I thought was a fairly simple scrolling number list (like a lotto ticker) and am trying to parse the XML data to display the digits for some reason I am having some trouble. Perhaps I could play the mc of the spinning numbers and then stop it and just import a number into a text field?
private function loadXML() : void {
var loader : XMLLoader = new XMLLoader();
loader.addEventListener(XMLLoaderEvent.COMPLETE, onXMLComplete, false, 0, true);
loader.addEventListener(XMLLoaderEvent.ERROR, xmlErrorHandler, false, 0, true);
loader.load("testRBS.xml"); //userStandingsXML.asp
[Code] .....
How can I parse my incoming string returned by server and get values?
Look at the code below, that is part of a class I am writing:
Code:
var PHPURLRequest:URLRequest = new URLRequest(MyServerURL+"myscript.php");
var PHPsendVars:URLVariables = new URLVariables();
var PHPLoader:URLLoader = new URLLoader();
[Code]...
Can anyone tell me how to create ActionScript to parsing data from website?
View 5 Repliesi'm still transitioning from as2 to as3, i'm having trouble with parsing XML data to Multi dimensional array, below is the onComplete handler which is succesfully tracing 'event.target.data' but outputs 'A term is undefined and has no properties' when tracing _vein_data[0][0].xPos. I'm guessing there is a easier way to approach it than this attempt
[Code]...