Cacher is the code snippet organizer for pro developers

<?php

$res=$defaultDB->table('test2')->getAll(
  			array(	'select'=>'*',
					//'where'=>'',
					'limit'=>10
		));
		var_dump($res);
		
		$res=$defaultDB->table('test2')->getVal(
				array(	'select'=>'str1','where'=>array("str1 like '%h%'","str1 like '%2%'",array('str2 = ?','world2'),array("str2 like ?",'%w%'))
		));
		var_dump($res);
		
		$res=$defaultDB->table('test2')->getArray(
				array(	'select'=>'id, str1',
					//'where'=>'',
					'limit'=>10
		),$defaultDB::FETCH_ARRAY_GROUP,1/*group by zero based index column  ?*/);		
		
		var_dump($res);
		

		$res=$defaultDB->table('test2')->getArray(
				array(	'select'=>'str1',
					//'where'=>'',
					'limit'=>10
		),$defaultDB::FETCH_ARRAY);		
		
		var_dump($res);