ActionScript 3.0 :: MySQL Database Access?
May 31, 2010
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 Replies
Similar Posts:
May 20, 2009
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 Replies
Feb 10, 2009
something 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?
View 3 Replies
Jan 13, 2010
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 Replies
Feb 18, 2010
how different is actionscript 3 compared to actionscript 2 i mean to integrate a datebase using mySQL if so how?
View 1 Replies
Oct 24, 2010
I 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 Replies
Jan 7, 2011
I 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.
View 3 Replies
Jan 9, 2012
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.
View 2 Replies
Feb 7, 2006
I 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.
View 6 Replies
Feb 12, 2007
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 Replies
Dec 24, 2010
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.
View 1 Replies
Aug 25, 2004
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]....
View 2 Replies
Aug 30, 2010
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
View 2 Replies
Apr 29, 2011
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].....
View 4 Replies
Jun 20, 2011
I 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].....
View 6 Replies
Aug 8, 2010
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 Replies
May 15, 2011
I 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]...
View 2 Replies
May 15, 2004
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 Replies
Jun 16, 2006
I'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)
View 1 Replies
May 3, 2009
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 Replies
Sep 19, 2003
I'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].....
View 4 Replies
May 15, 2004
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]
View 3 Replies
Jul 1, 2010
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 Replies
Dec 21, 2009
I have a quiz game that i have finish. in this game have a finish button. if the finish button clicked the score from the quiz want to insert into mysql database.
View 1 Replies
Aug 2, 2010
So I want to store richtext in my database created from Flex 3's rich text editor, but I am unable to.
for example this would need to be placed into the database:
<TEXTFORMAT LEADING="2"><P ALIGN="LEFT"><FONT FACE="Verdana" SIZE="10" COLOR="#0B333C" LETTERSPACING="0" KERNING="0">sdfsdfdsfsdfdsf</FONT></P></TEXTFORMAT>
Is it because of all the special characters?
Is it common practice to store formatted text in a database?
View 1 Replies
Aug 30, 2010
I can't seem to post needed information to my database, here's what I've got:
[Code]...
So what is wrong? Why ain't it adding the information to my database?
View 3 Replies
Mar 22, 2011
I am trying to create a video that loads the videos stred in a directory, depenant on the users id etc.To do this, I am using php. However, I cannot then get the php to convert to xml within the actionscript:[code]It works with a normal xml file just not php
View 1 Replies
Jan 10, 2012
I would like to have a Flash Application (not air) to connect to a local database. Air is not only getting unsupported by Adobe in LINUX but besides, it has serious problems and miss implementation with SQLite. So we want to connect to a local MySQL database. This application should be simple, so we do not want to also have an unnecessary web server (also local) to make a middle communication between the flash app and the MySQL server. There is this driver that allow to communicate Flash with MySQL [URL] Question is: Would it be any problem using this approach when installing the whole application to each client? (because we also in the installation should install a MySQL server).
View 1 Replies
Feb 28, 2011
What I am wanting to do is create a "registration form" and send the form data to a MySQL Database. Once the user submits the form, a password is created and emailed to the user.
Then once all has been created and stored, the user can log in and gain access to secure pages.
View 9 Replies
Jun 18, 2008
First time poster and new to the board. I have been asked to solve a difficult problem and am seeking guidance in completing the task. Basically, to give you an overview, I need to build a custom tracker that counts how many clicks per month a particular link(s) is/are hit within a website I built. I used Flash (ActionScript 2.0)and XML to build the website along with pulling in external swf files as needed. I have an idea of how to create the MySQL table using myPHPAdmin. I know I want to build an actionScript class to pull into the core swf that holds a majority of the functionality, and to create a PHP file that will pass the info to the simple MySQL database AND send an email out on the last day of each month with the totals from the database. Then I need to reset the database to 0 for each link that we are tracking on the 1st of every month.
My goal is to make it as reusable as possible in case I am asked to follow any more links within the site for documentation. Does anyone have some good documentation, examples, or reference links to point me towards? I have an idea of what I want to do, but I'd also like some other people's input on how they would possible move forward in completing this task.
View 4 Replies
