Untitled

<!--A Design by W3layouts
Author: W3layout
Author URL: http://w3layouts.com
License: Creative Commons Attribution 3.0 Unported
License URL: http://creativecommons.org/licenses/by/3.0/
-->
<?php include 'koneksi.php'; ?>
<!DOCTYPE html>
<head>
<title>ADMIN</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="keywords" content="Visitors Responsive web template, Bootstrap Web Templates, Flat Web Templates, Android Compatible web template,
Smartphone Compatible web template, free webdesigns for Nokia, Samsung, LG, SonyEricsson, Motorola web design" />
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- bootstrap-css -->
<link rel="stylesheet" href="css/bootstrap.min.css" >
<!-- //bootstrap-css -->
<!-- Custom CSS -->
<link href="css/style.css" rel='stylesheet' type='text/css' />
<link href="css/style-responsive.css" rel="stylesheet"/>
<!-- font CSS -->
<link href='//fonts.googleapis.com/css?family=Roboto:400,100,100italic,300,300italic,400italic,500,500italic,700,700italic,900,900italic' rel='stylesheet' type='text/css'>
<!-- font-awesome icons -->
<link rel="stylesheet" href="css/font.css" type="text/css"/>
<link href="css/font-awesome.css" rel="stylesheet">
<!-- //font-awesome icons -->
<script src="js/jquery2.0.3.min.js"></script>
</head>
<body>
<section id="container">
<!--header start-->
<header class="header fixed-top clearfix">
<!--logo start-->
<div class="brand">

    <a href="index.html" class="logo">
        ADMIN
    </a>
    <div class="sidebar-toggle-box">
        <div class="fa fa-bars"></div>
    </div>
</div>
<!--logo end-->
<div class="top-nav clearfix">
    <!--search & user info start-->
    <ul class="nav pull-right top-menu">
        <li>
            <input type="text" class="form-control search" placeholder=" Search">
        </li>
        <!-- user login dropdown start-->
        <li class="dropdown">
            <a data-toggle="dropdown" class="dropdown-toggle" href="#">
                <img alt="" src="images/2.png">
                <span class="username">John Doe</span>
                <b class="caret"></b>
            </a>
            <ul class="dropdown-menu extended logout">
                <li><a href="creative.handlettering/loginadmin.php"><i class="fa fa-key"></i> Log Out</a></li>
            </ul>
        </li>
        <!-- user login dropdown end -->

    </ul>
    <!--search & user info end-->
</div>
</header>
<!--header end-->
<!--sidebar start-->
<aside>
    <div id="sidebar" class="nav-collapse">
        <!-- sidebar menu start-->
        <div class="leftside-navigation">
            <ul class="sidebar-menu" id="nav-accordion">
                <li>
                    <a class="active" href="index.html">
                        <i class="fa fa-dashboard"></i>
                        <span>Dashboard</span>
                    </a>
                </li>

                <li class="sub-menu">
                    <a href="javascript:;">
                        <i class="fa fa-book"></i>
                        <span>Master</span>
                    </a>
                    <ul class="sub">
                        <li><a href="tabel_admin.php">Data Admin</a></li>
                        <li><a href="tabel_barang.php">Data Barang</a></li>
                    </ul>
                </li>
                <li class="sub-menu">
                    <a href="javascript:;">
                        <i class="fa fa-th"></i>
                        <span>Data</span>
                    </a>
                    <ul class="sub">
                        <li><a href="tabel_handlettering.php">Data Handlettering</a></li>
                        <li><a href="tabel_framebuket.php">Data Frame and Bouquet</a></li>
                        <li><a href="tabel_frameflowers.php">Data Frame with Flower</a></li>
                        <li><a href="tabel_snack.php">Data Bouquet Snack</a></li>
                        <li><a href="tabel_flanel.php">Data Bouquet Flanel</a></li>
                        <li><a href="tabel_photoinframe.php">Data Photos in Frame</a></li>
                    </ul>
                </li>
            </ul>            </div>
        <!-- sidebar menu end-->
    </div>
</aside>
<!--sidebar end-->
<!--main content start-->
<section id="main-content">
	<section class="wrapper">
		<div class="table-agile-info">
 <div class="panel panel-default">
    <div class="panel-heading">
     DATA PESAN HANDLETTERING
    </div>
    <div>
        <a href="formhandlettering.php" class="btn btn-success"><i class="fa fa-plus"></i> Tambah</a>
      <table class="table" ui-jq="footable" ui-options='{
        "paging": {
          "enabled": true
        },
        "filtering": {
          "enabled": true
        },
        "sorting": {
          "enabled": true
        }}'>
        <thead>
          <tr>
            <th>NO</th>
            <th data-breakpoints="xs">ID PESAN</th>
            <th >NAMA</th>
            <th>ALAMAT</th>
            <th>NO HP</th>
            <th>DESKRIPSI</th>
            <th>WARNA FRAME</th>
            <th>MODEL</th>
            <th>HARGA</th>
            <th>JUMLAH PESAN</th>
            <th>TOTAL</th>
            <th data-breakpoints="xs sm md">TANGGAL PESAN</th>
            <th data-breakpoints="xs sm md">TANGGAL KEMBALI</th>
            <th>ORDER BY</th>
            <th>ACTION</th>
            <?php $query = mysqli_query($koneksi, "select * from tabel_handlettering"); ?>
            <?php $i = 1; ?>
            <?php while($row = mysqli_fetch_array($query)) : ?>
                <tr>
                    <td><?= $i ?></td>
                    <td><?= $row['id_handlettering']; ?></td>
                    <td><?= $row['nama']; ?></td>
                    <td><?= $row['alamat']; ?></td>
                    <td><?= $row['nohp']; ?></td>
                    <td><?= $row['deskripsi']; ?></td>
                    <td><?= $row['warnaframe']; ?></td>
                    <td><?= $row['model']; ?></td>
                    <td><?= $row['harga']; ?></td>
                    <td><?= $row['jumlahpesan']; ?></td>
                    <td><?= $row['totalharga']; ?></td>
                    <td><?= $row['orderby']; ?></td>

                    <td>
                        <a href="update_formhandlettering.php?id=<?= $row['id_handlettering']; ?>">Ubah</a> &nbsp; <a href="delete_handlettering.php?id=<?= $row['id_handlettering']; ?>" onclick="return confirm('Yakin menghapus data?');">Hapus</a>
                    </td>
                </tr>
            <?php $i++; ?>
            <?php endwhile; ?>
          </tr>
        </thead>
      </table>
    </div>
  </div>
</div>
</section>
 <!-- footer -->
		  <div class="footer">
			<div class="wthree-copyright">
			  <p>© 2019 Design by <a href="£">Kaveeta Sri Puja Dianiratih</a></p>
			</div>
		  </div>
  <!-- / footer -->
</section>

<!--main content end-->
</section>
<script src="js/bootstrap.js"></script>
<script src="js/jquery.dcjqaccordion.2.7.js"></script>
<script src="js/scripts.js"></script>
<script src="js/jquery.slimscroll.js"></script>
<script src="js/jquery.nicescroll.js"></script>
<!--[if lte IE 8]><script language="javascript" type="text/javascript" src="js/flot-chart/excanvas.min.js"></script><![endif]-->
<script src="js/jquery.scrollTo.js"></script>
</body>
</html>