<?php require_once('Connections/dental.php'); ?>
<?php
$maxRows_dokter = 10;
$pageNum_dokter = 0;
if (isset($_GET['pageNum_dokter'])) {
  $pageNum_dokter = $_GET['pageNum_dokter'];
}
$startRow_dokter = $pageNum_dokter * $maxRows_dokter;

mysql_select_db($database_dental, $dental);
$query_dokter = "SELECT * FROM dokter";
$query_limit_dokter = sprintf("%s LIMIT %d, %d", $query_dokter, $startRow_dokter, $maxRows_dokter);
$dokter = mysql_query($query_limit_dokter, $dental) or die(mysql_error());
$row_dokter = mysql_fetch_assoc($dokter);

if (isset($_GET['totalRows_dokter'])) {
  $totalRows_dokter = $_GET['totalRows_dokter'];
} else {
  $all_dokter = mysql_query($query_dokter);
  $totalRows_dokter = mysql_num_rows($all_dokter);
}
$totalPages_dokter = ceil($totalRows_dokter/$maxRows_dokter)-1;
?><html lang="en">
<head>
    <!--=============================================== 
    Template Design By WpFreeware Team.
    Author URI : http://www.wpfreeware.com/
    ====================================================-->

    <!-- Basic Page Needs
    ================================================== -->
    <meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Family's Dental Health : Dokter</title>

    <!-- Mobile Specific Metas
    ================================================== -->
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <!-- Favicon -->
    <link rel="shortcut icon" type="image/icon" href="images/favicon.ico"/>

    <!-- CSS
    ================================================== -->       
    <!-- Bootstrap css file-->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <!-- Font awesome css file-->
    <link href="css/font-awesome.min.css" rel="stylesheet">       
    <!-- Default Theme css file -->
    <link id="switcher" href="css/themes/default-theme.css" rel="stylesheet">    
    <!-- Slick slider css file -->
    <link href="css/slick.css" rel="stylesheet"> 

    <!-- Main structure css file -->
    <link href="style.css" rel="stylesheet">
   
    <!-- Google fonts -->
    <link href='http://fonts.googleapis.com/css?family=Raleway' rel='stylesheet' type='text/css'>  
    <link href='http://fonts.googleapis.com/css?family=Habibi' rel='stylesheet' type='text/css'>      
    <link href='http://fonts.googleapis.com/css?family=Cinzel+Decorative:900' rel='stylesheet' type='text/css'>

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>
<body>    
    <!-- BEGAIN PRELOADER -->
    <div id="preloader">
      <div id="status">&nbsp;</div>
    </div>
    <!-- END PRELOADER -->

    <!-- SCROLL TOP BUTTON -->
    <a class="scrollToTop" href="#"><i class="fa fa-heartbeat"></i></a>
    <!-- END SCROLL TOP BUTTON -->

   <!--=========== BEGIN HEADER SECTION ================-->
    <header id="header">
      <!-- BEGIN MENU -->
      <div class="menu_area">
        <nav class="navbar navbar-default navbar-fixed-top" role="navigation">  
          <div class="container">
            <div class="navbar-header">
              <!-- FOR MOBILE VIEW COLLAPSED BUTTON -->
              <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
                <span class="sr-only">Toggle navigation</span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
              </button>

              <!-- LOGO -->              
              <!-- TEXT BASED LOGO -->
              <a class="navbar-brand" href=""><i class="fa fa-heartbeat"></i>Family's <span> Dental Health </span></a>              
