Flash :: Data Integration - MySQL - PHP - Display A Full Recordset
Jul 29, 2006
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).
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?
I'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
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.
I 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.
I 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;
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]
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.
I want to get image data from php and also display in flash. I want to know... how to read and display imagejpeg( $imgData ); from php. I am able to get php data in flash through below method...
I am a complete rookie in ActionScript2.0/Flash.I just started learning regarding a project. My problem is I want to display data from MySQL in a DropDown Menu in Flash. the SendAndRecieve functionality only aids us to receive any responses,right?(Please correct me If I am Wrong.
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.
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 have an SQL database setup which contains Herbal Information such as CommonName, LatinName, MedicalUse etc, and need to display the information in a Flash DataGrid Component. I also have the corresponding PHP script to connect, retrieve, add and delete items from the database. Although I am familiar with Flash in a design sense I have limited experience using Action Scripts and am unable to complete the connection myself.
I'm trying to deploy flash e-learning with dynamic content on a content management server. The xml will not display, no matter how many different approaches I take. So I need a method of encapsulating lots of text within Flash and referencing it from say, an actionscript window.
I seems that referecing any outside content, be it an external actionscript file or text file is out, so I'm left with the option of encapsulation.
I am building an application in Flex Builder 3. Yes, I know that it has an auto-magic feature to build datasheet, but that will not work. I see many Flex controls, such as combo box, can take an array as a data source.
My question, therefore, is (1) How do I send the request from my action script to my PHP form to request a record set. (2) Presuming that my dataset is in a PHP assoc array, how do I format it to send it back to Action Script. (3) How do I take the data received from the recordset, and put it inot an actionscript array, suitable for use as a data source.
I can connect to my database in PHP, and query it just fine, so I don't need help with that. For consistency, and humor, lets presume that I have the following data in an assoc array that I pulled from a database.
Ok, so I've read up on the TextArea class in Livedocs, and i've been looking at XML explanations and their implementation into Flash for about a week. I've tried this EXACT code on another Flash document, except on the main stage instead of embedded inside of a separate movie clip, and it worked perfectly. Can anyone explain why the text won't display in the TextArea? Does it have something to do with it being inside of a movieclip and that being placed on the Main Stage? (By the way, proxy.xml is just a copy of the xml produced by my CFM proxy for easier usage, in case you were wondering.
I am using an xml file to display text in a flash file. It works fine when it?s horizontal but I need to display the text vertical, the screens that will be playing the flash will be rotated 90 degrees so that they are in portrait view. When I do this the text does not display at all.
I'm designing a website aiming to provide visual coverage of surfing locations across the UK through the use of webcam images. Each of the images themselves will be retrieved externally,with permission, from various hotels over-looking these locations.I have spoken to someone who has completed a similar project,a widget which retrieves and displays webcam images, which can be viewed here:
Is there a tutorial somewhere that tells/shows how to display an image from a db. I have my image paths in a mysql db and I am using php to display my other text fields. I just haven't been able to get my images to show. Below is the code that I am using so far. Here is my actual goal, I am trying to have a flash document the has a list in the datagrid that is connected to a mysql db. I have successfully done this. When a user clicks on a product in the datagrid it populates the details below the grid and I have done so successfully. What I now need is to show a picture of the product in the details section. I would also like to see how to show different images for different vendors, each vendor has its own image size, so if I put just one image placeholder then some of the images will be scewed. I need something that shows image in placeholder 1 if company=1, show image in placeholder 2 if company=2, etc.
I've been building an XML feed reader, here's the code I'm using:
var myXML:XML;var myLoader:URLLoader = new URLLoader(); myLoader.load(new [code]....
It works fine and loads the XML inside the flash authoring environment (ie when i preview with crtl+enter), or when I make an executable projector, but when I try to run the SWF by double-clicking, or when the SWF is on the webserver, the text box doesn't display the data...
I'm having a slight problem getting XML data to read out in dynamic text files. I'm doing a pretty small experiment here. The XML file loads fine. I just must be making some small error in how I assign the value of the text fields to the values in the XML file. Can anyone please tell me my error? I am using Flash CS3 and ActionScript 3.
I have RSS reader it's work fine with english but the problem is arabic text don't display in RSS reader just english and about to display arabic text in ScrollPane component that component reader info from xml file and display it?
I need to parse and display the value for variable VALUE in xml to the screen but read from the file continuously instead of once. The XML file is being created dynamically so its getting larger but flash only displays first value for variabel VALUE.
I have a video player that is currently using XML for its video library which is all fine and dandy. Now I have some developers working on a CMS type page in PHP that is going to hopefully pass some sort of information to my player that will let it know where the video is stored on our server. Is there a way to do this without using FMS? If so does anyone have ideas where I can find the information for it.
I'd like to create one empty Flash movie that is essentially a placeholder for externally loaded content I can change through XML. This content would just be able to randomly load 1 of 3 photos, with a button linking to a website within each of the photos on page load. If the user refreshes the page, a new photo with it's link would appear, but I understand since it's random,having 3 images the same image is likely to reappear, but I can always add additional photos and links.
Does anyone know of a tutorial that might lead me on the correct path to create this? I've found some tuts, but they've been different than my need.