Php :: Create A Query From Flash Builder To MySQL With SelectedItems?
Nov 22, 2010
I 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'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:
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]
i 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):
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"}]
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.
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 application, I am using a ComboBoxs control and where in the init() of the mxml, I am defaulting the selectedItems to a subset of the list in the combobox.The combobox has a simple array of items:[code].....
Does any one know of an article's on the element's / structure needed to create a flash , php , MySQL cms ? I failed to mention flash would be the GUI for the CMS
I'm trying to create a dynamic menu in Flash using PHP & MySQL and bring it into Flash using AS3 DataProvider. My menu works fine with a local Array, but I seem to have an issue with the Type being a String and not an Array, but how do I set it up properly so the types are correctSo I started with a typical, non-dynamic array and it works to create my menu:
Code: var items1:Array = [ {myClass:"SCI101", question:"What color is the sky?"}, {myClass:"MATH110", question:"What is the square root of 81?"},[code].....
how to create a live message board in flash php and mysql databases what i want to do is for users to be abel to post messages in forum style , with title message and so on , and for them to be listed out on a page ( not more complicated than that, no different topics or anything) and i want flash to check if there are any new posts ever like 10 seconds
how to create a live message board in flash php and mysql databases
what i want to do is for users to be abel to post messages in forum style , with title message and so on , and for them to be listed out on a page ( not more complicated than that, no different topics or anything) and i want flash to check if there are any new posts ever like 10 seconds
I am looking to create a flash gallery which imports images from a mysql datbase and links associated to the image which will also be in the databae . The idea is to show the user in a carousel style the last picture added to the database at the front and if that or any other picture within the carousel is clicked another swf will load.Using php will do I just don't know where to start.
I know that all the cool animations are created in Flash (the program) unfortunately, I am not very good with it. However I like flash builder, because you can use a markup language and because it is better optimized for large projects.
Can you create animations that are as good in flash builder?
I am an actionscript developer and I know nothing when it comes to mxml. recently switched to using flash builder and I really like it but I want to create an AIR application in flash builder but I don't want to use mxml since I don't need any of the built in framework to accomplish my goal.Is that possible? If I have to use mxml to start the application how do I use .as files with .mxml files?
I 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?
I am refactoring some code. I have a PHP page that contains a MySQL query and stores the result in a PHP variable $my_result. This result is then echoed to a Flash SWF during embedding with SWFObject. I now want to call this PHP page that makes the query from a javascript function like so - one change I have made to the PHP is that instead of storing the result in a variable $my_result I am echoing the result. Javascript function to call the PHP page and make the database query
How can I set up a project in Flash Builder for creating a collection of classes that is not an application by itself? When creating an Actionscript project it forces having a main application file, as well as sets up the whole bin-debug folder and such.
For instance, if you wanted to start coding something like Tweener, Papervision, or some other set of classes that doesn't publish to an application, how would you set up the project in Flash Builder?
My project is open - I see the expanded sub-folders. There are not compile errors showing up. Under the project's properties I see Run/Debug Settings but the New button is greyed out.