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