PHP Query::get_rows_assoc Examples

Example #1

File: course.php Project: RogerGee/abet1

function get_courses()
{
    $query = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('course' => array('id', 'title', 'course_number', 'fk_coordinator', 'instructor', 'description', 'textbook', 'credit_hours')), 'aliases' => array('course.fk_coordinator' => 'coordinator'), 'orderby' => 'title')));
    return $query->get_rows_assoc();
}

Example #2

File: characteristics.php Project: RogerGee/abet1

function get_characteristics()
{
    $query = new Query(new QueryBuilder(SELECT_QUERY, array('tables' => array('abet_characteristic' => array('id', 'level', 'short_name', 'description', 'program_specifier')), 'orderby' => 'CHAR_LENGTH(level), level')));
    return $query->get_rows_assoc();
}