ActionScript 3.0 :: Read Informations By MySql DB?
May 13, 2011
I have to develop an iOS application able to read "news" by an existent mySql DB on my customer's web site.Is there a way to do this in AS3? I didn't wrote that DB, but I've got these informations:
Served Address; 33.222.1.000
DB: myDbName
User Login: brandon
Password: *******
I never used DBs in my personal works, then I don't know how to implement my code to communicate (read only) with my customer's web site database.
I am building an interface in flash and want to know if I can write to and from a MySQL db.I am using php and mysql is this possible and what woud I use?
I am trying to send a php variable with one field from mysql. When I print the php variable on my php page it outputs the field, but when I try to send it to flash it doesn't output anything.Here is my php script that tries to send a mysql field to flash and there nothing is shown. It works on my php page, it outputs the mysql field.
$product=$result['product']; $pro=$product; $pro = "&pro=".$pro."&"; //~ make it a flashable variable
im trying to read values from a mysql database into different textboxes but as at now all the textboxes are filled with the same thing which is the first item of the database. This is not what i want. What i want is for the text boxes to be filled with the different items of the database. Attached to this message is the php code i have and the actionscript code
I have a page (MovieClip) which is charger and have a attribut a matrix (not the class). On this page, there is some cases (MovieClip) which receive value of the matrix.
Each cases are managed by Class. It's a good option, because I can put a listener into the contructor of the class and not having 64 functions if I have 64 cases. This listener allows to change the value of the cases when it clicked.
The problem is that I don't see how to know when a case is clicked in the page for changing the value of the matrix.
For my work I have to introduce a Print button that will prints everything that is in the cart. However, I never did anything of that sort in Flash,.For now, I did a bit of research about how to do it and I do understand I'll have to use PrintJob with another MovieClip... but I need a bit of explanations about a few things.
First, in the cart (which can be printed), there are several "items" that have the same informations, such as the name, the price, comments, etc.Do I have to create one MC that contains informations on one row and add it to the AddPage of PrintJob (I will have 5 MC [5 pages] if I have 5 items in cart), or add all the items into the same MC?
Also, the flash is horizontal (1920x1280). Do I have to change the orientation of the PrintJob to print in landscape? Plus, how to know if the text is far enought of the margins? Do I have to consider the margins in the MC and thus puts a good distance between the borders of the MC and my content?
Adding a "page" to the PrintJob, how does it work? Is it a real "paper page"? I hope you understand what I mean by that, I can give more details if needed but I can't give the source (.fla).
I have a strange problem with LocalConnection.Situation: A sample e-shop. I have a parent .swf who load 3-4 external swf.In a external swf (let's name it "X") u can order items u want.
Because i don't want to lose the informations of the 'shopping' bag of customer when the parent swf unload the 'X' and load something another (for example "contact us"), i use localconnection with both duplex between parent swf and 'X'.
Problem: In the swf "X" i have an array "Bag" which holds the id of items the customer clicked to buy. When change the external swf, i send via localconnection to the parent .swf this array (done, i tried with trace).
I'm trying to create a webRadio player, wich different sources. On a click on a button, the player plays the corresponding flow. I would like to display some informations, like : current music, url, description, I think it's possible to have all those informations, because when I play my. files in my audio player (winamp), I've got them. Here is my code corresponding to this part :
I have a parent .swf who load 3-4 external swf. In a external swf (let's name it "X") u can order items u want. Because i don't want to lose the informations of the 'shopping' bag of customer when the parent swf unload the 'X' and load something another (for example "contact us"), i use localconnection with both duplex between parent swf and 'X'.
Problem: In the swf "X" i have an array "Bag" which holds the id of items the customer clicked to buy. When change the external swf, i send via localconnection to the parent .swf this array (done, i tried with trace). And when the parent loads again the external .swf "X" , it send again the same array via localconnection to "X". The "X" receives it right (done, i verified it with trace). The strange is.. when the customer clicks another item, the array resets to zero!!!
I have a typical Flex-based application that was written to use a Java/Hibernate/MySQL backend. The client changed the requirements - now they want to distribute it on a CD where the user can just run the app without any installation or a network connection.
To do this, I certainly need to eliminate the web server and the database server and adapt my application (with as few changes as possible, of course) to a stand-alone application that will fit on a CD/DVD. I've managed to export the data to XML and read it into Flex, but I'm wondering if there's a way to recreate the Hibernate data structures in Flex so I could change as little code as possible. Failing that, is there any way to keep the existing Java/Hibernate external to the Flex code but retrievable without installing Apache Tomcat or MySQL?
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
In my table the Collation is:latin1_swedish_ci (but i tried UTF8_unicode too).In my flex application when it shows the table,it displays it correct,with all accent and pointing correct,but in the table is like :
A friend of mine has a Flash Action script running on a LAMP server that currently reads an xml config file. He's asked me if it's possible to remove the xml file, and replace it somehow with a system (lets call it an 'auto xml generator') that intercepts the request to read that file and generates an output, so it appears to all intents and purposes as if the file still exists and contains the contents that has actually been returned from our auto xml generator'
So I want to read http streams using flash tcp sockets. I do not really need the http header at all - all I need is body which contains flv. so how to read http response body into byte array using flash sockets?
i am good in php though, i am trying to make it so when the user presses a button, it updates a field by 1, i dont mind if it cant do it with text but if it just can do numbers at least then i can do an if echo statement. so far i have looked around and this is the best one i got (it is a poll but should give similar results)(i replace personal details with exactly 5 *'s): With this the table is called votesystem with fields vote1, vote2, vote3, vote4
i've done some simple apps to get the felling of it, nothing involving updating a file or a database.I wanted help, how to do a query to a MySql DB from a Flex application (thats gonna be running in a web server).I didn't saw any duplicated questions, sorry if any exists, just point me to it.
tutorials (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?
I wanted to use flex line chart for displaying data stored in mysql table. Can anyone suggest me on how do I do this with flex as UI and mysql as db, I am not sure how to call .php file in flex to query from mysql. I wanted to show some data of time v/s temperature.I wrote a php file to query data from mysql, but my flex program is not able to connect to mysql, is there any configuration I need to update. I am using XAMPP
I'm not shure if this goes in the ActionScript forum, but no one anwsered in the Flash MX 2004 forum. And seens this is 50% ActionScript and 50% PHP i thought i would post it here aswell. Here is the thread that i started in the MX 2004 forum
So I have a "blog" db setup on my server. I have the proper tables setup because you can test the entries by going here.url...You will see 3 different entries with text, date, time etc ..How I have a very very basic flash movie calling this data. It'll change when i complete the site, but at the moment I'm trying to make this work.url...With the following code, it's suppost to call and get the data from the most recent blog entry, and post it in the appropriate text box, along with date and time.Next it also calls previous entries, and posts it in the 'entries_txt' box.I know it's on the flash side of things because when accessing the .php file I can clearly see the entries, time and date. Well when exporting it out of flash, the only thing that shows is the most recent entry. No time, date, or previous posts. This happens 'online', and on my local machine. I get a "undefined" post because it can't find the blog.php file—which is expected.[code]This code is not my own, as I am/was following a tutorial. Any help would be greatly appreciated. I don't want to setup a blog for my client through a 3rd party because I want to keep the whole site flash-based, and don't want users to travel out of the site. I could also set this up just by calling dynamic text etc .. but I'm having fun learning to use MySQL and php.
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.
I'm running into a problem with a login and password screen through Flash. It connects to MySQL database to check if the username and pass are correct. Well, when I test it and click submit it just sits there and says in the status bar of the browser, URL...I believe that the PHP and MySQL part of this project are working correctly and just want to see if anybody notices anything wrong with the AS code calling for the PHP that's in the swf:[code]
It tells me how I can let a flash movie check if people are registered.I was wondering how I could add a function where people can register, so their username + password is stored in the MySQL database (instead of static users that were inserted by me, I want people to be able to add their own username + password)
I need to create a scoreboard for my game. I want to be able to let my user submit the time it took to complete the game to my scoreboard. I have been able to purchase webspace with SQL, PHP. I have set up my SQL database. I have found a great tutorial about how to do precisely what I wanted on YouTube BUT after starting the tutorial I realised it was ActionScript 2, I REALLY need time type of tutorial but for ACTIONSCRIPT.
I've been working on a login for my AS3 website and I keep running into this issue where my novie gets stuck at "loading..." as you can see if you go to this websiteand try to create an account. I have a login.swf, a login.as, login.php, and newAccount.php all in the same directory folder. I've cleaned up some of the more obvious coding errors, but I'm a design guy thrown into a coding job... Errrr, not so fun. I'll post the contents of the files below , even though I'm pretty sure that's a no no...ogin.as
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.