generate.php

<?php
/**
 * Created by PhpStorm.
 * User: quyentruong
 * Date: 6/9/16
 * Time: 12:47 PM
 */
define("maxvalue", 5);
function mysql_connection()
{
    $password = "XXX";
    $dsn = 'mysql:dbname=usCitizenTest;host=vergil.u.washington.edu;port=XXX;
        charset=utf8';
    return new PDO($dsn, "root", $password);
}

function generate_choices()
{

    // connect to multiple_choices
    try {
        $db = mysql_connection();
    } catch (PDOException $e) {
        die('Could not connect to the database:<br/>' . $e);
    }
    $questions = $db->query("SELECT * FROM questions ORDER BY id"); // get question title
//        $questions = $questions->fetchAll();
//        print_r($questions);
    //    $n = (int)$number_of_questions->fetchColumn();
    //    echo gettype($n);
    $i = 1; ?>
    <div class="container">
        <div class="row">
            <?php
            $count = 1;
            foreach ($questions as $question) {
                //    for ($i = 0; i < $n; $i++) {
                $letter = array("A", "B", "C", "D", "E");
                $id = $db->quote($i);
                // choice for English
                // choice_vi for Vietnamese
                $choices = $db->query("SELECT answer_id,choice_vi,choice FROM choices
                                                WHERE question_id = $id");
                $choices = $choices->fetchAll(); // object -> array
                shuffle($choices); ?>
                <div id="<?= $count ?>" class="hide_words btn-group btn-group-vertical
                col-lg-12 col-md-12 col-sm-12 col-xs-12" data-toggle="buttons">
                    <h2 id="q_en" class="question_class"><?= $i . ") " ?>
                        <!-- question for English
                        // question_vi for Vietnamese -->
                        <span class="show_vi hide_words"> <?= $question["question_vi"] ?></span>
                        <span class="show_en"> <?= $question["question"] ?> </span>
                        <!-- speaker -->
                        <audio class="audio" src="<?= $question["audio"] ?>"></audio>
                        <button name="play_<?= $i - 1 ?>" type="button" class="btn btn-info play_audio"><span
                                class="glyphicon glyphicon-volume-up"></span>
                        </button>
                    </h2>
                    <?php
                    $j = 0;
                    foreach ($choices as $choice) {
                        $q_id = $choice["answer_id"]; // this is the answer id
                        $ch_vi = $choice["choice_vi"]; // get choice vietnamese
                        $ch = $choice["choice"]; // get choice english
                        ?>

                        <div class="form-group">
                        <div class="radioo" type="radio" name="question-<?= $i ?>-answers"
                               value="<?= $q_id . "_" . $question["answer"] ?>">
                            <?= $letter[$j++] . ") "?>
                            <span class="show_vi hide_words"> <?= $ch_vi ?> </span>
                            <span class="show_en"> <?= $ch ?></span>

                        </div> </div>
                        <?php
                    }
                    $i++;
                    $count++;?>
                </div>
                <?php
            } ?>
        </div>
    </div>
    <?php
    $db = null;
} ?>