-
Notifications
You must be signed in to change notification settings - Fork 1
/
contact_us.php
100 lines (100 loc) · 3.84 KB
/
contact_us.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
<!-- DOCUMENTS BEGINS HERE -->
<!DOCTYPE html>
<html lang = 'en'>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>Carbnb - Car Rentals</title>
<!-- Stylesheet can be edited at css/contact_style.css -->
<link href="css/contact_style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<main class ='main'>
<!-- Edit NavBar at assets/navbar.php -->
<?php include('assets/navbar.php') ?>
<!-- Page content begins here -->
<div class = 'center'>
<div id= "carform">
<br>
<br>
<h1 class = "formhead">Contact Us</h1>
<br>
<br>
<!-- Form to get complaints or feedback or queries begins here -->
<form action = "" method = "post">
<!-- Entering Full Name -->
<input type = "text" name = "fullname" id = "name" placeholder="Name"><br>
<!-- Entering Email ID -->
<input type = "email" name = "email" id="email" placeholder="Email"><br>
<!-- Entering Phone Number -->
<input type = "text" name = "phno" id="phno" placeholder="Phone No"><br>
<!-- Entering Location -->
<select name="location" id = "location">
<option value="select" selected disabled hidden>Location</option>
<option value="Kolkata">Kolkata</option>
<option value="Chennai">Chennai</option>
<option value="Mumbai">Mumbai</option>
<option value="Delhi">Delhi</option>
</select><br>
<!-- Entering Review Type -->
<select name="reviewType" id = "reviewType">
<option value="select" selected disabled hidden>Review Type</option>
<option value="Query">Query</option>
<option value="Suggestions">Suggestions</option>
<option value="Complaint">Complaint</option>
</select><br><br>
<!-- Entering Description of their Feedback -->
<textarea placeholder="Enter your Review" name = "reviewdesc" id="textarea" rows='10' cols='40'></textarea>
<br><br>
<!-- Submitting the form -->
<input type="submit" name = "submit" value="Submit">
</form>
<!-- Form ends here -->
<br><br>
<p>2021 © Carbnb. All rights reserved.<br><br></p>
</div>
</div>
</main>
<!-- Page content ends here -->
</body>
</html>
<!-- HTML Content ends here -->
<!-- PHP Code begins -->
<?php
//Connecting to the database
$conn = mysqli_connect('localhost','root','','carbnb');
//Action when 'Submit' button is clicked
if(isset($_POST['submit']))
{
//Getting values from the input fields
$fullname = $_POST['fullname'];
$email = $_POST['email'];
$phone = $_POST['phno'];
$location = $_POST['location'];
$reviewType = $_POST['reviewType'];
$reviewDesc = $_POST['reviewdesc'];
$status = "OPEN";
if($reviewType == 'Query')
{
$a_id = "1";
}
elseif($reviewType == 'Suggestions')
{
$a_id = "2";
}
else
{
$a_id = "3";
}
//SQL Query to insert all these data as a row into the feedback table
$sql = "INSERT INTO feedback(NAME, EMAIL, PHONENUMBER, LOCATION, REVIEW_TYPE, DESCRIPTION, STATUS, A_ID) VALUES ('$fullname','$email','$phone','$location','$reviewType','$reviewDesc','$status','$a_id')";
//Executing the Query
$res = mysqli_query($conn, $sql) or die(mysqli_error($conn));
//Message displayed when the process is successful
if($res == TRUE)
{
echo '<script>alert("Your feedback has been submitted successfully!")</script>';
}
}
?>
<!-- END OF DOCUMENT -->