-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathBill_generate_insert.php
29 lines (24 loc) · 1.22 KB
/
Bill_generate_insert.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<?php
$connection = mysqli_connect("localhost", "root", "","sas_db");
$data = json_decode(file_get_contents("php://input"));
if(count($data) > 0){
$title = mysql_real_escape_string($data->txtBtitle);
$desc = mysql_real_escape_string($data->txtBdesc);
$fdate = mysql_real_escape_string($data->txtFdate);
$ddate = mysql_real_escape_string($data->txtDuedate);
$month = mysql_real_escape_string($data->txtbMonth);
$socname = mysql_real_escape_string($data->txtSocbname);
$amount = mysql_real_escape_string($data->txtAdetails);
$text1 = mysql_real_escape_string($data->txtText1);
$text2 = mysql_real_escape_string($data->txtText2);
$discount = mysql_real_escape_string($data->txtDisbillamt);
$tamt = mysql_real_escape_string($data->txtFfinalAmt);
$query = "INSERT INTO `maintenance_bill`(`bill_title`, `bill_description`, `bill_fdate`, `bill_ddate`, `bill_month`, `bill_society_name`, `bill_amount`, `bill_text_amount`, `bill_text2_amount`, `bill_discount_amount`, `bill_total_amount`) VALUES ('".$title."','".$desc."','".$fdate."','".$ddate."','".$month."','".$socname."','".$amount."','".$text1."','".$text2."','".$discount."','".$tamt."')";
if (mysqli_query($connection,$query)) {
echo "Bill Form is Generated .!";
}
else{
echo "ERROR!";
}
}
?>