sat/questionsAndChoicesAPI.php at main · dodosi/sat · GitHub

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
<?php
include 'connect.php';
$group=$_GET['group'];
//$querry = "SELECT question.row_counter, question.name, question.title, question.type, choice.question_name, choice.choice_name, question.is_required, question.flag, question.description ,question.groupe,question.category,question.visible_if,question.show_other FROM question, choice" . " WHERE choice.question_name = question.name";
$querry = "SELECT question.row_counter, question.name, question.title, question.type, choice.question_name, choice.choice_name, question.is_required, question.flag, question.description ,question.groupe,question.category,question.visible_if,question.show_other,data_capture
FROM question, choice WHERE choice.question_name = question.name and choice.question_name = question.name and groupe LIKE '%$group%' ORDER BY row_counter ASC";
if($group=='ADMIN'){
    $querry = "SELECT question.row_counter, question.name, question.title, question.type, choice.question_name, choice.choice_name, question.is_required, question.flag, question.description ,question.groupe,question.category,question.visible_if,question.show_other,data_capture FROM question, choice WHERE choice.question_name = question.name ORDER BY row_counter ASC";
}
//echo $querry;
$result = $connect->query($querry);

$output = array('data' => array());

if ($result->num_rows > 0) {
    while ($row = $result->fetch_array()) {
        $deleteLink = '<a href="deleteQuestionAndChoice.php?name=' . $row[1] . '">Delete</a>';
        $updateLink = '<a href="updateQuestionAndChoice.php?row_counter=' . $row[0] . '&name=' . $row[1] . '&title=' . $row[2] . '&type=' . $row[3] . '&question_name=' . $row[4] . '&choice_name=' . $row[5] . '&is_required=' . $row[6] .'&flag=' . $row[7] .'&description=' . $row[8] .'&groupe=' . $row[9] .'&category=' . $row[10] .'&visible_if=' . $row[11].'&question=' . $row[12].'&data_capture=' . $row['data_capture'].'">Update</a>';
        $linksColumn = $deleteLink . ' | ' . $updateLink;
        $output['data'][] = array(
            $row[0],
            $row[1],
            $row[2],
            $row[3],
            $row[4],
            $row[5],
            $row['groupe'],
            $row['flag'],
            $row['data_capture'],
            $linksColumn
        );
    }
}

$connect->close();

echo json_encode($output);
?>