Premier League Standings

<?php
    $xcrud = Xcrud::get_instance();
    $xcrud->table('standings');
    $xcrud->columns('logo,team_id,played,won,drawn,lost,goals_for,goals_against,points');
    $xcrud->label('team_id', 'Team')->relation('team_id', 'teams', 'team_id', 'team_name');

    $xcrud->unset_add();
    $xcrud->unset_edit();
    $xcrud->unset_remove();
    $xcrud->unset_view();
    $xcrud->unset_search();
    $xcrud->unset_limitlist();
    $xcrud->limit(20);

    $xcrud->order_by("points","desc");
    $xcrud->column_class('team_id','align-left font-bold');
    $xcrud->highlight('points','>=','23','#9FD58C');
    $xcrud->highlight('lost','=','0','#B3968B');
    $xcrud->highlight('lost','=','1','#D2E3D9');
    $xcrud->highlight_row('points','>=','26','#D5BEB5');

    
    $xcrud->change_type('logo', 'image', false, array(
    'width' => 450,
    'path' => '../uploads/gallery',
    'thumbs' => array(array(
            'height' => 55,
            'width' => 120,
            'crop' => true,
            'marker' => '_th'))));

    echo $xcrud->render();
?>