如何使Laravel查询生成器如Codeigniter活动记录 [英] how to make laravel query builder like codeigniter active record

问题描述

我对Laravel 4查询生成器有疑问，我想做一个可重用的方法

I have a problem with Laravel 4 query builder, i want make a re-usable method

public function getData($where=array())
{
    // $where = array('city' => 'jakarta', 'age' => '25');
    return User::where($where)->get();

    // this will produce an error, because i think laravel didn't support it
}

在CodeIgniter中，很容易将数组传递给活动记录:

In CodeIgniter it easy to passing array to active record :

public function getData($where=array())
{
    $rs = $this->db->where($where)->from('user')->get();

    return $rs->result();
}

// it will produce :
// SELECT * FROM user WHERE city = 'jakarta' AND age = '25'

有人知道如何在Laravel 4查询构建器上使用它吗?我正在谷歌搜索，但找不到任何答案.谢谢你.

Any idea how to have it on Laravel 4 query builder? I have googling but not find any answer. Thanks before.

推荐答案

您可以尝试使用此方法(假定此功能在您的User模型中)

You may try this (Assumed, this function is in your User model)

class User extends Eloquent {

    public static function getData($where = null)
    {
        $query =  DB::table('User');
        if(!is_null($where )) {
            foreach($where as $k => $v){
                $query->where($k, $v);
            }
        }
        return $query->get();
    }
}

请注意，=是可选的.像这样

Rember that, = is optional. Call it like

$data = User::getData(array('first_name' => 'Jhon'));

这篇关于如何使Laravel查询生成器如Codeigniter活动记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！