ActionScript 3.0 :: Establishing Connection To Php And Mysql Data Base?
Sep 11, 2009
i have been trying to execute a simple flash program that communicates with a php page which is linked to a mysql database.somehow the php is not returning any data to flash , and even falsh is not sending any data to php.. I am using wamp server on win7.Heres my actionscript code:
stop();var variables:URLVariables = new URLVariables();var varSend:URLRequest = new URLRequest("php.php");
varSend.method = URLRequestMethod.POST;varSend.data = variables;
i have been trying to execute a simple flash program that communicates with a php page which is linked to a mysql database. somehow the php is not returning any data to flash , and even falsh is not sending any data to php.. I am using wamp server on win7.
So, we want to move out from Air (Adobe stopping support and really bad implementation for the sqlite api, among other things). I want to make 3 things:
Connect with a flash (not web) application to a local mysql database. Connect with a falsh (not web) application to a remote mysql database. Connect with a flash (web) application with a remote mysql database.
[Code]...
if you can connect with socket wit mysql server, why use a web server (for example with php) to connect like a inter connectioN? why not connnect directly? I have done this a lot of times, using AMFPHP for example, but wouldn't be faster going directly? In the case of accessing local machine, it will be a more simple deploy application that only require the flash application + mysql server, not need to also instal a web server.
I have a flash file which uses asp to connect to a mysql database. Is there some way to add an event listener which will send a notification to the user when the connection to the server has been lost?I was thinking of just setting a timer so every 10 seconds it runs an asp file which checks if there is still a connection.
i am looking for some kind of library which does CRUD easily using PHP and MYSQL.My goal is to make some app in flash AS3.0 , where i will be receiving some data from user and storing in data base , and perform CRUD opertaions. I dont want to be so much involved in writing php and sl query.My scenario is:
Data types : [ like user_profile data, etc]
add under data types 1 to many fields with various types..
Database tables and realtions etc should be done by my DREAM library, then user when select a Dtat Type, he is presented with related fields to fill up data.
I will be using Flash AS3.0 ( Builder or IDE ) to perform .If only i can find some php library i think AMFPHP can connect flash with php
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 want to create a flash form and be able to collect the dataoffline. The company I work for has a e-newsletter, and we wouldlike to set a lab top up (outdoors w/ no interenet connection) atan event and have the people sign up for the newsletter on thisflash form and collect the data in some kind of database (excel orwhatever). We had used paper in the past, but taking the names andemail addresses from the paper is time consuming and sometimes very
I'm developing an application "with Flex Adobe Builder, AS3" that will add contacts in the user contacts and may retrieve some and add events and get from the user calender.
Flex didn't provide and API to do such a thing yet, so, can I access the contacts data base by it's uri and select and insert into it directly ?
I am working on one CD presentation for chamber of commerce I have to make a search engine in this CD presentation. they have 8,000 company name address email website address and product details in Access data base can i make a search in flash MX or is there any possibility to search from XLS file
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'm trying to get some data from PHP/MySQL and send it to Flex..Let's say That my object in Flex would look like this:
package some.package.VO { [RemoteClass(alias="VOPerson")] [Bindable] public class VOPerson {
[code]....
In my case, personDetails is an Array, and in theory, it could be some other object... But is it really necessary to make it an object? I do not intend to use that data nowhere else except within my VOPerson class. It is some associative array, and I can easily transform it to another object, but there will be lots of similar situations in my app, so I would like to avoid making unnecessary (value) objects if there is no need for it...
I need to pass private data from MySQL to a flash file securely. I have a PHP script that is assigning variables on the server side - how do I pass this to flash without being available publically? I assume XML and an HTTP query string are out of the question because of security. What's the most secure way of doing this? Basically I have some file paths that I need to load into a music player - however, I don't want these URLs to be publicly known. I was hoping I could pass data directly to flash securely somehow.
I don't like cookies. For saving data, submitting scores, etc. I'd like everything to be submitted into user's accounts in a mySQL database. I can do all that very easily with PHP, but how would I make it worth with flash/actionscript (I mainly/am used to working with AS2, but I have Flash CS5 now, so I can work with AS3 if necessary or more efficient). I have no idea how to mix actionscript with other languages (other than using a link with get variables, but, aside from the obvious reasons why that won't work, I'd prefer, if possible, to transmit data without any page reloading).
Are there any security holes or downsides I should consider before making a flash login system? I'd like to allow users to login if they wish to submit their score or save their data (mainly for users playing on a third-party site).
i'm trying to connect Action Script 2.0 Scrollpane to get data from php and mysql... my problem is in the action script 2.0 i'm trying to recieve data from mysql by php, Here is my php code :
[Code]....
and my data base is working 100%
i need to display the result in a ScrollPane Object In AS 2.0
I've scripted a connection to PHP that gets data from MYSQL and outputs that into a datagrid.When I encrypt the swf with Ameyata SWF Encrypt 5.0, and upload it to my webhost, it looks fine. I can click the header of the datagrid (that sorts the data), but when I click on a field of the datagrid, it just freezes and my datagrid is not usable. I'd have to reload the page in order to do something with the datagrid again. But the problem with the field remains.It works when I'm not encrypting the swf.URL...
assigned to 101. Inside of 101 I have dynamic text fields with the var names of price, fee, and state.I have a movieclip 102 that is exactly like 101. What I need to know is, how can differentiate 101 from 102 so that when the db data comes in that 101 and 102 display different info?Also, I can't change the var names. They must stay as price, fee, and state in both movieclips.
I use loadvariables to get data from mySQL using PHP and up to Flash. Flash gets the data flawlessly. Now one of the data I load into Flash is a path to an image.
My problem is, when I check the imgVar variable, it telles me, its value is: images/news/001.jpg
Now When I use the AS: loadMovie(imgVar, blanker);
it does nothing (blanker is the movie clip I load the picture to).
When I use the AS: loadMovie("images/news/001.jpg", blanker); it shows the picture...
My other question: If I solve this problem, how Can I resize the externally loaded image by just setting either the height or width and doing the resize so that it won't deform my image.
assigned to 101. Inside of 101 I have dynamic text fields with the var names of price, fee, and state.I have a movieclip 102 that is exactly like 101. What I need to know is, how can differentiate 101 from 102 so that when the db data comes in that 101 and 102 display different info?Also, I can't change the var names. They must stay as price, fee, and state in both movieclips.
The idea behind is a multiplayer browser game which interacts with a PHP server. Right now it works like this: Every second the browser is doing an ajax call to the php script which checks everything and returns the response. All in all it runs fine, but the problem is that the browser gets overloaded (because of thousands of ajax requests) after a while and it becomes impossible to play anymore. Also the delay of 1+ second is pretty much. My idea is to have a simple flash pixel which will have a 2-way communication with the server. For example:
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
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'm making a login script and adding the data to my local mysql database using php.it works as long as I browse in my browser to localhost/ flash/ movie.swf but if I just open the folder and run the .swf file it doesnt work
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?
