Data Integration :: Date Interchange Between Flash And MySQL?
Jun 16, 2009
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;
[code]......
View 1 Replies
Similar Posts:
Feb 16, 2009
Can anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 Replies
Jun 27, 2006
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 Replies
Mar 24, 2007
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
<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...
View 2 Replies
Feb 23, 2007
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 Replies
Mar 13, 2007
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.
View 3 Replies
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).
View 2 Replies
May 23, 2007
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 Replies
Jun 17, 2007
I 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.
View 6 Replies
Oct 1, 2007
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 Replies
Jan 23, 2007
I 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 Replies
Aug 23, 2009
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 Replies
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?
View 2 Replies
Mar 31, 2005
I have a php page that sends xml compiled from data in a mysql table to my swf. The swf is actually an auction and I need to load in the' end time' of that item and do a date comparision for a countdown.
So what I'm asking for, in a nutshell, is for the best way to load in a date from a database in such a way that it can be used for date comparisons?
The mysql field is a datetime field. I can modify the format in php to whatever you feel in the best format (I need year, month,day,hour,min, seconds) - but I don't know what to do with the date once I have it in flash.
example xml: <Item end_time="2005-04-01 00:00:00" />
can I convert it into a valid date with out string manipulation? since the following doesn't work (obviously)
my_date = new Date(oXML.firstChild.attributes.end_time)
What I need is to be able to take the current time & substract it from the time in the xml to give me the remaining time.
View 1 Replies
Jan 1, 2010
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.
View 2 Replies
Jun 17, 2011
I'm kinda new to Flex and I'm using Flash Builder 4.5. I'm so frustrated.. Trying to solve this since yesterday morning and seems like there is just not enough resources to learn more about Flex! so here is the problem: I have a db field with a "date" DataType and i just can't order by it the xField! i tried so many things and nothing works.. when i try to order it by the id its working but its not supporting dates or something.
[Code]....
View 1 Replies
Nov 12, 2007
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.
View 2 Replies
Feb 1, 2007
We want to be able to upload over 100+ files (if needed) to a server along with desc + keywords. I see that Flash 8 has the neccessary tools to handle file uploading, but my question is, can we have it act as a Stand alone FTP program so that we can utilize the fastest user upload, or will we be confined to the settings in the server INI settings.IE MAX_UPLOAD_TIME,MAX_FILESIZE, etc. If possible we want to avoid using the HTTP upload as it is noticeably slower. So if we can use flash to utilize user BW to upload, then that would be ideal.
View 1 Replies
May 27, 2007
ok I have amfphp returning a query that is a Date data type in side of mysql. It is in this format "2007-27-5" which is a string. When making a date object in flash you need some thing like this
Code: var testDate:Date = new Date(2007, 4, 27); I would like to know if there is a short cut around this problem. As it would look now I need to take that string and have a regular expression pull the sub-strings ("2007", "5", "27") out and some how convert the sub-strings in to a numbers (2007, 5, 27), then set vars with the number latter sending it to that date constructor.
View 5 Replies
Aug 7, 2009
Anyone has experience to display the last log date from the mysql database to the flash?
i did it with the username - that was displaying but not the last_log_date anyone can profide suggestion or an easier method/solution? sample script would be coolz.
[Code]...
i read the data in actionscript with username_name and then display the data into the textfield. this worked for the username only but not for the last log date..
View 1 Replies
May 4, 2007
How to store the data text in Access databases using flash form and to search into the database. It is possible to work without server because I don't want to put this flash file on the net. how to make databases and to connect with flash and to have possibility to search the database, but to work database in the local computer.
View 1 Replies
Jul 18, 2007
Im 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.
View 1 Replies
Jun 15, 2007
Is it possible to read/write data to and from Access with Flash in a offline format? I need to create a stand alone system that users can log into and pull information from - but it will not be networked or have any sort of internet connection.
View 2 Replies
May 31, 2007
I would like my flash to act differently depending on what html page it is on. Can I send information from html code to action script?
View 1 Replies
Mar 1, 2007
i have a problem regarding the integration between flash and ASP file i have an ASP file that gets a record set from the database i don't know how to send this record set to flash and place it in a data grid
View 4 Replies
Apr 9, 2007
I will be creating a program to use for data entry. I'll be studying zebras in kenya and I won't have the internet there as I'm recording the data. I'd like to be able to send the data I generate in flash to an external text file. I understand I need some sort of script to do that, but is this something I can run just on my machine? (I'll probably make the data into xml format).
View 1 Replies
May 26, 2006
I have form in flash with input text fields with Var field set to t2_2 t3_2 t4_2... what i want to do when user enter values and press buton it should post data(values) to aspx page - how can i do that ? i saw what i did
[Code].....
then i can access t2_2 value on aspx page, so what shoul i put before getURL so it will set values from texboxes
View 2 Replies
Jan 9, 2011
I've always just kind of randomly chosen DateTime or TimeStamp. What are the pros/cons of each and what do you use and why? (I realize some have more detail, I'm usually looking for year/month/day/hour/minute/second resolution and I'm currently working with PHP, AS3, and Objective-C.
View 1 Replies
May 19, 2010
I retrieved the time from MySQL DateTime column and it's formatted just like this. "2010-04-30 04:12:07"How do I convert a MySQL DateTime so that I can display two seperate fields, I'd like to get "April, 30th, 2010" and "4:12 AM" separately.
View 3 Replies
Sep 5, 2006
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]...
View 1 Replies