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