<button type='submit' class='btn btn-primary btn-xs save' name="add_course" style="margin-left:25%;margin-top:5%">   Save   </button>
</form>
<button class='btn btn-default btn-xs close1' style="margin-left:1%;margin-top:5%">   Close   </button>
</div>
<?php
if (isset($_POST['add_course'])) {
$n_ct = $_POST['new_course'];
// new course title
$n_inst = $_POST['new_inst'];
// instructor of new course
$n_sd = $_POST['sd'];
// starting date of new course
$n_ed = $_POST['ed'];
// ending date of new course
include 'ids.php';
$n_course_id = courseID($n_ct);
$n_user_id = $_SESSION['username'];
echo "New Course : " . $n_ct . "<br>";
echo "Instructor : " . $n_inst . "<br>";
echo "Starts on : " . $n_sd . "<br>";
echo "Ends on: " . $n_ed . "<br>";
$query = $db->prepare("insert into course_detail(course_id,course_name,instructor,start,end) values('{$n_course_id}','{$n_ct}','{$n_inst}','{$n_sd}','{$n_ed}')");
$query->execute();
$query2 = $db->prepare("insert into inst_course values('{$n_user_id}','{$n_course_id}')");
$query2->execute();
header("refresh:0");
}
?>
</section>
<!-- Registered Trainers -->
<?php
require_once 'home/hashTables.php';
/*
DB::table('users')->insert(array(
array('email' => '*****@*****.**', 'votes' => 0),
array('email' => '*****@*****.**', 'votes' => 0),
));
DB::table('course')->insert(array(
array('subject' => , 'coursenumber' => ,'coursename' => ,'class' => ,'section1' => ,'section2' => ,'days' => ,'starttime' => ,'endtime' => ,'room' => ,'instructor' => ,'meetingdates' => ),
array('email' => '*****@*****.**', 'votes' => 0),
));*/
$csv = array_map('str_getcsv', file('test.csv'));
$total = count($csv);
//print_r($csv);
$i = 1;
echo "DB::table('courses')->insert(array(" . "<br>";
for ($i; $i < $total; $i++) {
echo "array('subject' => '" . $csv[$i][0] . "', 'courseNumber' => '" . $csv[$i][1] . "', 'cid' => '" . courseID($csv[$i][0] . " " . $csv[$i][1]) . "', 'courseName' => '" . $csv[$i][2] . "', 'class' => '" . $csv[$i][3] . "', 'section1' => '" . $csv[$i][4] . "', 'section2' => '" . $csv[$i][5] . "', 'days' => '" . $csv[$i][6] . "', 'startTime' => '" . $csv[$i][7] . "', 'endTime' => '" . $csv[$i][8] . "', 'room' => '" . $csv[$i][9] . "', 'instructor' => '" . addslashes($csv[$i][10]) . "', 'iid' => '" . instructorID($csv[$i][10]) . "', 'meetingDates' => '" . $csv[$i][11] . "')," . "<br>";
/*
for($j=0; $j < 12; $j++){
echo$csv[$i][$j];
echo " ---- ";
}
echo "<br>";*/
}
echo "));" . "<br>";
<?php
require_once 'hashTables.php';
/*
DB::table('users')->insert(array(
array('email' => '*****@*****.**', 'votes' => 0),
array('email' => '*****@*****.**', 'votes' => 0),
));
DB::table('course')->insert(array(
array('subject' => , 'coursenumber' => ,'coursename' => ,'class' => ,'section1' => ,'section2' => ,'days' => ,'starttime' => ,'endtime' => ,'room' => ,'instructor' => ,'meetingdates' => ),
array('email' => '*****@*****.**', 'votes' => 0),
));*/
$csv = array_map('str_getcsv', file('requisites.csv'));
$total = count($csv);
//print_r($csv);
$i = 1;
echo "DB::table('requisites')->insert(array(" . "<br>";
for ($i; $i < $total; $i++) {
echo "array('cid' => '" . courseID($csv[$i][0] . " " . $csv[$i][1]) . "', 'prid' => '" . courseID($csv[$i][2] . " " . $csv[$i][3]) . "', 'ORprid' => '" . courseID($csv[$i][6] . " " . $csv[$i][7]) . "', 'coid' => '" . courseID($csv[$i][4] . " " . $csv[$i][5]) . "')," . "<br>";
/*
for($j=0; $j < 12; $j++){
echo$csv[$i][$j];
echo " ---- ";
}
echo "<br>";*/
}
echo "));" . "<br>";
global $instructorsHT;
return $instructorsHT[$instructor];
}
function courseID($course)
{
global $coursesHT;
return $coursesHT[$course];
}
function courseReverseID($courseID)
{
global $coursesReversedHT;
return $coursesReversedHT[$courseID];
}
/*
echo "MATH 19"." = ".courseID( "MATH 19" )."<br>";
echo "MATH 19W"." = ".courseID( "MATH 19W" )."<br>";
echo "CS 49J"." = ".courseID( "CS 49J" )."<br>";
echo "CS 49C"." = ".courseID( "CS 49C" )."<br>";
echo "<br>Next Semester:<br>";
echo "MATH 42"." = ".courseID( "MATH 42" )."<br>";
echo "MATH 30"." = ".courseID( "MATH 30" )."<br>";
echo "MATH 30"." = ".courseID( "MATH 30W" )."<br>";
echo "MATH 42"." = ".courseID( "MATH 42" )."<br>";
echo "<br>Next Semester:<br>";
echo "CS 46A"." = ".courseID( "CS 46A" )."<br>";
echo "MATH 32"." = ".courseID( "MATH 32" )."<br>";
*/
echo "MATH 31" . " = " . courseID("MATH 31") . "<br>";
echo "MATH 129A" . " = " . courseID("MATH 129A") . "<br>";
echo "CS 146" . " = " . courseID("CS 146") . "<br>";
//try{
/* $statement = $db->prepare("UPDATE course_detail SET syllabus = (?) WHERE course_id='$course_id'");
$statement->execute(array($syllabus));
$_SESSION['syllabus'] = $syllabus; */
/* for($j=0;$j<$tn;$j++){
$otw = $_POST["otw_$j"];
$ot = $_POST["ot_$j"];
$query1=$db->prepare("updare topics set topics ='$otw', topic_name='$ot' where course_id='$course_id' and course_topic.topic_id = topics.topic_id");
$query1->execute();
} */
/* echo "<script>location.reload();</script>";
}
catch(Exception $err){
echo "error: ". $err->getMessage();
}
} */
/*................................................ adding a new topic to syllabus...............................*/
if (isset($_POST['add_topic'])) {
$t_id = courseID($_POST['nt']);
$ntnm = $_POST['nt'];
$ntm = $_POST['n_wt'];
$addt = $db->prepare("insert into topics(topic_id,topic_name,marks) values(?,?,?)");
$addt->execute(array($t_id, $ntnm, $ntm));
$addtc = $db->prepare("insert into course_topic values(?,?)");
$addtc->execute(array($course_id, $t_id));
echo "<script>location.reload();</script>";
//header("Location:rand.php");
}
}
?>
