Permisi Para mastah programmer, mohon pencerahannya , bagaimana ya cara mengupdate tipe data enum supaya berubah ketika kita klik button?
Kok pake script saya tidak bisa ya
Quote:
<form action="orders_act.php" method="POST">
<div class="table-responsive">
<table class="table table-striped b-t b-light">
<thead>
<tr>
<th>No</th>
<th>Tanggal Order</th>
<th>Kode Order</th>
<th>Reseller</th>
<th>Alamat Kirim</th>
<th>QTY</th>
<th>Total Harga</th>
<th>Pengiriman</th>
<th></th>
<th style="width:30px;"></th>
</tr>
</thead>
<tbody>
<?php
if(isset($_GET['cari'])){
$cari= mysqli_real_escape_string($db, $_GET['cari']);
$sw = $db->query("SELECT* from det_payment where kd_orders like '$cari' or kd_member like '$cari'");
}
elseif(isset($_GET['status'])){
$status= mysqli_real_escape_string($db, $_GET['status']);
$sw = $db->query("SELECT* from det_payment where status_pay='$status'");
}
else{
$sw = $db->query("SELECT * from det_payment ORDER BY tgl DESC");
}
$no=1;
while ($b = $sw->fetch_array()) {
?>
<tr>
<input name="kd_orders" id="kd_orders" type="text" hidden="" value="<?php echo $b['kd_orders']?>">
<td><?php echo $no++ ?>.</td>
<td><?php echo $b['tgl'] ?></td>
<td ><a href="../reseller/inv.php?orders=<?php echo $b['kd_orders']?>" target="_blank"><font color="bolt">#<?php echo $b['kd_orders']?></font></a></br>
(<?php echo $b['status_pay']?> )
</td>
<td><?php echo $b['nm_reseller'] ?></br>
Username : <?php echo $b['email_tagihan'] ?></br>
ID : <?php echo $b['kd_member'] ?>
</td>
<td><?php echo $b['alamat_kirim'] ?></br>
<?php echo $b['kota_kirim'] ?>
</td>
<td><?php echo $b['qty'] ?></td>
<td>Rp <?php echo number_format($b['total_pay']) ?></td>
<td><?php echo strtoupper($b['jenis_kurir']) ?></br>
<?php echo $b['type_kurir'] ?></br>
Rp <?php echo number_format($b['harga_kurir']) ?>
</td>
<td>
<input type="submit" name="lunas" class="btn btn-info" value="Lunas">
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</form>
Untuk actionnya :
Quote:
<?php
include 'config.php';
$kd_orders=$_POST['kd_orders'];
if (isset($_POST['lunas'])){
mysqli_query($db,"update det_payment set status_pay='Lunas' where kd_orders='$kd_orders'");
header("location: orders.php");
}
header("location: orders.php");
?>
Struktur table det_payment :
Isi table det_payment :
Terima kasih pencerahannya para mastah
