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 RepliesHow to connect to MYSQL DB from Java, create table, insert data, retrieve it with datatypes. How to make use of the data to/from in Flex application. i have basic knowledge in sending and receiving messages using BlazeDS.
View 1 RepliesHow do I load data from a mysql table to a combobox using php and AS ?
I do know how to retrieve the data from my table needed but how is this inserted the combobox ?
Assume you have combobox1 and combobox2. When I, in combobox1 select: 'cars' I would now like the script to search my table for cars in the column 'stuff' and then insert the result in combobox2.
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 RepliesSo, here is the question. I have a small flash application that sends some variables to a php script (via POST), and that php script sends them to a mySQL database.
This works fine when I'm testing my flash offline, I go to phpmyadmin, and the registry is done. When I upload the swf to a online html, this stops working. It no longer creates another registry in the database. I have no ideia why this happens.
I read a bit about it and found out about cross domain policy, and thought it might be the problem. Thus I made a small .xml file and uploaded it to both servers (the one the swf is on, and the one that has the database), and its still not working.
[Code]...
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.
I would like to make my flash form submit to mysql database.
View 2 RepliesFirst: I want to create a sort of webshop and I want to create a MySQL database in which people can sign up/log in.How can I create this in FlashMX + PHP + MySQL.I want people to log in, sign up and the database should register what people bought the last time(s) they visited.
Now for my second question:For this shop I have a section on the homepage with news.This sections needs to display the news and have a link to the archives.Each newsitem is an images that contains the news.How can I make Flash loads in the news dynamicaly and let Flash detect if there is an archive (archive = more than 3 newsitems in folder) and if there is one, display it?
I want to collect email addresses on my Flash/AS3 site for a project.I just have basic web hosting (just FTP upload space) and do not have access to a LAMP server.I assume this is what I need to be able to run PHP/MySQL etc.Does this mean there is no way of me making a form that will allow visitors to input their email addresses to sign up for a newsletter I send out?
View 2 RepliesI need to create a login page in my flash site that relates to information input to a mysql database. after the submit their information we want to send them a link to a differnt flash page with a login screen they will use their first name and a password (already in our database) to gain access to this "new" page. on that page there will be a welcome message that says "Welcome, User First Name" so I guess i have two questions
1: how do i set up a login page?
2: how do i pull that login info to a welcome page?
Whenever i start my flash game ... it updates my mysql table at cash and sets it to 0 and in no place do i have a update statement...
the only thing i have is at the very end it loadvar command thing and then the script selects cash but it selects 0 everytime because whenu start the game ... it sets cash to 0
how would i display mysql table in flash?
View 11 RepliesHeres my setup:MySQL Table:ID, FIRSTNAME, LASTNAME, DATE of BIRTH, EMAILMy PHP file reads a email from flash and finds any matches. Then it relays them back to flash using echo command.Now i need my flash swf to generate a table with all the matches using collumns for each piece of data.When i tried to do it, it only showed the last match and that was it...How do i make it generate a full table?
View 2 RepliesBasically, I want a sample php script, that can let me call from Flash, to save a bitmap data as a record into a mysql table!
View 1 RepliesI'm trying to insert embeddable video code, such as youtube/viddler/etc.. which all start with the object tag:
<object width="480" height="385">
<param name="movie" value="[URL]">
</param><param name="allowFullScreen" value="true">
</param><param name="allowscriptaccess" value="always">
</param><embed src="[URL]" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="385">
</embed></object>
into MySQL with PHP.
I'm trying to call it in php, but only get the text value back, basically, the entire embed code as text is displayed instead of the video itself. Here is my display code which shows text. How can I make it show the actual video instead?
<?php
//assuming a connection to the database exists
$sql = "SELECT * FROM table";
$result = mysql_query( $sql );
while( $row = mysql_fetch_array( $result, MYSQL_ASSOC ) ) {
$html = array(); //create an array of html formated values.
[Code] .....
The php code right above it pulls out this data, without the slashes and it displays the embed code perfectly as text, but the actual video does not form from that. Is there anyway to have the code displayed act as code and show the video instead of text?
I have spent many days tearing my hair out trying to get this simple flash code to work. I have four text fields named player,tournament,position,prize and a submit button. I have a working mysql database. The php file without the POST variables (i.e. using static data) works fine. I just cannot get the flash to talk to the php correctly. I have looked at many examples and tutorials and forums, but am at a loss. I have had many flash errors over the days. At the moment it is ArgumentError: Error #1063: Argument count mismatch on actions::main/processLogin(). Expected 0, got 1
[Code]...
I have spent many days tearing my hair out trying to get this simple flash code to work.I have four text fields named player,tournament,position,prize and a submit button.I have a working mysql database. The php file without the POST variables (i.e. using static data) works fine.I just cannot get the flash to talk to the php correctly. I have looked at many examples and tutorials and forums, but am at a loss.I have had many flash errors over the days. At the moment it is ArgumentError: Error #1063: Argument count mismatch on actions::main/processLogin(). Expected 0, got 1
[CODE]<?php
$player = $_POST['player'];
$tournament = $_POST['tournament'];
[code].....
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 downloaded MySQL JDBC driver from [URL]... How do I configure it?
View 1 Replieshow 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.
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]....