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
|
<?php
require '../config.php';
require_once(TEMPLATES_PATH . "/header.php");
require_once(TEMPLATES_PATH . "/panel.php");
require_once(LIBRARY_PATH . "/functions.php");
if(session_set()) {
$conn = new PDO($config['db']['dsn'], $config['db']['username'], $config['db']['password']);
$query = $_POST['id'] == "" ?
$conn->prepare("INSERT INTO reports (author, title, description, bug) VALUES (:user_id, :title, :description, :bug_id)")
: $conn->prepare("UPDATE reports SET title=:title, description=:description, bug=:bug_id WHERE id=:report_id");
if($_POST['id'] == "") {
$query->bindParam(':user_id', $_SESSION['user_id']);
} else {
$query->bindParam(':report_id', $_POST['id']);
}
$query->bindParam(':title', $_POST['title']);
$query->bindParam(':description', $_POST['description']);
$query->bindValue(':bug_id', $_POST['bug_id'] == "" ? null : $_POST['bug_id']);
if($query->execute()) {
echo "<h2>report submitted</h2>";
} else {
echo "<h2>report failed to submit</h2>";
}
}
header("Refresh: 2; URL=$_SERVER[HTTP_REFERER]");
footer: require_once(TEMPLATES_PATH . "/footer.php");
?>
|
