Function db_findBy
Get data of a table by condition
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 |
<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> |
integer |
$limit = null |
The number of records to return; No limit by default |
array
|
array |