-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpost_reply.php
More file actions
67 lines (55 loc) · 1.92 KB
/
Copy pathpost_reply.php
File metadata and controls
67 lines (55 loc) · 1.92 KB
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
<?php
session_start();
require_once 'vendor/autoload.php';
require_once 'db.php';
$loader = new Twig_Loader_Filesystem('views');
$twig = new Twig_Environment($loader, array());
$db = new db;
$db->connect();
if(isset($_POST['submit']))
{
post_reply();
}
function post_reply(){
global $db;
//$replyID = $db->post_question($_SESSION['id'],$_REQUEST['QuestionTitle'],$_REQUEST['QuestionBody']);
//echo $twig->render('ask.html',$params);
// sleep(10);
$replyID = $db->post_answer($_REQUEST['questionID'],$_REQUEST['answer'],$_SESSION['id']);
//sleep (10);
//show_question($_REQUEST['questionID']);
show_question($replyID);
}
function show_question($qid){
global $twig;
global $db;
$question = $db->get_question_by_id($qid);
$replies = $db->get_reply_by_question($qid);
/*echo "<pre>";
print_r($replies);
die();*/
$params = array();
$params["userName"] = $_SESSION['username'];
$params["questionID"] = $qid;
$params["questionTitle"] = $question['TITLE'];
$params["questionContent"] = $question['CONTENT'];
$params["dateTime"] = $question['DATE_TIME'];
//$params["askerName"] = $question['ASKER_NAME'];
$params["askerID"] = $question['ASKER'];
$params["votes"] = $question['VOTEUP'] - $question['VOTEDOWN'];
$params["numberAnswers"] = count($replies);
$params["replies"] = array();
for($i=0;$i<$params["numberAnswers"];$i++){
$params["replies"][$i] = array();
//$params["replies"][i]["answerVotes"] = array();
//$params["replies"][i]["replyID"] = $replies[i]["USER_ID"];
$params["replies"][$i]["replyName"] = $replies[$i]["USER_NAME"];
$params["replies"][$i]["timeStamp"] = $replies[$i]["DATE_TIME"];
$params["replies"][$i]["answerContent"] = $replies[$i]["TEXT"];
}
// echo "<pre>";
// print_r($params);
// echo "</pre>";
echo $twig->render('question.html',$params);
}
?>