connecting to mysql using php in flex

Question

Hi I am new to flex, I wanted to use flex line chart for displaying data stored in mysql table. Can anyone suggest me on how do I do this with flex as UI and mysql as db, I am not sure how to call .php file in flex to query from mysql. I wanted to show some data of time v/s temperature

I wrote a php file to query data from mysql, but my flex program is not able to connect to mysql, is there any configuration I need to update. I am using XAMPP

Do you know the HTTPService? help.adobe.com/en_US/FlashPlatform/reference/actionscript/3/mx/… You can also configure your backend: rightclick on project -> properties -> Flex Server but I haven't worked with this properties yet. — hering
– hering, Commented Mar 8, 2011 at 15:32

shaunhusain · Accepted Answer · 2011-03-08 16:27:16Z

1

Generally speaking theres no extra configuration you need to make this work as hering said in the comment an HTTPService will serve your purposes. Here's what you need to do:

private var myCollection:ArrayCollection;

public function creationComplete(event:Event):void
{
    var myService:HTTPService = new HTTPService();
    myService.url = "myscript.php"
    myService.method = "POST";
    myService.addEventListener(ResultEvent.RESULT, resultHandler);
    myService.send();
}

public function resultHandler(event:ResultEvent):void
{
    if(event.result..entries is ArrayCollection)
        myCollection = event.result..entries;
    else if(event.result..entries is Object)
        myCollection = new ArrayCollection(event.result..entries)
}

I'm assuming you're adding a listener to whatever control this service call lives in for creation complete that calls the creation complete function. I also assume you have (php generate) an xml structure like:

<entry>
    <entries>1</entries>
    <entries>2</entries>
</entry>

edited Mar 8, 2011 at 16:27

answered Mar 8, 2011 at 16:13

shaunhusain

19.7k4 gold badges41 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

shaunhusain Over a year ago

To note if you see nothing add a listener to the HTTPService for the FaultEvent.FAULT string and you'll get messages if you get something other than an ok message from the server.

Collectives™ on Stack Overflow

connecting to mysql using php in flex

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related