ansaurus

Question

symfony doctrine query result and execute function

Answer 1

+1 A:

A few things:

Instead of $course->firstname and $course->title, you want $course->getFirstName() and $course->getTitle().
You should use singular names for your tables instead of plural, e.g. Course instead of Courses.
The convention in symfony is to use "id" for the primary key name instead of what you're doing.

Fix those problems - especially the first one - and your overall problem should go away.

Jason Swett 2010-09-24 19:54:44

Actually, there should be no difference between the two. In fact, the `getXXX` methods aren't part of Doctrine, they're added by Symfony to add an interface that matches Propel. Personally, I'm of the opinion that, whenever possible, only array style notation should be used in templates so they're agnostic as to whether they receive Records or arrays.

jeremy 2010-09-24 21:16:33

I have tried your answer. $course->getFirstName results this 'adsfasdfsdf'. it is supposed to answer my name. Also when i try to run foreach loop this error occurs. **Unknown record property / related component "getFirstName" on "Students"**

mysterious 2010-09-25 04:29:35

Answer 2

+1 A:

this is how i get it work...

$q= Doctrine_Query::create()
     ->select('s.firstname,
              s.middlename,
              s.lastname,
              p.program,
              c.title,
              pc.year')
     ->from('Students s')
     ->leftJoin('s.Programs p')
     ->leftJoin('p.Programcourses pc')
     ->leftJoin('pc.Courses c')
     ->where("idstudents = ".$studentid);

//$this->query=$q->getSqlQuery();
$q->setHydrationMode(Doctrine_Core::HYDRATE_SCALAR);
$this->Student=$q->execute(array());

and in template

<?php foreach ($Student as $student): ?>
<tr>
  <td><?php echo $i; ?></td>
  <td><?php echo $student['c_title'] ?></td>
  <td><?php echo $student['pc_year'] ?></td>
  <td><?php echo $student['p_program'] ?></td>
</tr>
<?php endforeach; ?>

mysterious 2010-09-26 10:38:48

Answer 3

+1 A:

Your top node is the a Students object, because you use Students in the from()

Your error describe this

Also when i try to get $course->title, this error appears Unknown record property / related component "title" on "Students"

because you have a Students object, not a Courses one (where title belongs)

You are confusing yourself using

$this->courses=$q->execute();

$q= Doctrine_Query::create()
 ->select('s.firstname,
          s.middlename,
          s.lastname,
          p.program,
          c.title,
          pc.year')
 ->from('Students s')
 ->leftJoin('s.Programs p')
 ->leftJoin('p.Programcourses pc') 
 ->leftJoin('pc.Courses c')
 ->where("idstudents = ?", $studentid); // beware to SQL injection, use parameters

$this->Student=$q->fectchOne(); // as you are only retrieve one in your where clause
$this->Student=$q->execute()->getFirst(); // same

<tr>
  <td><?php echo $i; /* not sure what this is for */ ?></td>
  <td><?php echo $Student->Programs->Programcourses->Courses->title ?></td>
  <td><?php echo $Student->Programs->Programcourses->year ?></td>
  <td><?php echo $Student->Programs->program ?></td>
</tr>

If you want Courses to be the top, just go for something like:

$q= Doctrine_Query::create()
 ->select('s.firstname,
          s.middlename,
          s.lastname,
          p.program,
          c.title,
          pc.year')
 ->from('Courses c')
 ->leftJoin('c.Programcourses pc') 
 ->leftJoin('pc.Programs p')
 ->leftJoin('p.Students s')
 ->where("s.idstudents = ?", $studentid);

Julien 2010-09-26 19:05:02

I tried this solution, the error is almost same **Unknown record property / related component "title" on "Programcourses"**, Moreover this query does not return one record, it returns many records.

mysterious 2010-09-27 04:46:06

ansaurus

tags:

views:

answers:

symfony doctrine query result and execute function

related questions