View difference between Paste ID: 7uc5AHQZ and t2jGy5G4

 <script language="javascript">
 function validasi(form){
 if (form.nama.value == ""){
 alert("Anda belum mengisikan Nama.");
 form.nama.focus();
 return (false);
 }
 if (form.alamat.value == ""){
 alert("Anda belum mengisikan Alamat.");
 form.alamat.focus();
 return (false);
 }
 if (form.telpon.value == ""){
 alert("Anda belum mengisikan Telpon.");
 form.telpon.focus();
 return (false);
 }
 if (form.email.value == ""){
 alert("Anda belum mengisikan Email.");
 form.email.focus();
 return (false);
 }
 if (form.kota.value == 0){
 alert("Anda belum mengisikan Kota.");
 form.kota.focus();
 return (false);
 }
 if (form.kode.value == ""){
 alert("Anda belum mengisikan Kode.");
 form.kode.focus();
 return (false);
 }
 return (true);
 }
 function validasi2(form2){
 if (form2.email.value == ""){
 alert("Anda belum mengisikan Email.");
 form2.email.focus();
 return (false);
 }
 if (form2.password.value == ""){
 alert("Anda belum mengisikan Password.");
 form2.password.focus();
 return (false);
 }
 return (true);
 }
 function harusangka(jumlah){
 var karakter = (jumlah.which) ? jumlah.which : event.keyCode
 if (karakter > 31 && (karakter < 48 || karakter > 57))
 return false;
 return true;
 }
 </script>
 <?php
 // Halaman utama (Home)
 if ($_GET[module]=='home'){
 ?>
 <div class="w3l_banner_nav_right">
   <section class="slider">
     <div class="flexslider">
       <ul class="slides">
         <?php
         $sql=mysqli_query($con,"SELECT * FROM produk ORDER BY id_produk DESC LIMIT 5");
         while ($r=mysqli_fetch_array($sql)){
         $deskripsi=substr($r[deskripsi],0,10);
         ?>
 
         <li> <img src='foto_produk/<?=$r['gambar']?>' title='Products Mabes Frozen' width='220' height='400' />
           <h3>Make your <span>food</span> <a href='home.php?module=detailproduk&id=<?=$r['id_produk']?>'><?= $r['nama_produk']?></a></h3> <span><?= $divharga ?></span>
 
           <div class='more'>
             <a href='home.php?module=detailproduk&id=<?=$r['id_produk']?>' class='button--saqui button--round-l button--text-thick' data-text='Selengkapnya'>Selengkapnya</a>
           </div>
 
         </li>
         <?php
         }
         ?>
       </ul>
     </div>
   </section>
   <!-- flexSlider -->
   <link rel="stylesheet" href="template/css/flexslider.css" type="text/css" home="screen" property="" />
   <script defer src="template/js/jquery.flexslider.js"></script>
   <script type="text/javascript">
   $(window).load(function(){
   $('.flexslider').flexslider({
   animation: "slide",
   start: function(slider){
   $('body').removeClass('loading');
   }
   });
   });
   </script>
   <!-- //flexSlider -->
 </div>
 <!-- banner -->
 <div class="clearfix"></div>
 <div class="banner_bottom">
   <div class="wthree_banner_bottom_left_grid_sub">
   </div>
   <div class="wthree_banner_bottom_left_grid_sub1">
     <div class="col-md-4 wthree_banner_bottom_left">
       <div class="wthree_banner_bottom_left_grid">
         <img src="template/images/4.jpg" alt=" " class="img-responsive" />
         <div class="wthree_banner_bottom_left_grid_pos">
           <h4>Discount Offer <span>25%</span></h4>
         </div>
       </div>
     </div>
     <div class="col-md-4 wthree_banner_bottom_left">
       <div class="wthree_banner_bottom_left_grid">
         <img src="template/images/5.jpg" alt=" " class="img-responsive" />
         <div class="wthree_banner_btm_pos">
           <h3>introducing <span>best store</span> for <i>groceries</i></h3>
         </div>
       </div>
     </div>
     <div class="col-md-4 wthree_banner_bottom_left">
       <div class="wthree_banner_bottom_left_grid">
         <img src="template/images/6.jpg" alt=" " class="img-responsive" />
         <div class="wthree_banner_btm_pos1">
           <h3>Save <span>Upto</span> $10</h3>
         </div>
       </div>
     </div>
     <div class="clearfix"> </div>
   </div>
   <div class="clearfix"> </div>
 </div>
 <!-- top-brands -->
 <div class='top-brands'>
   <div class='container'>
     <h3>Hot Offers</h3>
     <div> <br> </br></div>
     <?php
     $sql=mysqli_query($con,"SELECT * FROM produk ORDER BY id_produk DESC LIMIT 8");
     while ($r=mysqli_fetch_array($sql)){
 
     include "diskon_stok.php";
 
     ?>
     <div class="col-md-3 top_brand_left">
       <div class="hover14 column">
         <div class="agile_top_brand_left_grid" style="margin: 5px;">
           <div class="tag">
             <img src="images/tag.png" alt=" " class="img-responsive" />
           </div>
           <div class="agile_top_brand_left_grid1">
             <figure>
               <div class="snipcart-item block" >
                 <div class="snipcart-thumb">
                   <a href="home.php?module=detailproduk&id=<?= $r['id_produk']?>"><img title=" " alt=" " src="foto_produk/small_<?=$r['gambar']?>" /></a>
                   <p><?=$r['nama_produk']?> <?= $divharga ?> </p>
 
                 </div>
                 <div class="snipcart-details top_brand_home_details">
                   <form action="aksi.php?module=keranjang&act=tambah&id=<?= $r['id_produk']?>" method="post">
 
 
                     <input type="submit" name="submit" value="Add to cart" class="button" />
 
                   </form>
 
                 </div>
               </div>
             </figure>
           </div>
         </div>
       </div>
     </div>
     <?php
     }
     ?>
     <div class="clearfix"> </div>
   </div>
 </div>
 </div>
 <!-- //top-brands -->
 <?php
 }
 //MODULE INI DIGUNAKAN UNTUK MEMBUAT MENU BARU////////////////////////////////////
 elseif ($_GET[module]=="tes") {
 //include digunakan untuk memanggil file
 include "tes.php";
 }
 //Module Warning
 elseif ($_GET[module]=='warning') {
 echo "<div id='info'>! Untuk Melakukan Hal ini Anda Harus Login Terlebih Dahulu <a href='home.php?module=login'>disini</a></div>";
 }
 // Modul detail produk
 elseif ($_GET[module]=='detailproduk'){
 // Tampilkan detail produk berdasarkan produk yang dipilih
 $detail=mysqli_query($con,"SELECT * FROM produk,kategori
 WHERE kategori.id_kategori=produk.id_kategori
 AND id_produk='$_GET[id]'");
 $r = mysqli_fetch_array($detail);
 include "diskon_stok.php";
 ?>
 <div class='center_title_bar' ><h3><?= $r['nama_produk'] ?></h3></div>
 <div class="col-md-4" style="margin: 10px;">
 <img id="example" src="foto_produk/<?=$r['gambar']?>" alt=" " class="img-responsive" />
 </div>
 <div class="col-md-8 agileinfo_single_right">
 <div class="rating1">
   <span class="starRating">
     <input id="rating5" type="radio" name="rating" value="5">
     <label for="rating5">5</label>
     <input id="rating4" type="radio" name="rating" value="4">
     <label for="rating4">4</label>
     <input id="rating3" type="radio" name="rating" value="3" checked>
     <label for="rating3">3</label>
     <input id="rating2" type="radio" name="rating" value="2">
     <label for="rating2">2</label>
     <input id="rating1" type="radio" name="rating" value="1">
     <label for="rating1">1</label>
   </span>
 </div>
 <div class="w3agile_description">
   <h4>Deskripsi Produk :</h4>
   <p><?=$r['deskripsi']?></p>
 </div>
 <div class="snipcart-item block">
   <div class="snipcart-thumb agileinfo_single_right_snipcart">
     <div class='prod_price'><?= $divharga ?></div>
     <div class=''>Stok : <?= $r['stok'] ?></div>
   </div>
   <div class="snipcart-details agileinfo_single_right_details">
     <form action="aksi.php?module=keranjang&act=tambah&id=<?= $r['id_produk']?>" method="post">
       <input type="submit" name="submit" value="Add to cart" class="button" />
 
     </form>
   </div>
 </div>
 </div>
 <div class="clearfix"> </div>
 </div>
 <!-- echo "
 <div class='product-detail'>
 <div class='img'><a href='foto_produk/$r[gambar]'><img src='foto_produk/$r[gambar]' border='0' width='230' height='210'/></a><br/>
 <div class='prod_price'>$divharga</div>
 <div style='text-align:center;margin-right:18px;'>(stok: $r[stok])</div>
 $tombol
 </div>
 <div class='product_title_big'>$r[nama_produk]</div>
 <div class='deskripsi'>$r[deskripsi]</div>
 </div>"; -->
 <?php
 }
 // Modul produk per kategori
 elseif ($_GET[module]=='detailkategori'){
 // Tampilkan nama kategori
 $sq = mysqli_query($con,"SELECT nama_kategori from kategori where id_kategori='$_GET[id]'");
 $n = mysqli_fetch_array($sq);
 ?>
 <div class='center_title_bar'><h3>Kategori: <?= $n['nama_kategori']?><span class="blink_me"></span></h3></div>
 <?php
 $sql = mysqli_query($con,"SELECT * FROM produk WHERE id_kategori='$_GET[id]'
 ORDER BY id_produk DESC LIMIT 9");
 $jumlah = mysqli_num_rows($sql);
 // Apabila ditemukan produk dalam kategori
 if ($jumlah > 0){
 while ($r=mysqli_fetch_array($sql)){
 include "diskon_stok.php";
 ?>
 <div class="col-md-4 w3l_banner_nav_right_banner3_btml" style="margin: 5px;">
 <div class="view view-tenth">
 <img src='foto_produk/<?=$r['gambar']?>' style="height: 210px; width: 380px;" alt=" " class="img-responsive" />
 <div class="mask">
 <h4><?= $r['nama_produk']?> </h4>
 <h3><a href='home.php?module=detailproduk&id=<?= $r['id_produk']?>'><?= $r['deskripsi']?></a></h3>
 </div>
 </div>
 <p align="center"><?= $r['nama_produk']?> <span><?= $divharga?></span>
 <br><button class="btn btn-primary"><a href='home.php?module=detailproduk&id=<?= $r['id_produk']?>' class='prod_details'>Selengkapnya</a></button></p>
 <div class="snipcart-details">
 <form action="aksi.php?module=keranjang&act=tambah&id=<?= $r['id_produk']?>" method="post">
 <input type="submit" name="submit" value="Add to cart" class="button" />
 </form>
 </div>
 
 </div>
 <?php
 }
 }
 else{
 echo "<p align=center>Belum ada produk pada kategori ini.</p>";
 }
 }
 // Modul profil
 elseif ($_GET[module]=='profilkami'){
 // Data profil mengacu pada id_modul=43
 ?>
 <body>
 <!-- products-breadcrumb -->
 <!-- //products-breadcrumb -->
 <div class="banner">
 <div class="w3l_banner_nav_right">
 <!-- about -->
 <div class="privacy about">
 <h3>Profil Kami</h3>
 <?php
 $profil = mysqli_query($con,"SELECT * FROM modul WHERE id_modul='1'");
 $r      = mysqli_fetch_array($profil);
 ?>
 <p class="animi"><?= $r['static_content']?></p>
 <div class="agile_about_grids">
   <!-- <div class="col-md-6 agile_about_grid_right">
     <img src="../foto_banner/<?= $r['gambar']?>" alt=" " class="img-responsive" />
   </div>
   -->
   <div class="clearfix"> </div>
 </div>
 <!-- //about -->
 </div>
 <div class="clearfix"></div>
 </div>
 <!-- //banner -->
 <!-- testimonials -->
 <div class="testimonials">
 <div class="container">
 <h3>Testimonials</h3>
 <div class="w3_testimonials_grids">
   <div class="wmuSlider example1 animated wow slideInUp" data-wow-delay=".5s">
     <div class="wmuSliderWrapper">
       <article style="position: absolute; width: 100%; opacity: 0;">
         <div class="banner-wrap">
           <div class="col-md-6 w3_testimonials_grid">
             <p><i class="fa fa-quote-right" aria-hidden="true"></i>Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis
               voluptatibus maiores alias consequatur aut perferendis doloribus asperiores
             repellat.</p>
             <h4>Andrew Smith <span>Customer</span></h4>
           </div>
           <div class="col-md-6 w3_testimonials_grid">
             <p><i class="fa fa-quote-right" aria-hidden="true"></i>Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis
               voluptatibus maiores alias consequatur aut perferendis doloribus asperiores
             repellat.</p>
             <h4>Thomson Richard <span>Customer</span></h4>
           </div>
           <div class="clearfix"> </div>
         </div>
       </article>
       <article style="position: absolute; width: 100%; opacity: 0;">
         <div class="banner-wrap">
           <div class="col-md-6 w3_testimonials_grid">
             <p><i class="fa fa-quote-right" aria-hidden="true"></i>Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis
               voluptatibus maiores alias consequatur aut perferendis doloribus asperiores
             repellat.</p>
             <h4>Crisp Kale <span>Customer</span></h4>
           </div>
           <div class="col-md-6 w3_testimonials_grid">
             <p><i class="fa fa-quote-right" aria-hidden="true"></i>Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis
               voluptatibus maiores alias consequatur aut perferendis doloribus asperiores
             repellat.</p>
             <h4>John Paul <span>Customer</span></h4>
           </div>
           <div class="clearfix"> </div>
         </div>
       </article>
       <article style="position: absolute; width: 100%; opacity: 0;">
         <div class="banner-wrap">
           <div class="col-md-6 w3_testimonials_grid">
             <p><i class="fa fa-quote-right" aria-hidden="true"></i>Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis
               voluptatibus maiores alias consequatur aut perferendis doloribus asperiores
             repellat.</p>
             <h4>Rosy Carl <span>Customer</span></h4>
           </div>
           <div class="col-md-6 w3_testimonials_grid">
             <p><i class="fa fa-quote-right" aria-hidden="true"></i>Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis
               voluptatibus maiores alias consequatur aut perferendis doloribus asperiores
             repellat.</p>
             <h4>Rockson Doe <span>Customer</span></h4>
           </div>
           <div class="clearfix"> </div>
         </div>
       </article>
     </div>
   </div>
   <script src="template/js/jquery.wmuSlider.js"></script>
   <script>
   $('.example1').wmuSlider();
   </script>
 </div>
 </div>
 </div>
 <!-- //testimonials -->
 <!-- newsletter -->
 <div class="newsletter">
 <div class="container">
 <div class="w3agile_newsletter_left">
   <h3>sign up for our newsletter</h3>
 </div>
 <div class="w3agile_newsletter_right">
   <form action="#" method="post">
     <input type="email" name="Email" value="Email" onfocus="this.value = '';" onblur="if (this.value == '') {this.value = 'Email';}" required="">
     <input type="submit" value="subscribe now">
   </form>
 </div>
 <div class="clearfix"> </div>
 </div>
 </div>
 <!-- //newsletter -->
 <!-- footer -->
 </body>
 <?php
 }
 // Modul cara pembelian
 elseif ($_GET[module]=='payment'){
 ?>
 <div class="w3l_banner_nav_right">
 <!-- about -->
 <div class="privacy about" >
 <h3>Cara Pembelian</h3>
 <?php
 $profil = mysqli_query($con,"SELECT * FROM modul WHERE id_modul='2'");
 $r      = mysqli_fetch_array($profil);
 ?>
 <p class="animi"><?= $r['static_content']?></p>
 <div class="agile_about_grids">
 <!-- <div class="col-md-6 agile_about_grid_right">
   <img src="../foto_banner/<?= $r['gambar']?>" alt=" " class="img-responsive" />
 </div>
 -->
 <div class="clearfix"> </div>
 </div>
 </div>
 <!-- //about -->
 <!-- //banner -->
 <?php
 }
 // Modul keranjang belanja
 elseif ($_GET[module]=='keranjangbelanja'){
 // Tampilkan produk-produk yang telah dimasukkan ke keranjang belanja
 $sid = $_SESSION[email];
 $sql = mysqli_query($con,"SELECT * FROM orders_temp, produk
 WHERE id_session='$sid' AND orders_temp.id_produk=produk.id_produk");
 $ketemu=mysqli_num_rows($sql);
 if($ketemu < 1){
 echo "<script>window.alert('Keranjang Belanjanya Masih Kosong');
 window.location=('index.php')</script>";
 }
 else{
   ?>
   <div class="w3l_banner_nav_right">
  <p style="text-align: left; font-size: 30px; ">
  Your shopping cart contains
 </p>
   <div class="col-md-12">
     <form method=post action=aksi.php?module=keranjang&act=update>
       <table class="timetable_sub">
           <thead>
           <tr>
             <th>No</th>
             <th>Produk</th>
             <th>Nama Produk</th>
             <th>Berat(Kg)</th>
             <th>Qty</th>
           <th>Harga</th>
           <th>Sub Total</th>
           <th>Hapus</th>
         </tr>
       </thead>
           <?php
           $no=1;
           while($r=mysqli_fetch_array($sql)){
           $disc        = ($r[diskon]/100)*$r[harga];
           $hargadisc   = number_format(($r[harga]-$disc),0,",",".");
           $subtotal    = ($r[harga]-$disc) * $r[jumlah];
           $total       = $total + $subtotal;
           $subtotal_rp = format_rupiah($subtotal);
           $total_rp    = format_rupiah($total);
           $harga       = format_rupiah($r[harga]);
           ?>
 
          <tbody><tr class="rem1">
           <td><?=$no?></td><input type=hidden name=id[<?=$no?>] value=<?=$r['id_orders_temp']?>>
           <td align=center><br><img src=foto_produk/small_<?=$r['gambar']?>></td>
           <td><?=$r['nama_produk']?></td>
           <td align=center><?=$r['berat']?></td>
           <td>
             <select name='jml[<?=$no?>]' value=<?=$r['jumlah']?> onChange='this.form.submit()'>
               <?php
             for ($j=1;$j <= $r['stok'];$j++){
             if($j == $r['jumlah']){
             echo "<option selected>$j</option>";
             }else{
             echo "<option>$j</option>";
             }
             }
             ?>
           </select></td>
           <td><?=$hargadisc?></td>
           <td><?=$subtotal_rp?></td>
           <td align=center><a href='aksi.php?module=keranjang&act=hapus&id=<?=$r['id_orders_temp']?>'>
           <img src=images/kali.png border=0 title=Hapus></a></td>
         </tr>
         <?php
         $no++;
         }
         ?>
         <tr style='color:#000'><td colspan=6 align=right><br><b>Total</b>:</td><td colspan=2><br>Rp. <b><?=$total_rp?></b></td></tr>
         <tr><td colspan=3><br /><a href='javascript:history.go(-1)' class='btn btn-primary'>Lanjutkan Belanja</a><br /></td>
         <td colspan=5 align=right><br /><a href='home.php?module=simpantransaksimember' class='btn btn-success'>Selesai Belanja</a></a><br /></td></tr>
       </tbody></table></form><br />
       <div id='info'>*) Total harga diatas belum termasuk ongkos kirim yang akan dihitung saat <b>Selesai Belanja</b>.</div>
     </div>
 
   </div>
 </div>
 <div class='bottom_prod_box_big'></div>
 </div>
 
 <?php
 }
 }
 // Modul hasil pencarian produk
 elseif ($_GET['module']=='hasilcari'){
 // menghilangkan spasi di kiri dan kanannya
 $kata = trim($_POST['kata']);
 // mencegah XSS
 $kata = htmlentities(htmlspecialchars($kata), ENT_QUOTES);
 // pisahkan kata per kalimat lalu hitung jumlah kata
 $pisah_kata = explode(" ",$kata);
 $jml_katakan = (integer)count($pisah_kata);
 $jml_kata = $jml_katakan-1;
 $cari = "SELECT * FROM produk WHERE " ;
 for ($i=0; $i<=$jml_kata; $i++){
 $cari .= "deskripsi LIKE '%$pisah_kata[$i]%' OR nama_produk LIKE '%$pisah_kata[$i]%'";
 if ($i < $jml_kata ){
 $cari .= " OR ";
 }
 }
 $cari .= " ORDER BY id_produk DESC LIMIT 7";
 $hasil  = mysqli_query($con,$cari);
 $ketemu = mysqli_num_rows($hasil);
 echo "<div class='center_title_bar'>Hasil Pencarian</div>";
 if ($ketemu > 0){
 echo "<div class='prod_details_cari'>Ditemukan <b>$ketemu</b> produk dengan kata <font style='background-color:#00FFFF'><b>$kata</b></font> : </div>";
 while($t=mysqli_fetch_array($hasil)){
 // Tampilkan hanya sebagian isi produk
 $isi_produk = htmlentities(strip_tags($t['deskripsi'])); // mengabaikan tag html
 $isi = substr($isi_produk,0,250); // ambil sebanyak 250 karakter
 $isi = substr($isi_produk,0,strrpos($isi," ")); // potong per spasi kalimat
 echo "<div class='prod_box_big'>
 <div class='top_prod_box_big'></div>
 <div class='center_prod_box_big'>
   <div class='details_big_cari'>
     <div class='product_title_big'><a href=produk-$t[id_produk]-$t[produk_seo].html>$t[nama_produk]</a></div>
     <div>
       <br />$isi ... <a href=produk-$t[id_produk]-$t[produk_seo].html>selengkapnya</a>
     </div>
   </div>
 </div>
 <div class='bottom_prod_box_big'></div>
 </div>";
 }
 }
 else{
 echo "<p>Tidak ditemukan produk dengan kata <b>$kata</b></p>";
 }
 }
 // Modul hubungi kami(Hardware Repair)
 elseif ($_GET[module]=='pemesanan'){
 echo "<div class='login-box'>
 <h2>Hubungi Kami</h2>
 Kami Menerima Pemesanan barang, baik itu Komputer, Printer dan sebagainya, Anda dapat menghubungi Kami lewat Form di bawah ini
 <div class='details_big_box'>
   <div class='product_title_big'>Pesan Barang Yang Anda Inginkan Sekarang, Hubungi Kami Secara Online:</div>
 </div>
 </div>";
 if (empty($_SESSION[username]) AND empty($_SESSION[password])) {
 echo "<div id='info'>Silahkan anda login terlebih dahulu, untuk mendapatkan layanan ini</div>";
 }
 else {
 $sql=mysqli_query($con,"SELECT * FROM kustomer WHERE email='$_SESSION[email]'");
 $r=mysqli_fetch_array($sql);
 echo "<div class='login-box'>
 <table width=100% style='border: 1pt dashed #0000CC;padding: 10px;'>
   <form action=home.php?module=hubungiaksi method=POST><input type=hidden name=id value='$r[id_kustomer]'>
     <tr><td>Id Kustomer</td><td> : $r[id_kustomer]</td></tr>
     <tr><td>Nama</td><td> : $r[nama_lengkap] </td></tr>
     <tr><td>Nomor Telepon</td><td> : $r[telpon]</td></tr>
     <tr><td>Alamat Anda</td><td> : $r[alamat]</td></tr>
     <tr><td colspan=2>
       <br/><b>Silahkan Anda Memesan Barang Dibawah Ini</b><br>
       Contoh Format Pengisian : <br/>
       Subjek : Printer<br/>
     Pesan  : Saya Memesan 2 Unit Printer Epson L200</td></tr>
     <tr><td>Subjek</td><td>  <input type=text name=subjek size=40></td></tr>
     <tr><td valign=top>Pesan</td><td> <textarea name=pesan  style='width: 390px; height: 160px;'></textarea><br/>
   <i></i> </td></tr>
   <tr><td>&nbsp;</td><td><img src='captcha.php'></td></tr>
   <tr><td>&nbsp;</td><td>(masukkan 6 kode di atas)<br /><input type=text name=kode size=6 maxlength=6><br /></td></tr>
   </td><td colspan=2><input type=submit name=submit value=Kirim class='button' ></td></tr>
 </form></table>
 </div>
 </div>
 </div>
 <div class='bottom_prod_box_big'></div>
 </div>";
 }
 }
 // Modul hubungi aksi
 elseif ($_GET[module]=='hubungiaksi'){
 $nama=trim($_POST['nama']);
 $email=trim($_POST['email']);
 $subjek=trim($_POST['subjek']);
 $pesan=trim($_POST['pesan']);
 echo "<div id='info'>";
 if (empty($subjek)){
 echo "Anda belum mengisikan SUBJEK<br />
 <a href=javascript:history.go(-1)><b>Ulangi Lagi</b>";
 }
 elseif (empty($pesan)){
 echo "Anda belum mengisikan PESAN<br />
 <a href=javascript:history.go(-1)><b>Ulangi Lagi</b>";
 }
 else{
 if(!empty($_POST['kode'])){
 if($_POST['kode']==$_SESSION['captcha_session']){
 mysqli_query($con,"INSERT INTO hubungi(id_kustomer,
 subjek,
 pesan,
 tanggal)
 VALUES('$_POST[id]',
 '$_POST[subjek]',
 '$_POST[pesan]',
 '$tgl_sekarang')");
 echo "
 <div class='prod_box_big'>
 <div class='top_prod_box_big'></div>
 <div class='center_prod_box_big'>
   <div class='product_img_big'>
     <img src='foto_banner/adminn.png' border='0' />
   </div>
   <div class='details_big_box'>
     <div class='product_title_big'>Terimakasih</div>
     <div>
       <br />Terimakasih telah menghubungi kami.<br /><br /> Kami akan segera Merespon Pemesanan Anda.
     </div>
   </div>
 </div>
 <div class='bottom_prod_box_big'></div>
 </div>";
 }else{
 echo "Kode yang Anda masukkan tidak cocok<br />
 <a href=javascript:history.go(-1)><b>Ulangi Lagi</b></a>";
 }
 }else{
 echo "Anda belum memasukkan kode<br />
 <a href=javascript:history.go(-1)><b>Ulangi Lagi</b></a>";
 }
 }
 echo "</div>";
 }
 //Module Login
 elseif ($_GET[module]=='login') {
 if ($_GET[act]=='aksilogin') {
 echo "<div id='info'>";
 $email = $_POST['email'];
 $password = md5($_POST['password']);
 $sql = "SELECT * FROM kustomer WHERE email='$email' AND password='$password'";
 $hasil = mysqli_query($con,$sql);
 $r = mysqli_fetch_array($hasil);
 if(mysqli_num_rows($hasil) == 0){
 echo "Email atau Password Anda tidak benar<br />";
 }
 else{
 session_start();
 $_SESSION[email]= $r[email];
 $_SESSION[password]= $r[password];
 $_SESSION[nama_lengkap]= $r[nama_lengkap];
 echo "<script> alert('Silahkan Berbelanja Di Toko Kami');window.location='index.php'</script>\n";
 exit(0);
 }
 echo "</div>";
 }
 ?>
 <div class='login-box'>
 <div class="w3_login_module">
 <div class="module form-module">
   <center><i class="fa fa-user fa-lg"></i> <b>Sign In </center>
   <div class="toggle">
   </div>
   <div class="form">
     <h2>Login to your account</h2>
     <form action="home.php?module=login&act=aksilogin" method="post" onSubmit=\"return validasi2(this)\">
       <input type="text" name="email" placeholder="Email" required=" ">
       <input type="password" name="password" placeholder="Password" required=" ">
       <input type="submit" value="Login">
     </form>
   </div>
 
   <div class="cta"><a href="home.php?module=lupapassword">Forgot your password?</a></div>
 </div>
 </div>
 </div>
 <!-- team -->
 <div class="team">
 <div class="container">
 <h3>Meet Our Amazing Team</h3>
 <div class="agileits_team_grids">
   <div class="col-md-3 agileits_team_grid">
     <img src="template/images/32.jpg" alt=" " class="img-responsive" />
     <h4>Martin Paul</h4>
     <p>Manager</p>
     <ul class="agileits_social_icons agileits_social_icons_team">
       <li><a href="#" class="facebook"><i class="fa fa-facebook" aria-hidden="true"></i></a></li>
       <li><a href="#" class="twitter"><i class="fa fa-twitter" aria-hidden="true"></i></a></li>
       <li><a href="#" class="google"><i class="fa fa-google-plus" aria-hidden="true"></i></a></li>
     </ul>
   </div>
   <div class="col-md-3 agileits_team_grid">
     <img src="template/images/33.jpg" alt=" " class="img-responsive" />
     <h4>Michael Rick</h4>
     <p>Supervisor</p>
     <ul class="agileits_social_icons agileits_social_icons_team">
       <li><a href="#" class="facebook"><i class="fa fa-facebook" aria-hidden="true"></i></a></li>
       <li><a href="#" class="twitter"><i class="fa fa-twitter" aria-hidden="true"></i></a></li>
       <li><a href="#" class="google"><i class="fa fa-google-plus" aria-hidden="true"></i></a></li>
     </ul>
   </div>
   <div class="col-md-3 agileits_team_grid">
     <img src="template/images/34.jpg" alt=" " class="img-responsive" />
     <h4>Thomas Carl</h4>
     <p>Supervisor</p>
     <ul class="agileits_social_icons agileits_social_icons_team">
       <li><a href="#" class="facebook"><i class="fa fa-facebook" aria-hidden="true"></i></a></li>
       <li><a href="#" class="twitter"><i class="fa fa-twitter" aria-hidden="true"></i></a></li>
       <li><a href="#" class="google"><i class="fa fa-google-plus" aria-hidden="true"></i></a></li>
     </ul>
   </div>
   <div class="col-md-3 agileits_team_grid">
     <img src="template/images/35.jpg" alt=" " class="img-responsive" />
     <h4>Laura Lee</h4>
     <p>CEO</p>
     <ul class="agileits_social_icons agileits_social_icons_team">
       <li><a href="#" class="facebook"><i class="fa fa-facebook" aria-hidden="true"></i></a></li>
       <li><a href="#" class="twitter"><i class="fa fa-twitter" aria-hidden="true"></i></a></li>
       <li><a href="#" class="google"><i class="fa fa-google-plus" aria-hidden="true"></i></a></li>
     </ul>
   </div>
   <div class="clearfix"> </div>
 </div>
 </div>
 </div>
 <!-- //team -->
 <script>
 $('#login').submit(function(e){
 //Ubah tulisan pada button saat click login
 $('#btnLogin').attr('value','Silahkan tunggu ...');
 e.preventDefault();
 //Gunakan jquery AJAX
 $.ajax({
 url   : 'cek_login.php',
 //mengirimkan username dan password ke script login.php
 data  : $('#login').serialize(),
 //Method pengiriman
 type  : 'POST',
 //Data yang akan diambil dari script pemroses
 /*  dataType: 'html',*/
 //Respon jika data berhasil dikirim
 success : function(pesan){
 if(pesan=='ok'){
 //Arahkan ke halaman admin jika script pemroses mencetak kata ok
 $.toast({
 text: "Anda Akan diarhakan Dalam 3 Detik.",
 heading: 'Sukses Login.',
 icon: 'success',
 showHideTransition: 'fade',
 allowToastClose: true,
 hideAfter: 3000,
 stack: 5,
 position: 'top-right',
 });;
 /*window.location = 'media.php?module=home';*/
 setTimeout(function(){location.href="home.php?module=home"} , 3000);
 }
 else{
 //Cetak peringatan untuk username & password salah
 $.toast({
 text: "Username/Password salah.",
 heading: 'Gagal Login',
 icon: 'error',
 showHideTransition: 'fade',
 allowToastClose: true,
 hideAfter: 3000,
 stack: 5,
 position: 'top-right',
 });;
 $('#btnLogin').attr('value','Coba lagi ...');
 }
 },
 });
 })
 </script>
 <?php
 }
 //Module Profil Kustomer
 elseif ($_GET[module]=='profilKustomer') {
 $sql=mysqli_query($con,"SELECT * FROM kustomer WHERE email='$_SESSION[email]'");
 $p=mysqli_fetch_array($sql);
 $password=md5($p['password']);
 ?>
 <div class="col-md-9 address_form_agile">
             <h4>Add a new Details</h4>
 <table class="table table-striped table-bordered">
 <tr><td>Nama Lengkap</td><td> <?= $p['nama_lengkap']?> </td></tr>
 <tr><td>Alamat Pengiriman</td><td> <?= $p['alamat']?></textarea></td></tr>
 <tr><td>Nomor Telepon</td><td> <?= $p['telpon']?></td></tr>
 <tr><td>Email</td><td> <?=  $p['email']?></td></tr>
 <tr><td colspan=2><a href='home.php?module=editProfilKustomer' class="btn btn-success">Edit Profil</a></td></tr></table>
 </div>
 <?php
 }
 //Module editProfilKustomer
 elseif ($_GET[module]=='editProfilKustomer') {
 if ($_GET[aksi]=='edit') {
 mysqli_query($con,"UPDATE  kustomer SET nama_lengkap='$_POST[nama]',
 alamat= '$_POST[alamat]',
 telpon= '$_POST[telpon]',
 id_kota ='$_POST[kota]'
 WHERE email= '$_POST[email]'" ) ;
 ?>
 <div id='info'>Anda Berhasil Mengedit Profil Anda <a href='home.php?module=profilKustomer'>Lihat Disini</a></div>
 <?php
 }
 $sql=mysqli_query($con,"SELECT * FROM kustomer WHERE email='$_SESSION[email]'");
 $e=mysqli_fetch_array($sql);
 ?>
 <div class="col-md-9 address_form_agile">
             <h4>Add a new Details</h4>
 <form name=form action=home.php?module=editProfilKustomer&aksi=edit method=POST onSubmit=\"return validasi(this)\">
   <table class="table table-striped table-bordered">
     <tr>
       <td>Nama Lengkap</td>
       <td><input type=text name=nama value='<?=$e['nama_lengkap']?>'></td>
     </tr>
     <tr>
       <td>Alamat Pengiriman</td>
       <td> <textarea name='alamat'><?= $e['alamat']?></textarea>
   <br /> Alamat pengiriman harus di isi lengkap, termasuk kota/kabupaten dan kode posnya.</td>
 </tr>
   <tr>
     <td>Nomor Telepon</td><td>  <input type=text name=telpon value='<?= $e['telpon']?>'></td></tr>
   <tr>
     <td></td>
     <td>  <input type=hidden name=email size=30 value='<?= $e['email']?>'></td></tr>
   <tr>
     <td valign=top>Kota Tujuan</td>
     <td>
   <select name='kota'>
     <option value=0 selected>- Pilih Kota -</option>
     <?php
     $tampil=mysqli_query($con,"SELECT * FROM kota ORDER BY nama_kota");
     while($r=mysqli_fetch_array($tampil)){
     echo "<option value=$r[id_kota]>$r[nama_kota]</option>";
     }
   ?>
 </select> <br /><br />*)  Apabila tidak terdapat nama kota tujuan Anda, pilih <b>Lainnya</b>
 <br />**) Ongkos kirim dihitung berdasarkan kota tujuan</td></tr>
 <tr><td colspan=2><input type='submit' class='btn btn-success' value='Edit My Profil'></td></tr>
 </table>
 </form>
 </div>
 <?php
 }
 //Module Register
 elseif ($_GET[module]=='register') {
 $kar1=strstr($_POST[email], "@");
 $kar2=strstr($_POST[email], ".");
 $password=md5($_POST[password]);
 echo "<div id='info'>";
 // Cek email kustomer di database
 $cek_email=mysqli_num_rows(mysqli_query($con,"SELECT email FROM kustomer WHERE email='$_POST[email]'"));
 // Kalau email sudah ada yang pakai
 if ($cek_email > 0){
 echo "Email <b>$_POST[email]</b> sudah ada yang pakai.<br />";
 }
 elseif (empty($_POST[nama]) || empty($_POST[password]) || empty($_POST[alamat]) || empty($_POST[telpon]) || empty($_POST[email]) || empty($_POST[kota]) || empty($_POST[kode])){
 echo "Data yang Anda isikan belum lengkap<br />";
 }
 elseif (!ereg("[a-z|A-Z]","$_POST[nama]")){
 echo "Nama tidak boleh diisi dengan angka atau simbol.<br />";
 }
 elseif (strlen($kar1)==0 OR strlen($kar2)==0){
 echo "Alamat email Anda tidak valid, mungkin kurang tanda titik (.) atau tanda @.<br />";
 }
 else{
 if(!empty($_POST['kode'])){
 if($_POST['kode']==$_SESSION['captcha_session']){
 // simpan data kustomer
 mysqli_query($con,"INSERT INTO kustomer(nama_lengkap, password, alamat, telpon, email, id_kota)
 VALUES('$_POST[nama]','$password','$_POST[alamat]','$_POST[telpon]','$_POST[email]','$_POST[kota]')");
 echo "<b>Anda berhasil Melakukan Registrasi</b><br/>
 Silahkan anda login <a href='home.php?module=login'>disini</a>";
 }else{
 echo "Kode yang Anda masukkan tidak cocok<br />
 <a href=javascript:history.go(-1)><b>Ulangi Lagi</b></a>";
 }
 }else{
 echo "Anda belum memasukkan kode<br />
 <a href=javascript:history.go(-1)><b>Ulangi Lagi</b></a>";
 }
 }
 echo "</div>";
 echo "
 <div class='login-box'>
 <h2>Form Register</h2>
 <form name=form action=home.php?module=register method=POST onSubmit=\"return validasi(this)\">
 <table width='90%'>
 <tr><td>Nama Lengkap</td><td>  <input type=text name=nama size=30></td></tr>
 <tr><td>Password</td><td>  <input type=password name=password></td></tr>
 <tr><td>Alamat Pengiriman</td><td> <textarea name='alamat'></textarea>
 <br /> Alamat pengiriman harus di isi lengkap, termasuk kota/kabupaten dan kode posnya.</td></tr>
 <tr><td>Nomor Telepon</td><td>  <input type=text name=telpon></td></tr>
 <tr><td>Email</td><td>  <input type=text name=email size=30></td></tr>
 <tr><td valign=top>Kota Tujuan</td><td>
 <select name='kota'>
 <option value=0 selected>- Pilih Kota -</option>";
 $tampil=mysqli_query($con,"SELECT * FROM kota ORDER BY nama_kota");
 while($r=mysqli_fetch_array($tampil)){
 echo "<option value=$r[id_kota]>$r[nama_kota]</option>";
 }
 echo "</select> <br /><br />*)  Apabila tidak terdapat nama kota tujuan Anda, pilih <b>Lainnya</b>
 <br />**) Ongkos kirim dihitung berdasarkan kota tujuan</td></tr>
 <tr><td>&nbsp;</td><td><img src='captcha.php'></td></tr>
 <tr><td>&nbsp;</td><td>(Masukkan 6 kode diatas)<br /><input type=text name=kode size=6 maxlength=6><br /></td></tr>
 <tr><td colspan=2><input type='submit' class='button' value='Daftar'></td></tr>
 </table>
 </form>
 </div>";
 }
 // Modul selesai belanja
 elseif ($_GET[module]=='selesaibelanja'){
 echo "<div class='login-box'>";
 $sid = $_SESSION[email];
 $sql =mysqli_query($con,"SELECT * FROM orders_temp, produk
 WHERE id_session='$sid' AND orders_temp.id_produk=produk.id_produk");
 $ketemu=mysqli_num_rows($sql);
 if($ketemu < 1){
 echo "<script> alert('Keranjang belanja masih kosong');window.location='index.php'</script>\n";
 exit(0);
 }
 else{
 echo "<h2>Kustomer Lama</h2>
 <form name=form2 action=simpan-transaksi-member.html method=POST onSubmit=\"return validasi2(this)\">
 <table>
 <tr><td>Email</td><td> <input type=text name=email size=30></td></tr>
 <tr><td>Password</td><td> <input type=password name=password size=30></td></tr>
 <tr><td><input type='submit' class='button' value='Login' id='submit'></td><td align=right><a href='home.php?module=lupapassword'>Lupa Password?</a></td></tr>
 </table>
 </form><br/><br/>
 ";
 echo "<h2>Kustomer Baru</h2>";
 echo "
 <form name=form action=home.php?module=simpantransaksi method=POST onSubmit=\"return validasi(this)\">
 <table width='90%'>
 <tr><td>Nama Lengkap</td><td>  <input type=text name=nama size=30></td></tr>
 <tr><td>Password</td><td>  <input type=text name=password></td></tr>
 <tr><td>Alamat Pengiriman</td><td>  <textarea name=alamat></textarea>
 <br /> Alamat pengiriman harus di isi lengkap, termasuk kota/kabupaten dan kode posnya.</td></tr>
 <tr><td>Nomor Telepon</td><td>  <input type=text name=></td></tr>
 <tr><td>Email</td><td>  <input type=text name=email size=30></td></tr>
 <tr><td valign=top>Kota Tujuan</td><td>
 <select name='kota'>
 <option value=0 selected>- Pilih Kota -</option>";
 $tampil=mysqli_query($con,"SELECT * FROM kota ORDER BY nama_kota");
 while($r=mysqli_fetch_array($tampil)){
 echo "<option value=$r[id_kota]>$r[nama_kota]</option>";
 }
 echo "</select> <br /><br />*)  Apabila tidak terdapat nama kota tujuan Anda, pilih <b>Lainnya</b>
 <br />**) Ongkos kirim dihitung berdasarkan kota tujuan</td></tr>
 <tr><td>&nbsp;</td><td><img src='captcha.php'></td></tr>
 <tr><td>&nbsp;</td><td>(Masukkan 6 kode diatas)<br /><input type=text name=kode size=6 maxlength=6><br /></td></tr>
 <tr><td colspan=2><input type='submit' class='button' value='Daftar'></td></tr>
 </table>
 </form>
 </div>";
 }
 }
 // Modul lupa password
 elseif ($_GET[module]=='lupapassword'){
 echo "<div class='center_title_bar'>Lupa Password</div>";
 echo "<div class='login-box'>
 <form name=form3 action=home.php?module=kirimpassword method=POST>
 <table>
 <tr><td>Masukkan Email Anda</td><td>  <input type=text name=email size=30></td></tr>
 <tr><td colspan=2><input type='submit' class='button' value='Kirim'></td></td></tr>
 </table>
 </form>
 </div>";
 }
 // Modul kirim password
 elseif ($_GET[module]=='kirimpassword'){
 // Cek email kustomer di database
 $cek_email=mysqli_num_rows(mysqli_query($con,"SELECT email FROM kustomer WHERE email='$_POST[email]'"));
 // Kalau email tidak ditemukan
 if ($cek_email == 0){
 echo "Email <b>$_POST[email]</b> tidak terdaftar di database kami.<br />
 <a href=javascript:history.go(-1)><b>Ulangi Lagi</b></a>";
 }
 else{
 $password_baru = substr(md5(uniqid(rand(),1)),3,10);
 // ganti password kustomer dengan password yang baru (reset password)
 $query=mysqli_query($con,"update kustomer set password=md5('$password_baru') where email='$_POST[email]'");
 // dapatkan email_pengelola dari database
 $sql2 = mysqli_query($con,"select email_pengelola from modul where id_modul='43'");
 $j2   = mysqli_fetch_array($sql2);
 $subjek="Password Baru";
 $pesan="Password Anda yang baru adalah <b>$password_baru</b>";
 // Kirim email dalam format HTML
 $dari = "From: $j2[email_pengelola]\r\n";
 $dari .= "Content-type: text/html\r\n";
 // Kirim password ke email kustomer
 mail($_POST[email],$subjek,$pesan,$dari);
 echo "<div class='center_title_bar'>Kirim Password</div>
 <div class='prod_box_big'>
 <div class='top_prod_box_big'></div>
 <div class='center_prod_box_big'>
 <div class='product_img_big'>
 <img src='foto_banner/gedung.jpg' border='0' />
 </div>
 <div class='details_big_box'>
 <div class='product_title_big'>Password Sudah Terkirim</div>
 <div>
 <br />Silahkan cek email Anda.
 </div>
 </div>
 </div>
 <div class='bottom_prod_box_big'></div>
 </div>";
 }
 }
 // Modul simpan transaksi member
 elseif ($_GET[module]=='simpantransaksimember'){
 echo "<div style='color:#000'>";
 $email = $_SESSION[email];
 $password = $_SESSION[password];
 
 $sql = "SELECT * FROM kustomer WHERE email='$email' AND password='$password'";
 $hasil = mysqli_query($con,$sql);
 $r = mysqli_fetch_array($hasil);
 // fungsi untuk mendapatkan isi keranjang belanja
 function isi_keranjang(){
   $isikeranjang = array();
   $sid = $_SESSION[email];
-  $sql = mysqli_query($con,"SELECT * FROM orders_temp WHERE id_session='$sid'");
+  $sql = mysqli_query($con,"SELECT * FROM orders_temp WHERE id_session='$sid'") or die( mysqli_error());
 
   while ($r=mysqli_fetch_array($sql)) {
     $isikeranjang[] = $r;
   }
   return $isikeranjang;
 }
 
 date_default_timezone_set('Asia/Jakarta');
 $tgl_skrg = date("Ymd");
 $jam_skrg = date("H:i:s");
-$id = mysqli_fetch_array(mysqli_query($con,"SELECT id_kustomer FROM kustomer WHERE email='$email' AND password='$password'"));
+$que = mysqli_query(
   $con,
     "SELECT id_kustomer FROM kustomer WHERE email='$email' AND password='$password'"
 )
 or die(mysql_error());
 
-mysqli_query($con,"INSERT INTO orders(tgl_order,jam_order,id_kustomer) VALUES('$tgl_skrg','$jam_skrg','$id_kustomer')");
+$id = mysqli_fetch_array($que);
 
 // mendapatkan nomor kustomer
 $id_kustomer=$id[id_kustomer];
 
 // simpan data pemesanan
 $que = mysqli_query($con,"INSERT INTO orders(tgl_order,jam_order,id_kustomer) VALUES('$tgl_skrg','$jam_skrg','$id_kustomer')")
 or die(mysql_error())
 ;
 
 
 // mendapatkan nomor orders
-mysqli_query($con,"INSERT INTO orders_detail(id_orders, id_produk, jumlah)
+
-               VALUES('$id_orders','{$isikeranjang[$i]['id_produk']}', '{$isikeranjang[$i]['jumlah']}')");
+
 die('id order='.$id_orders);
 // panggil fungsi isi_keranjang dan hitung jumlah produk yang dipesan
 $isikeranjang = isi_keranjang();
 $jml          = count($isikeranjang);
-mysqli_query($con,"DELETE FROM orders_temp
+
-               WHERE id_orders_temp = {$isikeranjang[$i]['id_orders_temp']}");
+die('<pre>'.print_r($isikeranjang,1));
 // simpan data detail pemesanan
 for ($i = 0; $i < $jml; $i++){
 $ar_sql[]=$sql="INSERT INTO orders_detail(id_orders, id_produk, jumlah)
                VALUES('$id_orders','{$isikeranjang[$i]['id_produk']}', '{$isikeranjang[$i]['jumlah']}')";
 $hasil = mysqli_query($con,$sql) or die(mysql_error());
 
 }
   die('<pre>'.print_r($ar_sql,1));
 
 // setelah data pemesanan tersimpan, hapus data pemesanan di tabel pemesanan sementara (orders_temp)
 for ($i = 0; $i < $jml; $i++) {
 $res = mysqli_query($con,"DELETE FROM orders_temp
                WHERE id_orders_temp = {$isikeranjang[$i]['id_orders_temp']}") or die(mysql_error());
 }
 die('hapus ok');
   echo "<div class='center_title_bar'>Proses Transaksi Selesai</div>";
         echo "<div class='prod_box_big'>
           <div class='top_prod_box_big'></div>
         <div class='center_prod_box_big'>
           <div class='details_big_cari'>
               <div>
       Data pemesan beserta ordernya adalah sebagai berikut: <br />
       <table>
       <tr><td>Nama Lengkap   </td><td> : <b>$r[nama_lengkap]</b> </td></tr>
       <tr><td>Alamat Lengkap </td><td> : $r[alamat] </td></tr>
       <tr><td>Nomor Telepon         </td><td> : $r[telpon] </td></tr>
       <tr><td>E-mail         </td><td> : $r[email] </td></tr></table><hr /><br />
 
       Nomor Order: <b>$id_orders</b><br /><br />";
 
       $daftarproduk=mysqli_query($con,"SELECT * FROM orders_detail,produk
                                  WHERE orders_detail.id_produk=produk.id_produk
                                  AND id_orders='$id_orders'");
 
 echo "<table cellpadding=10>
       <tr bgcolor=#6da6b1><th>No</th><th>Nama Produk</th><th>Berat(Kg)</th><th>Qty</th><th>Harga Satuan</th><th>Sub Total</th></tr>";
 
 $pesan="Terimakasih telah melakukan pemesanan online di toko online kami <br /><br />
         Nama: $r[nama_lengkap] <br />
         Alamat: $r[alamat] <br/>
         Nomor Telepon: $r[telpon] <br /><hr />
 
         Nomor Order: $id_orders <br />
         Data order Anda adalah sebagai berikut: <br /><br />";
 
 $no=1;
 while ($d=mysqli_fetch_array($daftarproduk)){
    $disc        = ($d[diskon]/100)*$d[harga];
    $hargadisc   = number_format(($d[harga]-$disc),0,",",".");
    $subtotal    = ($d[harga]-$disc) * $d[jumlah];
 
    $subtotalberat = $d[berat] * $d[jumlah]; // total berat per item produk
    $totalberat  = $totalberat + $subtotalberat; // grand total berat all produk yang dibeli
 
    $total       = $total + $subtotal;
    $subtotal_rp = format_rupiah($subtotal);
    $total_rp    = format_rupiah($total);
    $harga       = format_rupiah($d[harga]);
 
    echo "<tr bgcolor=#dad0d0><td>$no</td><td>$d[nama_produk]</td><td align=center>$d[berat]</td><td align=center>$d[jumlah]</td>
                              <td align=right>$harga</td><td align=right>$subtotal_rp</td></tr>";
 
    $pesan.="$d[jumlah] $d[nama_produk] -> Rp. $harga -> Subtotal: Rp. $subtotal_rp <br />";
    $no++;
 }
 
 $kota=$r[id_kota];
 
 $ongkos=mysqli_fetch_array(mysqli_query($con,"SELECT ongkos_kirim FROM kota WHERE id_kota='$kota'"));
 $ongkoskirim1=$ongkos[ongkos_kirim];
 $ongkoskirim = $ongkoskirim1 * $totalberat;
 
 $grandtotal    = $total + $ongkoskirim;
 
 $ongkoskirim_rp = format_rupiah($ongkoskirim);
 $ongkoskirim1_rp = format_rupiah($ongkoskirim1);
 $grandtotal_rp  = format_rupiah($grandtotal);
 
 // dapatkan email_pengelola dan nomor telepon dari database
 $sql2 = mysqli_query($con,"select email_pengelola,nomor_rekening,nomor_hp from modul where id_modul='43'");
 $j2   = mysqli_fetch_array($sql2);
 
 $pesan.="<br /><br />Total : Rp. $total_rp
          <br />Ongkos Kirim untuk Tujuan Kota Anda : Rp. $ongkoskirim1_rp/Kg
          <br />Total Berat : $totalberat Kg
          <br />Total Ongkos Kirim  : Rp. $ongkoskirim_rp
          <br />Grand Total : Rp. $grandtotal_rp
          <br /><br />Silahkan lakukan pembayaran sebanyak Grand Total yang tercantum, rekeningnya: $j2[nomor_rekening]
          <br />Apabila sudah transfer, konfirmasi ke nomor: $j2[nomor_hp]";
 
 $subjek="Pemesanan Online";
 
 // Kirim email dalam format HTML
 $dari = "From: $j2[email_pengelola]\r\n";
 $dari .= "Content-type: text/html\r\n";
 
 // Kirim email ke kustomer
 mail($email,$subjek,$pesan,$dari);
 
 // Kirim email ke pengelola toko online
 mail("$j2[email_pengelola]",$subjek,$pesan,$dari);
 
 echo "<tr><td colspan=5 align=right>Total : Rp. </td><td align=right><b>$total_rp</b></td></tr>
       <tr><td colspan=5 align=right>Ongkos Kirim untuk Tujuan Kota Anda: Rp. </td><td align=right><b>$ongkoskirim1_rp</b>/Kg</td></tr>
       <tr><td colspan=5 align=right>Total Berat : </td><td align=right><b>$totalberat Kg</b></td></tr>
       <tr><td colspan=5 align=right>Total Ongkos Kirim : Rp. </td><td align=right><b>$ongkoskirim_rp</b></td></tr>
       <tr><td colspan=5 align=right>Grand Total : Rp. </td><td align=right><b>$grandtotal_rp</b></td></tr>
       </table>";
 echo "<hr /><p>
       <div style='color:#E1473D;border:1px solid #E78686;padding:10px;background:#FFE1E1;'>
         No Order anda adalah : <b>$id_orders</b> , Silahkan Melakukan Pembayaran Pada Rekening dibawah ini, <br/>
         Anda dapat melakukan Konfirmasi Pembayaran Melalui SMS Ke NO : <b>081275371724</b>
         <br/>Dengan Format :
         <b>#No Orders #Nominal Transfer # Bank Tujuan # Bank Pengirim</b> Contoh :
         <b> # $id_orders #$grandtotal_rp #Mandiri #Riau </b></div> <br /> <br />
                Apabila Anda tidak melakukan pembayaran dalam 3 hari, maka transaksi dianggap batal.</p><br />    ";
   $sql  = mysqli_query($con,"SELECT * FROM modul WHERE id_modul='3'");
     $r    = mysqli_fetch_array($sql);
    echo "$r[static_content]";
 
 echo"
               </div>
           </div>
           </div>
             <div class='bottom_prod_box_big'></div>
           </div>";
 
     echo "</div>";
 }
 ?>