active-record-example.php

<?php

// Query with no Active Record
$query = "SELECT questions.* FROM assessments LEFT JOIN questions ON assessments.id=questions.assessment_id WHERE assessments.id=4";

// Query with ORM (Idiorm)
ORM::for_table('assessments')
    ->select('questions.*')
    ->join('questions',array('assessments.id','=','questions.assessment_id'))
    ->where('assessments.id',4)
    ->find_many();

// Query with Active Record (Paris)
Model::factory('Assessment')->has_many('Question');