-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcinsert.php
145 lines (135 loc) · 7.41 KB
/
cinsert.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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
<?php include('header.php'); ?>
<style>
.button{
background: transparent;
border: none;
outline: none;
color: #fff;
background: #00cc00;
padding: 10px 20px;
cursor: pointer;
border-radius: 6px;
height: 40px;
width: 200px;
font-size: 25px;
}
.com{
border-radius: 6px;
height: 40px;
width: 300px;
}
#combbrief{
border-radius: 6px;
}
</style>
<br>
<div id="services" class="services-area area-padding">
<div class="container">
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="section-headline services-head text-center">
<h2>ONLINE-COMPLAINS</h2><br>
<p>At Sangath, we strive very hard to make your experience very pleasant and satisfactory but still if you are not happy with our service, we would most willingly like to sort it as soon as possible. Leave your complaint here and we will look in to it.</p><br>
for Rental Enquiry call : +91 7359865986 or Submit your requirements below.
</div>
<br>
<h3><span style="color: green">
<?php
$projname=$_POST['comProj'];
$houseno=$_POST['comHno'];
$dateofpuss=$_POST['comDatePoss'];
$cname=$_POST['comName'];
$cemail=$_POST['comEmail'];
$cphone=$_POST['comPhone'];
$cstatus=$_POST['comStatus'];
$contype=$_POST['comType'];
$condetails=$_POST['comDetail'];
$cpriority=$_POST['comPriority'];
$combrief=$_POST['comDesc'];
$csolutiontime=$_POST['comTime'];
$cimg=$_POST['comFile'];
$con = mysqli_connect('localhost','root','','sas_db');
$quy = "INSERT INTO `complains`(`cprojectname`, `chouseno`, `cpossdate`, `cname`, `cemail`, `ccontactno`, `cstatus`, `ctype`, `cdetail`, `cpriority`, `cinbrief`, `csolutiontime`, `cimg`) VALUES ('$projname','$houseno','$dateofpuss','$cname','$cemail','$cphone','$cstatus','$contype','$condetails','$cpriority','$combrief','$csolutiontime','$cimg')";
$run = mysqli_query($con,$quy);
if ($run == TRUE)
{
echo "*Comaplin is Submitted. -><a href='complain.php'>Comaplain-Form</a>.....*";
}
else
{
echo "Error! In Insertion";
}
?>
</span></h3>
<br>
<div>
<form action="cinsert.php" method="post" name="ComplainRegistration">
<table width="1000px" height="1000px" align="center">
<tr>
<td>Project Name <span style="color: red;">*</span></td>
<td><input type="radio" name="comProj" value="tarres" id=""/>Terras <input type="radio" name="comProj" value="Pure" id=""/>Pure <input type="radio" name="comProj" value="posh" id=""/>POSH <input type="radio" name="comProj" value="other" id=""/>Other</td>
</tr>
<tr>
<td>House Number <span style="color: red;">*</span></td>
<td><input type="number" name="comHno" class="com" size="22" required/></td>
</tr>
<tr>
<td>Date Of Possession<span style="color: red;">*</span></td>
<td>Customer Name<span style="color: red;">*</span></td>
</tr>
<tr>
<td><input type="date" name="comDatePoss" class="com" size="22" required/></td>
<td><input type="text" name="comName" id="" class="com" required/></td>
</tr>
<tr>
<td>Customer Email<span style="color: red;">*</span></td>
<td>Customer Phone Number <span style="color: red;">*</span></td>
</tr>
<tr>
<td><input type="email" name="comEmail" class="com" size="22" required/></td>
<td><input type="number" name="comPhone" class="com" required/></td>
</tr>
<tr>
<td>Status Of the Customer <span style="color: red;">*</span></td>
<td><input type="radio" name="comStatus" value="owner" id=""/>Owner <input type="radio" name="comStatus" value="tenent" id=""/>Tenent</td>
</tr>
<tr>
<td>Type Of the Complain <span style="color: red;">*</span></td>
<td><input type="radio" name="comType" value="personal" id=""/>Personal <input type="radio" name="comType" value="common" id=""/>Common</td>
</tr>
<tr>
<td>Complain Details <span style="color: red;">*</span></td>
<td><input type="radio" name="comDetail" value="Plumbing" id=""/>Plumbing <input type="radio" name="comDetail" value="Electrical" id=""/>Electrical <input type="radio" name="comDetail" value="Mech" id="">Mechanical <input type="radio" name="comDetail" value="waterproofing" id="">Water Proofing
<input type="radio" name="comDetail" value="other" id="">Other </td>
</tr>
<tr>
<td>Priority <span style="color: red;">*</span></td>
<td><input type="radio" name="comPriority" value="high" id=""/>High <input type="radio" name="comPriority" value="medium" id=""/>Medium <input type="radio" name="comPriority" value="low" id="">Low</td>
</tr>
<tr>
<td>Complain in Brief <span style="color: red;">*</span></td>
<td><textarea name="comDesc" id="combbrief" cols="50" rows="8"></textarea></td>
</tr>
<tr>
<td>Suitable Time For Solution <span style="color: red;">*</span></td>
<td>
<input type="radio" name="comTime" value="10 to 12 PM" id=""/>10 to 12 PM <input type="radio" name="comTime" value="10 to 10 AM" id=""/>10 to 12 AM <br> <input type="radio" name="comTime" value="1 to 3 PM" id="">1 to 3 PM <input type="radio" name="comTime" value="3 to 6 PM" id="">3 to 6 PM <br>
<input type="radio" name="comTime" value="other" id="">Other
</td>
</tr>
<tr>
<td>If Possible uplod IMAGE of Problem Complain <span style="color: red;">*</span></td>
<td><input type="file" name="comFile" class="com"></td>
</tr>
<tr>
<td><input type="reset" name="ComplainRegister1" value="Reset" class="button" /></td>
<td><input type="submit" name="ComplainRegister" value="ADD Them" class="button" /></td>
</tr>
</table>
</form>
</div>
</div>
</div>
</div>
</div>
<?php include('footer.php'); ?>