PHP Data Services for Flash Builder 4

#1
[eluser]Unknown[/eluser]
Flash Builder 4 can consume PHP classes directly as data services via the Zend AMF class. How would I integrate such PHP classes into a CI app? For example, what if I need to authenticate my PHP data service class from a current CI user that is logged into the app?

Basically, I need to embed a Flash Builder app into some pages of my CI app, and issue calls to these PHP classes.

Here's an example of a PHP data service created by Flash Builder 4:

Code:
<?php
class EmployeeService {
  var $username = "dbuser";
  var $password = "dbpassword";
  var $server = "127.0.0.1";
  var $port = "3306";
  var $databasename = "testdrive_db";
  var $tablename = "employees";
  
  var $connection;
  public function __construct() {
    $this->connection = mysqli_connect(
                       $this->server,  
                       $this->username,  
                       $this->password,
                       $this->databasename,
                       $this->port
                       );
    
    $this->throwExceptionOnError($this->connection);
  }

  public function getEmployees() {
     $stmt = mysqli_prepare($this->connection,
          "SELECT
              employees.id,
              employees.firstname,
              employees.lastname,
              employees.title,
              employees.departmentid,
              employees.officephone,
              employees.cellphone,
              employees.email,
              employees.street,
              employees.city,
              employees.state,
              employees.zipcode,
              employees.office,
              employees.photofile
           FROM employees");    
        
      $this->throwExceptionOnError();

      mysqli_stmt_execute($stmt);
      $this->throwExceptionOnError();

      $rows = array();
      mysqli_stmt_bind_result($stmt, $row->id, $row->firstname,
                    $row->lastname, $row->title, $row->departmentid,
                    $row->officephone, $row->cellphone, $row->email,  
                    $row->street, $row->city, $row->state,
                    $row->zipcode, $row->office, $row->photofile);

      while (mysqli_stmt_fetch($stmt)) {
          $rows[] = $row;
          $row = new stdClass();
          mysqli_stmt_bind_result($stmt,  $row->id, $row->firstname,
                    $row->lastname, $row->title, $row->departmentid,
                    $row->officephone, $row->cellphone, $row->email,  
                    $row->street, $row->city, $row->state,
                    $row->zipcode, $row->office, $row->photofile);
      }

      mysqli_stmt_free_result($stmt);
      mysqli_close($this->connection);

      return $rows;
  }  

  public function getEmployeesByID($itemID) {
     $stmt = mysqli_prepare($this->connection,
          "SELECT
              employees.title,
              employees.street,
              employees.id,
              employees.firstname,
              employees.lastname,
              employees.cellphone,
              employees.departmentid,
              employees.zipcode,
              employees.office,
              employees.email,
              employees.state,
              employees.officephone,
              employees.photofile,
              employees.city
           FROM employees where employees.id=?");
      $this->throwExceptionOnError();
          
      mysqli_stmt_bind_param($stmt, 'i', $itemID);
      $this->throwExceptionOnError();

      mysqli_stmt_execute($stmt);
      $this->throwExceptionOnError();

      $rows = array();
      mysqli_stmt_bind_result($stmt, $row->title, $row->street, $row->id,
                              $row->firstname, $row->lastname, $row->cellphone,
                              $row->departmentid, $row->zipcode, $row->office,
                              $row->email, $row->state, $row->officephone ,
                              $row->photofile, $row->city);

      if (mysqli_stmt_fetch($stmt)) {
                  return $row;
      } else {
                  return null;
          }

      mysqli_stmt_free_result($stmt);
      mysqli_close($this->connection);

  }  

   public function createEmployee($item) {
    $stmt = mysqli_prepare($this->connection,
        "INSERT INTO employees (
            firstname,lastname,title,departmentid,officephone,cellphone,    
            email,street,city,state,zipcode,office,photofile)
        VALUES (?, ?, ?, ?, ?, ?,?,?,?,?,?,?,?)");
    $this->throwExceptionOnError();
    
    mysqli_bind_param($stmt, 'sssisssssssss', $item->firstname, $item->lastname,
        $item->title, $item->departmentid, $item->officephone, $item->cellphone,
        $item->email, $item->street, $item->city, $item->state,
        $item->zipcode, $item->office, $item->photofile
    );
    $this->throwExceptionOnError();

    mysqli_stmt_execute($stmt);
    $this->throwExceptionOnError();
    
    $autoid = mysqli_stmt_insert_id($stmt);
    
    mysqli_stmt_free_result($stmt);
    mysqli_close($this->connection);
    
    return $autoid;
  }

#2
[eluser]mak.gnu[/eluser]
hey you Got the solution on this even I'm looking for the solution.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.