Project Report of Electricity Billing System
Page - 112
value=""/>
Total Units
id="bill_total_units" type="text" required value=""/>
Charge Per Unit
name="bill_charge_per_unit" id="bill_charge_per_unit" type="text" required
value=""/>
Fix Charges
id="bill_fix_charges" type="text" required value=""/>
Project Report of Electricity Billing System
Page - 113
Tax
id="bill_tax" type="text" required value=""/>
Final Amount
id="bill_final_amout" type="text" required value=""/>
Description
cols="" rows="6" required>
Project Report of Electricity Billing System
Page - 114
value="Submit" >
>
value="">
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);
Project Report of Electricity Billing System
Dostları ilə paylaş: |
