Project Report of Electricity Billing System Page - 114
value="Submit" >
>
value="=$data[bill_id]?>">
Project Report of Electricity Billing System Page - 115 Coding for Billing-Confirmation.php include_once("includes/header.php");
/// Update the booking status /////
$date = date("F j, Y");
$SQL = "UPDATE bill SET bill_payment_status = 1, bill_payment_date = '$date' WHERE bill_id =
'$_REQUEST[bill_id]'";
$rs = mysql_query($SQL) or die(mysql_error());
/// Get the booking details /////
if($_REQUEST[bill_id])
{
$SQL="SELECT * FROM `bill`,`connection`,`user`,`month` WHERE bill_month = month_id
AND connection_customer_id = user_id AND bill_connection_id = connection_id AND bill_id =
$_REQUEST[bill_id]";
$rs=mysql_query($SQL) or die(mysql_error());
$data=mysql_fetch_assoc($rs);