ansaurus

Question

Doctrine symfony multiple leftjoin Query

Answer 1

+2 A:

You can easily try your dql using the command line symfony doctrine:dql Now, in your query your relation programs is in lowercase, whereas it is in uppercase in your schema. If I were you, I would try something like this:

$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')
             ->where("idstudents = ?", $studentid);

greg0ire 2010-09-24 13:14:05

Those joins should have capital names of the relations. Also, you don't have to cast $studentid as an array.

jeremy 2010-09-24 15:06:36

I'm answering too quickly today. Thank god, you're here :)

greg0ire 2010-09-24 15:11:29

thanks greg..its working now but i am confused..i made my database in phpbb..and all relations were in lowercase..then i generated schema.yml from this database..in phpbb i still have lowercase relation names..then what for what reason symfony using this kind of convention?.. also what does idstudents = ? mean?

mysterious 2010-09-24 15:47:37

the question mark is a placeholder for a parameter ($studentid in this case). I triggers a prepared statement. See here what this is : http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html

greg0ire 2010-09-25 00:10:36

Answer 2

A:

There was a little mistake in your answer greg, if u can see select function, each column name is separated by comma, it should be like this..

$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);

mysterious 2010-09-24 16:23:32

Using that style where condition is a BIG mistake! You are by passing PDO by doing that and all of the benefits that come with it (like preventing SQL injection!).

jeremy 2010-09-24 18:31:54

Fixed. I definitely should get some sleep.

greg0ire 2010-09-24 23:59:37

ansaurus

tags:

views:

answers:

Doctrine symfony multiple leftjoin Query

related questions