PHP hrm_result_limit Examples

Example #1

File: language.php Project: Ejeus/Human-Resource-Management-hrm

<div class="hrm-update-notification"></div>
<?php 
//search form
$search['language'] = array('label' => __('Language', 'hrm'), 'type' => 'text', 'value' => isset($_POST['language']) ? $_POST['language'] : '', 'desc' => 'please insert language');
$search['type'] = array('type' => 'hidden', 'value' => '_search');
$search['action'] = 'hrm_search';
$search['table_option'] = 'hrm_language';
echo Hrm_Settings::getInstance()->get_serarch_form($search, 'Language');
?>
<div id="hrm-language"></div>

<?php 
$pagenum = hrm_pagenum();
$limit = hrm_result_limit();
if (isset($_POST['type']) && $_POST['type'] == '_search') {
    $post = $_POST;
    $results = Hrm_Settings::getInstance()->search_query($post, $limit, $pagenum);
    $search_satus = true;
} else {
    $results = Hrm_Settings::getInstance()->hrm_query('hrm_language', $limit, $pagenum);
    $search_satus = false;
}
$total = $results['total_row'];
unset($results['total_row']);
$add_permission = hrm_user_can_access($tab, $subtab, 'add') ? true : false;
$delete_permission = hrm_user_can_access($tab, $subtab, 'delete') ? true : false;
foreach ($results as $key => $value) {
    if ($delete_permission) {
        $del_checkbox = '<input name="hrm_check[' . $value->id . ']" value="" type="checkbox">';
    } else {
        $del_checkbox = '';

Example #2

File: settings.php Project: Ejeus/Human-Resource-Management-hrm

 function hrm_query($table, $limit = 0, $pagenum = 1)
 {
     global $wpdb;
     $tabledb = $wpdb->prefix . $table;
     $offset = ($pagenum - 1) * $limit;
     if ($limit) {
         $limit = "LIMIT {$offset},{$limit}";
     } else {
         $limit = hrm_result_limit();
         $limit = "LIMIT 0,{$limit}";
     }
     $results = $wpdb->get_results("SELECT SQL_CALC_FOUND_ROWS * FROM {$tabledb} ORDER BY id desc {$limit}");
     $results['total_row'] = $wpdb->get_var("SELECT FOUND_ROWS()");
     return $results;
 }