PHP :: Display Query Results Back To Flash Via AS3
Apr 23, 2010
I've made a query in PHP, and I'm trying to send the results back into Flash via AS3, but it's throwing up this error...
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.
at Error$/throwError()
at flash.net::URLVariables/decode()
at flash.net::URLVariables()
at flash.net::URLLoader/onComplete()
Here is the relevant part of the PHP and AS3 code, including the query. The Flash variable rssAdd is passed over to the PHP which is using it in the PHP query accordingly.
$url = $_POST['rssAdd'];
$query= SELECT title
FROM Feed
WHERE category = (SELECT category
FROM Feed
WHERE url =$url) AND url!=$url;
$result = mysql_query($query);
echo $query;
Here is the AS3 code I've done so far.
function recommendation(){
var request:URLRequest = new URLRequest("url");
request.method = URLRequestMethod.POST
var recVars:URLVariables = new URLVariables();
[Code] .....
View 2 Replies
Similar Posts:
Feb 18, 2011
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):
...
(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).
View 3 Replies
May 26, 2011
I have a GUI using Flex. I have a condition like i need to execute some command line arguments in the local machine and get the results back or output back to a textbox area. How can i do a button on submit, execute command in the local machine and return the output?Command to execute example:
echo logfile.log | grep username
Code:
button1.onRelease = function ()
{
// in this computer, it will now run a command, please wait.
}
View 1 Replies
Feb 23, 2011
I located a code example to reference my ASP.NET web service and have saved it as MainDocument.as. I have a combo box cbRentalType that has entries of Party (value=3), Sale (value=1) and All (value = All). I have a combo box cbCatSelect that allows the user to select Product Categories. I have a text input field txtSearch where the user enters their search string.
What I need to do:
1. Submit a query with RentalType=1 or 3 or Blank, Category = dbCatSelect.selectedvalue and Product Keyword = txtSearch to my web service.
2. The ASP.NET web service returns all database entries from MS Access query named ProductDetailsAll. These query results need to be populated in individual rectangle objects with dynamic text fields for Product Name, Image, Description and Price. How do I set these dynamic fields to populate data from my query?
3. The Flash movie clip contains 16 rectangles, or can house up to 16 product results from the web service. If more than 16 results are returned, how do I populate a new page of product details in my movie clip?
4. How do I reference the outgoing variables in Actionscript 3.0 pertaining to CategoryID, RentalType and search string? How/where do I store the incoming variables for Product Name, Description, Image and Price?
View 1 Replies
May 30, 2007
I need to run a query and convert the results to an XML string. I *think* I need to do all of this in PHP but I wanted to get some guidance as sometimes I make things more difficult than necessary.
Do I have 2 scripts... one to query and one to process the results to XML? Or can I put them both in the same script. To do the latter is not proper OOP practice, correct?
Once that is done, I can get the data into Flash. I need it to be XML though because the same data is being used elsewhere outside of Flash.
Is this the proper, most efficient way of handling this task?
View 4 Replies
Jan 29, 2010
I am asking this question as a complete Flash novice, so please do point out if I'm doing anything wrong here (I suspect I am). I have a Flash MPU size animation with a link in it which has been created by using a full sized transparent layer as a button (is that the correct way) with the following ActionScript:
[Code]...
View 1 Replies
May 13, 2011
I am querying to server through flex,first time its show the result but when I insert a new record and query next time,its shows previous results only(problem facing in IE but not in chrome).
View 2 Replies
Jan 2, 2012
I'm having some trouble getting around a security restriction of flex. Saving a file is apparently an action that can only be invoked upon user interaction. The problem is that after my user clicks on the save button, I need to perform a database query to get the data for the file I want to save.
Because Flex works asynchronous, I have to make the database call and then catch the ResultEvent in a different function. In that function, I no longer have the user's mouseclick event. How am I then supposed to save this file?
[Code]...
View 1 Replies
Nov 27, 2010
would go about setting up flash to display results returned by a SQL query one at a time.I can work out the query and PHP, but want I want to know is how to make flash take each one and animate it, including pausing and clearing the screen when full, then continuing on a 'new' screen. It's basically for displaying a list of events in a database.
Blank screen
Event 1 (pause)
Event 2 (pause)
[code].....
View 1 Replies
Dec 15, 2009
I have been looking for a tutorial that shows or explains how to display the contents of a search engine like 'Google' or 'Youtube' inside Flash. No luck so far...
View 1 Replies
Jan 18, 2010
I am working in Flash 8 and using AS 2.0 coding. I am working with page flipping application. Here I have an option "search". I will tell you the scenario. Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages. How this functionality has to done. How to search the jpg's with a given string?
View 1 Replies
Feb 22, 2011
I have a dropdown box that is used to select a Category. I need the Flash Application to send the value of Category plus the search string in my textbox to my Access query and return results for each product meeting selection criteria. The Flash Application is calling an ASP.NET web service which in turn queries an MS Access database.
To start, how do I define the category ID and search value in my Actionscript 3 code?I've placed a series of 12 or so objects that will be populated with the product description, title and price. How do I setup each field to be dynamic text associated with the title description and price from my query results? If there are more than 12 products returned by the query, how do I add an additional page of objects to house more than 12 query results?
View 2 Replies
Jan 17, 2010
I am working in Flash 8 and using AS 2.0 coding.
I am working with page flipping application. Here i have an option "search". I will tell you the scenario.
Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages.
How this functionality has to done. How to search the jpg's with a given string ?
View 1 Replies
Jan 18, 2010
I am working in Flash 8 and using AS 2.0 coding. I am working with page flipping application. Here i have an option "search". I will tell you the scenario. Here I am loading images/pages dynamically thru an xml. It was loading and working like a page flipping. so far it was done. Now if you enter some text inside the search option and press the button, it has to search for all the loaded images/pages and has to display the resulted pages. How this functionality has to done. How to search the jpg's with a given string?
View 0 Replies
Mar 24, 2011
Why flash don't display my data query send from a php file that use the $_GET to retrive the information and run a query to display the result back to flash.but when I change the $_GET variable in the php file for a static value let's say (2), flash display the data that was requested in the php query..with $_GET I get in flash undefined with "2".I get in flash the data requested...
View 12 Replies
Mar 24, 2010
I need to show the results in my flash program. The results are working great in a trace. I get the text to show, but not the results from high1.lab, high2.lab and high3.lab.
[Code].....
View 3 Replies
Apr 11, 2011
I've got a simple app that is currently getting information form a database and just displaying the content into a datagrid.
Instead of having this information displayed in a datagrid, I'd like to display it in a couple of labels (first name, last name, phone, etc.), but I'm not really sure how to.
Currently on creationComplete I call my php query function - which looks like this.
public function getPeople() {
return mysql_query("SELECT * FROM tbl_people ORDER BY pers_name ASC");
}
[Code].....
Eventually my query will be modified and will only ever return 1 row from the database. So how do I get the results to display in labels instead of the datagrid?
View 1 Replies
Jul 8, 2010
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
[Code]....
View 2 Replies
Sep 14, 2009
I am trying to write a small flash app which will load and display images provided as a query. My flash app works fine when I provide the image path directly in the browser address bar, but it is not working when I do the same using html.Here is the direct link to the flash appThe Html code is attached with the post.I know my app is getting invoked and it appears to work fine when I hardcode the image url into the flash app. But the query method just does not seem to be working!!This is hosted on a linux site supporting php.
View 1 Replies
Apr 7, 2010
I am trying to adapt this search code to display the results one at a time.Right now it displays all the terms it finds all at once and separated by commas. How would I adapt the code so it displays one item or term at a time.
[Code]...
View 9 Replies
May 5, 2010
I am trying to create an array (1-35), mix that array and display the results with a trace. I am getting an error with the following code.
public function generateArray(toNumber : int) : Array {
var result : Array = [];
for (var i : int = toNumber;
i != 0; i--) {
result.push(i);
[Code] .....
The error(s) are:
1180: Call to a possibly undefined method generateArray.
1120: Access of undefined property generateArrays.
View 27 Replies
Jul 4, 2010
Is it possible for recent versions of flash to directly (or thru Php) access (& update) data from a mysql database and display results based on the data?
So if my database were like this (math scores):User 13Jerry | 20Kane | 7 the flash output would be a bar graph like this (those hyphens would be bars in flash)
Is this possible these days? Google analytics does something like similar to this.
I last used flash somewhere in 2003/4. Never after that :-) I've completely lost touch.
View 6 Replies
Sep 20, 2011
Any Info about using the new Twitter API's to search images with a hashtag and display the results?
View 2 Replies
Jul 24, 2009
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].......
View 6 Replies
Apr 5, 2011
I am working on a search function but am having a bit of trouble finishing some display details. The following code works fine for finding and displaying text within an xml file, but I want to display the results differently. Using the following xml as a source, I would like to:- highlight the search term (var searchTerm) in red when found in the xml- add some characters found before and after the search term to give the term that is found some contextFor now, how could I add 3 characters before and after the search term, like so: "The first tex" - and highlight 'first' in red
var xmlFileToSearch:XML =
<xml>
<sim>
[code].....
View 4 Replies
Aug 6, 2011
i have two functions written to work out the time until lesson starts.
However, if i try to output the results in a dynamic text field, it doesn't work? It only works with the trace method?
View 5 Replies
Dec 14, 2011
I followed this guide to display data from mysql database:But what to do if i have datagrid like this:
<mx:DataGrid id="dataGrid" width="100%" height="100%" creationComplete="dataGrid_creationCompleteHandler(event)" >
<mx:columns>
[code].....
View 1 Replies
Aug 25, 2006
Similar to PHP and GD Library I want the SWF to load the query string and display it in a custom font.for example
header.swf?word=NEWS
And it would display NEWS in my certain font that is embedded in the clip How do i load a query string?
View 1 Replies
Mar 31, 2010
I have an AdvancedDataGrid with a custom label function whose value can change based on other form status (specifically, there's a drop down to choose the time display format for some columns).Right now, I have this labelFunction:
internal function formatColumnTime(item: Object, column: AdvancedDataGridColumn): String {
var seconds: Number = item[column.dataField];
return timeFormat.selectedItem.labelFunction(seconds);
}
[code]....
... and the timeFormat object is a combo box with items whose labelFunction attributes are formatTimeAsFractions and formatTimeAsInterval.The columns that have time formats have formatColumnTime as their labelFunction value, because extracting the seconds in that function and passing it in to the formatters made for a more testable app (IMHO).
when the timeFormat.selectedItem value changes, I want to force my grid to re-calculate the labels of these colums. What method must I call on it? invalidateProperties() didn't work, so that's out.
View 2 Replies
Aug 26, 2010
I am successfully Passing HTTP Query String to Flash Query String.
Resuming:
inside html
Code:
' <EMBED src="Film1.swf'+document.location.search+'"
'+
inside as3
[Code].....
Then Film1.swf can't grab no more the userName parameter.
View 4 Replies