Untitled

<html>
<head>
    <title></title>
    <style type="text/css">
        .pagination1 {
margin:0;
padding:0;
float:left;
}
.pagination1 ul {
width:300px;
float: right;
list-style: none;
margin:0 0 0 ;
padding:0;
}
.pagination1 li span { line-height:45px; font-weight:bold;}
.pagination1 li {
margin:0 0 0 0;
float:left;
font-size:16px;
text-transform:uppercase;
}
.pagination1 li a {
color:#7f8588;
padding:10px 0 0 0; width:33px; height:33px;
text-decoration:none; text-align:center;
-webkit-border-radius: 5px;
-moz-border-radius: 5px;
display:block;
}
.pagination1 li:last-child a:hover { background:none; color:#7f8588;}
.pagination1 li:first-child a:hover { background:none;color:#7f8588;}
.pagination1 li a:hover {
color:#fff;
text-decoration: none;
display: block;
padding:10px 0 0 0; width:33px; height:33px;
}
.pagination1 li.activepage a {
color:#fff;
text-decoration: none;
padding: 10px 0 0 0; }
    </style>
</head>
    <body>

<?php
//include '../include/connect.php';
ini_set('display_errors',1);
ini_set('memory_limit' , '1280M');
$hostname = 'localhost';
$database = 'simrs2016';
$username = 'root';
$password = 'jamet1324';
$connect = mysql_connect($hostname, $username, $password,true,65536) or die(mysql_error());
mysql_select_db($database,$connect)or die(mysql_error());
/*
// $query_rsruang = "SELECT * FROM m_ruang";
// $rsruang = mysql_query($query_rsruang) or die(mysql_error());
// $row_rsruang = mysql_fetch_assoc($rsruang);
// $totalRows_rsruang = mysql_num_rows($rsruang);
// $data=array();
//  do {
//     $data['nomer']=  $row_rsruang['no'];
//     $data['nama']=  $row_rsruang['nama'];
//     $data['kelas']=  $row_rsruang['kelas'];
//     $data['ruang']=  $row_rsruang['ruang'];
//     $data['jumlah_tt'] = $row_rsruang['jumlah_tt'];
//      echo json_encode($data,JSON_PRETTY_PRINT);


//     var_dump($data);
//      } while ($row_rsruang = mysql_fetch_assoc($rsruang));

        $params = $columns = $totalRecords = $data = array();
        $params= $_POST;
        $columns = array(
            0 => "koderuang",
            1 => "nama",

            2 => "kodekelas",
            3 => "jumlahtt",
            4 => "kapasitas",
            5 => "tersedia",
            6 => "tersediapria",
            7 => "tersediawanita",
            8 => "tersediapriawanita"
        );
        $order = "";
        $draw = empty($params['draw'])? 0: $params['draw']; //DRAW TABLE REALTIME
        $start = empty($params['start'])? 0 :$params['start'];
        $length = empty($params['length'])?10 :$params['length'];
        $search = empty($params['search']['value'])?NULL:$params['search']['value'];
        $order = empty($columns[$params['order'][0]['column']])?'kodekelas ASC':$columns[$params['order'][0]['column']]." ".$params['order'][0]['dir'];


        // $sqls = "SELECT
        //      a.no as koderuang, a.nama as namaruang,a.idx_ruang as kodekelas,a.jumlah_tt as kapasitas,
        //      B.no_tt,
        //      (CASE
        //          WHEN (SELECT nott FROM t_admission WHERE noruang = b.idxruang AND nott = b.no_tt AND keluarrs IS NULL) IS NULL
        //              THEN 'kosong'
        //          ELSE
        //              'ada'
        //      END) AS status
        //      FROM m_ruang AS a
        //      INNER JOIN m_detail_tempat_tidur AS b ON a.no = b.idxruang
        //      ";

        // $querys = mysql_query($sqls);
        // $recordsTotal = mysql_num_rows($querys);
        // $recordsFiltered = $recordsTotal;

        $sql = "SELECT
                a.no as koderuang,
                a.nama as namaruang,
                a.idx_ruang as kodekelas,
                a.jumlah_tt as kapasitas,
                B.no_tt,
                (CASE
                    WHEN (SELECT nott FROM t_admission WHERE noruang = b.idxruang AND nott = b.no_tt AND keluarrs IS NULL) IS NULL
                        THEN 'kosong'
                    ELSE
                        'ada'
                END) AS status
                FROM m_ruang AS a
                INNER JOIN m_detail_tempat_tidur AS b ON a.no = b.idxruang";

        // if($search!=NULL || $search!=""){
        //  $sql.= " WHERE kodekelas = '$search'";
        //  $sql.= " OR koderuang = '$search'";
        //  $sql.= " OR namaruang LIKE '%$search%'";
        // }

        $query = mysql_query($sql);
        // $recordsFiltered = mysql_num_rows($query);
        // $sql.=" ORDER BY $order LIMIT $start,$length";
        // $query1 = mysql_query($sql);

        $array = [];
        while ($rows = mysql_fetch_array($query)) {
            $array[] = array(
                'koderuang' => $rows['koderuang'],
                'namaruang' => $rows['namaruang'],
                'kodekelas' => $rows['kodekelas'],
                'kapasitas' => $rows['kapasitas'],
                'no_tt' => $rows['no_tt'],
                'status' => $rows['status']
            );
        }

        $json_data = array(
            "draw"            => intval($draw),
            "recordsTotal"    => intval($recordsTotal),
            "recordsFiltered" => intval($recordsFiltered),
            "data"            => $datax
            );

        echo  json_encode($json_data); */

$sql = mysql_query("SELECT
                a.no as koderuang,
                a.nama as namaruang,
                a.idx_ruang as kodekelas,
                a.jumlah_tt as kapasitas,
                B.no_tt,
                (CASE
                    WHEN (SELECT nott FROM t_admission WHERE noruang = b.idxruang AND nott = b.no_tt AND keluarrs IS NULL) IS NULL
                        THEN 'kosong'
                    ELSE
                        'ada'
                END) AS status
                FROM m_ruang AS a
                INNER JOIN m_detail_tempat_tidur AS b ON a.no = b.idxruang");
$total = mysql_num_rows($sql);

$adjacents = 3;
$targetpage = "myPage.php"; //your file name
$limit = 12; //how many items to show per page
$page = $_GET['page'];

if($page){
$start = ($page - 1) * $limit; //first item to display on this page
}else{
$start = 0;
}

/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is current page - 1
$next = $page + 1; //next page is current page + 1
$lastpage = ceil($total/$limit); //lastpage.
$lpm1 = $lastpage - 1; //last page minus 1

$sql2 = "SELECT
                a.no as koderuang,
                a.nama as namaruang,
                a.idx_ruang as kodekelas,
                a.jumlah_tt as kapasitas,
                B.no_tt,
                (CASE
                    WHEN (SELECT nott FROM t_admission WHERE noruang = b.idxruang AND nott = b.no_tt AND keluarrs IS NULL) IS NULL
                        THEN 'kosong'
                    ELSE
                        'ada'
                END) AS status
                FROM m_ruang AS a
                INNER JOIN m_detail_tempat_tidur AS b ON a.no = b.idxruang where 1=1";
$sql2 .= " order by kodekelas desc limit $start ,$limit ";
$sql_query = mysql_query($sql2);
$curnm = mysql_num_rows($sql_query);

/* CREATE THE PAGINATION */

$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class='pagination1'> <ul>";
if ($page > $counter+1) {
$pagination.= "<li><a href=\"$targetpage?page=$prev\">prev</a></li>";
}

if ($lastpage < 7 + ($adjacents * 2))
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a href='#' class='active'>$counter</a></li>";
else
$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<li><a href='#' class='active'>$counter</a></li>";
else
$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
}
$pagination.= "<li>...</li>";
$pagination.= "<li><a href=\"$targetpage?page=$lpm1\">$lpm1</a></li>";
$pagination.= "<li><a href=\"$targetpage?page=$lastpage\">$lastpage</a></li>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<li><a href=\"$targetpage?page=1\">1</a></li>";
$pagination.= "<li><a href=\"$targetpage?page=2\">2</a></li>";
$pagination.= "<li>...</li>";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a href='#' class='active'>$counter</a></li>";
else
$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
}
$pagination.= "<li>...</li>";
$pagination.= "<li><a href=\"$targetpage?page=$lpm1\">$lpm1</a></li>";
$pagination.= "<li><a href=\"$targetpage?page=$lastpage\">$lastpage</a></li>";
}
//close to end; only hide early pages
else
{
$pagination.= "<li><a href=\"$targetpage?page=1\">1</a></li>";
$pagination.= "<li><a href=\"$targetpage?page=2\">2</a></li>";
$pagination.= "<li>...</li>";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage;
$counter++)
{
if ($counter == $page)
$pagination.= "<li><a href='#' class='active'>$counter</a></li>";
else
$pagination.= "<li><a href=\"$targetpage?page=$counter\">$counter</a></li>";
}
}
}

//next button
if ($page < $counter - 1)
$pagination.= "<li><a href=\"$targetpage?page=$next\">next</a></li>";
else
$pagination.= "";
$pagination.= "</ul></div>\n";
}
?>
    </body>
</html