function userCourseCourseNameReports()
{
$sql = "SELECT DISTINCT courseName FROM usercoursetest, userregistration, courses WHERE usercoursetest.userID=userregistration.idUserRegistration AND courses.idCourses=usercoursetest.courseID";
$dbObj = new InteractDatabase();
$json = $dbObj->getJSONData($sql);
return $json;
}
} else {
$rows = array();
while ($row = $result->fetch_assoc()) {
$rows[] = $row;
}
/* $rows = mysqli_fetch_all($result, MYSQLI_ASSOC); */
$json = json_encode($rows);
//This function returns the JSON representation of a value on success or FALSE on failure.
}
mysqli_free_result($result);
//The mysqli_free_result() function frees the memory associated with the result
$conn->close();
return $json;
}
function getSharedServerJSONData($sql)
{
$db = new interactDatabase();
$conn = $db->dbinteraction();
$arr = array();
$result = mysqli_query($conn, $sql);
$totalrecords = mysqli_num_rows($result);
while ($row = mysqli_fetch_assoc($result)) {
$arr[] = $row;
}
$json = json_encode($arr, true);
$conn->close();
return $json;
}
}
$db = new InteractDatabase();
$db->dbinteraction();
function getAdminTestResults()
{
$sql = "SELECT firstName, lastName, courseName, testType,questionResults, marksResults, ExamDate, ExamStatus ";
$sql .= " FROM `usercoursetest`, `courses`, `userregistration` WHERE `courses`.idCourses= `usercoursetest`.courseID ";
$sql .= " AND `usercoursetest`.userID=`userregistration`.idUserRegistration";
$dbObj = new InteractDatabase();
$json = $dbObj->getJSONData($sql);
echo $json;
}
}
}
}
}
}
// 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 getListOfActivatedCourseDetails($userId, $courseId)
{
$sql = "SELECT * FROM `courseuserview` WHERE `userID`=" . $userId . " AND CourseID=" . $courseId;
$dbObj = new InteractDatabase();
$json = $dbObj->getJSONData($sql);
return $json;
}
