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.
[Code].....
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;
[code].....
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 Flex application which manage a database composed by 7 tables.I have created the insert form and all work great. Now I wanto to improve the Form performances; the idea is to replace the TextInput of the Form with ComboBoxes which are provided by the DataBase tables
View 1 RepliesI 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.
View 1 RepliesI've started with Flex recently, I've noticed that some plugin for Visual Studio exist, instead of buying a licence for another program (Flex Builder).I was wondering how I could manage to remotely connect to my database with a Flash/Flex application with the help of C#/Asp.Net.
If I've correctly understood what I've read in the last few days, there is basically no way to 'query' to a database with Flex 3. So I suppose there is another way by using a webservice in C# on the database server that would respond to the Http query from Flex.
I have some troubles writing a database connection in AS2.0.I use LoadVars for loading and sending data. This is an example how it works, but when I use this inside a class it doesn't work.
ActionScript Code:
var loadVars_in:LoadVars = new LoadVars();
var loadVars_out:LoadVars = new LoadVars();
[code].....
how tp use databases with Flash CS4 ?I have created a form, an email page and a username/password protected pages, but I cannot find any tutorials that would help me how to connect to a database.
View 7 Replieshow different is actionscript 3 compared to actionscript 2 i mean to integrate a datebase using mySQL if so how?
View 1 RepliesI am reading one tutorial :- But I can't understand what is "Gateway.php" and all such things. I am a beginner in Flash.
View 2 RepliesI have a problem with saving the £ symbol to a mysql database.I am running a flex front end, with a php + mysql backend When I save a record from flex, the string gets sent to the server as "This amount is £10" php views the string as above, and when it gets saved into the DB, it gets saved as "This amount is £10".
My understanding is that this is correct based on MySQL or PHP is appending a whenever the £ is used I now retrieve the above record, and it gets sent to flex as "This amount is £10". Flex correctly displays this in a textarea as "This amount is £10" I change another field in the same record in flex, and re-save the transaction. The string now gets sent to the server as "This amount is £10" The record is now saved into the DB as "The amount is £10". Each time the record is re-saved, this effect snowballs.
I am accessing my MySQL database through Flash using AS3. I am using php scripts to access my database and send and receive variables. Everything is working fine. No problems there. The problem, or rather the question is, is it possible for flash to run a script to access a database without a webserver running on the machine? Isn't there some sort of plugin or adapter or interface class available in flash that will allow me to do that?
View 7 RepliesI have a database with info about each of my movies (filename, size, length, credits, etc) How would I load the variables for a particular movie from the database into the flash?
I did a search on the forum, but I wasnt sure excatlly to search for so I didn't find anything.
i am trying to connect php to a mysql database by doing the following: $con = mysql_connect("localhost:8080","username","passwor d"); when i try to run the php file in the browser it takes forever to load. What could be the problem? and what am i doing wrong. i created the database with mysql in xampp.
View 2 Repliessomething strange about loading database mysql with urlloader
[url]
when i compile and run it via flash it worked , i can load the data but when i embed that swf into website the data won't loaded . what's happened?
I am making an online game with AS2 and my method for storing the location of users is with a table with columns: name, x, y. The table has many rows.
I have a PHP script which makes a query in the DB for all x and y locations from -6x to +6x and -4y to +4y (Relative to the user).
If a user exists at that location, then they will be printed on a list that will end up looking something like this:
&username1=John&x1=16&y1=8&username2=Fred&x2=16&y2 =9
I want to know how to make a loop which takes the information printed from the PHP script and use some sort of efficient loop to take username1, username2, username3, etc. and place them at the x and y positions listed. I will use the "loadVariables" function to get the variables from the PHP script.
The main thing that confuses me is how I am to make a loop which manipulates the variable name. I am thinking of using OO with which I can do username(1), username(2), etc. but I am not familiar with actionscript so it would be difficult.
I also need to be able to place an object from my library to the screen and when I did a search, I could not find how to do this.
I have made the following script to search in a Mysql database. The script works fine the first time you search. Second time if you try to search for some thing else the old search result keep appearing. Is there some way that i can clear the search result when ever i initiate in a new search?
This is my script:
this.createEmptyMovieClip("myForm_europe", 0);
myForm_europe.newSearch = 1;
myForm_europe.searchType = 0;
myForm_europe.searchArea = 0;
[code]....
How can I establish connection of a Flash site with a database(i.e. MYSQLetc)?
View 4 RepliesWhen working with CRUD operation in flex, I want to know how to open only one time for all update and delete operations. How can I do this?
View 2 RepliesI'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
View 2 RepliesI can get the data from the mysql database into the flash onDataLoad function but cant get it outside the function, and that is what i need to malipulate other data already in the project (update it)
var myLoader:URLLoader = new URLLoader() myLoader.dataFormat = URLLoaderDataFormat.VARIABLES myLoader.load(new URLRequest("http://localhost/flash_php_mysql/FormData.php?"))
[code].....
I cannot pre-view a flash movie in a php.page. Question, How, where, do i store a swf file name and location in mySQL database and then use this data to call it in the application?
View 1 RepliesI need some help with a flash app im currenctly programming. I have a management flash app that does some operations in a MySql databases. I have had some problems, but for the most part, I have been able to press on. I'm a flash AS3 newb, so bear that in mind.
My actual problem is that I need to do a "Search" module, and I need it to print several results at once. I am although unsure how to get the results on flash. what I have been doing now is calling a php script that, after doing its operation, does something like (for example):
[Code]...
I am using Freddy Thunder's tutorial on how to make a login script with php/mySQL The problem is that the button doesn't do anything when I click it. I can't tell if it goes to the php script, but it sure doesn't return the correct variables like it is supposed to.
View 3 RepliesI'm using this actionscript to load a jpeg from a MySql database
Code:
_root.detailfade.detail2.photoContainer.loadMovie(myLv["pic"+(numb)]);
All images loaded are in landscape proportions. I would like to resize the images that are loaded to a set height (the photo might have to be either enlarged or reduced) but maintain the proportions of the picture (i.e the resize the width to keep proportions)
I am trying to connect to a MySQL database using PHP in Flash CS3 using Actionscript 3.I have written the PHP file and some AS3 code and it displays the information but for some reason it also displays the tags.[code]The picture below shows what happens when I test the movie.I also need to add buttons to move to the next and previous record and to add or edit the database via the Flash interface?
View 7 RepliesI'm trying to get text from a database into Flash via PHP/MySQL. While this works perfectly outside of Flash (ie. the text shows up fine if I just open the PHP file), I get an "undefined" in my textbox when I try to get the text in Flash.
[Code].....
I am using Freddy Thunder's tutorial on how to make a login script with php/mySQL
The problem is that the button doesn't do anything when I click it. I can't tell if it goes to the php script, but it sure doesn't return the correct variables like it is supposed to.
[URL]
for my project im trying to get output data from xml into flash...with images & url with description on top of image, load like 10 images with ur and if there is more give me options with numbers.
View 1 RepliesI have got Flash CS5 and i create AIR desktop application. I would like to create and edit sql lite local air database. I know i should use SQLStatement and sqlConnection. Could someone give me any advice about doing that. Maybe some tutorial or something what let me to do that.
I don`t know should i create that database sql lite file earlier and include it to air project or should i create that database in dynamic way by as3? How can i get and edit data from this database? How can i save that local database if it included in air project (i would like to that database file would be inside of air project)?