コード例 #1
0
 function remainingCourses()
 {
     $db = new DatabaseConnector();
     $return = [];
     $stmt = "SELECT CourseInfo.courseID, CourseInfo.courseName, CourseInfo.credits, StudentCourse.weight, StudentCourse.relevance FROM StudentCourse INNER JOIN CourseInfo ON StudentCourse.courseInfoID = CourseInfo.courseInfoID WHERE userID = ? AND (grade = 'IP' OR grade = 'ND')";
     $params = array($this->userID);
     $output = $db->select($stmt, $params);
     if (count($output) == 0) {
         $this->log->toLog(2, __METHOD__, "No course information available");
         echo json_encode([]);
         return;
     }
     for ($i = 0, $c = count($output); $i < $c; $i++) {
         if ($output[$i][3] == "") {
             $this->log->toLog(3, __METHOD__, "weight is null");
         } else {
             if ($output[$i][4] == "") {
                 $this->log->toLog(3, __METHOD__, "relevance is null");
             }
         }
         $courseID = $output[$i][0];
         $courseName = $output[$i][1];
         $credits = $output[$i][2];
         $courseWeight = $output[$i][3];
         $courseRelevance = $output[$i][4];
         array_push($return, array($courseID, $courseName, $credits, $courseWeight, $courseRelevance));
     }
     echo json_encode($return);
     return $return;
 }
コード例 #2
0
ファイル: BdManager.php プロジェクト: nadiadev/bdloc
 public function getRandomBd()
 {
     $dbConnector = new DatabaseConnector();
     $dbh = $dbConnector->getDbh();
     $sql = "SELECT id, illustrator, scenarist, colorist, cover\n\t\tFROM books\n\t\tORDER BY RAND()\n\t\tLIMIT 20";
     $sth = $dbh->prepare($sql);
     $sth->execute();
     $movies = $sth->fetchAll();
     return $books;
 }
コード例 #3
0
ファイル: MovieManager.php プロジェクト: Web-God/movies-oo
 /**
  * Récupère x films au hazard depuis la table movies
  */
 public function getRandomMovies()
 {
     $dbConnector = new DatabaseConnector();
     $dbh = $dbConnector->getDbh();
     $sql = "SELECT id, title, year, imdb_id\n\t\t\t\t\tFROM movies\n\t\t\t\t\tORDER BY RAND()\n\t\t\t\t\tLIMIT 30";
     $sth = $dbh->prepare($sql);
     $sth->execute();
     $movies = $sth->fetchAll();
     return $movies;
 }
コード例 #4
0
ファイル: Manager.php プロジェクト: Web-God/movies-oo
 public function find($id)
 {
     $dbConnector = new DatabaseConnector();
     $dbh = $dbConnector->getDbh();
     $sql = "SELECT *\n\t\t\t\t\tFROM {$this->table}\n\t\t\t\t\tWHERE id = :id";
     $sth = $dbh->prepare($sql);
     $sth->bindValue(":id", $id);
     $sth->execute();
     $row = $sth->fetch();
     return $row;
 }
コード例 #5
0
ファイル: dataRetriever.php プロジェクト: harvPrentiss/ToDo
function getConnection()
{
    global $dbConnection;
    $dbConnector = new DatabaseConnector();
    $dbConnection = $dbConnector->connect();
    if ($dbConnection == "Failed to connect") {
        return json_encode("Connection to the database has failed");
    } else {
        return json_encode("Connection successful");
    }
}
コード例 #6
0
 static function GetDatabase()
 {
     if (self::$database == NULL) {
         self::$database = new medoo(array('database_type' => 'mysql', 'database_name' => 'CompanyCalendar', 'server' => 'localhost', 'username' => 'root', 'password' => 'swe6623', 'charset' => 'utf8'));
     }
     return self::$database;
 }
