CakePHP 3 - Inner Join

Question

CakePHP 3 - Inner Join

Navigation

#1 by (1 votes)

0

How do I make an inner join to relate an article table to a favorite article table using cakephp 3.

favorites table:

CREATE TABLE IF NOT EXISTS 'favorites' (
'id' int(11) NOT NULL,
  'user_id' int(11) NOT NULL,
  'article_id' int(11) NOT NULL,
  'favorited' datetime NOT NULL
)

article table:

CREATE TABLE IF NOT EXISTS 'articles' (
'id' int(11) NOT NULL,
  'name' varchar(100) NOT NULL,
  'content' text NOT NULL,
  'created' datetime NOT NULL,
  'modified' datetime NOT NULL
)

php cakephp

asked by anonymous 09.05.2015 / 18:51

1 answer

Slideshow JQuery Error while passing Slide MySQL, load upside down

score 1 · Accepted Answer

In CakePHP 3.x this way!

Example:

$this->Favorites
    ->find('all')
    ->leftJoin('articles', 'articles.id = Favorites.article_id');

Documentation:

leftJoin () , rightJoin () , innerJoin () and manually join ( )