-
Notifications
You must be signed in to change notification settings - Fork 0
/
add_review.php
113 lines (96 loc) · 4.03 KB
/
add_review.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
<?php
include 'inc/db.php';
session_start();
$user_id = $_SESSION['user_id'];
if (!isset($user_id)) {
header('location:login.php');
}
if (isset($_POST['add_review'])) {
$name = mysqli_real_escape_string($conn, $_POST['name']);
$review = mysqli_real_escape_string($conn, $_POST['review']);
$select_name = mysqli_query($conn, "SELECT name FROM `review` WHERE name = '$name'") or die('query failed');
if (mysqli_num_rows($select_name) > 0) {
$message[] = 'Review already added';
} else {
$add_query = mysqli_query($conn, "INSERT INTO `review`(name,review) VALUES('$name','$review')") or die('query failed');
if ($add_query) {
$message[] = 'Thanks for your review!';
header('location:testimonial.php');
} else {
$message[] = 'Something went wrong. Please try again!';
header('location:add_review.php');
}
}
}
?>
<?php
include "inc/header.php";
?>
<!-- Header Start -->
<div class="container-fluid bg-primary py-5 mb-5 page-header">
<div class="container py-2">
<div class="row justify-content-center">
<div class="col-lg-10 text-center">
<h1 class="display-3 text-white animated slideInDown">Add Your Review</h1>
<nav aria-label="breadcrumb">
<ol class="breadcrumb justify-content-center">
<li class="breadcrumb-item"><a class="text-white" href="#">Home</a></li>
<li class="breadcrumb-item"><a class="text-white" href="#">Pages</a></li>
<li class="breadcrumb-item text-white active" aria-current="page">Add Your Review</li>
</ol>
</nav>
</div>
</div>
</div>
</div>
<!-- Header End -->
<!-- Review Start -->
<div class="container-xxl">
<div class="container">
<div class="row g-5">
<div>
<?php
if (isset($message)) {
foreach ($message as $message) {
echo '<div class="message alert alert-success d-flex justify-content-between">
<span>' . $message . '</span>
<i class="fas fa-times" onclick="this.parentElement.remove();"></i>
</div>
';
}
}
?>
</div>
<div class="col-12 wow fadeInUp" data-wow-delay="0.3s">
<center>
<form method="POST" style="max-width:500px;">
<div class="row g-3">
<div class="col-12">
<div class="form-floating">
<input type="text" class="form-control" id="name" placeholder="Your Name"
name="name" value="<?php echo $_SESSION['user_name']; ?>" required>
<label for="name">Your Name</label>
</div>
</div>
<div class="col-12">
<div class="form-floating">
<textarea class="form-control" placeholder="Leave a review here" id="review"
style="height: 150px" name="review" required></textarea>
<label for="review"> Your Review</label>
</div>
</div>
<div class="col-12">
<button class="btn btn-primary w-100 py-3" name="add_review" type="submit">Add
Review</button>
</div>
</div>
</form>
</center>
</div>
</div>
</div>
</div>
<!-- Review End -->
<?php
include "inc/footer.php";
?>