Function db_findWithPager
Get array of data row objects with pagination result
Package: PHPLucidFrame\Core
Copyright: Copyright (c), PHPLucidFrame.
License: MIT License This source file is subject to the MIT license that is bundled with this source code in the file LICENSE
Located at helpers/db_helper.mysqli.php
Copyright: Copyright (c), PHPLucidFrame.
License: MIT License This source file is subject to the MIT license that is bundled with this source code in the file LICENSE
Located at helpers/db_helper.mysqli.php
string |
$table |
The table name to fetch data from |
array |
$condition = array() |
<p>The condition array for query</p> <p>array( 'fieldName1' => $value1, 'fieldName2 >=' => $value2, 'fieldName3 => NULL )</p> <p>OR</p> <p>array( 'fieldName1' => $value1, 'fieldName2 >=' => $value2, 'fieldName3 => NULL, '$or' => array( 'fieldName4' => array(1, 2, 3) 'fieldName4 <' => 10 ) )</p> |
array |
$orderBy = array() |
<p>The order by clause for query</p> <pre><code>array( 'field' => 'asc|desc' ) </code></pre> |
array |
$pagerOptions = array() |
Array of key/value pairs to Pager options |
array
|
[QueryBuilder, Pager, total] |