converting sql query to laravel ( 5.2 )

With no lessons completed, I'd highly suggest viewing some videos, many are free. In fact one of the free ones Jeffrey covers some basic relations.

Code is also free on Github to download and study.

Usually a member attempts something and if they get stuck, then ask.

Also format code with backticks. https://help.github.com/categories/writing-on-github/

lol I have attempted it of course. here is my laravel code.

protected $table = 'photo_album as t1';

public function user()
{
    return $this->belongsTo(User::class, 'userId');
}

public static function getPhotoAlbum($userId)
{
    $result = self::select('t1.id as album_id', 't3.id as photo_id', 't3.hash')
              ->join('ow_protectedphotos_passwords as t2' , 't2.albumId', '=', 't1.id')
              ->join('ow_photo as t3' , 't3.albumId', '=', 't1.id')
              ->where('t1.userId', $userId)
              ->where('t2.userId', 'password')->get();

    return $result;
}

This don't look right:

->where('t2.userId', 'password')

'password' ?

late night coding ... .

should be

->where('t2.privacy', 'password')->get();

that fixed my issue.. thanks

Can you mark as answered.