forked from if-itb/IF3110-2015-T1
-
Notifications
You must be signed in to change notification settings - Fork 0
/
submitQuestions.php
56 lines (49 loc) · 1.5 KB
/
submitQuestions.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
<?php
// Nama : Ryan Yonata
// NIM : 13513074
// Nama file : delete.php
// Keterangan : Berisi kode php untuk memasukkan pertanyaan ataupun mengeditnya dari database
function RedirectToHome($url, $permanent = false)
{
header('Location: ' . $url, true, $permanent ? 301 : 302);
exit();
}
function RedirectToAnswers($url, $permanent = false)
{
header('Location: ' . $url, true, $permanent ? 301 : 302);
exit();
}
//SubmitQuestions.php
include('ConnectDatabase.php');
include('stringProcessing.php');
date_default_timezone_set("Asia/Bangkok");
$Name = htmlspecialchars($_POST["name"]);
$Email = htmlspecialchars($_POST["email"]);
$Topic = htmlspecialchars($_POST["topic"]);
$Temp_Content = htmlspecialchars($_POST["content"]);
$Content = getValidString($Temp_Content);
$Today = date("Y-m-d G:i:s");
$id = $_GET['id'];
if ($id == 0)
{
$input = "INSERT INTO Questions (`Name`, `Email`, `Topic`, `Content`, `Date_Created`) VALUES ('$Name','$Email', '$Topic','$Content', '$Today')";
}
else {
$input = "UPDATE Questions SET Name = '$Name', Email = '$Email', Topic = '$Topic', Content = '$Content', Date_Created = '$Today' WHERE ID = '$id' ";
}
if ($conn->query($input) === TRUE)
{
//echo "New record created successfully";
} else {
echo "Error: " . $input . "<br>" . $conn->error;
}
echo $id;
if ($id == 0)
{
RedirectToHome('home.php', false);
} else {
$AnswerPage = "Answers.php?id=".trim($id);
RedirectToAnswers($AnswerPage, false);
}
$conn->close();
?>