Premier League Standings

Premier League Standings

HIDE CODE
<?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();
?>

Standings

#LogoTeamPlayedWonDrawnLostGoals ForGoals Against↓ Points
1Manchester City10910351028
2Liverpool1091030828
3Manchester United10820281026
4Chelsea10811251025
5Arsenal10721201023
6Tottenham Hotspur10721221023
7Aston Villa1063115821
8Everton10622201520
9Brentford10541181219
10Leicester City10532171518
11West Ham United10532151018
12Brighton & Hove Albion10451141017
13Leeds United10442151216
14Burnley1036112815
15Crystal Palace10262101012
16Southampton10325101511
17Newcastle United10172101510
18Norwich City1024481210
19Watford1016310189
20Wolverhampton Wanderers102358159