I like to call for different SWF files from a link in a MySQL database to use in a Detailpage with PHP. Photos and text are no problem. The AC code is probably complicating things.
View 6 RepliesI 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 need to create a stand alone desktop app that uses a database. It's been a long time since I did any VB work, and I need to learn Flash for another job anyway...is there any reason why I shouldn't use Flash for the desktop app?
View 1 RepliesI'm in the process of expanding an admin area for a website (coded with PHP and MySQL) and would like to get my client list into a flash combo box. the main columns I would need would be the account and the company name... In a regular example would be
<select name='client'>
<option value='2460'>Client 1</option>
<option value='2461'>Client 2</option>
</select>
If I could get this I should be away...
ive managed to get info from a mysql database into flash in a combo box. i have a text field and i want it to load in the corresponding data when a new title is selected in the combo box.
View 1 RepliesI would like load values from mySQL to select from in a combobox. I would love to do this the most simple way w/o php, but that
View 3 RepliesI am a DBA and I provide data to the developers at my companyin XML format. The developers create Flash graphics and use the XMLto populate data variables. I want to start requiring thedevelopers to make calls directly to my MySQL databases so anytimei have to make a change to the underlying data, I don't get stuckgenerating an updated XML file for the developers.My developers tell me a Flash graphic cannot make a calldirectly to a mySQL database. They say Flash has to reference apage in which variables are defined, such as an XML, PHP, ASP pageetc. This page, they say, is generated from database info, butFlash does not directly make the call to the database ... thatanother programming technology (XML, PHP, etc.) does and has toparse the information, making it available to Flash.
View 3 RepliesI am using the function below to convert a Flash AS3 Date type to a MySQL- compatible 'datetime' string. It is working fine, BUT I am worried that AS3 may not extract the 'same date format' from different client computers thereby rendering my function useless.Is there a better way of passing date to MySQL? One that gaurantees consistancy.
public function getMySQLdate(flashDate:Date):String var year:String;var month:String;var day:String;var hours:String;
var minutes:String;var seconds:String;
[code]......
First time on here.We teach English through games. All done on flash AS3 now. Want to put courses online so I have been told to use php to communicate to server and database. My question is:Do I use mysql to save stats or xml FIRST: I will get info from xml and send it to my activities in flash - I'm OK with thisSECOND: I want to send out stats from flash to mysql OR xml. The stats are:1. Student logs on of course using username and password (well that comes in not out)2. What lesson the student is on ie: 2, 3, etc...3. Highscores for game activities4. Scores student gets on each activity As far as I can see the only stats that grow are the scores on each activity and even those could be erased periodically.
View 1 RepliesFor 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 need to display a full recordset (say a table or a select from a table, returning many rows, not a single one) in a Flash doc, but I'm clueless. BTW, I read in other messages about amfphp which seems to be a good choice, but I can't use it on the Web Server (got no choice here).
View 2 RepliesIm new to placing external data into Flash. I just got CS3 and Im trying to use Flash to dynamically load XML data via a FlashVars call in the HTML.
The problem is I have followed the very straight forward AS2 Help files for using FlashVars and URL variables.I have placed the code directly from the Help file into the Html between
<noscript> <noscript>and i keep getting undefined.I have tried saving the file as flash 8 and i am publish flash 8.
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]...
I have an Access Database (doesn't need to be Access, I can phpAdmin or mysql, whatever will work) that has a list of names. I want the user to open a Flash form and have the names load up into seperate input boxes for each name. The user can then change the names, move them, whatever, and then save the record. I want it to just overwrite the record. I donlt want create a new record. I cannot, for the life of me, figure this out. I have tried to find some tutorials but nothing makes sense. Is ASP a good way to go? I have been struggling with this for a week now.
View 3 RepliesI currently have a Flash app that gets populated by parsing data from an external XML file. However, I need to get the XML data into a (JSP) session and can't neccesarily have an external XML file--any suggestions? Can I put the XML string into a hidden input field in a form on the HTML? Can Flash communicate with that HTML? Or are one of the below methods recommended:
* FlashVars
* Flash Remoting
* Web services
* JavaScript - call JS function
* fscommand
* ExternalInterface
I am trying to have a PHP page load some variables into aFlash banner ad that will be running on 8 different websites...I need to have one central location for the PHP page andallow 8 other domains access this data...I am finding that when everything is on one server... noissues... data reads just fine...But when the PHP page is on one server and the SWF file onanother... the data never gets through...I am assuming this is some issue with security within
View 1 RepliesI am trying to load data from mysql to xml to flash using actionscript and php. Im doing something wrong but not sure what.Basically, my php file (latestnews.php) looks like this
Code:
<?php
header("Content-type: text/xml");
$host = "host";
$user = "user";
$pass = "password";[code].......
this is placed in the same frame number as the dynamic text fields but on a seperate layer. The dynamic text fields are:
Title_txt
Comments_txt
Date_txt
There is no output error but nothing is showing up. The file is using actionscript 2.0 and wondering if the actionscript i am using is write for that format?
I am trying to load data from mysql to xml to flash using actionscript and php. Im doing something wrong but not sure what. Basically, my php file (latestnews.php) looks like this
[Code]...
There is no output error but nothing is showing up. The file is using actionscript 2.0 and wondering if the actionscript i am using is write for that format?
im trying to read data from a text file here [URL]what i cant figure out is how to call each value to its own dynamic text field.
YYYY MM DD hh mm H0 SwH SwP WWH WWP SwD WWD STEEPNESS AVP MWD
2006 12 10 00 00 0.3 0.3 6.2 0.1 3.2 ESE SE N/A 6.1 110
2006 12 09 23 00 0.3 0.3 9.1 0.1 3.6 SE SE N/A 6.2 134
2006 12 09 22 00 0.3 0.3 9.1 0.1 3.6 SE ESE N/A 6.2 125
2006 12 09 21 00 0.3 0.3 7.1 0.1 3.4 ESE ESE N/A 5.9 119
I`m having a trouble loading xml data to the uiloader. Look at my codes:(This is my index class, controller of the data.)
public function pylon() {
loadApp();
}
[code]....
Looking to load data from a MySQL database into a Tile List component. Not sure where to start to be honest, I've got a set up just now to add data from the same database into a List component - should I just use the same code and change it accordingly?
Or is there a simpler, more effective manner of loading my required info (it is a title and an image (x4), which changes regularly, ie every week depending on the sort applied for the products)[code]...
what i'm trying to do is create a "kind of rss feed" but where data gets pulled from my mysql database and gets placed into a dynamic text field in flash
View 1 RepliesCode:
var nc:NetConnection=new NetConnection();
nc.connect("http://localhost/amfphp/gateway.php");
var res:Responder=new Responder(onResult,onError);
[Code]....
The code is working good and brings back the info from mysql via amfphp, but I would like the "goBtn" to bring the info when pressed.
How do I load data from a mysql table to a combobox using php and AS ?
I do know how to retrieve the data from my table needed but how is this inserted the combobox ?
Assume you have combobox1 and combobox2. When I, in combobox1 select: 'cars' I would now like the script to search my table for cars in the column 'stuff' and then insert the result in combobox2.
Throwing this out there. I would like to know how to haveflash grab an XML URL from the embed tag (i.e. embed src=""flashvars="profile=http://xmlfile.xml". Reason:I make thesemyspace templates for people to use, but they can only be edited bypeople who own flash. If the user could edit an XML file with allof their content, then they would be able to use the layoutsregardless of whether or not they have flash. Does anyone here know how to do this? I believe it issomething like this on an actions layer:
_root.profile == undefined ? profile= "mp3player.xml" :
profile=_root.profile;
data_xml = new XML();
[code].....
Have a flash, that loads XML from server. Flash uses it to built up a site menu. Both xml and flash reside on the same host. When I try to run server locally - everything works. But when I try it online, XML is loaded only in FireFox, but in IE it can't be loaded. Flash movie itself loaded normally (I can right-click on it and see standard menu). I put my host into Trusted sites in IE and set very low security/privacy. I don't have any firewalls or proxies. I also put my host and flash movie into Trusted source in Flash Settings Manager.
View 4 RepliesI made a flash music player for my server the player works perfectly and loads the xml data when viewed on my computer and even when it has been uploaded to the server IF I view it by itself but once I try and view my HTML file, all of the information for the songs comes up as undefined, so none of the songs will play.
View 1 Replieswhere you can load an image from a SQL database ? I would like to show this image in Flash, but i don't know how to load in from a SQL database using ASP.
View 2 Replies