Repository navigation
Expand file tree
/
Copy pathdisplay_question.php
More file actions
57 lines (45 loc) · 1.63 KB
/
Copy pathdisplay_question.php
File metadata and controls
57 lines (45 loc) · 1.63 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
<?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_question();
}
$qid = $_GET["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["askerID"] = $question['ASKER'];
$params["askerName"] = $db->get_user_name_by_id($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]["ID"];
$params["replies"][$i]["replyName"] = $replies[$i]["USER_NAME"];
$params["replies"][$i]["timeStamp"] = $replies[$i]["DATE_TIME"];
$params["replies"][$i]["answerContent"] = $replies[$i]["TEXT"];
$params["replies"][$i]["votes"] = $replies[$i]["VOTEUP"]-$replies[$i]["VOTEDOWN"];
}
// echo "<pre>";
// print_r($params);
// echo "</pre>";
echo $twig->render('question.html',$params);
?>