function test_GetSingleField() { $_SESSION["a_userid"] = 10; $dept = GetSingleField("select deptid from users where uid=" . $_SESSION["a_userid"], "deptid"); $this->assertIsA($dept, 'string'); }
<tr> <th>Subject Section</th> <th>Subject Name</th> <th>Pre-Req</th> <th>Co-Reqs</th> <th>Credits</th> </tr> <?php $sql = "SELECT cs.sections,c.coursename,c.credits,c.prereqid,c.coreqid FROM section s,course_section cs,courses c where s.csid=cs.csid and cs.cid=c.cid and s.uid=" . $_POST["ddlfaculty"] . " and s.semid=" . $_POST["ddlsem"]; $data3 = ExecuteNonQuery($sql); while ($info3 = mysqli_fetch_assoc($data3)) { if ($info3["prereqid"] != "0") { $prereq = GetSingleField("select pcname from pre_req where prereqid=" . $info3["prereqid"], "pcname"); } if ($info3["coreqid"] != "0") { $coreq = GetSingleField("select ccname from co_req where coreqid=" . $info3["coreqid"], "ccname"); } ?> <tr> <td><?php echo $info3["sections"]; ?> </td> <td><?php echo $info3["coursename"]; ?> </td> <td><?php echo $prereq; ?> </td>
$ext = substr($str, $i + 1, $l); return $ext; } if (isset($_POST['Submit'])) { $errors = array(); $required_fields = array('imgnm'); $errors = array_merge($errors, check_required_fields($required_fields, $_POST)); if (empty($errors)) { if (empty($_POST["ddcatid"])) { $message = "Please select category"; } else { $inm = $_POST["imgnm"]; $visible = $_POST["cbvisible"]; $dispord = $_POST["dispord"]; $catid = $_POST["ddcatid"]; $existord = GetSingleField("select disporder from images where imageid=" . $_GET["id"], "disporder"); // echo $dispord." " . $existord; if (!file_exists($_FILES['photoimage']['tmp_name']) || !is_uploaded_file($_FILES['photoimage']['tmp_name'])) { //file not inside if ($exitstord != $dispord) { $i = 0; if ($visible == "on") { $i = 1; } $qry = "update images set disporder=" . $existord . " where disporder=" . $dispord; /// echo $qry." "; ExecuteNonQuery($qry); $c_date = date("Y-m-d"); $qry = "update images set imagename='" . $inm . "',visible=b'" . $i . "',imgcatid=" . $catid . ",modifyip='" . getip() . "',modifydate='" . $c_date . "',disporder=" . $dispord . " where imageid=" . $_GET["id"]; // echo $qry." "; $cntrec = ExecuteNonQuery($qry);
if (!empty($message)) { echo "<p class=message>" . $message . "</p>"; } else { echo " "; } ?> <?php if (!empty($errors)) { display_errors1($errors); } ?> </td> </tr> <?php $dept = GetSingleField("select deptid from users where uid=" . $_SESSION["a_userid"], "deptid"); $deptname = GetSingleField("select deptname from dept where deptid=" . $dept, "deptname"); ?> <tr> <td>Department</td> <td>:</td> <td style="font-weight:bold;"><?php echo $deptname; ?> </td> </tr> <tr> <td>Active</td> <td>:</td> <td><input type="checkbox" name="cbxactive" checked> </td>
if (in_array("F", $cday)) { if ($tp == 'lec') { $csnm = GetSingleField("select sections from course_section where csid=" . $info["csid"], "sections"); echo $csnm . "<br>"; } else { echo "Office Hours<br>"; } echo $info["starttime"] . " to " . $info["endtime"]; } ?> </td> <td align="center"> <?php if (in_array("S", $cday)) { if ($tp == 'lec') { $csnm = GetSingleField("select sections from course_section where csid=" . $info["csid"], "sections"); echo $csnm . "<br>"; } else { echo "Office Hours<br>"; } echo $info["starttime"] . " to " . $info["endtime"]; } ?> </td> </tr> <?php } } else { for ($i = 0; $i < 4; $i++) { echo "<tr>"; echo "<td> </td>";
?> <?php if ($_GET["flag"] == 2) { ?> <div id="diverror"> <img src="images/cross.png" width="25px" height="25px"><?php echo $_GET["msg"]; ?> </div> <?php } ?> <div id="viewsubjects"> <?php $per = GetSingleField('select permission from users where userid=$_POST["permission"]', "permission"); ?> <form method="post" action="viewsubjects.php"> <table border="1"> <tr> <td align="center" style="padding-top:20px;border:none;"> <b>Select Semester:</b> <select name="ddlsem"> <option value="">Select</option> <option value="Summer 2015">Summer 2015</option> <option value="Summer 2015">Fall 2015</option> <option value="Summer 2015">Spring 2016</option> <option value="Summer 2015">Summer 2016</option> <option value="Summer 2015">Fall 2016</option>
$query = "update outcomes_result set obj1=b'" . $res1 . "',obj2=b'" . $res2 . "',obj3=b'" . $res3; $query = $query . "',obj4=b'" . $res4 . "',obj5=b'" . $res5 . "' where ocmresid=" . $ocmresid1; $cnt = ExecuteNonQuery($query); } } } // $query=substr($query, 0, -1); // echo $query; if ($cnt > 0) { redirect_to("retrivesurvey.php?msg=Survey updated successfully?flag=1"); } else { redirect_to("retrivesurvey.php?msg=Error in updating survey?flag=2"); } } } else { $name = GetSingleField("select subname from subject where subid=" . $subid, "subname"); show_alert("Please enter objective of '" . $name . "\\'"); } } else { show_alert("Subject selection same on both side"); } } else { show_alert("please select subject from both list"); } } ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>Course Assesment Survey</title>
if (strpos($cnm, " ")) { $cnm = str_replace(" ", "_", $cnm); } $cnm = $cnm . "_" . $_POST["cbx_nu"]; $cntrec = CountRecords("select sections from course_section where sections='" . $cnm . "'"); if ($cntrec == 0) { $sql = "insert into course_section(sections,active,cid)values('" . $cnm . "',1," . $_POST["ddlcourse"] . ")"; // echo $sql; ExecuteNonQuery($sql); } else { $sql = "update course_section set active=1 where sections='" . $cnm . "'"; // echo $sql; ExecuteNonQuery($sql); } } else { $cnm = GetSingleField("select courseno from courses where cid=" . $_POST["ddlcourse"], "courseno"); if (strpos($cnm, " ")) { $cnm = str_replace(" ", "_", $cnm); } $cnm = $cnm . "_NU"; $cntrec = CountRecords("select sections from course_section where sections='" . $cnm . "'"); if ($cntrec > 0) { $sql = "update course_section set active=0 where sections='" . $cnm . "'"; ExecuteNonQuery($sql); $cbx_nu = ""; } } } } if (!isset($_SESSION["rdbdeg"])) { redirect_to("index.php");
ob_start(); ini_set('display_errors', 'off'); include_once "includes/connect.php"; require_once "includes/functions.php"; require_once "includes/session.php"; include "includes/DataAccess.php"; include_once "includes/form_functions.php"; include "../fckeditor/fckeditor.php"; if (!logged_in()) { redirect_to("index.php"); } $cnt = CountRecords("select * from insidepage where pagename='" . $_GET["page"] . "'"); if ($cnt == 1) { $pnm = GetSingleField("select pageietitle from insidepage where pagename='" . $_GET["page"] . "'", "pageietitle"); $desc = GetSingleField("select pagedesc from insidepage where pagename='" . $_GET["page"] . "'", "pagedesc"); } if (isset($_POST["Submit"])) { $errors = array(); $required_fields = array('pagetitle'); $errors = array_merge($errors, check_required_fields($required_fields, $_POST)); if (empty($errors)) { if ($cnt == 1) { $c_date = date("Y-m-d"); $qry = "update insidepage set pageietitle='" . $_POST["pagetitle"] . "',pagedesc='" . $_POST["editor1"] . "'"; $qry = $qry . ",modifyip='" . getip() . "',modifydate='" . $c_date . "' where pagename='" . $_GET["page"] . "'"; // echo $qry; $cntrec = ExecuteNonQuery($qry); if ($cntrec == 1) { redirect_to("welcome.php?msg=page content updated successfully.&flag=1"); } else {
redirect_to("index.php"); } if (isset($_POST["Submit"])) { $i = 0; if (isset($_POST["cbxactive"])) { ExecuteNonQuery("update semester set active=0"); $i = 1; } $crec = CountRecords("select * from semester"); $currsord = GetSingleField("select sortorder from semester where semid=" . $_GET["id"], "sortorder"); if ($currsord == $_POST["ddlso"]) { $updateold = "update semester set active=" . $i . " where semid=" . $_GET["id"]; ExecuteNonQuery($updateold); // echo $updateold."<br>"; } else { $stmpid = GetSingleField("select semid from semester where sortorder=" . $_POST["ddlso"], "semid"); $sql = "update semester set sortorder=" . $currsord . " where semid=" . $stmpid; ExecuteNonQuery($sql); // echo $sql."<br>"; $sql = "update semester set sortorder=" . $_POST["ddlso"] . ",active={$i} where semid=" . $_GET["id"]; ExecuteNonQuery($sql); // echo $sql; } redirect_to("viewsemesters.php"); } ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>Edit Semester</title>
} } $query = substr($query, 0, -1); $cnt = ExecuteNonQuery($query); echo $query; if ($cnt > 0) { redirect_to("editcoursesurvey.php?msg=Survey inserted successfully&flag=1"); } else { redirect_to("editcoursesurvey.php?msg=Error in inserting survey&flag=2"); } } else { $data = ExecuteNonQuery('select * from outcomes_main') or die(mysql_error()); while ($info = mysql_fetch_assoc($data)) { $data1 = ExecuteNonQuery('select * from outcomes_detail where ocmmainid=' . $info["ocmmainid"]) or die(mysql_error()); while ($info1 = mysql_fetch_assoc($data1)) { $ocmresid = GetSingleField("select * from outcomes_result where subid=" . $subid . " and ocmdetailid=" . $info1["ocmdetailid"], "ocmresid"); $myarr = array(); $temp = "mycb" . $info1["ocmdetailid"]; for ($i = 0; $i < 5; $i++) { $myarr[$i] = $_POST[$temp][$i]; } // echo "<table><tr>"; $res1 = empty($myarr[0]) ? "0" : "1"; // echo "<td style=width:20px;text-align:right;>".$res1."</td>"; $res2 = empty($myarr[1]) ? "0" : "1"; // echo "<td style=width:20px;text-align:right;>".$res2."</td>"; $res3 = empty($myarr[2]) ? "0" : "1"; // echo "<td style=width:20px;text-align:right;>".$res3."</td>"; $res4 = empty($myarr[3]) ? "0" : "1"; // echo "<td style=width:20px;text-align:right;>".$res4."</td>"; $res5 = empty($myarr[4]) ? "0" : "1";
} } else { if ($_POST["ddlprereq"] != "") { $pid = $_POST["ddlprereq"]; } else { $pid = "0"; } } if (isset($_POST["txtncoreq"]) && $_POST["txtncoreq"] != "") { $ccnt = CountRecords("select * from co_req where ccname like '" . $_POST["txtncoreq"] . "'"); if ($ccnt > 0) { $pid = GetSingleField("select coreqid from co_req where ccname like '" . $_POST["txtncoreq"] . "'", "coreqid"); } else { $sql = "insert into co_req(ccname)values('" . $_POST["txtncoreq"] . "')"; ExecuteNonQuery($sql); $cid = GetSingleField("select max(coreqid) as newid from co_req", "newid"); } } else { if ($_POST["ddlcoreq"] != "") { $cid = $_POST["ddlcoreq"]; } else { $cid = "0"; } } $str = "update courses set courseno='" . $_POST["txtcid"] . "',special='" . $_POST["spCourse"] . "',coursename='" . $_POST["txtcnm"] . "',description='" . $_POST["tadesc"] . "'"; $str .= ",prereqid=" . $pid . ",coreqid=" . $cid . ",credits=" . $_POST["txtcredits"] . ",active={$i} where cid=" . $_GET["id"]; ExecuteNonQuery($str); // echo $str; redirect_to("viewcourses.php"); } else { if (count($errors) == 1) {
$str .= " \r\n \t \t<td>Grading Policy:</td>\r\n \t<td style='text-align:center'>"; if (isset($gp) && $gp != "") { $str .= str_replace("<table>", "<table border='1'>", $gp); } $str .= "\r\n \t </td>\r\n </tr>\r\n\t\t\t <tr>\r\n \r\n \t<td>Course Policies:</td>\r\n \t\r\n \t\t<td>"; $sql = "select coursepolicy from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem']; $cp = GetSingleField($sql, "coursepolicy"); $str .= $cp; $str .= "</td></tr>\r\n\t\t\t\t\t<tr>\r\n \t\t \t<td>Attendance Policies:</td>\r\n\t\t\t\t\t\t<td>"; $attp = GetSingleField("select attpolicy from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem'], "attpolicy"); $str .= $attp; $str .= "</td></tr>\r\n\t\t\t\t\t <tr>\r\n \r\n \t<td>Academic Integrity:</td>\r\n \t\r\n \t\t<td>"; $ai = GetSingleField("select academicintegrity from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem'], "academicintegrity"); $str .= $ai; $str .= "</td></tr>\r\n\t\t\t\t\t<tr>\r\n \t<td>Course Calendar with Topics:</td>\r\n \t\r\n \t\t<td>"; $cctopics = GetSingleField("select coursetopics from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem'], "coursetopics"); $str .= $cctopics; $str .= "</td>\r\n </tr></table>"; $sylarr[$cnt] = "tmpfileloc/" . $syllabusinfo["sectionid"] . ".doc"; $htmltodoc = new HTML_TO_DOC(); $htmltodoc->createDoc($str, $sylarr[$cnt]); $cnt++; echo $str; } //----------------Creating zip /* $result = create_zip($sylarr,'tmpfileloc/test.zip'); // We'll be outputting a PDF header('Content-type: application/zip'); // It will be called downloaded.pdf header('Content-Disposition: attachment; filename=test.zip'); // The PDF source is in original.pdf
$obj3 = $_POST["objective3"]; $obj4 = $_POST["objective4"]; $obj5 = $_POST["objective5"]; $cnt = CountRecords("select * from objectives where subid=" . $_GET["subid"]); if ($cnt == 0) { $query = "insert into objectives(subid,obj1,obj2,obj3,obj4,obj5)values("; $query .= $_GET["subid"] . ",'" . $obj1 . "','" . $obj2 . "','" . $obj3 . "','" . $obj4 . "','" . $obj5 . "')"; $cnt1 = ExecuteNonQuery($query); echo $query; if ($cnt1 == 1) { redirect_to("viewsubjects.php?msg=Record inserted successfully.&flag=1"); } else { redirect_to("viewsubjects.php?msg=Error in inserting record..Please try later.&flag=2"); } } else { $getid = GetSingleField("select objid from objectives where subid=" . $_GET["subid"], "objid"); $query = "update objectives set obj1='" . $obj1 . "',obj2='" . $obj2 . "',obj3='" . $obj3 . "',obj4='" . $obj4 . "',"; $query .= "obj5='" . $obj5 . "' where objid=" . $getid; $cnt1 = ExecuteNonQuery($query); // echo $query; if ($cnt1 == 1) { redirect_to("viewsubjects.php?msg=Record updated successfully.&flag=1"); } else { redirect_to("viewsubjects.php?msg=Error in updating record..Please try later.&flag=2"); } } } ?> <!doctype html> <html>
if ($_GET["flag"] == "0") { $cnt = CountRecords("select filename from fileinfo where ftype='matrix'"); } else { redirect_to("index.php"); } } if ($_GET["flag"] == "1") { if ($cnt != 0) { $currentver = GetSingleField("select version from fileinfo where ftype='gmatrix' and active=1", "version"); } else { $currentver = "No Active Version"; } } else { if ($_GET["flag"] == "0") { if ($cnt != 0) { $currentver = GetSingleField("select version from fileinfo where ftype='matrix' active=1", "version"); } else { $currentver = "No Active version"; } } else { redirect_to("index.php"); } } $ver = $cnt + 1; $ver = "V" . $ver; ?> <td><input type="checkbox" name="chkver" <?php if ($cnt == 0) { echo "checked disabled"; } ?>
<?php if (!empty($errors)) { display_errors1($errors); } ?> </td> </tr> <tr> <td width="60px">Select Faculty</td> <td width="10px">:</td> <td> <?php $dept = GetSingleField("select deptid from users where uid=" . $_SESSION["a_userid"], "deptid"); $data = ExecuteNonQuery('select uid,firstname,lastname from users where deptid=' . $dept); ?> <select name="ddlfac" onChange="document.form1.submit();"> <?php while ($info = mysqli_fetch_assoc($data)) { ?> <option value="<?php echo $info["uid"]; ?> " <?php if ($_POST["ddlfac"] == $info["uid"]) { echo "selected"; } ?> ><?php
$cntrec = CountRecords("select * from co_req where ccname='" . trim($info1["corequisite"]) . "'"); if ($cntrec == 0) { $str = "insert into co_req(ccname)values('" . trim($info1["corequisite"]) . "')"; $cnt = ExecuteNonQuery($str); if ($cnt == 1) { $coid = mysqli_insert_id(); } } else { $sql = "select coreqid from co_req where ccname='" . trim($info1["corequisite"]) . "'"; // echo $sql."<br>"; $coid = GetSingleField($sql, "coreqid"); } } $cnt = CountRecords("select * from courses where courseno='" . $info1["courseid"] . "'"); if ($cnt > 0) { $cid = GetSingleField("select cid from courses where courseno='" . $info1["courseid"] . "'", "cid"); // $tmparray[$i][0]=$info1["courseid"]; // $tmparray[$i][1]=$info1["coursename"]; // $i++; $str = "update courses set courseno='" . $info1["courseid"] . "',coursename='" . $info1["coursename"] . "',description='" . str_replace("'", "\\'", $info1["coursedesc"]) . "',prereqid={$preid},coreqid={$coid},credits=" . $info1["credits"] . ",set active=1, set deptid=1 where cid=" . $cid; //echo $str."<br>"; ExecuteNonQuery($str); $str1 = "update catelog_temp set approve=1 where id=" . $info1["id"]; // echo $str1."<br>"; ExecuteNonQuery($str1); } else { $str = "insert into courses(courseno,coursename,description,prereqid,coreqid,credits,active,deptid)values('"; $str .= $info1["courseid"] . "','" . $info1["coursename"] . "','" . str_replace("'", "\\'", $info1["coursedesc"]) . "',{$preid},{$coid}," . $info1["credits"] . ",1,1)"; // echo $str."<br>"; ExecuteNonQuery($str); $str1 = "update catelog_temp set approve=1 where id=" . $info1["id"];
<div id="diverror"> <img src="images/cross.png" width="25px" height="25px"><?php echo $_GET["msg"]; ?> </div> <?php } ?> <div id="addbannerdiv"> <br><br> </div> <div id="contentdetail"> <?php $snm = GetSingleField("select semname from semester where active=1", "semname"); $year = GetSingleField("select year from semester where active=1", "year"); ?> Current Semester: <b><?php echo $snm . " " . $year; ?> </div> </div> </div> </div> <div id="footer"> <div id="footernav"> <?php include "footer.html"; ?>
?> <tr> <td ><?php echo "<b>" . $fnm . " " . $lnm . "</b>"; ?> </td> <?php $data1 = ExecuteNonQuery('select * FROM section where semid=' . $_SESSION["statusincsem"] . " and uid=" . $info["uid"] . " and active=1"); while ($info1 = mysqli_fetch_assoc($data1)) { $section = GetSingleField("select sections from course_section where csid=" . $info1["csid"], "sections"); $cntrecords = CountRecords("select * from fcamm where csid=" . $info1["csid"] . " and semid=" . $_SESSION["statusincsem"] . " and uid=" . $info["uid"]); if ($cntrecords > 0) { $sql = "SELECT SUM(obj1) + SUM(obj2) + SUM(obj3)+ SUM(obj4)+ SUM(obj5)+ SUM(obj6)+ SUM(obj7)+ SUM(obj8)+ SUM(obj9)+ SUM(obj10) as 'Total'\r\nFROM fcamm where csid=" . $info1["csid"] . " and semid=" . $_SESSION["statusincsem"] . " and uid=" . $info["uid"]; //echo $sql; $sfld = GetSingleField($sql, "Total"); if ($sfld != 0) { $cntrecords = 1; } else { $cntrecords = 0; } } else { $cntrecords = 0; } ?> <tr> <td> </td> <td><?php echo $section; ?> </td>
// Replace the <textarea id="editor1"> with a CKEditor // instance, using default configuration. CKEDITOR.config.toolbar_MA = [['Source', '-', 'Cut', 'Copy', 'Paste', '-', 'Undo', 'Redo', 'RemoveFormat', '-', 'Link', 'Unlink', 'Anchor', '-', 'Image', 'Table', 'HorizontalRule', 'SpecialChar'], '/', ['Format', 'Templates', 'Bold', 'Italic', 'Underline', '-', 'Superscript', '-', ['JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyBlock'], '-', 'NumberedList', 'BulletedList', '-', 'Outdent', 'Indent']]; CKEDITOR.replace('taai', {toolbar: 'MA'} ); </script> </td> </tr> <tr> <td>Course Calendar with Topics</td> <td>:</td> <td> <?php if (isset($_POST["ddlcnm"])) { $cctopics = GetSingleField("select coursetopics from section where csid=" . $_POST["ddlcnm"] . " and uid=" . $_SESSION["userid"] . " and semid=" . $_SESSION["ddlsem3"], "coursetopics"); } ?> <textarea name="tacc" id="tacc" rows="10" cols="50"> <?php if (isset($cctopics) && $cctopics != "") { echo $cctopics; } ?> </textarea> <script> // Replace the <textarea id="editor1"> with a CKEditor // instance, using default configuration. CKEDITOR.config.toolbar_MA = [['Source', '-', 'Cut', 'Copy', 'Paste', '-', 'Undo', 'Redo', 'RemoveFormat', '-', 'Link', 'Unlink', 'Anchor', '-', 'Image', 'Table', 'HorizontalRule', 'SpecialChar'], '/', ['Format', 'Templates', 'Bold', 'Italic', 'Underline', '-', 'Superscript', '-', ['JustifyLeft', 'JustifyCenter', 'JustifyRight', 'JustifyBlock'], '-', 'NumberedList', 'BulletedList', '-', 'Outdent', 'Indent']]; CKEDITOR.replace('tacc',
function filldata($syllabustmp) { recursiveRemoveDirectory("tmpfilesloc"); if ($syllabustmp == "All") { $str = ""; $syllabusdata = ExecuteNonQuery("select * from section where semid=" . $_SESSION['ddlsbssem'] . " and active=1"); $sylarr = array(); $sbscnt = 0; while ($syllabusinfo = mysqli_fetch_assoc($syllabusdata)) { $cno = GetSingleField("select courseno from courses where cid=(select cid from course_section where csid=" . $syllabusinfo["csid"] . ")", "courseno"); $cnot = substr($cno, 0, 1); if ($cnot == "C") { $version = GetSingleField("select version from fileinfo where active=1 and ftype='matrix'", "version"); } else { $version = GetSingleField("select version from fileinfo where active=1 and ftype='gmatrix'", "version"); } $cnm = GetSingleField("select coursename from courses where courseno like '" . $cno . "'", "coursename"); $desc = GetSingleField("select description from courses where courseno like '" . $cno . "'", "description"); $credits = GetSingleField("select credits from courses where courseno like '" . $cno . "'", "credits"); $sem = GetSingleField("select semname from semester where active=1", "semname"); $pid = GetSingleField("select prereqid from courses where courseno like '" . $cno . "'", "prereqid"); $cid = GetSingleField("select coreqid from courses where courseno like '" . $cno . "'", "coreqid"); $prereq = GetSingleField("select pcname from pre_req where prereqid={$pid}", "pcname"); $coreq = GetSingleField("select ccname from co_req where coreqid={$cid}", "ccname"); $sql = "select starttime,endtime,cday,roomno from facultyhours where uid=" . $syllabusinfo["uid"] . " and semid=" . $_SESSION["ddlsbssem"] . " and csid=" . $syllabusinfo["csid"]; $web = GetSingleField('select website from section where sectionid=' . $syllabusinfo["sectionid"], 'website'); $reqmaterials = GetSingleField('select reqmaterials from section where sectionid=' . $syllabusinfo["sectionid"], 'reqmaterials'); $uid = $syllabusinfo["uid"]; $dt2 = ExecuteNonQuery($sql); while ($inf2 = mysqli_fetch_assoc($dt2)) { $classloc = $inf2["roomno"]; $cday = explode(" ", $inf2["cday"]); $tmp = explode(":", $inf2["starttime"]); $sttimehr = $tmp[0]; $sttimemin = substr($tmp[1], 0, 2); $sttimeampm = substr($tmp[1], -2); $tmp1 = explode(":", $inf2["endtime"]); $entimehr = $tmp1[0]; $entimemin = substr($tmp1[1], 0, 2); $entimeampm = substr($tmp1[1], -2); } $str = "<table width='100%'><tr>\r\n\t\t\t\t\t\t <td><h3><b>Gannon University</b></h3></td>\r\n\t\t\t\t\t\t<td style='text-align:right'><h3><b>Department of Computer and Information Science</b></h3></td>\r\n\t\t\t\t\t </tr> \r\n\t\t\t\t\t </table>\r\n\t\t\t\t\t<table style='width:100%' border='1'>\r\n\t\t\t\t<tr>\r\n\t\t\t\t<td>\r\n\t\t\t\t\r\n\t\t\t\t\t <table>"; $data = ExecuteNonQuery('select * from users where uid=' . $uid); $inst = ''; $offrno = ''; $ph = ''; $email = ''; while ($info = mysqli_fetch_assoc($data)) { $inst = $info['salutation'] . ' ' . $info['firstname'] . $info['lastname']; $offrno = $info['office']; $ph = $info['officeno']; $email = $info['email']; } $str .= "<tr><td><b>Instructor:</b></td>\r\n\t\t\t\t\t\t<td>" . $inst . "</td>" . "</tr><tr>\r\n\t\t\t\t\t\t<td><b>Office:</b></td>\r\n\t\t\t\t\t\t<td>" . $offrno . "</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td><b>Phone:</b></td>\r\n\t\t\t\t\t\t<td>" . $ph . "</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td><b>Email:</b></td>\r\n\t\t\t\t\t\t<td>" . $email . "</td>\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t </table>\r\n\t\t\t\t\t </td>\r\n\t\t\t\t\t <td>\r\n\t\t\t\t\t <table>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan='2'><b>Office Hours</b></td>\r\n\t\t\t\t\t\t</tr>"; $data1 = ExecuteNonQuery('select starttime,endtime,cday from facultyhours where uid=' . $uid . ' and semid=' . $_SESSION['ddlsbssem'] . ' and type=\'office\''); while ($info1 = mysqli_fetch_assoc($data1)) { $str .= "<tr>\r\n\t\t\t\t\t\t\t\t\t<td>" . $info1['cday'] . ':' . "</td>" . "<td>" . $info1['starttime'] . ':' . $info1['endtime'] . "</td>\r\n\t\t\t\t\t\t\t\t</tr>"; } $str .= "</table></td>\r\n \t\t\t\t\t </tr>\r\n \t\t\t\t\t </table>\r\n \t<table border='1'>\r\n\t <tr>\r\n \t<td>Course Title:</td>\r\n <td>"; if (isset($cnm) && $cnm != '') { $str .= $cnm; } $str .= "</td>" . "</tr>\r\n \t<tr>\r\n \t<td>Credit Hours:</td>\r\n <td>"; if (isset($credits) && $credits != '') { $str .= $credits; } $str .= ' credit(s)' . "</td>" . "\r\n </tr>"; $str .= "<tr>\r\n \t<td>Semester:</td>\r\n <td>"; if (isset($sem) && $sem != '') { $str .= $sem; } $str .= "</td>\r\n </tr>\r\n \t<tr>\r\n \t<td>Class Location:</td>\r\n <td>"; if (isset($classloc) && $classloc != '') { $str .= $classloc; } $str .= "</td></tr>"; $sday = ""; if (in_array('M', $cday)) { $sday .= 'M '; } if (in_array('T', $cday)) { $sday .= 'T '; } if (in_array('W', $cday)) { $sday .= 'W '; } if (in_array('Th', $cday)) { $sday .= 'Th '; } if (in_array('F', $cday)) { $sday .= 'F '; } $str .= "\r\n <tr>\r\n \t<td>Class Time:</td>\r\n <td>"; $str .= $sday . " " . $sttimehr . ':' . $sttimemin . ' ' . $sttimeampm . "\r\n <b> to</b>" . $entimehr . ':' . $entimemin . ' ' . $entimeampm . "</option>\r\n \r\n </td>\r\n </tr> <tr>\r\n \t\t<td>Course Description:</td>\r\n \r\n \t\t<td>"; if (isset($desc) && $desc != '') { $str .= $desc; } $str .= "</td></tr>"; $str .= "<tr>\r\n \t\t<td>Course Learning Objectives:</td>\r\n \r\n <td>\r\n The student will be able to<br>"; $cnot = substr($cno, 0, 1); if ($cnot == "C") { $cntrec = CountRecords("select cno from course_mappings where cno='" . str_replace(' ', '_', $cno) . "' and version='" . strtoupper($version) . "'"); } else { $cntrec = CountRecords("select cno from gcourse_mappings where cno='" . str_replace(' ', '_', $cno) . "' and version='" . strtoupper($version) . "'"); } $cnt2 = CountRecords('select * from fclo where semid=' . $_SESSION['ddlsbssem'] . ' and csid=' . $syllabusinfo["csid"] . " and uid=" . $uid); if ($cntrec > 0) { if ($cnot == "C") { $data2 = ExecuteNonQuery("select mappingname from course_mappings where cno='" . str_replace(' ', '_', $cno) . "' and version='" . strtoupper($version) . "'"); } else { $data2 = ExecuteNonQuery("select mappingname from gcourse_mappings where cno='" . str_replace(' ', '_', $cno) . "' and version='" . strtoupper($version) . "'"); } $cnt = 1; while ($info2 = mysqli_fetch_assoc($data2)) { $str .= $info2['mappingname'] . '<br>'; } } if ($cnt2 > 0) { $data5 = ExecuteNonQuery('select * from fclo where semid=' . $_SESSION['ddlsbssem'] . ' and uid=' . $uid . ' and csid=' . $syllabusinfo["csid"]); while ($info5 = mysqli_fetch_assoc($data5)) { $str .= $info5['name'] . '<br>'; } } $str .= "\t\r\n </td>\r\n </tr>"; $str .= "<tr>\r\n \t\t<td>Co-requisites:</td>\r\n \t\t\r\n \t\t<td>"; if (isset($coreq) && $coreq != '') { $str .= $coreq; } $str .= "</td>\r\n </tr>\r\n \t<tr>\r\n \t\t<td>Prerequisites:</td>\r\n \t\t\r\n \t\t<td>"; if (isset($prereq) && $prereq != '') { $str .= $prereq; } $str .= "</td></tr>"; //echo $str; $str .= "<tr>\r\n \t\t\t<td>Resources:</td>\r\n \t\t<td>{$web} </td>\r\n </tr>\r\n\t\t\t<tr>\t<td>Required Textbooks:</td>\r\n \t\t\r\n \t\t<td>{$reqmaterials}\r\n \t\t </td>\r\n </tr>"; $str .= " <tr>\r\n \t\t<td>Course Assessment Method:</td>\r\n \t\t<td>"; $cnt = 0; $sql = 'select camid,camname,camdetails from cams where csid=' . $syllabusinfo["csid"] . ' and semid=' . $_SESSION["ddlsbssem"] . " and uid=" . $uid; $data3 = ExecuteNonQuery($sql); //echo $sql; $cntrec1 = mysqli_num_rows($data3); $cnt = mysqli_num_rows($data3); // echo $cnt; $str .= "<div>\r\n \t \t\t<table align='left' id='camtable' style='text-align:left;' border='1' >"; if ($cnt > 0) { $cnt = 1; while ($info3 = mysqli_fetch_assoc($data3)) { $str .= " <tr>\r\n <td>" . $info3['camname'] . "</td>\r\n <td width='100%'>" . $info3['camdetails'] . "\r\n </td>\r\n </tr>"; } } $str .= " </table>\r\n \t\t\t\t\t\t\r\n </div>\r\n </td>\r\n </tr>"; $str .= " <tr>\r\n \t\t<td>Assessment Method Mappings:</td>\r\n \t\t\r\n \t\t<td>"; // $sql="select * from course_mappings where cno='".str_replace(" ","_",$cno)."'"; // echo $sql; $cnot = substr($cno, 0, 1); if ($cnot == "C") { $cnt = CountRecords("select * from course_mappings where cno='" . str_replace(" ", "_", $cno) . "'"); } else { $cnt = CountRecords("select * from gcourse_mappings where cno='" . str_replace(" ", "_", $cno) . "'"); } $cnt2 = CountRecords('select * from fclo where semid=' . $_SESSION["ddlsbssem"] . ' and csid=' . $syllabusinfo["csid"] . " and uid=" . $uid); $myval = $cnt + $cnt2; // echo $myval; $str .= "<table align='left' border='1' style='text-align:center'>\r\n \t<tr>\r\n \t<td rowspan='2'>ASSESSMENT METHODS</td>\r\n \t<td colspan=" . $myval . " align='center'>\r\n \tOBJECTIVES\r\n \t\t </td>\r\n </tr>\r\n <tr>"; for ($i = 1; $i <= $cnt + $cnt2; $i++) { $str .= "<td>" . $i . "</td>"; } $str .= "</tr>"; $sql = 'select camid,camname from cams where csid=' . $syllabusinfo["csid"] . ' and semid=' . $_SESSION["ddlsbssem"] . " and uid=" . $uid; $data = ExecuteNonQuery($sql); while ($info = mysqli_fetch_assoc($data)) { $str .= "\t\r\n <tr>\r\n \t<td>" . $info['camname'] . "</td>"; for ($i = 1; $i <= $myval; $i++) { $objnm = 'obj' . $i; $t1 = GetSingleField('select ' . $objnm . ' from fcamm where camid=' . $info['camid'] . ' and csid=' . $syllabusinfo["csid"] . ' and semid=' . $_SESSION['ddlsbssem'] . " and uid=" . $uid, $objnm); $str .= "<td>"; if ($t1 == '1') { $str .= 'X'; } else { $str .= ''; } $str .= "</td>"; } $str .= "</tr>"; } $str .= "<tr>\r\n <td>Department-Wide Outcomes</td>"; $cnot = substr($cno, 0, 1); if ($cnot == "C") { $data = ExecuteNonQuery('select * from matrix_' . strtolower($version) . " where cno like '" . str_replace(" ", "_", $cno) . "'"); } else { $data = ExecuteNonQuery('select * from matrix_' . strtolower($version) . " where cno like '" . str_replace(" ", "_", $cno) . "'"); } // echo mysqli_num_rows($data); // echo $sql; while ($info = mysqli_fetch_assoc($data)) { $temp = ''; if ($info['col0'] == '1') { $temp = 'CIS-1'; } if ($info['col1'] == '1') { if ($temp == '') { $temp = 'CIS-2'; } else { $temp .= ',' . 'CIS-2'; } } if ($info['col2'] == '1') { if ($temp == '') { $temp = 'CIS-3'; } else { $temp .= ',' . 'CIS-3'; } } if ($info['col3'] == '1' || $info['col4'] == '1' || $info['col5'] == '1' || $info['col6'] == '1' || $info['col7'] == '1') { if ($temp == '') { $temp = 'CIS-4'; } else { $temp .= ',' . 'CIS-4'; } } if ($info['col8'] == '1') { if ($temp == '') { $temp = 'CIS-5'; } else { $temp .= ',' . 'CIS-5'; } } if ($info['col9'] == '1' || $info['col9'] == '1') { if ($temp == '') { $temp = 'CIS-6'; } else { $temp .= ',' . 'CIS-6'; } } $str .= "<td>{$temp}</td>"; } $data = ExecuteNonQuery('select * from fclo where csid=' . $syllabusinfo["csid"] . ' and semid=' . $_SESSION['ddlsbssem'] . " and uid=" . $uid); $i = mysqli_num_rows($data); while ($info = mysqli_fetch_assoc($data)) { $str .= "<td>" . $info['docm'] . "</td>"; } $str .= "\r\n\t\t\t\t\t\t\t</tr> \r\n <tr>\r\n <td>Program-Specific Outcomes</td>"; $cnot = substr($cno, 0, 1); if ($cnot == "C") { $data = ExecuteNonQuery('select * from matrix_' . strtolower($version) . " where cno='" . str_replace(" ", "_", $cno) . "'"); } else { $data = ExecuteNonQuery('select * from gmatrix_' . strtolower($version) . " where cno='" . str_replace(" ", "_", $cno) . "'"); } while ($info = mysqli_fetch_assoc($data)) { $temp = ''; if ($info['col11'] == '1' || $info['col12'] == '1') { if ($temp == '') { $temp = 'CS-1'; } else { $temp .= ',' . 'CS-1'; } } if ($info['col13'] == '1' || $info['col14'] == '1') { if ($temp == '') { $temp = 'CS-2'; } else { $temp .= ',' . 'CS-2'; } } if ($info['col15'] == '1') { if ($temp == '') { $temp = 'CS-3'; } else { $temp .= ',' . 'CS-3'; } } if ($info['col16'] == '1') { if ($temp == '') { $temp = 'CS-4'; } else { $temp .= ',' . 'CS-4'; } } if ($info['col17'] == '1') { if ($temp == '') { $temp = 'CS-5'; } else { $temp .= ',' . 'CS-5'; } } if ($info['col18'] == '1' || $info['col19'] == '1' || $info['col20'] == '1' || $info['col21'] == '1') { if ($temp == '') { $temp = 'IS-1'; } else { $temp .= ',' . 'IS-1'; } } if ($info['col22'] == '1') { if ($temp == '') { $temp = 'IS-2'; } else { $temp .= ',' . 'IS-2'; } } if ($info['col23'] == '1' || $info['col24'] == '1') { if ($temp == '') { $temp = 'IS-3'; } else { $temp .= ',' . 'IS-3'; } } if ($info['col25'] == '1') { if ($temp == '') { $temp = 'IS-4'; } else { $temp .= ',' . 'IS-4'; } } if ($info['col26'] == '1' || $info['col27'] == '1' || $info['col28'] == '1' || $info['col29'] == '1' || $info['col30'] == '1' || $info['col31'] == '1') { if ($temp == '') { $temp = 'SE-1'; } else { $temp .= ',' . 'SE-1'; } } if ($info['col32'] == '1') { if ($temp == '') { $temp = 'SE-2'; } else { $temp .= ',' . 'SE-2'; } } if ($info['col33'] == '1') { if ($temp == '') { $temp = 'SE-3'; } else { $temp .= ',' . 'SE-3'; } } $str .= "<td>{$temp}</td>"; } $data = ExecuteNonQuery('select * from fclo where csid=' . $syllabusinfo["csid"] . ' and semid=' . $_SESSION['ddlsbssem'] . " and uid=" . $uid); $i = mysqli_num_rows($data); while ($info = mysqli_fetch_assoc($data)) { $str .= "<td>" . $info['pocm'] . "</td>"; } $str .= "</tr> \r\n </table>\r\n\t </td>\r\n </tr>\r\n\t\t\t <tr>"; $gp = GetSingleField("select gradingpolicy from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem'] . " and uid=" . $uid, "gradingpolicy"); $str .= " \r\n \t \t<td>Grading Policy:</td>\r\n \t<td style='text-align:center'>"; if (isset($gp) && $gp != "") { $str .= str_replace("<table>", "<table border='1'>", $gp); } $str .= "\r\n \t </td>\r\n </tr>\r\n\t\t\t <tr>\r\n \r\n \t<td>Course Policies:</td>\r\n \t\r\n \t\t<td>"; $sql = "select coursepolicy from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem'] . " and uid=" . $uid; $cp = GetSingleField($sql, "coursepolicy"); $str .= $cp; $str .= "</td></tr>\r\n\t\t\t\t\t<tr>\r\n \t\t \t<td>Attendance Policies:</td>\r\n\t\t\t\t\t\t<td>"; $attp = GetSingleField("select attpolicy from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem'] . " and uid=" . $uid, "attpolicy"); $str .= $attp; $str .= "</td></tr>\r\n\t\t\t\t\t <tr>\r\n \r\n \t<td>Academic Integrity:</td>\r\n \t\r\n \t\t<td>"; $ai = GetSingleField("select academicintegrity from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem'] . " and uid=" . $uid, "academicintegrity"); $str .= $ai; $str .= "</td></tr>\r\n\t\t\t\t\t<tr>\r\n \t<td>Course Calendar with Topics:</td>\r\n \t\r\n \t\t<td>"; $cctopics = GetSingleField("select coursetopics from section where csid=" . $syllabusinfo["csid"] . " and semid=" . $_SESSION['ddlsbssem'] . " and uid=" . $uid, "coursetopics"); $csnm = GetSingleField("select sections from course_section where csid=" . $syllabusinfo["csid"], "sections"); $fnm = GetSingleField("select firstname from users where uid=" . $uid, "firstname"); $lnm = GetSingleField("select lastname from users where uid=" . $uid, "lastname"); $str .= $cctopics; $str .= "</td>\r\n </tr></table>"; if (!mkdir("tmpfilesloc", 0777, true)) { $sylarr[$sbscnt] = "tmpfilesloc/" . $csnm . "_" . substr($fnm, 0, 1) . substr($lnm, 0, 1) . ".doc"; $htmltodoc = new HTML_TO_DOC(); $htmltodoc->createDoc($str, $sylarr[$sbscnt]); $sbscnt++; } } if (!mkdir("tmpzips", 0777, true)) { //----------------Creating zip $file = 'tmpzips/allcourses.zip'; if (file_exists($file)) { unlink($file); } $result = create_zip($sylarr, 'tmpzips/allcourses.zip'); } // We'll be outputting a PDF header('Content-type: application/zip'); // It will be called downloaded.pdf header('Content-Disposition: attachment; filename=allcourses.zip'); // The PDF source is in original.pdf readfile('tmpzips/allcourses.zip'); // return $str; // rmdir("tmpfilesloc"); //----------------------------- } else { } }
</td> <td><?php echo $info["email"]; ?> </td> <td><?php echo $info["office"]; ?> </td> <td><?php echo $info["officeno"]; ?> </td> <td> <?php $semid = GetSingleField("select semid from semester where active=1", "semid"); $data1 = ExecuteNonQuery("select cday,starttime,endtime from facultyhours where uid=" . $info["uid"] . " and semid=" . $semid . " and type='office'"); while ($info1 = mysqli_fetch_assoc($data1)) { echo $info1["cday"] . " " . $info1["starttime"] . ":" . $info1["endtime"] . "<br>"; } ?> </td> </tr> <?php } ?> </table> </form> </div> </div> <div id="footer">
?> <?php if (isset($_POST["submit"])) { $errors = array(); $required_fields = array('username', 'password'); $errors = array_merge($errors, check_required_fields($required_fields, $_POST)); if (empty($errors)) { $unm = $_POST["username"]; $pwd = $_POST["password"]; $cnt = CountRecords("select * from users where username='******' and password='******' and permission=1"); // echo ".............".$usrid."asdas ".$permission; if ($cnt > 0) { $usrid = GetSingleField("select uid from users where username='******' and password='******'", "uid"); $permission = GetSingleField("select permission from users where username='******' and password='******'", "permission"); $activefld = GetSingleField("select active from users where username='******' and password='******'", "active"); if ($activefld == "1") { $_SESSION["a_username"] = $unm; $_SESSION["a_userid"] = $usrid; $_SESSION["a_usrpermission"] = $permission; redirect_to('welcome.php'); } else { $message = "You are not active user..Please contact administrator"; } } else { $message = "Username or password is incorrect..."; } } else { if (count($errors) == 1) { $message = "There was 1 error in the form."; } else {
$tmp = strpos($matrixfields[0][$i], ")"); $tmp1 = substr($matrixfields[0][$i], 0, $tmp + 1); $strqry .= "('" . $matrixfields[0][$i] . "','" . str_replace(")", "\\)", $tmp1) . "','{$ver}'),"; } $strqry = substr($strqry, 0, strlen($strqry) - 1); //echo $strqry."<br><br>"; ExecuteNonQuery($strqry); //--------------------------------------------------------UPLOAD SUB OUTCOMES--------------------------------------------------------------------- $strqry = "insert into sub_outcomes(docmid,socmname,version)values"; // echo "<tr><th>Course Outcomes</th></tr>"; for ($i = 2; $i < $cols - 1; $i++) { // echo "<tr>"; // echo "<td>".$matrixfields[$i][1]."</td>"; // echo "</tr>"; // echo $matrixfields[0][$i]; $id = GetSingleField("select docmid from dept_outcomes where docname='" . $matrixfields[0][$i] . "'", "docmid"); $strqry .= "(" . $id . ",'" . str_replace(")", "\\)", $matrixfields[1][$i]) . "','{$ver}'),"; } $strqry = substr($strqry, 0, strlen($strqry) - 1); // echo $strqry."<br><br>"; ExecuteNonQuery($strqry); //-----------------------------------------------------UPLOAD MAPPINGS------------------------------------------------------------------------------ $flag = 0; $tnm = "matrix_{$ver}"; $strqry = "create table {$tnm}("; $strcols = ""; for ($i = 0; $i < $cols - 3; $i++) { $strcols .= "col{$i} int,"; } $strqry = $strqry . $strcols . "requiredcol text,cno text,objno int,version text)"; // echo $strqry."<br><br>";
$cday = $matrixfields[$i][14]; $rno = $matrixfields[$i][15] . $matrixfields[$i][16]; $sid = $_SESSION["ddlcssem"]; $tmp1 = explode(" ", $matrixfields[$i][5]); if (count($tmp1) != 3) { $namelist[$nmcnt] = $matrixfields[$i][0]; $nmcnt++; continue; } // print_r($tmp1); $sql = "select * from users where salutation like '" . $tmp1[0] . "' and firstname like '" . $tmp1[1] . "%' and lastname like '" . $tmp1[2] . "'"; //echo $sql."<br>"; $cnt2 = CountRecords($sql); if ($cnt2 != 0) { $sql = "select uid from users where salutation like '" . $tmp1[0] . "' and firstname like '" . $tmp1[1] . "%' and lastname like '" . $tmp1[2] . "'"; $uid = GetSingleField($sql, "uid"); $cntrec3 = CountRecords("select * from facultyhours where semid=" . $sid . " and uid=" . $uid . " and csid=" . $csid); if ($cntrec3 == 0) { $sql = "insert into facultyhours(csid,starttime,endtime,type,cday,roomno,uid,semid)values("; $sql .= "{$csid},'{$sttime}','{$entime}','{$type}','{$cday}','{$rno}',{$uid},{$sid})"; ExecuteNonQuery($sql); // echo $sql; $sql = "select camname from cams where csid={$csid} and uid={$uid} and semid={$sid}"; $cnt = CountRecords($sql); if ($cnt == 0) { $sql1 = "insert into cams(camname,camdetails,csid,uid,semid)values('Assignments:','Students will periodically be assigned homework assignments related to software design principles, patterns and architecture, Due dates will be announced in class.',{$csid},{$uid},{$sid}),\r\n\t\t\t\t\t\t\t('Examinations/Quizzes:','Students will periodically take in-class examinations covering knowledge and application of software design principles,design patterns,architecture and related topics from the assigned readings,course notes,and homework.',{$csid},{$uid},{$sid}),\r\n\t\t\t\t\t\t\t('Project:','The project shall be staffed by individual student who will indentify design patterns/architecture present in open source software. Recommendation for areas of improvement using design patterns with rationale and implementation can be parts of the project.',{$csid},{$uid},{$sid})"; ExecuteNonQuery($sql1); // echo $sql1; } } else { $sql = "update facultyhours set starttime='" . $sttime . "',endtime='" . $entime . "',type='" . $type . "',cday='" . $cday . "',roomno='" . $rno . "' where csid=" . $csid . " and uid=" . $uid . " and semid=" . $sid;
?> " value="<?php echo $info["pocm"]; ?> "></td> <?php } } ?> </tr> </table> </td> </tr> <tr> <?php $gp = GetSingleField("select gradingpolicy from section where csid=" . $_SESSION["mapcsid"] . " and uid=" . $_SESSION["userid"] . " and semid=" . $_SESSION["ddlsem3"], "gradingpolicy"); ?> <td>Grading Policy</td> <td>:</td> <td> <textarea name="tagp" id="tagp" rows="10" cols="50"> <?php if (isset($gp) && $gp != "") { echo $gp; } else { ?> <table> <tr> <td style="vertical-align:top;"> <table border="1"> <tr>
$cid = GetSingleField("select coreqid from courses where cid=(select cid from course_section where csid=" . $info2["csid"] . ")", "coreqid"); $cdesc = GetSingleField("select description from courses where cid=(select cid from course_section where csid=" . $info2["csid"] . ")", "description"); $prnm = GetSingleField("select pcname from pre_req where prereqid=" . $pid, "pcname"); $crnm = GetSingleField("select ccname from co_req where coreqid=" . $cid, "ccname"); $credits = GetSingleField("select credits from courses where cid=(select cid from course_section where csid=" . $info2["csid"] . ")", "credits"); $csnm = GetSingleField("select sections from course_section where csid=" . $info2["csid"], "sections"); $cnm = $info2["name"]; $reqm = $info2["reqmaterials"]; $sal = GetSingleField("select salutation from users where uid=" . $info2["uid"], "salutation"); $fnm = GetSingleField("select firstname from users where uid=" . $info2["uid"], "firstname"); $lnm = GetSingleField("select lastname from users where uid=" . $info2["uid"], "lastname"); $email = GetSingleField("select email from users where uid=" . $info2["uid"], "email"); $rno = GetSingleField("select roomno from facultyhours where csid=" . $info2["csid"], "roomno"); $cday = GetSingleField("select cday from facultyhours where csid=" . $info2["csid"], "cday"); $sttime = GetSingleField("select starttime from facultyhours where csid=" . $info2["csid"], "starttime"); $entime = GetSingleField("select endtime from facultyhours where csid=" . $info2["csid"], "endtime"); $web = $info2["website"]; $gp = $info2["gradingpolicy"]; $cp = $info2["coursepolicy"]; $ap = $info2["attpolicy"]; $ai = $info2["academicintegrity"]; $ct = $info2["coursetopics"]; } ?> <h2 class="wow fadeIn">Select Course</h2> <div id="courseinfo"> <div class="content-row wow fadeIn"> <div class="content-column"> Course Name </div> <div class="content-column">