$per_page = 20;
$where = get_where_string($class_name);
$total_count = $class_name::count_all_where($where);
$pagination = new Pagination($page, $per_page, $total_count);
require_once LIB_PATH . DS . 'download' . DS . 'download_csv.php';
$sql = "SELECT * FROM {$table_name} ";
$sql .= " " . get_where_string($class_name);
if (isset($order_name)) {
$sql .= " ORDER BY {$order_name} {$order_type} ";
}
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
//echo "<p>$sql</p>";
//unset($_GET);
$result_class = $class_name::find_by_sql($sql);
$query_string = remove_get(array('view', 'page'));
$view_full_table = !empty($_GET) ? (int) $_GET["view"] : 0;
if ($view_full_table == 1) {
$page_link_view = $class_name::$page_manage . $query_string . "page=" . u($page) . "&view=" . u(0);
$page_link_text = $class_name::$page_name . " short view";
//$add_view="&view=".u(1);
$offset = "col-md-offset-2";
} else {
$page_link_view = $class_name::$page_manage . $query_string . "page=" . u($page) . "&view=" . u(1);
$page_link_text = $class_name::$page_name . " full view";
$offset = '';
}
?>
<?php
//var_dump($users)
public static function display_table_head_new($long_short = 0, $edit = true)
{
// $query_string= urldecode($_SERVER['QUERY_STRING']);
$query_string = remove_get(array('order_name', 'order_type', 'page'));
if ($long_short == 1) {
$table_field = static::$db_fields_table_display_full;
} else {
$table_field = static::$db_fields_table_display_short;
}
$output = "";
$where = get_where_string(get_called_class());
$found_count = static::count_all_where($where);
$total_count = static::count_all();
if ($found_count !== $total_count) {
// $output.="<b>Found records: <span style='color:blue;'> ".h($found_count)." of ".h($total_count)."</span></b> | ";
}
foreach ($_GET as $key => $val) {
$key_clean = str_replace("_", " ", $key);
$key_clean = ucfirst($key_clean);
if (!empty($_GET[$key]) && !in_array($key, array('page', 'view'))) {
// $output.="<b>".h($key_clean)." <span style='color:blue;'> ".h(urldecode($_GET[$key]))."</span></b> | ";
}
}
// $output.= "<tr>";
foreach ($table_field as $fieldname) {
if (property_exists(new static(), $fieldname)) {
$fieldname = str_replace("_", " ", $fieldname);
$fieldname = ucfirst($fieldname);
$output .= "<th class='text-center'>" . $fieldname . "</th>";
}
}
if ($edit) {
// $output.= "<th colspan=\"1\" class=\"text-center\" style='vertical-align:middle;'>Actions</th>";
$output .= "<th>Actions</th>";
$output .= "<th></th>";
}
// $output.= "</tr>";
return $output;
}
$per_page = 20;
$where = get_where_string($class_name);
$total_count = $class_name::count_all_where($where);
$pagination = new Pagination($page, $per_page, $total_count);
require_once LIB_PATH . DS . 'download' . DS . 'download_csv.php';
$sql = "SELECT * FROM {$table_name} ";
$sql .= " " . get_where_string($class_name);
if (isset($order_name)) {
$sql .= " ORDER BY {$order_name} {$order_type} ";
}
$sql .= "LIMIT {$per_page} ";
$sql .= "OFFSET {$pagination->offset()}";
//echo "<p>$sql</p>";
//unset($_GET);
$result_class = $class_name::find_by_sql($sql);
$query_string = remove_get(array('view', 'page', $class_name));
$view_full_table = !empty($_GET) ? (int) $_GET["view"] : 0;
if ($view_full_table == 1) {
$page_link_view = $class_name::$page_manage . $query_string . "page=" . u($page) . "&view=" . u(0);
$page_link_text = $class_name::$page_name . " short view";
//$add_view="&view=".u(1);
$offset = "col-md-offset-2";
} else {
$page_link_view = $class_name::$page_manage . $query_string . "page=" . u($page) . "&view=" . u(1);
$page_link_text = $class_name::$page_name . " full view";
$offset = '';
}
?>
<?php
//var_dump($users)
echo $home . "<br>";
$array = array();
foreach ($_GET as $key => $val) {
if ($key == 'page') {
} else {
$url_decode = urldecode($val);
$array[$key] = $url_decode;
}
}
echo "<pre>";
print_r($array);
echo "</pre>";
$new = http_build_query($array);
echo "http_build_query: " . $new . "<br>";
echo "<hr>";
$a = remove_get(array('page'));
echo $a;
?>
<h4 class="text-center"><mark><a href="<?php
echo $page_link;
?>
">my modele</a> </mark></h4>
<div class="col-md-7 col-md-offset-2 col-lg-7 col-lg-offset-2">
<div class ="background_light_blue">
