Data Integration :: Loading Images Stored As BLOBs In MySQL
May 10, 2010
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?
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.
i am creating a dynamic data list to show data for upcoming events on my website [URL] inside of the flash user interface I created: [URL] I loaded the XML file into the flash movie frame but the image will not show up Here is the XML file code used:
Im having a bit of trouble integrating dynamic variables pulled from a databse using an ASP script with a flash movie.
Background:
I need to send variables stored in a ms sql db to a flash movie to display several values.
The dyanmic element comes in because i am using an ID to select the values from the db e.g id1 = joe bloggs id2 = paul smith
etc
When i am hardcoding the id in the asp script the variables are sent to the flash movie no probs and they display correctly.
I am also printing the asp code on the page and that all displaying fine.
HOWEVER, the issue arises when i make the asp code dynamic and by that i mean I am using request.querystring to pull the id
from the URL - The print out of the asp code is still displaying the correct variables, BUT they are not being passed to the
flash movie at all - the placeholder is blank there isn't event an error!!.
Couple of things to note -
- if you change the id bit of the url in the dynamic script to the printed asp code changes
- THE FLASH MOVIE IS IDENTIAL in both scenarios
- all variable names have remained the same
- it is NOT a location of file issue as we have tested the dynamic code files In another folder and no joy
- we are not using any other file includes or asp code in any of the page - all other code has been stripped out
THE ISSUE WE HAVE IS THAT THE PRINTED VARIABLES ARE NOT BEING PASSED TO THE FLASH MOBIE in scenario 2 where the asp code is looking for the participant id dynamically (i.e from the URL)
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 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 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've got a job for a client that includes creating a flash movie that will contain a number of thumbnails that represents links to avi movies, powerpoint presentation etc. The thumbnails need to be updated and added to on a regular basis. Is it best to call the thumbnails from an xml doc so the client can update easily?In the flash movie the thumbnails will be presented as a horizontal slideshow that needs to scroll horizintally on mouseover, and the thumbnails will also display a caption on mouseover. Is this all possible if the images are coming from an external source such as an XML doc.
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
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 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:
I am loading images from a mysql database. Lets say I was displaying 8 on a page, how can I tell how many pages I have and have it update when more images are added? Like on sites where they have links like
I am trying to create a dynamic menu for a video player. Much like the one found here (MTV OverDrive. )Obviouslythis is a Flash site and I can only assume the video list is being generated via XML. I am trying to accomplish the same thing, only I am not using FCS.
I just want to create the buttons dynamically with thumbnail images and text via XML, and in turn load the video based on a button click. I have the video part working fine, using a video object, I just need to know how to create the buttons WITH THUMBS from an XML file. I can figure out how to load the video once the button is clicked. The problem is the menu itself and loading the different thumbnail with the button.I am sure it has something to do with "attachMovie,DuplicateMovie, or CreateEmptyMovieClip" but I am not sure how to do this with XML.
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.
links not showing up from my external xml file? I am trying to load an xml file that contains news, its basically an rss feed xml file i am trying to use a CSS file to make the links and images show up but to no avail. What do i have to do for the links to be clickable rather than just show up like <a-href="etc....
I am attempting to get data from an xml file load in flash. I followed a tutorial in a new fla and it seemed to work fine, I then tried to adapt it to my own needs which worked fine. But then when trying to implement this into my news section it doesn't seem to work. I am trying to make a news section, that displays the date and news article. This is in within a movie clip, I even tried putting it in the timeline of the scene but still nothing.
- I have 2 dynamic text boxes, date_txt and news_txt
- The xml file is named news.xml,
- both the fla and the xml are in the same folder
This is the actionscript I am using:
function loadXML(loaded) { if (loaded) { _root.thedate =
i am making one small cms system which is updating flash content , everything is done and working properly but image tag is not getting display in text area ( image is not comming in text area.[code]
I can think of to prevent my external images from being compressed. I have a few png files being pulled into flash via XML and AS3. For some reason the images that are being pulled in are being compressed and look terrible. What can i do to prevent them from being compressed so much. They are pulled in via an empty movieclip.URL...Here is the AS that is being used to pull the images in and the XML information.[code]
