PHP and flex help

[abed el salam]

Hi All
please can any one help me ..

How can i use PHP script in Flex to connect with database and server

[bjornbjorn]

It's pretty straightforward. You use PHP on the server side and do what you usually do (connect to the db, run queries) - and then you return XML.

The XML can easily be read by Flex (Look up HTTPService and XML).

If you want, you can use a solution such as AMFPHP but in my opinion this will require you to do a lot more research before you begin to understand how things work. So I would suggest just playing around with outputting XML in a PHP script and trying to read it in Flex.

Good luck!

[abed el salam]

i use xml in flex its easy but when i work with large amount of record
i could not convert db data to xml file it will take several time
i need to use data directly from db
thanks

[bjornbjorn]

If you have performance issues try AMFPHP .. they have a C module.

I hear that hundred thousand records with 3 properties were converted in a second or something like that.

[dr_zeus]

You also don't have to return all of the data at once if you have a large number of records. Limit it to 100 at a time (or some other number that works for you) and send multiple requests.

As bjornbjorn said, AMFPHP might be useful for you too.