コード例 #7
0
ファイル: PlexAPI.php プロジェクト: sister4sale/HackUState
 public function __construct()
 {
     $db = new DatabaseConnector();
     $res = $db->getPlex($_SESSION['CurrentUserID']);
     $row = $res->fetch_assoc();
     $curl = curl_init();
     curl_setopt($curl, CURLOPT_URL, "https://plex.tv/users/sign_in.xml");
     curl_setopt($curl, CURLINFO_HEADER_OUT, true);
     curl_setopt($curl, CURLOPT_HTTPHEADER, array('X-Plex-Platform: ' . PHP_OS, 'X-Plex-Client-Identifier: ' . 1234321423, 'X-Plex-Product: SHMWD'));
     curl_setopt($curl, CURLOPT_POST, 3);
     curl_setopt($curl, CURLOPT_USERPWD, "{$row['plexUser']}:{$row['plexPassword']}");
     curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
     curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
     $result = curl_exec($curl);
     $headerSent = curl_getinfo($curl, CURLINFO_HEADER_OUT);
     curl_close($curl);
     $this->splitted = explode(" ", $result);
 }
コード例 #8
0
function sendMsg($old, $id, $msg)
{
    $db = new DatabaseConnector();
    $newData = $db->GetServerMessages();
    if ($old != $newData) {
        //send a command;
        print_r($newData);
        $row = null;
        foreach ($newData as $n) {
            $row = $n;
        }
        print_r($row);
        print "<br>";
        echo "id: " . $row['messageType'] . PHP_EOL;
        echo "data: " . $row['message'] . PHP_EOL;
        echo PHP_EOL;
        ob_flush();
        flush();
    }
    return $newData;
}
コード例 #9
0
 public static function getPurePDO()
 {
     if (is_null(self::$pdo)) {
         $settings = Environment::databaseSettings();
         try {
             $PDO = new PDO($settings['driver'] . ":host=" . $settings['host'] . ";port=" . $settings['port'] . ";dbname=" . $settings['name'], $settings['username'], $settings['password']);
         } catch (PDOException $e) {
             throw new DatabaseException();
         }
         self::$purePDO = $PDO;
         self::$pdo = new FluentPDO($PDO);
     }
     return self::$purePDO;
 }
コード例 #10
0
 /**
  * @return bool
  */
 public function insertJobs()
 {
     $response = $this->getResponse();
     $connection = DatabaseConnector::getConnection();
     if (!isset($response->jobs) || !$response->jobs) {
         return false;
     }
     foreach ($response->jobs as $job) {
         $preparedStatement = $connection->prepare($this->insertQuery);
         $preparedStatement->bindParam(':name', $job->name);
         $preparedStatement->bindParam(':status', $this->getStatusByColor($job->color));
         $preparedStatement->bindParam(':created_at', date('Y-m-d H:i:s'));
         $preparedStatement->execute();
     }
     return true;
 }
コード例 #11
0
ファイル: database_connector.php プロジェクト: pilaf/yarr
 static function establish_connection($options)
 {
     if ($options['adapter']) {
         $options['adapter'] = strtolower($options['adapter']);
         $adapter_file_name = ACTIVE_RECORD_BASE_PATH . "/connection_adapters/adapters/{$options['adapter']}_adapter.php";
         if (file_exists($adapter_file_name)) {
             require_once $adapter_file_name;
         } else {
             throw new Exception("Couldn't find an appropiate adapter for the database connection.");
         }
         // Look for a class named <Adapter>Adapter (i.e. MysqliAdapter)
         $adapter_class_name = ucfirst($options['adapter']) . 'Adapter';
         if (!class_exists($adapter_class_name)) {
             throw new Exception("Expected {$adapter_file_name} to define class {$adapter_class_name}.");
         }
         if (self::$connection = new $adapter_class_name($options)) {
             return true;
         }
     }
 }
コード例 #12
0
 public function getAllCoursesNeeded()
 {
     $dbc = new DatabaseConnector();
     $params = array($this->userID);
     $courses = $dbc->select("SELECT DISTINCT CourseInfo.courseID, CourseInfo.credits, StudentCourse.weight,\n          StudentCourse.relevance, StudentCourse.studentCourseID FROM StudentCourse INNER JOIN\n          CourseInfo ON CourseInfo.courseInfoID = StudentCourse.courseInfoID WHERE StudentCourse.userID = ?\n          and grade = 'ND'", $params);
     $output = array();
     foreach ($courses as $course) {
         $this->log->toLog(0, __METHOD__, "courseID: {$course['0']},\n            credits: {$course['1']}, weight: {$course['2']}, relevance: {$course['3']}, id: {$course['4']},");
         array_push($output, array('courseID' => $course[0], 'credits' => $course[1], 'weight' => $course[2], 'relevance' => $course[3], 'id' => $course[4]));
     }
     echo json_encode($output);
 }
