Untitled

<?php
include "header.php";
include "db/koneksi.php";
                    $data= mysql_query("SELECT * FROM users WHERE username = '".$_SESSION['username']."'");
$hasil= mysql_fetch_array($data);
$username = $hasil['username'];
$balance = number_format($hasil['balance'],0,',','.');
?>
<html>
        <?php include"head.inc";?>


</ul>
  <body class="bg-gray">

    <div class="navbar navbar-default navbar-fixed-top" role="navigation">
      <div class="container">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>

          <a href="index.php" class="navbar-brand" title="<?php echo"$site";?>"><?php echo"$site";?></a>        </div>
        <div class="collapse navbar-collapse">
<ul class="nav navbar-nav navbar-right">
            <li><a>Saldo : Rp. <?php echo"$balance";?></a></li>
              <ul class="nav navbar-nav navbar-right">
    <li>
       <a href="profil.php">Kamu Masuk sebagai <b style="color:#0014FA"><?php echo"$username";?></b></a></b></li>
    <li class="active"><a href="logout.php">Keluar</a></li>
</ul>

          </ul>

<ul class="nav navbar-nav navbar-left">
<ul class="nav navbar-nav navbar-left">
    <li>
        <a href="index.php">User</a>    </li>
         <li class="active">
        <a href="tambah.php">Tambah Saldo</a>    </li>
   <li>
        <a href="layanan.php">Layanan</a>    </li>
    <li>
        <a href="order.php">orderan</a>    </li>

</ul>


        </div>
      </div>
    </div><br/><br/>
    <div class="text-center"></div>
              <div class="login-area" style="width:320px;padding-top:20px;margin-top:0">
<form name="edit" method="POST" action="">


   <div class="form-group">
<label>Username</label>
<input class="form-control" type="text" name="username"/></div>

   <div class="form-group">
<label>Saldo</label>
<input class="form-control" type="text" name="saldo"/></div>
  <div class="multi-select-full">
<label>Details</label>
:<select class="form-control" name="detail">
   <option value="Top UP by Admin [PULSA]">Pulsa</option>
   <option value="Top UP by Admin [BANK]">Bank</option>

</select>
</div>
<input type="submit" name="submit" value="Simpan" />
<input type="reset" name="reset" value="Reset"/></td>

</table>
</form>
</div>
<?php
include "db/koneksi.php";
$tanggal = gmdate("d-m-Y H:i:s", time()+60*60*7);
if(!empty($_POST['username'])){

$username1 = $_POST['username'];
$saldo = $_POST['saldo'];
$detail = $_POST['detail'];
/* Mengambil Data Dari Member Auto Tweet. */

$cand2 = mysql_query("SELECT * FROM users WHERE username='$username1'");
if(mysql_num_rows($cand2) > 0){
$data2 = mysql_fetch_array($cand2);
$balancenya = $data2['balance'];
$se = $data2['sebelum'];
$total = $balancenya + $saldo;

$a = mysql_query("update users set balance='$total' where username='$username1'");
$b = mysql_query("INSERT into payments(user_id,amount,details,created) VALUES('$username1','$saldo','$detail','$tanggal')");
    header("Location: ./tambah.php?sukses=input");
} else
{
header("Location: ./tambah.php?error=Vk");
}
    }

?>

<?php

$datawk= mysql_query("SELECT * FROM users order by id");
while($hasilwk= mysql_fetch_array($datawk)){
$saldowk = $hasilwk['balance'];

$totalwk+=$saldowk;
}
$BatasAwal = 50;
if (!empty($_GET['page'])) {
$hal = $_GET['page'] - 1;
$MulaiAwal = $BatasAwal * $hal;
} else if (!empty($_GET['page']) and $_GET['page'] == 1) {
$MulaiAwal = 0;
} else if (empty($_GET['page'])) {
$MulaiAwal = 0;
}//tampil data
$query = mysql_query("SELECT * FROM payments LIMIT $MulaiAwal , $BatasAwal");
?><h2>Tambah Pembayaran</h2>
<table class="table table-striped table-bordered">
    <thead>
        <tr>
            <th>No</th>
<th>Username</th>

<th>Saldo Saat ini</th>
<th>Jumlah</th>
<th>Detail</th>
<th>Tanggal</th>

        </tr>
    </thead>
    <tbody>
<?php
$BatasAwal = 50;
if (!empty($_GET['page'])) {
$hal = $_GET['page'] - 1;
$MulaiAwal = $BatasAwal * $hal;
} else if (!empty($_GET['page']) and $_GET['page'] == 1) {
$MulaiAwal = 0;
} else if (empty($_GET['page'])) {
$MulaiAwal = 0;
}//tampil data

$query = mysql_query("SELECT * FROM payments order by id DESC LIMIT $MulaiAwal , $BatasAwal");

?><h2>Edit Pembayaran</h2>
<h2>TOTAL SALDO MEMBER Rp.<?php echo"$saldowk";?> </h2>
<table class="table table-striped table-bordered">
    <thead>
        <tr>
            <th>No</th>
<th>Username</th>
<th>Saldo</th>
<th>Jumlah</th>
<th>Sebelum</th>

<th>Sesudah</th>
<th>Detail</th>
<th>Tanggal</th>

        </tr>
    </thead>
    <tbody>
    <?php

    $no = 1;
    while ($data = mysql_fetch_array($query)) {
    $username = $data['user_id'];
$balance = $data['details'];
$role = $data['created'];
$pass = $data['amount'];
$cand662 = mysql_query("SELECT * FROM users WHERE username='$username' order by id desc");
while ($data662 = mysql_fetch_array($cand662)) {
$balance66 = $data662['balance'];
$se66 = $data662['sebelum'];
$su66 = $data662['spent'];
    ?>
        <tr>
<td><?php echo"$no";?></td>
 <td><?php echo"$username";?></td>
   <td><?php echo"$balance66";?></td>
  <td><?php echo"$pass";?></td>
 <td><?php echo"$se66";?></td>

  <td><?php echo"$su66";?></td>
 <td><?php echo"$balance";?></td>
 <td><?php echo"$role";?></td>


        </tr>
    <?php
        $no++;
    }}
    ?>
    </tbody>
</table>