$con = mysql_connect("localhost", "root", "");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_query("SET character_set_results=utf8", $con);
mysql_select_db("db_e_learning", $con);
$result = mysql_query("SELECT * FROM el_theories WHERE `subjectid` = {$id}");
$theoryID;
while ($row = mysql_fetch_array($result)) {
echo "<a href=\"Ly%20thuyet.php?id={$id}&tid=" . $row['theoryid'] . "\">" . $row['theory_name'] . "</a>";
$theoryID = $row['theoryid'];
echo "<br />";
}
}
if (isset($id)) {
loadCourse($id);
}
if (isset($_GET['tid'])) {
$theoryID = $_GET['tid'];
}
if (isset($id) && isset($theoryID)) {
loadTheory($theoryID);
}
function loadTheory($theoryID)
{
$video = "";
$con = mysql_connect("localhost", "root", "");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_query("SET character_set_results=utf8", $con);
echo '<br>' . $checkmark . 'No of Modules does not mean number of chapters<br>' . '<br>' . $checkmark . 'No of Modules entry should be taken from University Syllabus copy.<br>';
?>
</div>
<div id="right">
<form method="post" action="createsy.php" onsubmit="return confirm('Are you sure you want to submit?')">
<center>
<table cellspacing="10" cellpadding="2" border="0" bgcolor="#00eeee">
<th colspan="2" align="center">Syllabus Creation</th>
<tr>
<td>Select Course</td>
<td align="right">
<select name="cscourse" id="cscourse" required size="1">
<?php
loadCourse();
?>
</select>
</td>
</tr>
<tr>
<td colspan="2"><div id="coursestatus"></div></td>
</tr>
<tr>
<td>No of Modules</td>
<td align="right"><input type="text" name="cschap" id="cschap" value="" placeholder="Ex: 5" required disabled="disabled"></td>
</tr>
<tr>
<td align="center" colspan="2"><input type="submit" class="button" value="Create"></td>
</tr>
</table>
