<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"); } } ?>