-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathrental_insert_op.php
33 lines (26 loc) · 1.26 KB
/
rental_insert_op.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
30
31
32
33
<?php
$connection = mysqli_connect("localhost", "root", "","sas_db");
$data = json_decode(file_get_contents("php://input"));
if(count($data) > 0){
$name = mysql_real_escape_string($data->tName);
$email = mysql_real_escape_string($data->tEmail);
$con = mysql_real_escape_string($data->tContact);
$pro = mysql_real_escape_string($data->tProffesion);
$hno = mysql_real_escape_string($data->tThno);
$bno = mysql_real_escape_string($data->tBlockno);
$society = mysql_real_escape_string($data->tSocName);
$add = mysql_real_escape_string($data->tresAddress);
$pass = mysql_real_escape_string($data->txtPass);
$sdate = mysql_real_escape_string($data->taggStartdate);
$duedate = mysql_real_escape_string($data->taggDuedate);
$rate = mysql_real_escape_string($data->tRate);
$skinfo = mysql_real_escape_string($data->tSpecinfo);
$query = "INSERT INTO `rental`(`rname`, `remail`, `rcontact`, `rproffesion`, `rhouse`, `rblock`, `rsociety`, `rfulladd`, `rafdate`, `raddaate`, `rrate`, `rspecinfo`, `rpass`) VALUES ('".$name."','".$email."','".$con."','".$pro."','".$hno."','".$bno."','".$society."','".$add."','".$pass."','".$sdate."','".$duedate."','".$rate."','".$skinfo."')";
if (mysqli_query($connection,$query)) {
echo "Reantal IS Registered Successfully";
}
else{
echo "ERROR!";
}
}
?>