<?php
public function getAll($sort, $start, $limit)
{
$sql = "SELECT
name, second_name, group_number, summary
FROM
students
ORDER BY :sort LIMIT :start, :limit";
$sth = $this->dbh->prepare($sql);
$sth->bindValue(":sort", $sort);
$sth->bindValue(":start", $start);
$sth->bindValue(":limit", $limit);
$sth->execute();
return $sth->fetchAll(\PDO::FETCH_CLASS, 'models\Student');
}
PD9waHAKCiBwdWJsaWMgZnVuY3Rpb24gZ2V0QWxsKCRzb3J0LCAkc3RhcnQsICRsaW1pdCkKICAgIHsKICAgICAgICAkc3FsID0gIlNFTEVDVCAKICAgICAgICAgICAgICAgIG5hbWUsIHNlY29uZF9uYW1lLCBncm91cF9udW1iZXIsIHN1bW1hcnkKICAgICAgICAgICAgICAgIEZST00gCiAgICAgICAgICAgICAgICBzdHVkZW50cwogICAgICAgICAgICAgICAgT1JERVIgQlkgOnNvcnQgTElNSVQgOnN0YXJ0LCA6bGltaXQiOwogICAgICAgICRzdGggPSAkdGhpcy0+ZGJoLT5wcmVwYXJlKCRzcWwpOwogICAgICAgICRzdGgtPmJpbmRWYWx1ZSgiOnNvcnQiLCAkc29ydCk7CiAgICAgICAgJHN0aC0+YmluZFZhbHVlKCI6c3RhcnQiLCAkc3RhcnQpOwogICAgICAgICRzdGgtPmJpbmRWYWx1ZSgiOmxpbWl0IiwgJGxpbWl0KTsKICAgICAgICAkc3RoLT5leGVjdXRlKCk7CiAgICAgICAgcmV0dXJuICRzdGgtPmZldGNoQWxsKFxQRE86OkZFVENIX0NMQVNTLCAnbW9kZWxzXFN0dWRlbnQnKTsKICAgIH0=