[new feature] table now supports query builder object as sql input

Example:

table(db()->from('user')->where('active','1'))
  ->text('name')
  ->text('email')
  ->btn_edit()
  ->btn_delete()
;

Advertisements

table() now can accept closure or object as first argument

table($data, $params)

$data argument now can be one of these variable types:

* string – expects SQL query to execute to retrieve data

* callable / closure – given closure will be called and result expected to be array of $data

* object – we automatically convert it from its properties into array of $data

Examples:

"sql"

table('SELECT * FROM table')
->link('name', url_admin('/@object/event_show/%d/'))

"closure"

table(
  function() use ($db) {
    foreach ((array)$db->utils()->list_events() as $name) {
      $data[$name] = array('name' => $name);
    }; return $data;
  })
->link('name', url_admin('/@object/event_show/%d/'))

"object"

$obj = new stdClass();
$obj->key1 = "val_1";
$obj->key2 = "val_2";
table($obj)
->link('name', url_admin('/@object/event_show/%d/'))