|
Service Name
|
Service Description
|
Edit
|
Delete
|
prefix .'abServiceMst';
$total_query = "SELECT COUNT(*) FROM ".$wp_abServiceMst." WHERE isDeleted=0";
$total = $wpdb->get_var( $total_query );
$items_per_page = 5;
$page = isset( $_GET['paged'] ) ? abs( (int) $_GET['paged'] ) : 1;
$offset = ( $page * $items_per_page ) - $items_per_page;
$treatmentResult= $wpdb->get_results( "SELECT serviceId, serviceName, serviceDescription FROM ".$wp_abServiceMst." WHERE isDeleted=0 ORDER BY serviceId DESC LIMIT ".$offset.", ".$items_per_page."", ARRAY_A );
$totalPage = ceil($total / $items_per_page);
foreach($treatmentResult as $trRes){
?>
|
|
|
Edit
|
Delete
|