-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathraise-request.php
102 lines (87 loc) · 2.42 KB
/
raise-request.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
<?php
/**
* @Author: Prabhakar Gupta
* @Date: 2016-02-16 01:57:09
* @Last Modified by: Prabhakar Gupta
* @Last Modified time: 2016-02-20 07:02:59
*/
require_once 'inc/connection.inc.php';
require_once 'inc/func.inc.php';
if(isset($_POST['request'])){
$request = clean_string($_POST['request']);
/**
* to check if the request is made by some
* logged in user or if it is anonymous
*/
if(loggedin()){
$sender_id = (int)($_SESSION['id']);
} else {
$sender_id = 0;
}
$query = "INSERT INTO `requests_raised` (`sender_id`,`request`) VALUES ('$sender_id','$request')";
if(mysqli_query($connection, $query)){
$error = false;
$error_message = "Request has been successfully logged";
} else {
$error = true;
if(stripos(mysqli_error($connection), 'duplicate') == FALSE){
$duplicate_flag = true;
$error_message = "This request has already been raised earlier, either resolved else it would be resolved soon!";
} else {
$duplicate_flag = false;
$error_message = "Some technical glitch, try again later!";
}
}
}
?>
<!DOCTYPE html>
<html>
<head>
<?php
include 'layout/meta.inc.php';
?>
</head>
<body class="skin-black">
<?php
include 'layout/header.inc.php';
?>
<div class="wrapper row-offcanvas row-offcanvas-left">
<?php
include 'layout/leftpanel.inc.php';
?>
<aside class="right-side">
<section class="content">
<div class="row" style="margin-bottom:5px;">
<div class="col-lg-8 col-lg-offset-2">
<?php
if(isset($error)){
$panel_color = ($error) ? 'danger' : 'success';
echo '<div class="alert alert-' . $panel_color . '">
<button data-dismiss="alert" class="close close-sm" type="button">
<i class="fa fa-times"></i>
</button>' . $error_message . '
</div>';
}
?>
<section class="panel">
<header class="panel-heading">Raise a Request</header>
<div class="panel-body">
<form method="POST" role="form">
<div class="form-group">
<label>Request Message <small>(eg.- agriculture)</small></label>
<textarea name="request" rows="3" class="form-control" placeholder="Enter your request message here..."></textarea>
</div>
<button type="submit" class="btn btn-info">Submit</button>
</form>
</div>
</section>
</div>
</div>
</section>
</aside>
</div>
<?php
include 'layout/scripts.inc.php';
?>
</body>
</html>