コード例 #13
0
  TrackBack here. Main source of information was: 
  
  	http://www.movabletype.org/docs/mttrackback.html

  Thanks for this useful piece of information :)

  MEMO: I don't really like TrackBack...
*/
error_reporting(E_ERROR | E_PARSE);
require_once './config.php';
require_once $CONFIG['LibDir'] . 'common.php';
require_once $CONFIG['LibDir'] . 'db/' . $CONFIG['DatabaseType'] . '.php';
require_once $CONFIG['LibDir'] . 'page/pagerequest.php';
require_once $CONFIG['LibDir'] . 'sys/console.php';
$console = new SystemConsole();
$connector = new DatabaseConnector();
$connector->setupConnection($CONFIG['DatabaseHost'], $CONFIG['DatabaseUser'], $CONFIG['DatabasePassword'], $CONFIG['DatabaseName'], $CONFIG['DatabasePort']);
$request = new pageRequest($connector);
$request->parseRequest();
if (isset($_POST['url'])) {
    $ping_url = $_POST['url'];
} else {
    $ping_url = "";
}
if ($ping_url == "") {
    header("Location: index.php?" . $request->getRequestedSite() . "/" . $request->getRequestedPage());
}
if (isset($_POST['title'])) {
    $ping_title = $_POST['title'];
} else {
    $ping_title = "";
コード例 #14
0
    }
    public function getPlex($userID)
    {
        $sql = "SELECT * FROM plexservers WHERE userID=" . $userID . ";";
        $connection = new mysqli($this->serverName, $this->username, $this->password, "hackusu");
        return $connection->query($sql);
    }
}
if (isset($_POST['login']) && $_POST['login'] == True) {
    session_start();
    $db = new DatabaseConnector();
    $db->LoginUser($_POST['user'], $_POST['passwd']);
}
if (isset($_POST['plexAdd']) && $_POST['plexAdd'] == True) {
    session_start();
    $db = new DatabaseConnector();
    $db->addPlex($_SESSION['CurrentUserID'], $_POST["userID"], $_POST['plexPASSWORD']);
    $res = $db->getPlex($_SESSION['CurrentUserID']);
    $row = $res->fetch_assoc();
    /*$curl = curl_init();
                echo PHP_OS . "<br>";
    			curl_setopt ($curl, CURLOPT_URL,"https://plex.tv/users/sign_in.xml");
               // curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_ANY);
                curl_setopt($curl, CURLINFO_HEADER_OUT, true);
                curl_setopt($curl, CURLOPT_HTTPHEADER, array(
                    'X-Plex-Platform: ' . PHP_OS,
                    'X-Plex-Client-Identifier: ' . 1234321423,
                    'X-Plex-Product: SHMWD' 
                    ));
                curl_setopt($curl, CURLOPT_POST, 3);
                curl_setopt($curl, CURLOPT_USERPWD, "$row[plexUser]:$row[plexPassword]");
コード例 #15
0
<?php

session_start();
require_once '../models/database.php';
require_once '../models/lesson.php';
$db = new DatabaseConnector($_SESSION['user_id']);
$lesson = $db->getLessonById($_POST['id']);
$lesson->setActive($_POST['state'] == "true" ? 1 : 0);
$db->updateLesson($lesson);
/*$pdo = new PDO("mysql:host=localhost;dbname=vokabeltrainer", "root", "123");
	$lesson["id"]=$_POST['id'];
	$lesson["state"]=($_POST['state']=="true"?1:0);
	$statement=$pdo->prepare("UPDATE lessons SET active = :state WHERE id = :id");
	$statement->execute($lesson);*/
echo "Set lesson with id " . $lesson->getId() . " to " . $lesson->getActive();
コード例 #16
0
ファイル: Query.php プロジェクト: xdrop/MammalWebCS
 public function __construct()
 {
     $this->db = DatabaseConnector::getDatabase();
 }
コード例 #17
0
		</script>
		<title>Lektionen</title>
	</head>
	<body>
		<table class='manage' id='lesson_table'>
			<caption>Lektionen verwalten</caption>
			<thead>
				<tr>
					<th><input type="checkbox" id="check_all"></th>
					<th>Name</th>
					<th>Vokabeln</th>
					<th></th>
				</tr>
			</thead>
			<?php 
$db = new DatabaseConnector($_SESSION['user_id']);
$lesson_list = $db->getAllLessons();
foreach ($lesson_list as $lesson) {
    if ($lesson->getName() == "Unsortiert") {
        echo "<tr><td></td><td><a href='manage_vocables.inc.php?name=" . $lesson->getName() . "'>" . $lesson->getName() . "</a></td><td>" . $db->countLessonVocs($lesson->getId()) . "</td><td></tr>";
    } else {
        echo "<tr><td><input type='checkbox' value='" . $lesson->getName() . "' id='l-" . $lesson->getName() . "'/></td><td><a href='manage_vocables.inc.php?name=" . $lesson->getName() . "'>" . $lesson->getName() . "</a></td><td>" . $db->countLessonVocs($lesson->getId()) . "</td><td><button onclick='change(this)' value='" . $lesson->getName() . "'>Umbenennen</button></td></tr>";
    }
}
?>
		</table>
		<div class='bottom_line'>
			<form action='new_lesson.inc.php' method="post" style='display:inline;'>
				<input type='submit' id='new' value='Neue Lektion/Import'>
				<input type='hidden' name='origin' value='manage_lessons.php'>
			</form>
コード例 #18
0
ファイル: index.php プロジェクト: swiftie821/DBConnector
<!DOCTYPE html>
<html>
<head>
    <title>DB test</title>
</head>
<body>
    <?php 
require_once 'connector.php';
?>
    <?php 
DatabaseConnector::$host = "localhost";
DatabaseConnector::$username = "myUsername";
DatabaseConnector::$password = "myPassword";
DatabaseConnector::$dbname = "myDatabase";
$conn = new DatabaseConnector();
$rs = $conn->Query("SELECT * FROM `users`;");
while ($result = mysqli_fetch_assoc($rs)) {
    var_dump($rs);
}
var_dump($conn->affected_rows());
var_dump($conn->ConnectError());
var_dump($conn->ConnectErrorNo());
/**
 * And more tests
 */
?>
</body>
</html>
コード例 #19
0
ファイル: getData.php プロジェクト: robin15/LeafMeter
<?php

header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");
include 'connectDatabase.php';
$connection = new DatabaseConnector();
$con = $connection->connect();
$response = array();
if ($con) {
    // Selecting database
    $database = mysql_select_db("leaf_me_alone");
    if ($database) {
        $select_query = "select * from leafs";
        $result = mysql_query($select_query) or die(mysql_error());
        if (!empty($result)) {
            if (mysql_num_rows($result) > 0) {
                $response["leafs"] = array();
                while ($row = mysql_fetch_array($result)) {
                    $leaf = array();
                    $leaf["id"] = $row["id"];
                    $leaf["location"] = $row["location"];
                    $leaf["defect_percentage"] = $row["defect_percentage"];
                    $leaf["time_stamp"] = $row["time_stamp"];
                    $leaf["salt_name"] = $row["salt_name"];
                    array_push($response["leafs"], $leaf);
                }
                $response["success"] = 1;
                echo json_encode($response);
            } else {
                $response["success"] = 0;
                $response["message"] = "No found";
コード例 #20
0
<?php

session_start();
require_once '../models/database.php';
require_once '../models/vocable.php';
require_once '../models/lesson.php';
$ids = json_decode($_POST['ids']);
$db = new DatabaseConnector($_SESSION['user_id']);
foreach ($ids as $id) {
    //ID and user_id are safe enough
    //$voc=$db->getVocById($id);
    $db->deleteVocById($id);
}
echo "Done";
コード例 #21
0
 function modifyWeightAndRelevance()
 {
     $db = new DatabaseConnector();
     if (isset($_POST['courseID'])) {
         $courseID = $_POST['courseID'];
     } else {
         $courseID = "";
     }
     if (isset($_POST['modifiedRelevance'])) {
         $modifiedRelevance = $_POST['modifiedRelevance'];
     } else {
         $modifiedRelevance = "";
     }
     if (isset($_POST['modifiedWeight'])) {
         $modifiedWeight = $_POST['modifiedWeight'];
     } else {
         $modifiedWeight = "";
     }
     $stmt = "UPDATE StudentCourse SET relevance = ?, weight = ? WHERE courseInfoID = (SELECT courseInfoID FROM CourseInfo WHERE courseID = ?) AND userID = ?";
     $params = array($modifiedRelevance, $modifiedWeight, $courseID, $this->userID);
     $db->query($stmt, $params);
     $this->log->toLog(1, __METHOD__, "weight and relevance have been modified");
 }
コード例 #22
0
 function __construct()
 {
     $this->database = DatabaseConnector::GetDatabase();
 }
コード例 #23
0
ファイル: Model.php プロジェクト: kazemisoroush/php-mvc
 /**
  * Create new model instance.
  */
 public function __construct()
 {
     parent::__construct();
 }
コード例 #24
0
<?php

session_start();
require_once 'models/database.php';
require_once 'models/user.php';
if (isset($_GET['login'])) {
    $email = $_POST['email'];
    $password = $_POST['password'];
    $db = new DatabaseConnector();
    $user = $db->getUserByEmail($email);
    //Überprüfung des Passworts
    if ($user !== false && $user->verifyPassword($password)) {
        $_SESSION['user_id'] = $user->getId();
        $_SESSION['email'] = $email;
        //TODO: Use Session variable to redirect to the page the user was trying to access
        if (isset($_SESSION['origin_url'])) {
            echo "<script>top.window.location='" . $_SESSION['origin_url'] . "';</script>";
            //header("Location: ".$_SESSION['origin_url']);
        } else {
            echo "<script>top.window.location='index.php';</script>";
            //header("Location: index.php");
        }
        die;
    } else {
        $errorMessage = "E-Mail oder Passwort war ungültig<br>";
    }
}
?>
<html> 
<head>
	<link rel="stylesheet" href="style/main.css" type="text/css">	
コード例 #25
0
<?php

session_start();
require_once '../models/database.php';
$db = new DatabaseConnector($_SESSION['user_id']);
$plan = $_POST['plan'] == "true" ? true : false;
$steps = json_decode($_POST['steps']);
$direction = $_POST['direction'];
//Store options to database
$options = ["plan" => $plan, "direction" => $direction, "steps" => $steps];
$db->saveOptions($options);
$_SESSION['count'] = $db->prepareLearnVocables($plan, $steps);
$_SESSION['direction'] = $direction;
$_SESSION['plan'] = $plan;
//Reset result counts
$_SESSION['right_c'] = 0;
$_SESSION['wrong_c'] = 0;
$_SESSION['mastered_c'] = 0;
$db->setResultCount("right_c", 0);
$db->setResultCount("wrong_c", 0);
$db->setResultCount("mastered_c", 0);
コード例 #26
0
 function test005()
 {
     $sc = new SettingsController(12, 'newuser20');
     $sc->importReq('nursing.xml');
     $db = new DatabaseConnector();
     $params = array(5);
     $buckets = $db->select("Select description from MajorBucket Where majorID = ?", $params);
     $output = array();
     $b = array();
     foreach ($buckets as $bucket) {
         array_push($b, $bucket[0]);
     }
     array_push($output, $b);
     $courses = $db->select("SELECT CourseInfo.courseID FROM CourseInfo\n          INNER JOIN MajorBucketRequiredCourses ON MajorBucketRequiredCourses.courseInfoID = CourseInfo.courseInfoID\n          WHERE MajorBucketRequiredCourses.bucketID IN (SELECT bucketID FROM MajorBucket WHERE majorID = ?)", $params);
     $c = array();
     foreach ($courses as $course) {
         array_push($c, $course[0]);
     }
     array_push($output, $c);
     $expected = [["Chemistry & Lab", "Human Anatomy & Lab", "Human Growth & Development", "Human Physiology & Lab", "Intro to Ethics", "Intro to Psychology", "Junior 1: Semester 1", "Junior 2: Semester 2", "Junior 2: Semester 3", "Microbiology & Lab", "Nursing Core", "Nutrition", "Prerequisites", "Senior 3: Semester 1", "Senior 4: Semester 2", "Statistics"], ["ZOO3731", "ZOO3731L", "PCB2099", "PCB2099L", "MCB2000", "MCB2000L", "CHM1045L", "CHM1045", "STA2023", "HUN2201", "DEP2000", "PSY2012", "PHI2600", "NUR3029", "NUR3029C", "NUR3029L", "NUR3125", "NUR3066C", "NUR3226", "NUR3226L", "NUR3145", "NUR3666", "NSP3801", "NUR3821", "NUR3227", "NUR3227L", "NUR4455", "NUR4455L", "NUR3685L", "NUR3535", "NUR3535L", "NUR4355", "NUR4355L", "NUR4686L", "NUR4667", "NUR4636C", "NUR4286", "NUR4940", "NUR4945L"]];
     $this->assertEquals($output, $expected);
 }
コード例 #27
0
ファイル: action.php プロジェクト: TexnologiaLog/SnapChatApp
<?php

include 'connect.php';
$dc = new DatabaseConnector();
$con = $dc->getConnection();
include 'functions.php';
$action = $_GET['action'];
$user = $_GET['user'];
$my_id = $_SESSION['user_id'];
if ($action == 'send') {
    mysqli_query($con, "INSERT INTO frnd_req VALUES('', '{$my_id}', '{$user}')");
}
if ($action == 'accept') {
    mysqli_query($con, "DELETE FROM `frnd_req` WHERE `from`='{$user}' AND `to`='{$my_id}'");
    mysqli_query($con, "INSERT INTO friends VALUES ('','{$user}', '{$my_id})");
}
if ($action == 'unfrnd') {
    mysqli_query($con, "DELETE FROM friends WHERE(user_id='{$my_id}' AND friend_id='{$user}') OR (user_id='{$user}' AND friend_id='{$my_id}')");
}
header('Location: profile,php?user=' . $user);
コード例 #28
0
<?php

session_start();
require_once '../models/database.php';
require_once '../models/vocable.php';
$date = date("Y-m-d");
$db = new DatabaseConnector($_SESSION['user_id']);
//if request come from change-site, update the vocable and return to managing page
if (isset($_POST['change'])) {
    $voc = $db->getVocById($_POST['id']);
    $voc->setOwnLang($_POST['ownLanguage']);
    $voc->setForeignLang($_POST['foreignLanguage']);
    $db->updateVoc($voc);
    header("Location: " . $_POST['origin']);
    die;
}
$voc = new Vocable($_SESSION['user_id'], $_POST["ownLanguage"], $_POST["foreignLanguage"], $_POST["lesson"], $date);
$db->createVoc($voc);
/*$pdo = new PDO("mysql:host=localhost;dbname=vokabeltrainer", "root", "123");
	#Prepare Array for insert
	$newVocable["ol"]=$_POST["ownLanguage"];
	$newVocable["fl"]=$_POST["foreignLanguage"];
	$newVocable["lesson"]=$_POST["lesson"];
	$newVocable["nextDate"]=$_POST["date"];
	$newVocable["user_id"]=$_SESSION['user_id'];
	$statement = $pdo->prepare("INSERT INTO vocables (own_language, foreign_language, lesson, next_date, user_id) VALUES (:ol, :fl, :lesson, :nextDate, :user_id)");

	$statement->execute($newVocable);
	
	$id=$pdo->lastInsertId();*/
echo TRUE;
コード例 #29
0
 /**
  * Returns the maximum image id (id of the last image)
  */
 public function getMaxImageId()
 {
     return DatabaseConnector::getPurePDO()->query("SELECT MAX(photo_id) FROM animal")->fetch()[0];
 }
コード例 #30
0
 function getGrades($assessment, $course)
 {
     $db = new DatabaseConnector();
     $return = [];
     $stmt = "SELECT grade FROM Assessment WHERE assessmentTypeID in (select assessmentTypeID FROM AssessmentType WHERE AssessmentName = ?) AND studentCourseID in (SELECT studentCourseID FROM StudentCourse WHERE grade = 'IP' and userID = ? AND courseInfoID in (select courseInfoID FROM CourseInfo WHERE courseID = ?))";
     $params = array($assessment, $this->userID, $course);
     $output = $db->select($stmt, $params);
     if (count($output) == 0) {
         $this->log->toLog(2, __METHOD__, "No grades returned form assessment");
         echo json_encode([]);
         return $return;
     }
     $index = 1;
     for ($i = 0, $c = count($output); $i < $c; $i++) {
         $grades = $output[$i][0];
         $this->log->toLog(0, __METHOD__, "Grade: {$grades}");
         array_push($return, array("Grade" . $index, $grades));
         $index++;
     }
     echo json_encode($return);
     return $return;
 }