<th><center>Status</center>
<table style="font-size:15px;width:100%" cellpadding="3px">
<td>M</td>
<td>RM</td>
<td>Web</td>
<td>GP</td>
<td>CP</td>
<td>AI</td>
<td>CT</td>
</table>
</th>
</tr>
<?php
$data = ExecuteNonQuery('select * FROM section where uid=' . $_SESSION["userid"] . " and semid=" . $semid . " and active=1");
while ($info = mysqli_fetch_assoc($data)) {
$cntrecords = CountRecords("select * from fcamm where csid=" . $info["csid"] . " and semid=" . $info["semid"] . " 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=" . $info["csid"] . " and semid=" . $info["semid"] . " and uid=" . $info["uid"];
//echo $sql;
$sfld = GetSingleField($sql, "Total");
if ($sfld != 0) {
$cntrecords = 1;
} else {
$cntrecords = 0;
}
} else {
$cntrecords = 0;
}
$csnm = GetSingleField("select sections from course_section where csid=" . $info["csid"], "sections");
?>
<tr>
$unm = $_POST["username"];
$pwd = $_POST["password"];
$fnm = $_POST["firstname"];
$lnm = $_POST["lastname"];
$sal = $_POST["ddlsal"];
$eml = $_POST["email"];
$office = $_POST["office"];
$user = $_POST["ddluser"];
$active = $_POST["cbxactive"];
// echo $active;
if ($active == "on") {
$active = 1;
} else {
$active = 0;
}
$chkusrexist = CountRecords("select * from users where username='******'");
if ($chkusrexist == 0) {
if ($_POST["password"] == $_POST["confirmpassword"]) {
$strinsert = "insert into users(username,password,firstname,lastname,salutation,\r\n\t\t\t\t\t\temail,office,permission,active) values('" . $unm . "','" . $pwd . "','" . $fnm . "','" . $lnm . "','" . $sal . "','" . $eml . "','" . $office . "',b'" . $user . "',b'" . $active . "')";
echo $strinsert;
$cnt = ExecuteNonQuery($strinsert);
if ($cnt == 1) {
redirect_to("viewfaculties.php?msg=Record inserted successfully.&flag=1");
} else {
redirect_to("viewfaculties.php?msg=Error in inserting record..Please try later.&flag=2");
}
} else {
$message = "There was 1 error in the form.";
single_errormessage('Password and Confirm password does not match');
}
} else {
} else {
$coreq = $_POST["ddlcoreq"];
}
if (trim($_POST["txtprereq"]) != "" && isset($_POST["txtprereq"])) {
$cntrec = CountRecords("select * from pre_req where pcname like '" . $_POST["txtprereq"] . "'");
if ($cntrec == 1) {
$prereq = GetSingleField("select prereqid from pre_req where pcname like '" . $_POST["txtprereq"] . "'", "prereqid");
} else {
$sql = "insert into pre_req(pcname)values('" . str_replace("'", "\\'", $_POST["txtprereq"]) . "')";
ExecuteNonQuery($sql);
$prereq = GetSingleField("SELECT MAX(prereqid) as newid from pre_req", "newid");
// echo $prereq;
}
}
if (trim($_POST["txtcoreq"]) != "" && isset($_POST["txtcoreq"])) {
$cntrec = CountRecords("select * from co_req where ccname like '" . $_POST["txtcoreq"] . "'");
if ($cntrec == 1) {
$coreq = GetSingleField("select coreqid from co_req where ccname like '" . $_POST["txtcoreq"] . "'", "coreqid");
} else {
$sql = "insert into co_req(ccname)values('" . str_replace("'", "\\'", $_POST["txtcoreq"]) . "')";
$cnt = ExecuteNonQuery($sql);
$coreq = GetSingleField("SELECT MAX(coreqid) as newid from co_req", "newid");
}
}
$credits = $_POST["txtcredits"];
// $cdet=str_replace("'","\'",$cdet);
$sql = "insert into courses(courseno,coursename,special,description,prereqid,coreqid,credits,active,deptid)values(";
$sql .= "'" . strtoupper($cid) . "','" . $cnm . "',{$spActive},'{$cdet}',{$prereq},{$coreq},{$credits},{$i},1)";
// echo $sql;
ExecuteNonQuery($sql);
redirect_to("viewcourses.php");
</td>
</tr>
<tr>
<td>Assessment Method Mappings</td>
<td>:</td>
<td>
<?php
$myc = substr($cnm, 0, 1);
if ($myc == "C") {
$cnt = CountRecords("select cocmid from course_mappings where cno='" . $cnm . "' and version='" . $version . "'");
} else {
$cnt = CountRecords("select cocmid from gcourse_mappings where cno='" . $cnm . "' and version='" . $version . "'");
}
$sql = "select * from fclo where semid=" . $_SESSION["ddlsem3"] . " and uid=" . $_SESSION["userid"] . " and csid=" . $_SESSION["mapcsid"];
$cnt2 = CountRecords($sql);
?>
<table align="left" border="1">
<tr>
<td rowspan="2">ASSESSMENT METHODS</td>
<td colspan="<?php
echo $cnt + $cnt2;
?>
" align="center">
OBJECTIVES
</td>
</tr>
<tr>
<?php
for ($i = 1; $i <= $cnt + $cnt2; $i++) {
<?php
include "includes/DataAccess.php";
ini_set('display_errors', 'off');
$q = $_GET["q"];
$cntrec = CountRecords('select * FROM objectives where subid=' . $q) or die(mysql_error());
if ($cntrec > 0) {
$data = ExecuteNonQuery('select * FROM objectives where subid=' . $q) or die(mysql_error());
while ($info = mysql_fetch_assoc($data)) {
?>
<table>
<tr>
<td class="namecol">Objective 1</td>
<td>:</td>
<td><input type="text" name="objective1" value="<?php
echo $info["obj1"];
?>
" class="inputtext"></td>
</tr>
<tr>
<td class="namecol">Objective 2</td>
<td>:</td>
<td><input type="text" name="objective2" value="<?php
echo $info["obj2"];
?>
" class="inputtext"></td>
</tr>
<tr>
<td class="namecol">Objective 3</td>
<td>:</td>
<td><input type="text" name="objective3" value="<?php
<tr>
<td>Visible</td>
<td>:</td>
<td><input type="checkbox" name="cbvisible" <?php
if ($visible == 1) {
echo "checked";
}
?>
></td>
</tr>
<tr>
<td>Display Order</td>
<td>:</td>
<td>
<?php
$cntrec = CountRecords("select disporder from banners");
$i = 1;
?>
<select name="dispord">
<?php
while ($i <= $cntrec) {
?>
<option value="<?php
echo $i;
?>
" <?php
if ($i == $dispord) {
echo "selected";
}
</div>
</td>
</tr>
<tr>
<td>Assessment Method Mappings:</td>
<td>
<?php
$frstc = substr($cno, 0, 1);
if ($frstc == "C") {
$cnt = CountRecords("select cocmid from course_mappings where cno='" . $cno . "' and version='" . $version . "'");
} else {
$cnt = CountRecords("select cocmid from gcourse_mappings where cno='" . $cno . "' and version='" . $version . "'");
}
$cnt2 = CountRecords("select * from fclo where semid=" . $_SESSION["ddlsem4"] . " and uid=" . $_SESSION["userid"] . " and csid=" . $_POST["ddlcnm"]);
?>
<table align="left" border="1" style="text-align:center">
<tr>
<td rowspan="2">ASSESSMENT METHODS</td>
<td colspan="<?php
echo $cnt + $cnt2;
?>
" align="center">
OBJECTIVES
</td>
</tr>
<tr>
<?php
for ($i = 1; $i <= $cnt + $cnt2; $i++) {
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");
}
if (isset($_POST["ddlcourse"])) {
$sql = "select sections from course_section where cid=" . $_POST["ddlcourse"] . " and active=1";
//for graduate
//rdb name: cbx_oa,cbx_ob,cbx_oc
require_once "includes/session.php";
include "includes/DataAccess.php";
include_once "includes/form_functions.php";
if (!logged_in()) {
redirect_to("index.php");
}
if (isset($_POST["btnsubmit"])) {
$errors = array();
$required_fields = array('oldpassword', 'newpassword', 'confirmpassword');
$errors = array_merge($errors, check_required_fields($required_fields, $_POST));
$opwd = $_POST["oldpassword"];
$npwd = $_POST["newpassword"];
$cpwd = $_POST["confirmpassword"];
if (empty($errors)) {
if ($npwd == $cpwd) {
$cntrec = CountRecords("select * from users where id=" . $_SESSION["a_userid"] . " and password='******'");
echo $cntrec;
if ($cntrec > 0) {
$query = "update users set password='******' where id=" . $_SESSION["a_userid"];
$ctrec = ExecuteNonQuery($query);
if ($ctrec == 1) {
// redirect_to("changepassword.php?msg=Password successfully.&flag=1");
redirect_to("logout.php");
} else {
redirect_to("changepassword.php?msg=Error in updating password..Please try later.&flag=2");
}
} else {
$message = "password is incorrect...Please try later.";
}
} else {
$message = "There was 1 error in the form.";
}
if (trim($info1["corequisite"]) != "" && !is_null($info1["corequisite"]) && strlen(trim($info1["corequisite"])) > 0) {
$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>";
<table>
<tr>
<td>Upload file(.csv only)</td>
<td>:</td>
<td><input type="file" name="matrixfile"></td>
</tr>
<tr>
<td>Make new version</td>
<td>:</td>
<?php
$currentver = "";
if ($_GET["flag"] == "1") {
$cnt = CountRecords("select filename from fileinfo where ftype='gmatrix'");
} else {
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 {
if (!empty($subid) || !empty($subrid)) {
if ($subid != $subrid) {
$q1 = CountRecords("select * from objectives where subid =" . $subid);
$flag = 0;
if ($q1 == 0) {
$flag = 1;
} else {
$q2 = ExecuteNonQuery("select * from objectives where subid=" . $subid);
while ($inf1 = mysql_fetch_assoc($q2)) {
if (empty($inf1["obj1"]) && empty($inf1["obj2"]) && empty($inf1["obj3"]) && empty($inf1["obj4"]) && empty($inf1["obj5"])) {
$flag = 1;
}
}
}
if ($flag == 0) {
$cntrec = CountRecords("select * from outcomes_Result where subid={$subid}");
if ($cntrec == 0) {
$query = ExecuteNonQuery("select * from outcomes_result where subid={$subid}");
// echo $query;
$strinsert = "insert into outcomes_result(ocmdetailid,obj1,obj2,obj3,obj4,obj5,subid,userid)values";
while ($info2 = mysql_fetch_assoc($query)) {
$strinsert .= "(";
$strinsert .= $info2["ocmdetailid"] . ",b'" . $info2["obj1"] . "',b'" . $info2["obj2"] . "',b'" . $info2["obj3"] . "',b";
$strinsert .= "'" . $info2["obj4"] . "',b'" . $info2["obj5"] . "'," . $subrid . "," . $_SESSION["userid"] . "),";
}
$strinsert = substr($strinsert, 0, -1);
echo $strinsert;
$cnt = ExecuteNonQuery($strinsert);
if ($cnt > 0) {
redirect_to("retrivesurvey.php?msg=Survey inserted successfully&flag=1");
} else {
<?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");
ob_start();
ini_set('display_errors', 'off');
require_once "includes/functions.php";
require_once "includes/session.php";
include "includes/DataAccess.php";
include_once "includes/form_functions.php";
if (!logged_in()) {
redirect_to("index.php");
}
if (isset($_POST["btnsubmit"])) {
$obj1 = $_POST["objective1"];
$obj2 = $_POST["objective2"];
$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);
<label><?php
echo $prereq;
?>
<?php
}
?>
</td>
</tr>
<tr>
<td>Corequisite</td>
<td>:</td>
<td>
<?php
$flag = 0;
if ($coreq != "") {
$cntrec = CountRecords("select ccname from co_req where ccname='" . $coreq . "'");
if ($cntrec == 0) {
$flag = 1;
}
} else {
$flag = 1;
}
?>
<?php
if ($flag == 1) {
?>
<input type="text" value="<?php
echo $coreq;
?>
" name="txtcoreq" id="txtcoreq">
if ($_POST["ddlfac"] == $info["uid"]) {
echo "selected";
}
?>
><?php
echo $info["firstname"] . " " . $info["lastname"];
?>
</option>
<?php
}
?>
</select>
</td>
</tr>
<?php
$cnt = CountRecords("select sections from course_section where semid=" . $_SESSION["ddlsem1"]);
if ($cnt == 0) {
$data1 = ExecuteNonQuery('select csid,sections from course_section');
}
?>
<tr>
<td align="right">
<br>
Sections
<select size="10" id="select1" name="select1[]" multiple>
<?php
while ($info1 = mysqli_fetch_assoc($data1)) {
?>
<option value="<?php
echo $info1["csid"];
?>
$data = ExecuteNonQuery('select uid FROM section where semid=' . $_SESSION["statusincsem"] . " group by uid");
while ($info = mysqli_fetch_assoc($data)) {
$fnm = GetSingleField("select firstname from users where uid=" . $info["uid"], "firstname");
$lnm = GetSingleField("select lastname from users where uid=" . $info["uid"], "lastname");
?>
<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>
<?php
$cnt++;
}
} else {
$cntrec = CountRecords("select * from course_mappings where cno='" . str_replace(" ", "_", $cno) . "' and version='" . $ver . "'");
?>
<input type="hidden" value="<?php
echo $cntrec + $cnt2;
?>
" name="hfclotot" id="hfclotot">
<?php
}
} else {
$ver = GetSingleField("SELECT version FROM fileinfo where active=1 and ftype='gmatrix'", "version");
$cntrec = CountRecords("select * from gcourse_mappings where cno='" . str_replace(" ", "_", $cno) . "' and version='" . $ver . "'");
if ($cntrec > 0) {
$data2 = ExecuteNonQuery("select mappingname from gcourse_mappings where cno='" . str_replace(" ", "_", $cno) . "' and version='" . $ver . "'");
$cnt = 1;
while ($info2 = mysqli_fetch_assoc($data2)) {
?>
<tr>
<td>
<input type="text" name="<?php
echo "txtclo_" . $cnt;
?>
" value="<?php
echo $info2["mappingname"];
?>
" size="70" disabled>
<input type="hidden" value="<?php
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 {
}
}
<?php
ini_set('display_errors', 'off');
include "includes/DataAccess.php";
require_once "includes/functions.php";
echo "hello";
$id = $_GET["id"];
$cnt = ExecuteNonQuery("delete from subject where subid=" . $id);
$cntrec = CountRecords("select * from outcomes_result where subid=" . $id);
if ($cntrec > 0) {
$cnt = ExecuteNonQuery("delete from outcomes_result where subid=" . $id);
}
if ($cnt > 0) {
redirect_to("viewsubjects.php?flag=1&msg=Record deleted successfully");
}
ini_set('display_errors', 'on');
require_once "includes/functions.php";
require_once "includes/session.php";
include_once "includes/DataAccess.php";
include_once "includes/form_functions.php";
?>
<?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...";
<tr>
<td>Visible</td>
<td>:</td>
<td><input type="checkbox" name="cbvisible" <?php
if ($visible == 1) {
echo "checked";
}
?>
></td>
</tr>
<tr>
<td>Display Order</td>
<td>:</td>
<td>
<?php
$cntrec = CountRecords("select disporder from images");
$i = 1;
?>
<select name="dispord">
<?php
while ($i <= $cntrec) {
?>
<option value="<?php
echo $i;
?>
" <?php
if ($i == $dispord) {
echo "selected";
}
require_once "includes/functions.php";
include_once "includes/DataAccess.php";
if (!logged_in()) {
redirect_to("index.php");
}
if (isset($_POST["Submit"])) {
$errors = array();
$required_fields = array('txtyear');
$errors = array_merge($errors, check_required_fields($required_fields, $_POST));
if (empty($errors)) {
$i = 0;
if (isset($_POST["cbxactive"])) {
ExecuteNonQuery("update semester set active=0");
$i = 1;
}
$crec = CountRecords("select * from semester");
$str = "insert into semester(semname,year,active,sortorder)";
$str .= "values('" . $_POST["ddlsem"] . "','" . $_POST["txtyear"] . "',{$i}," . ++$crec . ")";
// echo $str;
$cnt = ExecuteNonQuery($str);
if ($cnt == 1) {
redirect_to("viewsemesters.php");
} else {
show_alert("Error in adding record..Please verify values");
}
} else {
if (count($errors) == 1) {
$message = "There was 1 error in the form.";
} else {
$message = "There were " . count($errors) . " errors in the form.";
}
session_start();
}
if (isset($_POST["Submit"])) {
if (isset($_SESSION["ver"])) {
if (isset($_POST["cbxactive"])) {
if ($_GET["flag"] == "0") {
$cnt = CountRecords("select * from fileinfo where ftype='matrix'");
if ($cnt != 0) {
ExecuteNonQuery("update fileinfo set active=0 where ftype='matrix'");
}
$sql = "update fileinfo set active=1 where version='" . $_SESSION["ver"] . "' and ftype='matrix'";
ExecuteNonQuery($sql);
redirect_to("welcome.php");
} else {
if ($_GET["flag"] == "1") {
$cnt = CountRecords("select * from fileinfo where ftype='gmatrix'");
if ($cnt != 0) {
ExecuteNonQuery("update fileinfo set active=0 where ftype='gmatrix'");
}
$sql = "update fileinfo set active=1 where version='" . $_SESSION["ver"] . "' and ftype='gmatrix'";
ExecuteNonQuery($sql);
redirect_to("welcome.php");
}
}
}
}
}
?>
<!doctype html>
<html>
<head>
</div>
<?php
$data1 = ExecuteNonQuery('select * from outcomes_detail where ocmmainid=' . $info["ocmmainid"]) or die(mysql_error());
$cnt = 1;
echo "<table width=100%;padding-top:2px;>";
$cnt = 1;
while ($info1 = mysql_fetch_assoc($data1)) {
?>
<?php
$cntcbx = 0;
echo "<tr><td>" . $cnt . "</td><td WIDTH=80% style=font-size:14px>" . $info1["subobj"] . "</td>";
echo "<td align=right;>";
echo "<div style=float:right>";
$noofrec = CountRecords("select * from outcomes_result where subid=" . $q);
if ($noofrec > 0) {
$data2 = ExecuteNonQuery("select obj1,obj2,obj3,obj4,obj5 from outcomes_result where subid=" . $q . " and ocmdetailid=" . $info1["ocmdetailid"]);
while ($info2 = mysql_fetch_assoc($data2)) {
?>
<?php
if (!empty($obj1)) {
?>
<input type=checkbox name=mycb<?php
echo $info1["ocmdetailid"];
?>
[<?php
echo $cntcbx;
?>
]
</div>
<?php
$data1 = ExecuteNonQuery('select * from outcomes_detail where ocmmainid=' . $info["ocmmainid"]) or die(mysql_error());
$cnt = 1;
echo "<table width=100%;padding-top:2px;>";
$cnt = 1;
while ($info1 = mysql_fetch_assoc($data1)) {
?>
<?php
$cntcbx = 0;
echo "<tr><td>" . $cnt . "</td><td WIDTH=80% style=font-size:14px>" . $info1["subobj"] . "</td>";
echo "<td align=right;>";
echo "<div style=float:right>";
$noofrec = CountRecords("select * from outcomes_result where subid=" . $q . " and ocmdetailid=" . $info1["ocmdetailid"]);
if ($noofrec > 0) {
$data2 = ExecuteNonQuery("select obj1,obj2,obj3,obj4,obj5 from outcomes_result where subid=" . $q . " and ocmdetailid=" . $info1["ocmdetailid"]);
while ($info2 = mysql_fetch_assoc($data2)) {
?>
<?php
if (!empty($obj1)) {
?>
<input type=checkbox name=mycb<?php
echo $info1["ocmdetailid"];
?>
[<?php
echo $cntcbx;
?>
]
$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;
$cnt = CountRecords("select * from course_mappings where cno='" . str_replace(" ", "_", $cno) . "'");
$cnt2 = CountRecords('select * from fclo where semid=' . $_SESSION["ddlsbssem"] . ' and csid=' . $syllabusinfo["csid"]);
$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"];
$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'], $objnm);
$str .= "<td>";
