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] .....

ADVERTISEMENT

ActionScript 3.0 :: Display Results Of MySQL Query From AMFPHP By ArrayCollection?

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 View Related

Flash - Execute Some Command Line Arguments In The Local Machine And Get The Results Back Or Output Back To A Textbox Area?

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 View Related

ActionScript 3.0 :: Retrieve Query Results From ASP.NET Web Service?

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 View Related

Data Integration :: Run A Query And Convert The Results To An XML String?

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 View Related

Actionscript :: Pass FlashVars In To Flash And Then Back Out As A Query String

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 View Related

Flex :: 3 - Cachy - Insert A New Record And Query Next Time - Its Shows Previous Results Only

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 View Related

Flex - Security Restriction - Save The Results Of A Database Query To A Local File?

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 View Related

Professional :: Display SQL Results In Flash?

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 View Related

How To Display Search Results Using AS2 And Flash

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 View Related

IDE :: How To Search And Display Results In Flash

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 View Related

ActionScript 3.0 :: Send Search String To Database Query And Return Results To Dynamic Text Fields?

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 View Related

ActionScript 1/2 :: Search And Display The Results In Flash?

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 View Related

ActionScript 2.0 :: How To Search And Display Results In Flash

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 View Related

Professional :: Why Flash Don't Display Data Query Send From Php File

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 View Related

ActionScript 3.0 :: Display Results In Dynamic Text?

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 View Related

Flex :: Zend Amf - Display Results In Different Labels

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 View Related

Php :: Calling A Page With MySQL Query From Javascript Function Then Returning Results To Another Javascript Function

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 View Related

Load And Display Images Provided As A Query?

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 View Related

ActionScript 2.0 :: Display Multiple Search Results One At A Time?

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 View Related

ActionScript 3.0 :: Creating Array / Mix And Display Results With Trace

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 View Related

Professional :: Ql Database And Display Results Based On The Data?

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 View Related

ActionScript 3.0 :: Twitter API To Search Images And Display Results

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 View Related

ActionScript 3.0 :: UILoader Won't Display Images From PHP/MYSQL Query?

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 View Related

ActionScript 3.0 :: Modify/stylize Search Results For Use In .htmlText Display?

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 View Related

ActionScript 3.0 :: Display Function Results In A Dynamic Text Field?

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 View Related

Flex :: Display Result Of Query To Custom Cell Of DataGrid?

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 View Related

ActionScript 2.0 :: SWF To Load The Query String And Display It In A Custom Font?

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 View Related

Flex :: Make An AdvancedDataGrid Re-display Its Labels When The Results Of The LabelFunction Change?

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 View Related

ActionScript 3.0 :: Passing HTTP Query String To Flash Query String

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 View Related

ActionScript 3.0 :: Passing HTTP Query String To Flash Query String?

Aug 26, 2010

I am successfully Passing HTTP Query String to Flash Query String.Resuming:inside html

HTML Code:
' <EMBED src="Film1.swf'+document.location.search+'"
'+

[code].....

View 1 Replies View Related

Query - Run A Sqlite Query In Flex To Count The Total Number Of Records?

Apr 16, 2010

I'm trying to run a sqlite query in flex to count the total number of records I believe its working fine but I just can't figure out how to display the results - all I get back is [object Object].

private function overviewOne():void{
var stmt:SQLStatement = new SQLStatement();
stmt.sqlConnection = sqlConn;
stmt.text = "SELECT COUNT(user_id) FROM tbl_user WHERE status_status ='Away'";

[code]....

So how do I make a reference to the COUNT(user_id)?

(flash.data::SQLResult)#0
complete = true
data = (Array)#1

[code]....

View 1 Replies View Related

Flex :: Mobile: Display Back Button Automatically If View Is Not First In Stack?

Nov 19, 2011

In Flex 4.5 for mobile is it possible to check if there is > 1 view on a navigation stack and display a back button accordingly? If so how can I do this?My application is based ons:ViewNavigatorApplicationI'm adding a back button like this

<s:navigationContent>
<s:Button label="Back" click="backButtonPressed(event)"/>
</s:navigationContent>

[code]......

View 2 Replies View Related

Flex :: 3 - Collapsible Panel Is Removed From Display Then Switch Back To The Previous State?

Dec 3, 2009

I am using this collapsible panel - link. Unfortunately, I have a problem using it with application states. I have a state where this panel is visible, when I switch to this state, this panel shows, when I click on it, it opens and its content shows. If I switch to another state (this panel is removed from display), and then switch back to the previous state, the collapsible panel stays open, but its content disappears. In other words, the collapsible panel's content doesn't persist through states. Anyone know what the problem is? Or is there another collapsible panel that can work around this issue?

View 2 Replies View Related

ActionScript 2.0 :: Display What My Server Side Script Sends Back After Submit Form

Jul 11, 2003

Basically I would like to display what my server side script sends back after I submit my form. The results need to be displayed in my scroller box. I started to write it out but I am stuck.

[Code]...

View 4 Replies View Related

ADVERTISEMENT