function main($username, $password, $option) { $loginUrl = 'http://evarsity.srmuniv.ac.in/srmswi/usermanager/youLogin.jsp'; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $loginUrl); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, 'txtSN=' . $username . '&txtPD=' . $password . '&txtPA=1'); curl_setopt($ch, CURLOPT_COOKIEJAR, 'cookie.txt'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $store = curl_exec($ch); if (strpos($store, "Login failed, Username and password do not match") == false) { if ($option == "1") { $ret = storeDatabase("account_details", "('" . $username . "','" . $password . "')"); if ($ret == 1) { getDetails($username, $ch); } } else { if ($option == "2") { getMarks($username, $ch); } else { if ($option == "3") { getAttendance($usename, $ch); } } } } else { echo "fail"; } }
function getAllMarksOfTestArranged1($testObj, $order) { $conn = getConnection(); $list = array(); $query = "SELECT * FROM marks WHERE testID = '" . $testObj->getID() . "' AND activeflag!=-3 ORDER BY mark DESC"; $result = mysql_query($query); while ($member = mysql_fetch_array($result)) { $tempstu = getStudent($member['studentID'], 1); $tempmark = getMarks($member['ID']); $temparray = array($tempstu, $tempmark); //$temp = array($stuobj[$i]); array_push($list, $temparray); } if (count($list) != 0) { return $list; } return NULL; }
$db->query($query_insert_marks); $db->query($query_insert_groups); $db->query($query_insert_models); $db->query($query_insert_modifications); } if ($_model) { $c["list"] = getModifications($_model); $c["link"] = "modification"; } elseif ($_group) { $c["list"] = getModels($_group); $c["link"] = "model"; } elseif ($_mark) { $c["list"] = getGroups($_mark, $_cat); $c["link"] = "group"; } elseif ($_cat) { $cat_children = getCategories($_cat); if (count($cat_children) > 0) { $c["list"] = $cat_children; $c["link"] = "cat"; } else { $c["list"] = getMarks(); $c["link"] = "mark"; } } else { $c["list"] = $categories; $c["link"] = "cat"; } $c["uri"] = $_SERVER['REQUEST_URI']; echo $twig->render($template, $c); //print_r($errors); }
function getHighestMarks() { $conn = getConnection(); if ($this->getType() == 0) { $query = "SELECT * FROM marks WHERE testID='" . $this->ID . "' ORDER BY mark DESC"; $result = mysql_query($query, $conn); $member = mysql_fetch_array($result); $temp = getMarks($member['ID']); if ($temp != NULL) { return $temp; } return NULL; } else { $testlist = array(); $testlist = $this->getCommonTests(); $condition = ''; for ($i = 0; $i < count($testlist); $i++) { $condition .= "testID = '" . $testlist[$i]->getID() . "' "; if ($i != count($testlist) - 1) { $condition .= "OR "; } } $query = "SELECT * FROM marks WHERE " . $condition . " ORDER BY mark DESC"; $result = mysql_query($query); $member = mysql_fetch_array($result); $temp = getMarks($member['ID']); if ($temp != NULL) { return $temp; } return NULL; } }
function getHighestMarks() { $conn = getConnection(); $query = "SELECT * FROM marks WHERE testID='" . $this->ID . "' ORDER BY mark DESC"; $result = mysql_query($query, $conn); $member = mysql_fetch_array($result); $temp = getMarks($member['ID']); if ($temp != NULL) { return $temp; } return NULL; }