- Messages
- 1
- Reaction score
- 0
- Points
- 16
Magandang umaga po, patulong sana sa code ko hindi ko kasi mapagana gusto ko sanang mag update sa isang field na naka table
ang kelangan ko po kasi dapat bago maging clickable ung Confirm Order e ma update muna ung Sales_Invoice_Number ng order ang problema di ko ma update ung Sales_invoice_number
eto ung update_sir.php ko mga sir
Code:
<tr>
<td><?php echo $product_row['name']; ?></td>
<td><?php echo $member_row['Firstname']." ".$member_row['Lastname']; ?></td>
<td><?php echo $cart_row['price']; ?></td>
<td><?php echo $cart_row['qty']; ?></td>
<td><?php echo $cart_row['total']; ?></td>
<td><?php echo $cart_row['status']; ?></td>
<td><?php echo $cart_row['modeofpayment']; ?></td>
<form action="update_sir.php" method="get">
<td ><input type="text" name="sales_invoice_number"> <input type="submit" value="Confirm"></td>
</form>
<td><?php echo $cart_row['date'];?></td>
<td width="140"><a href="update_status.php<?php echo '?id='.$order_id; ?>" class="btn btn-success"><i class="fa fa-check"></i> Confirm Order</a></td>
</tr>
eto ung update_sir.php ko mga sir
Code:
<?php
include('connect.php');
$sir = $_GET["sales_invoice_number"];
mysql_query("update order_details set sales_invoice_number ='$sir' where orderid='$get_id'")or die(mysql_error());
header('location:orders.php');
?>
Last edited: