【FuelPHP】Model_CrudのTips

P 2015年8月12日 , by shinn

• K
FuelPHP, PHP

Model_Crudの使い方を忘れないようにメモ。 基本的な使い方

// select * from users where id = $id; Model_Users::find_by_pk($id); // select * from users where username = 'test' limit 1; Model_Users::find_one_by('username ', 'test', '='); // select * from users where email like 'xxx%' limit 20 offset 0; Model_Users::find_by('email', 'xxx%', 'like', 20, 0); // select COUNT(DISTINCT id) AS count_result FROM users WHERE delete_flg = 0; Model_Users::count('id', true, [['delete_flg', '=', 0]]);

1 2 3 4 5 6 7 8 9 10 11

// select * from users where id = $id; Model_Users::find_by_pk($id);   // select * from users where username = 'test' limit 1; Model_Users::find_one_by('username ', 'test', '=');   // select * from users where email like 'xxx%' limit 20 offset 0; Model_Users::find_by('email', 'xxx%', 'like', 20, 0);   // select COUNT(DISTINCT id) AS count_result FROM users WHERE delete_flg = 0; Model_Users::count('id', true, [['delete_flg', '=', 0]]);

ちょっとだけ応用

// select * from users where username = 'test' and email = 'test@xxx.jp' limit 1; Model_Users::find_one_by([['username', '=', 'test'],['email', '=', 'test@xxx.jp']]); // select * from mst_user where created_at < extract(epoch from timestamp '2015-08-01') order by id asc; Model_Users::find([ 'where' => [ ['created_at ', '<', DB::expr('extract(epoch from timestamp \'2015-08-01\'')], ], 'order_by' => [ 'id' => 'asc', ] ]);

1 2 3 4 5 6 7 8 9 10 11 12

// select * from users where username = 'test' and email = 'test@xxx.jp' limit 1; Model_Users::find_one_by([['username', '=', 'test'],['email', '=', 'test@xxx.jp']]);   // select * from mst_user where created_at < extract(epoch from timestamp '2015-08-01') order by id asc; Model_Users::find([     'where' => [         ['created_at ', '<', DB::expr('extract(epoch from timestamp \'2015-08-01\'')],     ],     'order_by' => [         'id' => 'asc',     ] ]);

---