Need help about Query Bilder

Something like below:

PHP Code:

// Your Model
private $builder;

public function __construct()
{
    parent::__construct();

    $db = db_connect();
    $this->builder = $db->table($table);
}

// get_rows
public function getRows($table, $arr)
{
    $this->builder
         ->where($arr)
         ->get()
         ->getResultArray();

    return $this;
}

// order_row
public function orderRow($by)
{
    $this->builder
         ->orderBy($by, 'desc')
         ->get()
         ->getResultArray();

    return $this;
}

// call using:
$data = $this->my_model->orderRow('column')->getRows('my_table', array()) 


Not tested but should work for you.

The table name is in the builder when connecting to the db.

PHP Code:

$this->builder = $db->table($table); 


What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )