Adobe Flex, WebORB for PHP and Qcodo

This may not be your normal post, but I believe we'll be seeing more of this kind of mash-up in the future.

Qcodo has such a great implementation for a full CRUD approach, that I want to implement it for use with WebORB for PHP and Adobe Flex as the presentation layer. This at the same time allows us to maintain web application functionality outside of Adobe Flex (aka non-RIA pages.)

WebORB for PHP is part of the data access layer, which takes the output of a SQL query and returns it to Adobe Flex as an object via RPC.

A lot of background to the following question:

What would you say is best practice of extending the Qcodo classes so that I can return the results of the actual SQL queries rather than returning an array?

Which classes would need to be extended?

Thanks,

Jurgen

Obviously, returning an array would be the easiest implementation. However, we loose quite a bit in terms of advanced concepts in Flex. Using AMF3 is the preferred way of getting large amounts of data back to Flex.

I'll keep digging and see if I can come up with a solution.

Jurgen

<?php
   if (!defined('__PREPEND_INCLUDED__')) {
       // Ensure prepend.inc is only executed once
       define('__PREPEND_INCLUDED__', 1);

       require(dirname(_FILE_) . '/qcodo/qcodo_conf.inc.php');

       require(_QCODO_CORE_ . '/qcodo_orm_only.inc.php');

       abstract class QApplication extends QApplicationBase {
           public static function Autoload($strClassName) {
               // First use the Qcodo Autoloader
               parent::Autoload($strClassName);
           }

           public static $EncodingType = 'UTF-8';
       }

           QApplication::Initialize();
       QApplication::InitializeDatabaseConnections();
   }
?>

Hi klucznik, it works like magic!
Great! Thank you very much. Changing the prepend.inc.php does work magically.
However is that an older version of qcodo? I have slightly different code ()

<?php
   if (!defined('__PREPEND_INCLUDED__')) {
       // Ensure prepend.inc is only executed once
       define('__PREPEND_INCLUDED__', 1);

       require(dirname(_FILE_) . '/configuration.inc.php');

       require(_QCODO_CORE_ . '/qcodo.inc.php');

       abstract class QApplication extends QApplicationBase {
           public static function Autoload($strClassName) {
               // First use the Qcodo Autoloader
               parent::Autoload($strClassName);
           }

           public static $EncodingType = 'UTF-8';
       }

           QApplication::Initialize();
       QApplication::InitializeDatabaseConnections();
   }
?>

Once again thanks! Jurgen, I am sure it will work for you too. In my AMFPHP service, all I did is this:
require('C:/Apache/htdocs/qcodo/wwwroot/includes/prepend.inc.php');

Well, I can't return a query result to Flash by just calling MyObject::LoadAll();

Say I have an table call People with fields, 'id', 'name' and 'gender'.
Qcodo will generate a class: People.class.php
You would need to write a function that would return an assoc array of the fields available in People so that Flash/Flex can received it as ArrayCollection.

public function getAsArray(){
   return array(
       'id'=>$this->intId,
       'name'=>$this->strName,
       'isAssessment'=>$this->strGender
   );
}

In your AMF service class you can write a function like this:

public function getAllPeople(){
   $people = People::LoadAll();
   $rs=array();
   
   foreach ($people as $p){
          $rs[] = $p->getAsArray();
     }
   return $rs;
}

I am not sure is there any better method, this getAsArray function is tedious if you write for all of your tables. Maybe we should extend the code gen? Or is there any exisiting method to return an assoc array of the People instance?