<!-- IMG BASED LOGO  -->
              <!--  <a class="navbar-brand" href="index.html"><img src="images/logo.png" alt="logo"></a>   -->     
                     
            </div>
            <div id="navbar" class="navbar-collapse collapse">
             <ul id="top-menu" class="nav navbar-nav navbar-right main-nav">
                <li class="active"><a href="index.php">Home</a></li>
                <li class="dropdown">
                  <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false">Fasilitas  <span class="fa fa-angle-down"></span></a>
                  <ul class="dropdown-menu" role="menu">
                    <li><a href="fasilitas.php">Perawatan </a></li>
                     <li><a href="fashion.php"> Fashion </a></li>
                  </ul>
                </li>
                <li><a href="galeri.php">Gallery</a></li>
                </li>
                <li> 
                  <a href="dokter.php"> Dokter </a>
                </li>               
                <li><a href="tentangkami.php"> Tentang Kami</a></li>
              </ul>           
            </div><!--/.nav-collapse -->
          </div>     
        </nav>  
      </div>
      <!-- END MENU -->    
    </header>
    <!--=========== END HEADER SECTION ================-->       
    <section id="blogArchive">      
      <div class="row">
        <div class="col-lg-12 col-md-12">
          <div class="blog-breadcrumbs-area">
            <div class="container">
              <div class="blog-breadcrumbs-left">
                <h2> Dokter </h2>
              </div>
              <div class="blog-breadcrumbs-right">
              </div>
            </div>
          </div>
        </div>        
      </div>      
    </section>
    <section id="errorPage">
      <div class="container">
        <div class="row">
          <div class="col-lg-12 col-md-12">
            <div class="error-page-area">
              <h5> Dokter </h5>
			  <p align="center"> Inilah beberapa nama dokter yang ada di Family's Dental Health. <br> Silahkan konsultasi dengan dokter yang anda inginkan. Terima kasih.... 
		      </p>
            
              <table border="1" align="center">
                <tr>
                  <td>id_dokter</td>
                  <td>nama_dokter</td>
                  <td>tempat_praktek</td>
                  <td>alamat_praktek</td>
                  <td>jam_operasi</td>
                  <td>no_tlpn</td>
                </tr>
                <?php do { ?>
                  <tr>
                    <td><?php echo $row_dokter['id_dokter']; ?></td>
                    <td><?php echo $row_dokter['nama_dokter']; ?></td>
                    <td><?php echo $row_dokter['tempat_praktek']; ?></td>
                    <td><?php echo $row_dokter['alamat_praktek']; ?></td>
                    <td><?php echo $row_dokter['jam_operasi']; ?></td>
                    <td><?php echo $row_dokter['no_tlpn']; ?></td>
                  </tr>
                  <?php } while ($row_dokter = mysql_fetch_assoc($dokter)); ?>
              </table>
            </div> 
		  </div>
        </div>
      </div>
    </section>
    <!--=========== Start Footer SECTION ================-->
    <footer id="footer">
	<p align="center"> <a href="login_user.php"> <input type="button" value="Konsultasi"> </a> </p> 

      <!-- Start Footer Top -->
      
      <!-- Start Footer Middle -->
      <div class="footer-middle">
        <div class="container">
          <div class="row">
          <div class="col-lg-6 col-md-6 col-sm-6 col-xs-12">
            <div class="footer-copyright">
            <p align="center"> &copy; Family's Dental Health </p> </div>
          </div>
          <div class="col-lg-6 col-md-6 col-sm-6 col-xs-12">
            
          </div>
        </div>
        </div>
      </div>
      <!-- Start Footer Bottom -->
      <div class="footer-bottom">
        <div class="container">
          <div class="row">
            <div class="col-md-12">
             
            </div>
          </div>
        </div>
      </div>
    </footer>
    <!--=========== End Footer SECTION ================-->

    <!-- jQuery Library  -->
    <script src="js/jquery.js"></script>    
    <!-- Bootstrap default js -->
    <script src="js/bootstrap.min.js"></script>
    <!-- slick slider -->
    <script src="js/slick.min.js"></script>    
    <script type="text/javascript" src="js/modernizr.custom.79639.js"></script>      
    <!-- counter -->
    <script src="js/waypoints.min.js"></script>
    <script src="js/jquery.counterup.min.js"></script>
    <!-- Doctors hover effect -->
    <script src="js/snap.svg-min.js"></script>
    <script src="js/hovers.js"></script>
    
    <!-- Custom JS -->
    <script src="js/custom.js"></script>
     
</body>
</html>
<?php
mysql_free_result($dokter);
?>