<?php
$db = mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name, $db);
$sid = mysql_real_escape_string($_GET['sid']);
$les = mysql_real_escape_string($_GET['les']);

if (!isset($do) or empty($do))
{
    if (!isset($sid) or empty($sid))
    {
        include('exe/error.php');
    }
    else
    {
        if (!empty($sid) and !empty($les))
        {
            echo "<p class='pagename'>редактирование теста</p>";
            echo "<form action='?page=edit&do=edit' method='post'>";
            echo "<table class='add'>
            <tr>
            <td class='td40'><label for='id_sub'>Выберите название предмета и номер лекции</label></td>
            <td class='td60'>
            <select class='td50' name='id_sub' id='id_sub' size='1'>";
            $result_sub = mysql_query("SELECT * FROM test_lessons WHERE id_sub='$sid'");
            $myrow_sub = mysql_fetch_array($result_sub);
            echo "<option selected value='" . $myrow_sub['id_sub'] . "'>" . $myrow_sub['name'] . "</option>";
            $result_sub_all = mysql_query("SELECT * FROM test_lessons WHERE id_sub!='$sid'");
            $myrow_sub_all = mysql_fetch_array($result_sub);
            if (empty($myrow_sub_all))
            {
                echo "</select>";
            }
            else
            {
                do
                {
                    printf("<option value='%s'>%s</option>", $myrow_sub_all['id_sub'], $myrow_sub_all['name']);
                }
                while ($myrow_sub_all = mysql_fetch_array($result_sub_all));
                echo "</select>";
            }
            echo "<select class='td30' name='id_lesson' size='1'>";
            echo " <option selected value='$les'>Лекция № $les</option>
            <option value='1'>Первая лекция</option>
            <option value='2'>Вторая лекция</option>
            <option value='3'>Третья лекция</option>
            <option value='4'>Четвертая лекция</option>
            <option value='5'>Пятая лекция</option>
            <option value='6'>Шестая лекция</option>
            <option value='7'>Седьмая лекция</option>
            <option value='8'>Восьмая лекция</option>
            <option value='9'>Девятая лекция</option>
            <option value='10'>Десятая лекция</option>
            <option value='11'>Одиннадцатая лекция</option>
            <option value='12'>Двенадцатая лекция</option>
            </select>";

            $result = mysql_query("SELECT * FROM test_quest WHERE id_sub=$sid and id_lesson=$les ORDER by id", $db);
            $num = 1;
            while ($myrow = mysql_fetch_array($result))
            {
                echo "<tr><td><label for='question$n'> Введите $num вопрос</label></td><td>

                <input class='td80' type='text' name='question[$myrow[id]][question]' id='question$num' value='$myrow[question]'/>";
                echo "<table class='variant'>";
                $result1 = mysql_query("SELECT * FROM test_answers WHERE q_id='$myrow[id]'", $db);
                $num1 = 1;
                while ($myrow1 = mysql_fetch_array($result1))
                {
                    echo "
                    <tr>
                    <td class='td40'>$num1 ответ (a)</td>
                    <td class='td60'><input class='td60' type='text' name='question[$myrow[id]][answer][$myrow1[id]]' id='a" . $num1 . "_question" . $num . "' value='$myrow1[answer]'/>
                    </tr>";
                    $num1 ++;
                }
                mysql_free_result($result1);
                echo "
                <tr>
                <td class='td40'>Правильный ответ</td>
                <td class='td60'>
                <table class='td60'>
                <tr>";

                foreach (array("а", "б", "в", "г") as $ans_v) {
                $true_ansv = ($myrow['correct'] !== "" && in_array($ans_v, str_split($myrow['correct']))) ? "checked=\"checked\"" : "";
                echo"<td><input name='r$num1"."_question$num' type='checkbox' value='$ans_v' $true_ansv/> <?= $ans_v ?></td>";
                }
                echo "</tr>
                </table>
                </td>

                </tr>

                </table>";
                $num ++;
            }
            mysql_free_result($result);
            echo "</td></tr>
             <tr>
                   <td colspan='2' class='a_center'><input type='submit' value='Сохранить' /></td>
                </tr>
            </table></form>";
        }
        else
        {
            echo "<p class='pagename error'>Тест не найден</p>";
        }

    }
}
else {
    if (in_array($do, $ex_links)) {
        if ($do = "edit") {
            if (isset($_POST['id_sub'])) {
                $id_sub = $_POST['id_sub'];
            }
            if (isset($_POST['id_lesson'])) {
                $id_lesson = $_POST['id_lesson'];
            }
                if (isset($_POST['question'])) {
                        foreach ($_POST['question'] as $q_k => $q_v) {
                        $question = mysql_real_escape_string($q_v['question']);
                        $qyery = "UPDATE test_quest SET question=\"$question\" WHERE id=$q_k;";
                         mysql_query($qyery, $db);
                        foreach ($q_v['answer'] as $a_k => $a_v) {
                            $answer = mysql_real_escape_string($a_v);
                            $qyery = "UPDATE test_answers SET answer=\"$answer\" WHERE id=$a_k;";
                             mysql_query($qyery, $db);
                        }
                    }
                }
            }
        }
    }
        mysql_close($db);
    ?>