MXML Connect to MySQL via PHP

Demo在這裡: http://140.112.31.185/flex/DBtest/bin/DBtest.html

先在資料庫建好一個叫做"sample"的資料表，其中欄位有userid, username, emailaddress
接著寫一個PHP程式，如下:

<br /><?php<br />define( "DATABASE_SERVER", "localhost" );<br />define( "DATABASE_USERNAME", "root" );<br />define( "DATABASE_PASSWORD", "root" );<br />define( "DATABASE_NAME", "sample" );<br /><br />//connect to the database<br />$mysql = mysql_connect(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD);<br />static $number = 0;<br /><br />mysql_select_db( DATABASE_NAME );<br /><br />// Quote variable to make safe<br />function quote_smart($value)<br />{<br /> // Stripslashes<br /> if (get_magic_quotes_gpc()) {<br /> $value = stripslashes($value);<br /> }<br /> // Quote if not integer<br /> if (!is_numeric($value)) {<br /> $value = "'" . mysql_real_escape_string($value) . "'";<br /> }<br /> return $value;<br />}<br /><br />if( $_POST["emailaddress"] AND $_POST["username"])<br />{<br /> //add the user<br /> $Query = sprintf("INSERT INTO users VALUES ('%d', %s, %s)", $number, quote_smart($_POST['username']), quote_smart($_POST['emailaddress']));<br /> $number = $number + 1;<br /> $Result = mysql_query( $Query );<br />}<br /><br />//return a list of all the users<br />$Query = "SELECT * from users";<br />$Result = mysql_query( $Query );<br /><br />$Return = "<users>";<br /><br />while ( $User = mysql_fetch_object( $Result ) )<br />{<br /> $Return .= "<user><userid>".$User->userid."</userid><username>".$User->username."</username><emailaddress>".$User->emailaddress."</emailaddress></user>"; <br />}<br />$Return .= "</users>";<br />mysql_free_result( $Result );<br />print ($Return)<br />?><br />

在Flex上新增一個Flex Project，編寫一個mxml程式:

<br /><?xml version="1.0" encoding="utf-8"?><br /><mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" xmlns="*" layout="absolute" creationComplete="userRequest.send()"><br /> <mx:HTTPService id="userRequest" url="http://localhost/flex/php/request.php" useProxy="false" method="POST"><br /> <mx:request xmlns=""><br /> <username>{username.text}</username><emailaddress>{emailaddress.text}</emailaddress><br /> </mx:request><br /> </mx:HTTPService><br /> <mx:Form x="22" y="10" width="493"><br /> <mx:HBox><br /> <mx:Label text="Username"/><br /> <mx:TextInput id="username"/><br /> </mx:HBox><br /> <mx:HBox><br /> <mx:Label text="Email Address"/><br /> <mx:TextInput id="emailaddress"/><br /> </mx:HBox><br /> <mx:Button label="Submit" click="userRequest.send()"/><br /> </mx:Form><br /> <mx:DataGrid id="dgUserRequest" x="22" y="128" dataProvider="{userRequest.lastResult.users.user}"><br /> <mx:columns><br /> <mx:DataGridColumn headerText="User ID" dataField="userid"/><br /> <mx:DataGridColumn headerText="User Name" dataField="username"/><br /> </mx:columns><br /> </mx:DataGrid><br /> <mx:TextInput x="22" y="292" id="selectedemailaddress" text="{dgUserRequest.selectedItem.emailaddress}"/><br /></mx:Application><br />