function updatePassword($login, $newpwd) { $sql = "UPDATE `userlogin` SET `password`='" . $newpwd . "' "; $sql .= "WHERE userlogin.idUserRegistration=(SELECT `idUserRegistration` FROM "; $sql .= "`userregistration` WHERE `emailID`='" . $login . "') OR userlogin.username='******';"; $gsql = "SELECT * FROM userlogin WHERE `emailID`='" . $login . "'"; $dbObj = new InteractDatabase(); $dbObj->addupdateData($sql); $json = $dbObj->getJSONData($gsql); return $json; }
function courseUserTest($userID, $courseID, $testType, $testTaken, $questionResults, $marksResults, $examStatus) { $sql = "INSERT INTO `usercoursetest`(`userID`, `courseID`, `testType`, `testTaken`,`ExamDate`, `questionResults`, `marksResults`, `ExamStatus`) "; $sql .= "VALUES (" . $userID . "," . $courseID . ",'" . $testType . "'," . $testTaken . ",'" . date('Y-m-d') . "','" . $questionResults . "','" . $marksResults . "','" . $examStatus . "')"; echo $sql; $dbObj = new InteractDatabase(); $dbObj->addupdateData($sql); }
} } } } } // echo $idTestDetails.' | '.$courselinkId.' | '; // echo $question.' | '.$option1.' | '; // echo $option2.' | '.$option3.' | '; // echo $option4.' | '.$answer.' | '.$active.' | '.' \n'; $question = urlencode($question); $option1 = urlencode($option1); $option2 = urlencode($option2); $option3 = urlencode($option3); $option4 = urlencode($option4); $insertSql = "INSERT INTO `testquestions`( `idTestDetails`, `courselinkId`, `question`, `option1`, `option2`, `option3`, `option4`, `answer`, `active`) "; $insertSql .= "VALUES (" . $idTestDetails . "," . $courselinkId . ",'" . $question . "','" . $option1 . "','" . $option2 . "','" . $option3 . "','" . $option4 . "','" . $answer . "'," . $active . ");"; echo $insertSql; $dbObj = new InteractDatabase(); $dbObj->addupdateData($insertSql); } // print_r($Row); } } } } catch (Exception $E) { echo $E->getMessage(); } echo "LastLine : "; for ($headerIndex = 0; $headerIndex < count($colheader); $headerIndex++) { echo "\n" . $colheader[$headerIndex]; }
function activateCoursesDetails($courseLinksID, $userID, $CourseID, $View) { $sql = "INSERT INTO `courseuserview`( `courseLinksID`, `userID`, `CourseID`, `View`) "; $sql .= "VALUES (" . $courseLinksID . "," . $userID . "," . $CourseID . "," . $View . ")"; echo $sql; $dbObj = new InteractDatabase(); $dbObj->addupdateData($sql); }