Category Archives for "PHP Framework"

Validation Laravel

By Phạm Đình Hậu | Laravel

Nếu không nhập liệu thì không vaild. Sử dụng nullable

Ví dụ:

‘mobile’ => [

‘max: 11’,

‘alpha_num’,

‘nullable’

],

Laravel Eloquent JOIN AND SELECT MAX ROW

By Phạm Đình Hậu | Laravel

\DB::table(‘table1 AS t1’)

->leftJoin(\DB::raw(‘(SELECT * FROM table2 A WHERE id = (SELECT MAX(id) FROM table2 B WHERE A.id=B.id)) AS t2’), function($join) {

$join->on(‘t1.id’, ‘=’, ‘t2.id’);

})->get();

===

\DB::table(‘table1 AS t1’)

->leftJoin(\DB::raw(‘(SELECT MAX(id), col1, col2 FROM table2 GROUP BY col1, col2) as t2’), function($join) {

$join->on(‘t1.id’, ‘=’, ‘t2.id’);

})->get();