for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace Example\Models;
use CoffeeCode\DataLayer\DataLayer;
class Course extends DataLayer
{
/**
* Course constructor.
*/
public function __construct()
parent::__construct("courses", ["name"], "id", false);
}
* @return array|null
public function studentsWhoPrefer(): ?array
$students = new Student();
return $this
->select("*, courses.name as course_name")
->join(
$students,
'courses.id', '=', 'students.preferred_course')
->where(
'courses.id = :id',
"id={$this->id}")
id
Example\Models\Course
__get
->limit(5)
->fetch(true);
public function studentsThatFinished(): ?array
$studentCourse = new StudentCourse();
->select()
$studentCourse,
"courses.id", "=", "student_course.idcourse"
)
"students.id", "=", "student_course.idstudent"
"courses.id = :id",
"id={$this->id}"