function AddCurriculum($userid, $classesArray)
{
echo '<div class="panel panel-default">';
echo '<div class="panel-heading">';
echo '<h3 class="panel-title">Информация за програмата</h3>';
echo '</div>';
echo '<div class="panel-body">';
echo '<div class="row">';
echo '<div class="col-sm-6">';
echo 'Седмица: ' . $classesArray["WEEK"];
echo '</div>';
echo '<div class="col-sm-6">';
echo 'Ден: ' . $classesArray["DAY"];
echo '</div>';
echo '</div>';
echo '<div class="row">';
//print_r($classesArray);
include "convert_class_number_to_words.php";
$idsArray = array();
for ($counter = 0; $counter < sizeof($classesArray["HOURS"]); $counter++) {
echo '<div class="col-sm-4">';
echo '<h3>' . ConvertClassNumberToWords($counter + 1) . ' час</h3>';
echo '<p>Време: ' . $classesArray["HOURS"][$counter] . '</p>';
echo '<p>Предмет: ' . $classesArray["SUBJECTS"][$counter];
echo '<p>Информация: ' . $classesArray["INFO"][$counter];
$SQL = "INSERT INTO class (time, subjectid, info) VALUES ('" . $classesArray["HOURS"][$counter] . "'," . $classesArray["SUBJECTS"][$counter] . ",'" . $classesArray["INFO"][$counter] . "')";
//echo $SQL;
$insertion = mysql_query($SQL);
array_push($idsArray, mysql_insert_id());
echo '</div>';
}
//print_r($idsArray);
$SQL = "INSERT INTO day (";
for ($counter = 0; $counter < sizeof($classesArray["HOURS"]); $counter++) {
if ($counter != sizeof($classesArray["HOURS"]) - 1) {
$symbol = ", ";
} else {
$symbol = "";
}
$SQL = $SQL . "class" . ($counter + 1) . "ID" . $symbol;
}
$SQL = $SQL . ") ";
$SQL = $SQL . "VALUES (";
for ($counter = 0; $counter < sizeof($classesArray["HOURS"]); $counter++) {
if ($counter != sizeof($classesArray["HOURS"]) - 1) {
$symbol = ", ";
} else {
$symbol = "";
}
$SQL = $SQL . $idsArray[$counter] . $symbol;
}
$SQL = $SQL . ")";
$insertion = mysql_query($SQL);
$InsertedDayID = mysql_insert_id();
//echo $SQL;
$SQL = "SELECT MAX(uw.TwoWeeksID) FROM uw, user WHERE uw.UserID = " . $userid;
//echo $SQL;
$TwoWeeksIDResult = mysql_query($SQL);
$TwoWeeksID = mysql_fetch_array($TwoWeeksIDResult);
if ($classesArray["WEEK"] == 1) {
//$NextWeek = "EvenWeekID";
$CurrentWeek = "OddWeekID";
} else {
if ($classesArray["WEEK"] == 2) {
//$NextWeek = "OddWeekID";
$CurrentWeek = "EvenWeekID";
} else {
if ($classesArray["WEEK"] == 3) {
$CurrentWeek = "OtherWeekID";
}
}
}
$SQL = "SELECT twoweeks." . $CurrentWeek . ", twoweeks.UID FROM twoweeks WHERE twoweeks.UID = " . $TwoWeeksID[0];
//echo $SQL;
$WeekIDResult = mysql_query($SQL);
$WeekID = mysql_fetch_array($WeekIDResult);
$SQL = "SELECT weeks.MondayId, weeks.TuesdayId, weeks.WednesdayId, weeks.ThursdayId, weeks.FridayId, weeks.SaturdayId, weeks.SundayId FROM weeks WHERE weeks.UID = " . $WeekID[0];
//echo $SQL;
$dayIDsResult = mysql_query($SQL);
$dayIDs = mysql_fetch_array($dayIDsResult);
//print_r($dayIDs);
$dayIDs[$classesArray["DAY"] - 1] = $InsertedDayID;
$SQL = "INSERT INTO weeks (MondayId, TuesdayId, WednesdayId, ThursdayId, FridayId, SaturdayId, SundayId) VALUES (";
//echo $SQL;
for ($counter = 0; $counter <= 6; $counter++) {
if ($counter != 6) {
$symbol = ", ";
} else {
$symbol = "";
}
$SQL = $SQL . $dayIDs[$counter] . $symbol;
}
$SQL = $SQL . ")";
//echo "<p>".$SQL."</p>";
$dayIDsResult = mysql_query($SQL);
$AddedWeekId = mysql_insert_id();
//echo $AddedWeekId;
//$dayIDs = mysql_fetch_array($dayIDsResult);
$SQL = "SELECT twoweeks.OddWeekID, twoweeks.EvenWeekID, twoweeks.OtherWeekID, twoweeks.CheckToOtherWeek FROM twoweeks WHERE twoweeks.UID = " . $TwoWeeksID[0];
$NextWeekIdResult = mysql_query($SQL);
$MyOldWeeksIDs = mysql_fetch_array($NextWeekIdResult);
$MyOldWeeksIDs[$classesArray["WEEK"] - 1] = $AddedWeekId;
//echo $MyNextWeekID[0];
$SQL = "INSERT INTO twoweeks (OddWeekID, EvenWeekID, OtherWeekID, CheckToOtherWeek) VALUES (" . $MyOldWeeksIDs[0] . ", " . $MyOldWeeksIDs[1] . ", " . $MyOldWeeksIDs[2] . ", " . $MyOldWeeksIDs[3] . ")";
$InsertingNewTwoWeeksResult = mysql_query($SQL);
$MyInsertedNewTwoWeeksId = mysql_insert_id();
//echo $MyInsertedNewTwoWeeksId;
$SQL = "INSERT INTO uw (UserID, TwoWeeksID) VALUES (" . $userid . ", " . $MyInsertedNewTwoWeeksId . ")";
$InsertingNewUserWeekResult = mysql_query($SQL);
echo '</div>';
echo '</div>';
include "garbage_collector.php";
}
<option value="6">Събота</option>
<option value="7">Неделя</option>
</select>
</div>
</div>
</div>
<div class="row">
<?php
include "some_external_phps/subject_select_list_menu.php";
include "some_external_phps/convert_class_number_to_words.php";
for ($k = 1; $k <= 9; $k++) {
echo '<div class="col-sm-4">';
echo '<div class="form-group">';
echo '<label for="text">';
echo ConvertClassNumberToWords($k) . " час";
echo '</label>';
$name = "hours[]";
//echo $name;
$name2 = "mins[]";
//echo $name2;
include "some_external_phps/time_picker.php";
//echo '<input type="time" class="form-control" name="time'.$k.'" placeholder="13:00">';
$name = "subjects[]";
$thereisnosubjects = MakeSubjectMenu($username, $name);
echo '<input type="text" class="form-control" name="info[]" placeholder="Информация">';
echo '</div>';
echo '</div>';
}
if ($EditMode == 1 && $thereisnosubjects == 0) {
echo '<button type="submit" class="btn btn-default" style = "margin-left: 15px;">Запиши</button>';
