PHP在Flex3裡的互動

　　大概是2月23日的時候，自己在圖書館裡看了一篇文章是講述FLEX3裡如何與PHP進行互動的。看得我如癡如醉，因為裡面的思想是如此的精鍊，勝過FLEX2許多許多。可見，它還是受重視的，FLEX還是在逐漸成長的。

　　不過，已經對自己說了，沒有考研之前，對除c++之外的技術全都放下。放下。C++最強大。

 

 

Flex3裡自動產生的程式碼十分有邏輯性，並且很精闢和通用。首先是資料類型（MYSQL-->FLEX）裡的變換的2個函數組成的PHP檔案：functions.inc.php

<?php /** * simple escape function for sql values */ function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? '"' . $theValue . '"' : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? '"' . doubleval($theValue) . '"' : "NULL"; break; case "date": $theValue = ($theValue != "") ? '"' . $theValue . '"' : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } function GetSQLValueStringForSelect($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? '"%' . $theValue . '%"' : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? '"' . doubleval($theValue) . '"' : "NULL"; break; case "date": $theValue = ($theValue != "") ? '"' . $theValue . '"' : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } ?>

 

　　然後是將常用的MYSQL命令（插入刪除更新等）封裝為FLEX裡的函數和事件。產生的Student.php。值得注意的是，這個檔案的內容是因你的資料表的不同而不同，並且值得以後提升的是，目前每個資料表對應一個php檔案，對應著自身的操作，但這就發生了許多的冗餘的產生。

 

　　這讓我想起了和王老師一起幹活時裡的LINQ，個人感覺兩者的思想上是一樣的。呵呵，也難怪昨晚在csdn首頁上看到某牛人的部落格，他走過了許多語言，現在停留在AS3上了。AS3本身是非常強大了，如果有了多線程與c裡面的某些特性的話，我也會一樣專心來研究了，呵呵，不過這都是我考研之後的事了。

 

　　Student.php代碼如下：

