/**
* Form method
*
* @param mixed $instance
* @return void
*/
public function form($instance)
{
// PHPLeague_Tools
$tools = new PHPLeague_Tools();
// Get all leagues in the database
global $wpdb;
$leagues = $wpdb->get_results($wpdb->prepare("SELECT id, name, year FROM {$wpdb->league} ORDER BY year DESC, name ASC", ARRAY_A));
// Get leagues list
$leagues_list = array();
foreach ($leagues as $item) {
$year = (int) $item->year;
$leagues_list[$item->name][$item->id] = $year . '/' . substr($year + 1, 2);
}
// Display the dropdown list with selected league
echo $tools->select(esc_attr($this->get_field_name('league_id')), $leagues_list, (int) $instance['league_id'], array('id' => esc_attr($this->get_field_id('league_id'))));
}
<p><?php
_e('Display all fixtures for a chosen league or only those for a team into that particular league.', 'phpleague');
?>
</p>
</div>
<!-- fixture panel -->
<div id="fixture_panel" class="panel"><br />
<table style="border: 0;" cellpadding="5">
<tr>
<td><label for="fixture_id"><?php
_e('Fixture', 'phpleague');
?>
</label></td>
<td>
<?php
echo $tools->select('fixture_id', $fixtures_list, '', array('id' => 'fixture_id', 'style' => 'width: 200px;'));
?>
</td>
</tr>
</table>
</div>
<!-- clubs panel -->
<div id="clubs_panel" class="panel"><br />
<table style="border: 0;" cellpadding="5">
<tr>
<td><label for="club_id"><?php
_e('Club', 'phpleague');
?>
</label></td>
<td>
<select id="club_id" name="club_id" style="width: 200px;">