Connecting Flex 4 with AMFPHP

These days am missing this blog coz am busy with learning Flex. When i tried to connect with AMFPHP i can't find anything useful. Most of them were vague .Using the default data connectivity in Flash Builder am more confused and it's code looks complex . Atlast i found someone helpfull from adobe forum.

When i tried to implement it , it shows nothing and missing some files. When i checked the PHP file, though am not good in PHP , i found there is also something also missing. I tried and searched and corrected the files.
Here is the MXML code:

	
import flash.events.MouseEvent;
import mx.controls.Alert;
import mx.events.FlexEvent;
import mx.rpc.events.FaultEvent;
import mx.rpc.events.ResultEvent;
protected function getAllEmployees_resultHandler(event: ResultEvent): void {
	dataGrid.dataProvider = event.result;
}
protected function getAllEmployeesByID_resultHandler(event: ResultEvent): void {
	dataGrid.dataProvider = event.result;
}
protected function createEmployees_resultHandler(event: ResultEvent): void {
	Alert.show("inserted with ID=" + event.result);
	EmpService.getAllEmployees();
}
protected function EmpService_faultHandler(event: FaultEvent): void {
	trace(event.fault.faultDetail);
}
protected function datagrid1_creationCompleteHandler(event: FlexEvent): void {
	EmpService.getAllEmployees();
}
protected function Insert_clickHandler(event: MouseEvent): void {
	var e: Employee = new Employee();
	e.first_name = fname.text;
	e.last_name = lname.text;
	e.hire_date = hdate.text;
	e.birth_date = bdate.text;
	e.gender = gender.text;
	e.emp_no = parseInt(empno.text);
	EmpService.createEmployees(e);
}
protected function search_clickHandler(event: MouseEvent): void {
	EmpService.getEmployeesByID(parseInt(stext.text));
}
protected function button1_clickHandler(event: MouseEvent): void {
	EmpService.getAllEmployees();
}
		

This is the PHP service class which needed to be placed in the /services folder both in AMFPHP1.9 and 2.0 versions.

<?php
  include('Employee.php');
  //amfphp1.9
  class EmployeesService
  {
      var $username = "root";
      var $password = "";
      var $server = "localhost";   
      var $port = "3306";
      var $databasename = "fb_tutorial_db";    
      var $tablename = "employees";
      var $connection;
      public function __construct()
      {
          $this->connection = mysqli_connect($this->server, $this->username, $this->password, $this->databasename, $this->port);
      }
      
      public function getAllEmployees()
      {
          $stmt = mysqli_prepare($this->connection, "SELECT * FROM $this->tablename");
          mysqli_stmt_execute($stmt);
          $rows = array();
		  $row = new Employee();
          mysqli_stmt_bind_result($stmt, $row->emp_no, $row->birth_date, $row->first_name, $row->last_name, $row->gender, $row->hire_date);
          while (mysqli_stmt_fetch($stmt)) {
              $rows[] = $row;
              $row = new Employee();
              mysqli_stmt_bind_result($stmt, $row->emp_no, $row->birth_date, $row->first_name, $row->last_name, $row->gender, $row->hire_date);
          }  
          mysqli_stmt_free_result($stmt);
          mysqli_close($this->connection);
          return $rows;
      }
      
      public function getEmployeesByID($itemID)
      {
          $stmt = mysqli_prepare($this->connection, "SELECT * FROM $this->tablename where emp_no=?");     
          mysqli_bind_param($stmt, 'i', $itemID);  
          mysqli_stmt_execute($stmt);
		  $row = new Employee();
          mysqli_stmt_bind_result($stmt, $row->emp_no, $row->birth_date, $row->first_name, $row->last_name, $row->gender, $row->hire_date);
          if (mysqli_stmt_fetch($stmt)) {
              return $row;
          } else {
              return null;
          }
      }
      
      public function createEmployees($item)
      {
          $stmt = mysqli_prepare($this->connection, "INSERT INTO $this->tablename (birth_date, first_name, last_name, gender, hire_date) VALUES (?, ?, ?, ?, ?)");  
          mysqli_stmt_bind_param($stmt, 'sssss', $item["birth_date"], $item["first_name"], $item["last_name"], $item["gender"], $item["hire_date"]);
          mysqli_stmt_execute($stmt);
          $autoid = mysqli_stmt_insert_id($stmt);
          mysqli_stmt_free_result($stmt);
          mysqli_close($this->connection);
          return $autoid;
      }
  }

Here is the PHP Value Object Class

<?php
class Employee{
public $emp_no;
public $first_name;
public $last_name;
public $gender;
public $hire_date;
public $birth_date;
}
?>

For AMFPHP 2.0 edit the endpoint from http://localhost/amfphp/gateway.php to http://localhost/amfphp2/ (version AmfPHP 2.0 )
And need to change the  createEmployees($item) function in EmployeeService.php to

  
public function createEmployees($item)
      {
          $stmt = mysqli_prepare($this->connection, "INSERT INTO $this->tablename (birth_date, first_name, last_name, gender, hire_date) VALUES (?, ?, ?, ?, ?)");  
          mysqli_stmt_bind_param($stmt, 'sssss', $item->birth_date, $item->first_name, $item->last_name, $item->gender, $item->hire_date);
          mysqli_stmt_execute($stmt);
          $autoid = mysqli_stmt_insert_id($stmt);
          mysqli_stmt_free_result($stmt);
          mysqli_close($this->connection);
          return $autoid;
      }

I don't know the reason but it worked for me. But i think in 1.9 the object passed to PHP function is an array and in 2.0 it's an object of stdClass. That's why this change.