Untitled

<?
if($_POST["action"] == "test"){

    $servername = "localhost";
    $username = "atomicwa_preview";
    $password = "*Pr3vi3w*";
    $dbname = "atomicwa_preview_advocate_health_assessment";

    $conn = mysqli_connect($servername, $username, $password, $dbname);
    if(!$conn){
        die("connection failed: " . mysqli_connect_error());
    }

    $QA = $_POST["QA"];
    $id_key = $_POST["key"];
    foreach($QA as $qa){
        $myq = $qa['question'];
        $mya = $qa['answer'];
        $sql = "SELECT * FROM QNA WHERE sID = '$id_key' AND qID = $myq";
        $result = $conn->query($sql);
        if($result->{"num_rows"} > 0){
            $sql = "UPDATE QNA SET aID = $mya WHERE sID = '$id_key' AND qID = $myq";
            $conn->query($sql);
        }
        else{
            $sql = "INSERT INTO QNA (sID, qID, aID) VALUES ('$id_key', $myq, $mya)";
            $conn->query($sql);
        }
    }

        $sql = "SELECT aID FROM QNA WHERE sID = '$id_key' ORDER BY aID";
        $result = $conn->query($sql);
        $answer_ids = array();
        while($row = $result->fetch_assoc()){
            array_push($answer_ids, $row["aID"]);
        }

        $in = join(',', array_fill(0, count($answer_ids), '?'));
$select = <<<SQL
SELECT *
FROM answers
WHERE aID IN ($in)
ORDER BY aID;
SQL;
        // var_dump($answer_ids);
        $answer_vals = array();
        $statement = $conn->prepare($select);
        $statement->bind_param(str_repeat('i', count($answer_ids)), ...$answer_ids);
        $statement->execute();
        $result = $statement->get_result();
        while($row = $result->fetch_assoc()){
            array_push($answer_vals, array("x"=> $row["axval"], "y"=> $row["ayval"]));
        }
        // var_dump($answer_vals);
        echo json_encode($answer_vals);


    die();
}
session_start();

$servername = "localhost";
$username = "atomicwa_preview";
$password = "*Pr3vi3w*";
$dbname = "atomicwa_preview_advocate_health_assessment";

$conn = mysqli_connect($servername, $username, $password, $dbname);
if(!$conn){
    die("connection failed: " . mysqli_connect_error());
}

$myQuestions = [];
$myAnswers = [];

$sql = "SELECT * FROM questions ORDER BY qID";
$result = $conn->query($sql);
    while($row = $result->fetch_assoc()){
        $question = array("qID" => $row["qID"],"qtext" => $row["qtext"]);
        array_push($myQuestions, $question);
    }

$sql = "SELECT * FROM answers ORDER BY aID";
$result = $conn->query($sql);
    while($row = $result->fetch_assoc()){
        $answer = array("qID" => $row["qID"], "aID" => $row["aID"], "atext" => $row["atext"], "axval" => $row["axval"], "ayval" => $row["ayval"] );
        array_push($myAnswers, $answer);
    }

for ($i = 0; $i < count($myQuestions); $i++){
    $myQuestions[$i]["answers"] = array();
    for ($j = 0; $j < count($myAnswers); $j++){
        if($myQuestions[$i]["qID"] == $myAnswers[$j]["qID"]){
            array_push($myQuestions[$i]["answers"], $myAnswers[$j]);
        }
    }
}
?>
 <head>
    <script src = "http://code.jquery.com/jquery-latest.js"></script>
 </head>
<?
echo "<table>";
for ($i = 0; $i <count($myQuestions); $i++){
    echo "<tr class = 'question'>";
    echo "<td>" . $myQuestions[$i]["qtext"] . "</td>";
        for($j = 0; $j < count($myQuestions[$i]["answers"]); $j++){
            echo "<td><input type='radio' name=" . $myQuestions[$i]["qID"]." value =". $myQuestions[$i]["answers"][$j]["aID"] . ">" . $myQuestions[$i]["answers"][$j]["atext"] . "</td>";
        }
    echo "</tr>";
}

?>
<table id= "xychart">
    <tr>
        <th>x</th>
        <th>y</th>
    </tr>
</table>
<script>
    var myquestions = <? echo  json_encode($myQuestions)?>;
    var mykey = "<? echo session_id() ?>";
    $(".question>td>input").change(function(){
        myQaArr = []
        $(".question>td>input:checked").each(function(){
            myqa = {"question" : $(this).attr("name"), "answer" : $(this).val() }
            myQaArr.push(myqa)

        })
        // console.log(myQaArr)

        $.ajax({
            method: "POST",
            data: {action: "test", QA : myQaArr, key: mykey},
            success: function(response){
                myresponse = JSON.parse(response);
                chart_array = []
                chart_array[0] = myresponse[0];
                for(i = 1; i<myresponse.length; i++){
                    chart_array.push({"x" : myresponse[i]["x"] + chart_array[i-1]["x"], "y" : myresponse[i]["y"] + chart_array[i-1]["y"]})
                }
                $(".chart_row").remove();
                for(i = 0;i<chart_array.length;i++){

                    $("#xychart").append("<tr class='chart_row'><td>"  + chart_array[i]["x"] + "</td><td>" + chart_array[i]["y"] + "</td></tr>")
                }
            }
        })

    })

</script>

<?
// SELECT QNA.sID, questions.qtext, answers.atext FROM QNA
//  join questions ON QNA.qID = questions.qID
//  join answers ON QNA.aID = answers.aID
//  ORDER BY sID
?>