[RESOLVED] Dynamic search/list thingy

[jara06]

Hi folks. 🙂

Lets say I got 3 tables in an db, 'Gallery', 'Pictures', 'Documents'. Each table has an idcolumn.

Now I wants to pull out some data, either complete data or searched result.

I would imagine something like this:

class request {
	public function getList($tbl, $cols = array('id'), $access_type = ACL::READ, $options = null) {
		// do option parsing, fetch data, return array
	}
}

( $options = single array which holds 'order', 'ordering', 'min', 'max', 'limit', 'offset', 'search_text' & 'search_col' )

Would be a complete stupid approach ?

[Weedpacket]

Depends on how you write it.