<?php
/**
 * Created by PhpStorm.
 * User: Langdon
 * Date: 08.03.16
 * Time: 15:02
 */
include(ROOT.'/components/Db.php');
class Student {
 
    public static  function getStudentList(){
        $db = Db::getConnection();
 
        $StudentList = array();
        $result = $db->query("SELECT * FROM studets ORDER BY marks DESC");
 
 
        $i = 0;
        while($row = $result->fetch()){
 
            $StudentList[$i]['firstName'] = $row['firstName'];
            $StudentList[$i]['secondName'] = $row['secondName'];
            $StudentList[$i]['number'] = $row['number'];
            $StudentList[$i]['marks'] = $row['marks'];
            $i++;
        }
 
        return $StudentList;
    }
} 

PD9waHAKLyoqCiAqIENyZWF0ZWQgYnkgUGhwU3Rvcm0uCiAqIFVzZXI6IExhbmdkb24KICogRGF0ZTogMDguMDMuMTYKICogVGltZTogMTU6MDIKICovCmluY2x1ZGUoUk9PVC4nL2NvbXBvbmVudHMvRGIucGhwJyk7CmNsYXNzIFN0dWRlbnQgewoKICAgIHB1YmxpYyBzdGF0aWMgIGZ1bmN0aW9uIGdldFN0dWRlbnRMaXN0KCl7CiAgICAgICAgJGRiID0gRGI6OmdldENvbm5lY3Rpb24oKTsKCiAgICAgICAgJFN0dWRlbnRMaXN0ID0gYXJyYXkoKTsKICAgICAgICAkcmVzdWx0ID0gJGRiLT5xdWVyeSgiU0VMRUNUICogRlJPTSBzdHVkZXRzIE9SREVSIEJZIG1hcmtzIERFU0MiKTsKCgogICAgICAgICRpID0gMDsKICAgICAgICB3aGlsZSgkcm93ID0gJHJlc3VsdC0+ZmV0Y2goKSl7CgogICAgICAgICAgICAkU3R1ZGVudExpc3RbJGldWydmaXJzdE5hbWUnXSA9ICRyb3dbJ2ZpcnN0TmFtZSddOwogICAgICAgICAgICAkU3R1ZGVudExpc3RbJGldWydzZWNvbmROYW1lJ10gPSAkcm93WydzZWNvbmROYW1lJ107CiAgICAgICAgICAgICRTdHVkZW50TGlzdFskaV1bJ251bWJlciddID0gJHJvd1snbnVtYmVyJ107CiAgICAgICAgICAgICRTdHVkZW50TGlzdFskaV1bJ21hcmtzJ10gPSAkcm93WydtYXJrcyddOwogICAgICAgICAgICAkaSsrOwogICAgICAgIH0KCiAgICAgICAgcmV0dXJuICRTdHVkZW50TGlzdDsKICAgIH0KfSA=