This content has been marked as final. Show 5 replies
I haven't been using Flex for very long, but I have found it very easy to work with Flex and MySQL using PHP. All I had to do was make a php page with multiple functions that accessed the database and executed a query. In flex, I send an HTTPService request to myPhpPage.php?functionName=myUpdateFunction and send out any other data that the function will need. Then the php function prints out xml containing parts of the results that I needed, and Flex does what it needs to do with the xml.
Hope that helped,
How difficult or easy to send/obtain data from you data tier depends of the way and how much data at the same time you request or send, I have a couple of examples of Flex 2 + PHP + MySQL and all work great,
I think that Flex not only can be use for request and present the data, Flex support many ways to send data to a data tier (DB) but again depend of the way you structure the form of send that data.
Thanks for the replies everyone. Chris, I definetely like your idea of just one php file that handles all of it. Joaquín, would it be possible to perhaps see some of the code for those applications or some of the part to exactly how you handle the integration between flex and the database and what sort of layer you use inbetween? I am interested in just some sample php files to get me going. Thanks!
Furthermore, Flex is completely independent or the server tier, and you can use almost any server-side platform you are comfortable with.
I personally use ASP.NET and communicate with Flex using HTTPService. I have also used classic ASP and JSP to do this. ColdFusion also works well I am told.
Unless you buy FDS(Flex Data Services), you must choose between RemoteObject, HTTPService or WebService as your transport protocols, but that is a very wide selection of mostly standard options.
Joaquin, what do you use with PHP?
Until now I use HTTPServices to get/send data to my DB.
Dan Orth let me find some code that can help you.