Symfony Doctrine help

Expand Post »

Hi everybody,

I have some difficulties getting my objects mapped from a query.

My query is this one:

PHP Syntax (Toggle Plain Text)
        $this->myPlanes = Doctrine_Query::create()
                ->from('FsPlane p')
                ->leftJoin('p.FsPlanetech t')
                ->leftJoin('t.FsPicture')
                ->where('player_id = ?', $id)
                ->execute();
        $this->myPlanes = Doctrine_Query::create()
                ->from('FsPlane p')
                ->leftJoin('p.FsPlanetech t')
                ->leftJoin('t.FsPicture')
                ->where('player_id = ?', $id)
                ->execute();

But when I want to retrieve my objects FsPicture I get something strange
code:

PHP Syntax (Toggle Plain Text)
        foreach ($myPlanes as $key => $iterPlane) {
            $picture = $iterPlane->FsPlanetech->getFsPicture();
 
}
        foreach ($myPlanes as $key => $iterPlane) {
            $picture = $iterPlane->FsPlanetech->getFsPicture();

}

$picture is a object(sfOutputEscaperIteratorDecorator)
Which is not what I want I just want my object from the db mapped.

My schema.yml

PHP Syntax (Toggle Plain Text)
 
FsPlane:
       actAs: { Timestampable: ~  }
       columns:
              id: { type: integer, notnull: true, autoincrement:true, primary:true }
              player_id: { type: integer, notnull: false }
              planetech_id: { type: integer, notnull: false }
              pilot_id: { type: integer, notnull: false, unique: true }
              copilot_id: { type: integer, notnull: false, unique: true }
       relations:
              FsPlayer: { onDelete: CASCADE, local: player_id, foreign: id }
              FsPlanetech: { onDelete: CASCADE, local: planetech_id, foreign: id }
              FsPilot: { onDelete: CASCADE, local: pilot_id, foreign: id, class: FsEmployee }
              FsCoPilot: { onDelete: CASCADE, local: copilot_id, foreign: id, class: FsEmployee }
 
FsPlanetech:
       actAs: 
       columns:
              id: { type: integer, notnull: true, autoincrement:true, primary:true }
              manufacturer: { type: string(255), notnull: true }
              model: { type: string(255), notnull: true }
              type: { type: string(255), notnull: true }
              weight: { type: integer, notnull: true }
              maxweight: { type: integer, notnull: true }
              speed: { type: float, notnull: true }
              maxspeed: { type: float, notnull: true }
              landingspeed: { type: float, notnull: false }
              maxpassengers: { type: integer, notnull: true }
              nrofreactors: { type: integer, notnull: true }
              price: {type: integer, notnull: true }
 
 
FsPicture:
       columns:
             id: { type: integer, notnull: true, autoincrement:true, primary:true }
             picture: { type: string(255) }
             plane: {type: integer }
       relations:
             FsPlanetech: {onDelete: CASCADE, local: plane, foreign: id}
FsPlane:
       actAs: { Timestampable: ~  }
       columns:
              id: { type: integer, notnull: true, autoincrement:true, primary:true }
              player_id: { type: integer, notnull: false }
              planetech_id: { type: integer, notnull: false }
              pilot_id: { type: integer, notnull: false, unique: true }
              copilot_id: { type: integer, notnull: false, unique: true }
       relations:
              FsPlayer: { onDelete: CASCADE, local: player_id, foreign: id }
              FsPlanetech: { onDelete: CASCADE, local: planetech_id, foreign: id }
              FsPilot: { onDelete: CASCADE, local: pilot_id, foreign: id, class: FsEmployee }
              FsCoPilot: { onDelete: CASCADE, local: copilot_id, foreign: id, class: FsEmployee }

FsPlanetech:
       actAs: 
       columns:
              id: { type: integer, notnull: true, autoincrement:true, primary:true }
              manufacturer: { type: string(255), notnull: true }
              model: { type: string(255), notnull: true }
              type: { type: string(255), notnull: true }
              weight: { type: integer, notnull: true }
              maxweight: { type: integer, notnull: true }
              speed: { type: float, notnull: true }
              maxspeed: { type: float, notnull: true }
              landingspeed: { type: float, notnull: false }
              maxpassengers: { type: integer, notnull: true }
              nrofreactors: { type: integer, notnull: true }
              price: {type: integer, notnull: true }


FsPicture:
       columns:
             id: { type: integer, notnull: true, autoincrement:true, primary:true }
             picture: { type: string(255) }
             plane: {type: integer }
       relations:
             FsPlanetech: {onDelete: CASCADE, local: plane, foreign: id}

Greetz
Nodoso

Similar Threads

Symfony MOdule redirection in PHP
Doctrine query in PHP
Choosing Symfony , Zend Framework, CakePHP in PHP
Symfony in PHP
Symfony + skipping actions in PHP

nodoso

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Apr 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: The main uses of PHP within the Interactive Media/Web Design Industry...

Next Thread in PHP Forum Timeline: how to show the current date and time in my database tables

DaniWeb Message

Cancel Changes

User Name
Password