fork download
  1. public function getStudents($order, $start, $limit, $search = '')
  2. {
  3. var_dump($order);
  4. $query = "SELECT
  5. name, secondName, groupNumber, gender, birthYear, summary, email, local
  6. FROM
  7. students ";
  8. if(!empty($search)){
  9. $query .= "WHERE
  10. name LIKE :search OR
  11. secondName LIKE :search OR
  12. groupNumber LIKE :search OR
  13. summary LIKE :search ";
  14. }
  15. $query .= " ORDER BY
  16. :order
  17. LIMIT :start, :end";
  18.  
  19. $stmt = $this->dbh->prepare($query);
  20.  
  21. $stmt->bindValue(':order', $order);
  22. $stmt->bindValue(':start', $start);
  23. $stmt->bindValue(':end', $limit);
  24.  
  25. if(!empty($search)) $stmt->bindValue(':search', $search);
  26.  
  27. $stmt->execute();
  28. $result = $stmt->fetchAll(\PDO::FETCH_CLASS,\App\Models\Student::class);
  29.  
  30. return $result;
  31. }
Success #stdin #stdout 0s 82880KB
stdin
Standard input is empty
stdout
public function getStudents($order, $start, $limit, $search = '')
    {
        var_dump($order);
        $query = "SELECT
                    name, secondName, groupNumber, gender, birthYear, summary, email, local
                  FROM
                    students ";
        if(!empty($search)){
            $query .= "WHERE
                   name LIKE :search OR 
                   secondName  LIKE :search OR 
                   groupNumber  LIKE :search OR 
                   summary  LIKE :search ";
        }
        $query .= " ORDER BY 
                    :order
                  LIMIT :start, :end";
        
        $stmt = $this->dbh->prepare($query);
        
        $stmt->bindValue(':order', $order);
        $stmt->bindValue(':start', $start);
        $stmt->bindValue(':end', $limit);
        
        if(!empty($search)) $stmt->bindValue(':search', $search);
        
        $stmt->execute();
        $result = $stmt->fetchAll(\PDO::FETCH_CLASS,\App\Models\Student::class);
        
        return $result;
    }