ActionScript 3.0 :: Integrate A Database Using MySQL?
Feb 18, 2010how different is actionscript 3 compared to actionscript 2 i mean to integrate a datebase using mySQL if so how?
View 1 Replieshow different is actionscript 3 compared to actionscript 2 i mean to integrate a datebase using mySQL if so how?
View 1 RepliesI 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 Repliestutorials (e.g. ) show how to integrate Flash and MySQL. Also Flash can manipulate and sent this back to serverTo integrate flash and MySQL one can do the following:(1) MySQL -> php -> Flash (e.g. What is the most robust way to set up (1) and (2) to work at scale - as quickly as possible? What are the server loading implications? Is there any other way to do (1) and (2) more effectively?
View 2 RepliesI 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 Repliessimple way to integrate flash forms with any database,without using ASP or any other scary programming.All I want is to insert & retrieve data from a database directly from my flash movie.
View 5 RepliesI've been looking around the internet now and haven?t been able to find anything referencing my problem so I thought I'm looking to create a series of adverts for our website. I say adverts, there more like a ?what?s on? synopsis of our website on a area specific homepage. We have 22 area homepages that need to display certain adverts.
What I?d like to be able to do is setup an admin system for my boss to use so he can control via the admin system the adverts to be displayed on each area homepage. I?ve seen that you can import database information via text fields on the movie itself but I?d like to be able to set the movies up so they pull the relevant information into the action script (basically referencing which file name to load and in what order.
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 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.
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 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]....
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 Repliesi 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 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 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 RepliesSo 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?
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?