I want to pass variables to php, then the php runs a query from the mysql database, and then sends back the new variable... I looked for tutorial, but nothin' seemed to work.
[Code]....
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.
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 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]
I've been searching ferociously and can't seem to find a solution that works for me. I am trying to pass variables via query string on a PHP page to Flash, and then have the swf add movie clips to the stage depending on the information it receives. Here is what the PHP outputs:
[Code]...
When I pass a single variable (telephone) from Flash using the below it works fine
var xmlSaveLoader:URLLoader = new URLLoader();
xmlSaveLoader.load(new URLRequest("customer_insert.php?telephone="+teleph one));
I can read the variable in PHP using $key_telephone = $HTTP_GET_VARS[telephone];
and then run sql command to insert into table customers mysql_query("INSERT into customers (telephone) values ($key_telephone) ");
However, I have a problem and don't know how to pass multiple variables to PHP. I tried the following to pass a second variable (first_name)but it doesn't seem to work... xmlSaveLoader.load(new URLRequest("customer_insert.php?telephone="+teleph one+"&first_name="+first_name));
I'm trying to develop a simple as3 flash program that passes a collection a variables and returns a result based on the filtered results of a mysql table. Here is my as3 file:
[Code]...
No value is returned. If I replace with '$test4' and '$test5' with numbers such as 1 and 17, a value is returned. Where am I making a mistake?
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[code]I am not sure whether i am going correct, i am always getting the return value no though i enter the correct username and password.
View 7 RepliesI want to pass through an array from php (which queries a MySQL database) to flash.
[Code]....
Can I not use any form of array in php when I sendandload to it from Flash? If so I'm going to be typing a lot of code in the next few days.
I'm working on an online photo catalog, it works in straight PHP/HTML but the photos are too easy to grab (Facebook and myspace are loaded with my photos). I know anything on screen can be grabbed, I just want to make it a little harder.I've got a version of the ordering page with a SWF on it that will hopefully display the photos,but so far no luckHere's the PHP:
<?php
$page = $_GET['num'];
$el = urlencode($_GET["el"]);
[code].......
I'm using a Flash file to make a comments section for my website but every time I hit the button my query only outputs blank fields to MySQL throguh the PHP file.I'm wondering if it's my actionscript or PHP file... and I feel it may be my actionscript because all the rest of the SWL query I put in through PHP functions work.can anybody tell me what's wrong with the way I'm posting variables to my PHP/MySQL?[code]
View 2 RepliesI am trying to create a query from Flash Builder to PHP/mySQL with selectedItems. I have a simple SELECT query set up to populate a datagrid of items I would like to select for main query (two records looks something like this "19 10","20 10"). This is where I get stuck. I don't know if I need to break down the selectedItems in Flash Builder for formatting in SQL or if I can do it in PHP.
I would assume that it should be done in Flash Builder and I would then send the partial SQL statement to PHP. As of right now, Flash Builder is holding the selected values as CustomObjects and I unsure of how to retrieve what is in the objects for formatting.
var arr:Array = dataGrid.SelectedItems
This yields an array of CustomObjets and I lost from there.I will need the resulting SQL statement would need to look something like this.
SELECT *
FROM Stats
WHERE neu IN ('19 10','20 10');
i wish to do something similar to what is shown on the top banner of this website [URL] like passing the result of a mysql query to the flash banner.
View 1 Repliesi am using Flash CS4 (AS3) + AMFPHP + MySQL to do own flash frontend for Wordpress CMS. Everything is going fine but i`ve got one problem. Problem with properly display of result of query in AS3 by using ArrayCollection.
When i check my service in "amfphp/browser/" in web browser i`ve got this (with all needed data):
...
(mx.collections::ArrayCollection)#0
filterFunction = (null)
length = 2
[Code].....
I know that "result" is an ArrayCollection type but i don`t know how to get rows and columns from this. I know that my data is there but i have no idea how to get it.
how to get to Arrays and simple data variables which are in ArrayCollection.
P.S. I tried also change query type in service.PHP for mysql_fetch_query but in that case i`ve got only one row (not all data).
I'm populating a datagrid with some JSON data that came from a mysql query.I was wondering if it's possible to tell a piece of JSON data to go to a column other than the name it has?My JSON data comes in with abbreviated names...
[{"gID":"Rock","vID":"Darby's Pub","gRec":"Yes"}]
and I load it into my dataGrid's data provider...
myDG.dataProvider = new DataProvider(myJSON);
Currently, my columns have to be named...
gID, vID, and gRec
for the above data to be populated.Is it possible to have more meaningful column names, while keeping the abbrieviated form in the JSON data? eg...
GIG STYLE, VENUE, CAN BE RECORDED
or do I have no choice but to make the full names a part of the JSON like...
[{"GIG STYLE":"Rock","VENUE":"Darby's Pub","CAN BE RECORDED":"Yes"}]
Im building this AIR app on Flash CS5, and I have this TileList that loads its data (images and names) from a database. I want to do a query with the name any item of the Tilelist when its clicked, so i need to send the name of that item to a PHP file that will execute the query. I am thinking of a function that loads the item name to a variable when the item is clicked. How can I send it to the PHP file and how would I load it to the query? The query I want on the php file goes something like this: Select lat, lon from mapdata where name=theVariable;
View 3 RepliesI am trying to query a sql database and echo the image into xml so I can view the queried image in flash.
I already know how to query and echo the image url from the database.
This is the code:
//The database is already queried at this point.
echo "<?xml version="1.01"?>
";
echo "<content>
[Code].....
The echoed xml in the first code produces a url link that contains a link to an image in the database. The flash is supposed to display the image on a flash movie clip call movieobject. I am having problem getting the image displayed in flash.
I'm having a problem with my flash-php-sql integration, my text output in flash keeps on returning NaN even if the data in mysql has a valid number(double).
View 1 RepliesI have text being inserted into a textarea component dynamically from a MySQL database. The problem is getting characters like the ampersand (&) to show. Also the carriage returns are being processed twice (or the carriage return and newline characters are both being processed).
View 3 Repliesjust for fun I have been messing around with AMFPHP and I have hit a design problem and I was just wondering if anyone had any input?
I have been using AMFPHP to make calls to a PHP script like so:
[Code]...
I'm trying to display query data into multiple TextInput Fields in Flex.
<mx:TextInput id="stagInput" text="{acContacts}" width="170" x="120" y="74"/>
This is what I'm trying but all that displays is [object Object]
I think I need to define the database field I'm wanting to display, but I'm unsure how to do this as TextInput fields don't support dataField or labelField properties. Is there another property I don't know about? How do i go about fixing this?
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.
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 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?