Project Report of Electricity Billing System
Page - 48
Project Report of Electricity Billing System
Page - 49
Project Report of Electricity Billing System
Page - 50
Project Report of Electricity Billing System
Page - 51
Project Report of Electricity Billing System
Page - 52
Project Report of Electricity Billing System
Page - 53
Project Report of Electricity Billing System
Page - 54
Project Report of Electricity Billing System
Page - 55
Project Report of Electricity Billing System
Page - 56
Project Report of Electricity Billing System
Page - 57
Project Report of Electricity Billing System
Page - 58
Project Report of Electricity Billing System
Page - 59
Project Report of Electricity Billing System
Page - 60
Project Report of Electricity Billing System
Page - 61
Project Report of Electricity Billing System
Page - 62
Code of the Project
Electricity Billing
System
Project Report of Electricity Billing System
Page - 63
Coding for Bill.php
include_once("../includes/db_connect.php");
include_once("../includes/functions.php");
if($_REQUEST[act]=="save_bill")
{
save_bill();
exit;
}
if($_REQUEST[act]=="delete_bill")
{
delete_bill();
exit;
}
if($_REQUEST[act]=="update_bill_status")
Project Report of Electricity Billing System
Page - 64
{
update_bill_status();
exit;
}
###Code for save bill#####
function save_bill()
{
$R=$_REQUEST;
if($R[bill_id])
{
$statement = "UPDATE `bill` SET";
$cond = "WHERE `bill_id` = '$R[bill_id]'";
$msg = "Data Updated Successfully.";
}
else
Project Report of Electricity Billing System
Page - 65
{
$statement = "INSERT INTO `bill` SET";
$cond = "";
$msg="Data saved successfully.";
}
$SQL= $statement."
`bill_connection_id` = '$R[bill_connection_id]',
`bill_current_reading` = '$R[bill_current_reading]',
`bill_previous_reading` = '$R[bill_previous_reading]',
`bill_total_units` = '$R[bill_total_units]',
`bill_charge_per_unit` = '$R[bill_charge_per_unit]',
`bill_fix_charges` = '$R[bill_fix_charges]',
`bill_tax` = '$R[bill_tax]',
`bill_month` = '$R[bill_month]',
`bill_final_amout` = '$R[bill_final_amout]',
`bill_description` = '$R[bill_description]'".
|