Flexing with PHP

February 12, 2008 in Programming
Tags: adobe flex, php

I have developed this example to understand how the data services and data providers work in Adobe Flex, and after I finished it I thought this would be a good mini-tutorial.

I used PHP as the server side scripting language, but the same can be applied to any other language e.g. JSP/Serlvets, ASP, …etc.

First You have to create a simple mysql database “named flexdump in the example” that contains a single table called products:
create table products(id int NOT NULL AUTO_INCREMENT PRIMARY KEY, product
VARCHAR(250) NOT NULL);

Flex code:

<mx:HTTPService id="addFormService" url="http://127.0.0.1:5050/flex1/add.php"
method="GET">
<mx:request xmlns="">
<product>
{product.text}
</product>
</mx:request>
</mx:HTTPService>
<mx:Form id="addForm" x="10" y="10">
<mx:FormHeading label="Add new products"/>
<mx:FormItem label="Product name:">
<mx:TextInput id="product"/>
</mx:FormItem>
<mx:FormItem>
<mx:Button label="Add" click="addFormService.send()"/>
</mx:FormItem>
</mx:Form>
<mx:HTTPService id="viewFormService" url="http://127.0.0.1:5050/flex1/ret.php" method="GET">
</mx:HTTPService>
<mx:Form id="viewForm" x="10" y="126">
<mx:FormHeading label="View products"/>
<mx:FormItem label="Products:">
<mx:List width="162" dataProvider="{viewFormService.lastResult.products.product}" />
</mx:FormItem>
<mx:FormItem>
<mx:Button label="View" click="viewFormService.send()"/>
</mx:FormItem>
</mx:Form>


PHP code:

//db.php
<?php
$db = mysql_connect("127.0.0.1:5051", "root", "") or die("erroorrr");
mysql_select_db("flexdump", $db) or die("erroorrr");
?>



//add.php
<?php
require("db.php");
$sql = "INSERT INTO products (product) VALUES ('" . $_GET['product'] . "');";
mysql_query($sql);
?>



//ret.php
<?php
require("db.php");
echo "<?xml version='1.0' encoding='ISO-8859-1' ?>\n";
echo "<products>\n";
$sql = "SELECT * FROM products";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
echo "<product>" . $row['product'] . "</product>\n";
}
echo "</products>";
?>

if there is any part you don’t understand feel free to contact me by leaving a comment..