<?php require_once(dirname(__FILE__) . "/FlexPHPDBconn.php"); require_once(dirname(__FILE__) . "/functions.inc.php"); require_once(dirname(__FILE__) . "/XmlSerializer.class.php"); /** * This is the main PHP file that process the HTTP parameters, * performs the basic db operations (FIND, INSERT, UPDATE, DELETE) * and then serialize the response in an XML format. * * XmlSerializer uses a PEAR xml parser to generate an xml response. * this takes a php array and generates an xml according to the following rules: * - the root tag name is called "response" * - if the current value is a hash, generate a tagname with the key value, recurse inside * - if the current value is an array, generated tags with the default value "row" * for example, we have the following array: * * $arr = array( * "data" => array( * array("id_pol" => 1, "name_pol" => "name 1"), * array("id_pol" => 2, "name_pol" => "name 2") * ), * "metadata" => array( * "pageNum" => 1, * "totalRows" => 345 * ) * * ) * * we will get an xml of the following form * * <?xml version="1.0" encoding="ISO-8859-1"?> * <response> * <data> * <row> * <id_pol>1</id_pol> * <name_pol>name 1</name_pol> * </row> * <row> * <id_pol>2</id_pol> * <name_pol>name 2</name_pol> * </row> * </data> * <metadata> * <totalRows>345</totalRows> * <pageNum>1</pageNum> * </metadata> * </response> * * Please notice that the generated server side code does not have any * specific authentication mechanism in place. */ /** * The filter field. This is the only field that we will do filtering after. */ $filter_field = "Name"; /** * we need to escape the value, so we need to know what it is * possible values: text, long, int, double, date, defined */ $filter_type = "text"; /** * constructs and executes a sql select query against the selected database * can take the following parameters: * $_REQUEST["orderField"] - the field by which we do the ordering. MUST appear inside $fields. * $_REQUEST["orderValue"] - ASC or DESC. If neither, the default value is ASC * $_REQUEST["filter"] - the filter value * $_REQUEST["pageNum"] - the page index * $_REQUEST["pageSize"] - the page size (number of rows to return) * if neither pageNum and pageSize appear, we do a full select, no limit * returns : an array of the form * array ( * data => array( * array('field1' => "value1", "field2" => "value2") * ... * ), * metadata => array( * "pageNum" => page_index, * "totalRows" => number_of_rows * ) * ) */ function findAll() { global $conn, $filter_field, $filter_type; /** * the list of fields in the table. We need this to check that the sent value for the ordering is indeed correct. */ $fields = array('id','Name','Sex','age','Address','Remark'); $where = ""; if (@$_REQUEST['filter'] != "") { $where = "WHERE " . $filter_field . " LIKE " . GetSQLValueStringForSelect(@$_REQUEST["filter"], $filter_type); } $order = ""; if (@$_REQUEST["orderField"] != "" && in_array(@$_REQUEST["orderField"], $fields)) { $order = "ORDER BY " . @$_REQUEST["orderField"] . " " . (in_array(@$_REQUEST["orderDirection"], array("ASC", "DESC")) ? @$_REQUEST["orderDirection"] : "ASC"); } //calculate the number of rows in this table $rscount = mysql_query("SELECT count(*) AS cnt FROM `student` $where"); $row_rscount = mysql_fetch_assoc($rscount); $totalrows = (int) $row_rscount["cnt"]; //get the page number, and the page size $pageNum = (int)@$_REQUEST["pageNum"]; $pageSize = (int)@$_REQUEST["pageSize"]; //calculate the start row for the limit clause $start = $pageNum * $pageSize; //construct the query, using the where and order condition $query_recordset = "SELECT id,Name,Sex,age,Address,Remark FROM `student` $where $order"; //if we use pagination, add the limit clause if ($pageNum >= 0 && $pageSize > 0) { $query_recordset = sprintf("%s LIMIT %d, %d", $query_recordset, $start, $pageSize); } $recordset = mysql_query($query_recordset, $conn); //if we have rows in the table, loop through them and fill the array $toret = array(); while ($row_recordset = mysql_fetch_assoc($recordset)) { array_push($toret, $row_recordset); } //create the standard response structure $toret = array( "data" => $toret, "metadata" => array ( "totalRows" => $totalrows, "pageNum" => $pageNum ) ); return $toret; } /** * constructs and executes a sql count query against the selected database * can take the following parameters: * $_REQUEST["filter"] - the filter value * returns : an array of the form * array ( * data => number_of_rows, * metadata => array() * ) */ function rowCount() { global $conn, $filter_field, $filter_type; $where = ""; if (@$_REQUEST['filter'] != "") { $where = "WHERE " . $filter_field . " LIKE " . GetSQLValueStringForSelect(@$_REQUEST["filter"], $filter_type); } //calculate the number of rows in this table $rscount = mysql_query("SELECT count(*) AS cnt FROM `student` $where"); $row_rscount = mysql_fetch_assoc($rscount); $totalrows = (int) $row_rscount["cnt"]; //create the standard response structure $toret = array( "data" => $totalrows, "metadata" => array() ); return $toret; } /** * constructs and executes a sql insert query against the selected database * can take the following parameters: * $_REQUEST["field_name"] - the list of fields which appear here will be used as values for insert. * If a field does not appear, null will be used. * returns : an array of the form * array ( * data => array( * "primary key" => primary_key_value, * "field1" => "value1" * ... * ), * metadata => array() * ) */ function insert() { global $conn; //build and execute the insert query $query_insert = sprintf("INSERT INTO `student` (id,Name,Sex,age,Address,Remark) VALUES (%s,%s,%s,%s,%s,%s)" , GetSQLValueString($_REQUEST["id"], "int"), # GetSQLValueString($_REQUEST["Name"], "text"), # GetSQLValueString($_REQUEST["Sex"], "text"), # GetSQLValueString($_REQUEST["age"], "int"), # GetSQLValueString($_REQUEST["Address"], "text"), # GetSQLValueString($_REQUEST["Remark"], "text")# ); $ok = mysql_query($query_insert); if ($ok) { // return the new entry, using the insert id $toret = array( "data" => array( array( "id" => $_REQUEST["id"], "Name" => $_REQUEST["Name"], # "Sex" => $_REQUEST["Sex"], # "age" => $_REQUEST["age"], # "Address" => $_REQUEST["Address"], # "Remark" => $_REQUEST["Remark"]# ) ), "metadata" => array() ); } else { // we had an error, return it $toret = array( "data" => array("error" => mysql_error()), "metadata" => array() ); } return $toret; } /** * constructs and executes a sql update query against the selected database * can take the following parameters: * $_REQUEST[primary_key] - thethe value of the primary key * $_REQUEST[field_name] - the list of fields which appear here will be used as values for update. * If a field does not appear, null will be used. * returns : an array of the form * array ( * data => array( * "primary key" => primary_key_value, * "field1" => "value1" * ... * ), * metadata => array() * ) */ function update() { global $conn; // check to see if the record actually exists in the database $query_recordset = sprintf("SELECT * FROM `student` WHERE id = %s", GetSQLValueString($_REQUEST["id"], "int") ); $recordset = mysql_query($query_recordset, $conn); $num_rows = mysql_num_rows($recordset); if ($num_rows > 0) { // build and execute the update query $row_recordset = mysql_fetch_assoc($recordset); $query_update = sprintf("UPDATE `student` SET Name = %s,Sex = %s,age = %s,Address = %s,Remark = %s WHERE id = %s", GetSQLValueString($_REQUEST["Name"], "text"), GetSQLValueString($_REQUEST["Sex"], "text"), GetSQLValueString($_REQUEST["age"], "int"), GetSQLValueString($_REQUEST["Address"], "text"), GetSQLValueString($_REQUEST["Remark"], "text"), GetSQLValueString($row_recordset["id"], "int") ); $ok = mysql_query($query_update); if ($ok) { // return the updated entry $toret = array( "data" => array( array( "id" => $row_recordset["id"], "Name" => $_REQUEST["Name"], # "Sex" => $_REQUEST["Sex"], # "age" => $_REQUEST["age"], # "Address" => $_REQUEST["Address"], # "Remark" => $_REQUEST["Remark"]# ) ), "metadata" => array() ); } else { // an update error, return it $toret = array( "data" => array("error" => mysql_error()), "metadata" => array() ); } } else { $toret = array( "data" => array("error" => "No row found"), "metadata" => array() ); } return $toret; } /** * constructs and executes a sql update query against the selected database * can take the following parameters: * $_REQUEST[primary_key] - thethe value of the primary key * returns : an array of the form * array ( * data => deleted_row_primary_key_value, * metadata => array() * ) */ function delete() { global $conn; // check to see if the record actually exists in the database $query_recordset = sprintf("SELECT * FROM `student` WHERE id = %s", GetSQLValueString($_REQUEST["id"], "int") ); $recordset = mysql_query($query_recordset, $conn); $num_rows = mysql_num_rows($recordset); if ($num_rows > 0) { $row_recordset = mysql_fetch_assoc($recordset); $query_delete = sprintf("DELETE FROM `student` WHERE id = %s", GetSQLValueString($row_recordset["id"], "int") ); $ok = mysql_query($query_delete); if ($ok) { // delete went through ok, return OK $toret = array( "data" => $row_recordset["id"], "metadata" => array() ); } else { $toret = array( "data" => array("error" => mysql_error()), "metadata" => array() ); } } else { // no row found, return an error $toret = array( "data" => array("error" => "No row found"), "metadata" => array() ); } return $toret; } /** * we use this as an error response, if we do not receive a correct method * */ $ret = array( "data" => array("error" => "No operation"), "metadata" => array() ); /** * check for the database connection * * */ if ($conn === false) { $ret = array( "data" => array("error" => "database connection error, please check your settings !"), "metadata" => array() ); } else { mysql_select_db($database_conn, $conn); /** * simple dispatcher. The $_REQUEST["method"] parameter selects the operation to execute. * must be one of the values findAll, insert, update, delete, Count */ // execute the necessary function, according to the operation code in the post variables switch (@$_REQUEST["method"]) { case "FindAll": $ret = findAll(); break; case "Insert": $ret = insert(); break; case "Update": $ret = update(); break; case "Delete": $ret = delete(); break; case "Count": $ret = rowCount(); break; } } $serializer = new XmlSerializer(); echo $serializer->serialize($ret); die(); ?>