Accès rapide : Féminine, 2nde Série, 3ème Série A, 3ème Série B, 4ème Série
Attention : ne pas tenir compte des dates des matchs à venir qui peuvent ne pas être à jour.
Féminines
Poule A
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=11
and t1.group=\’A\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=11 group=A]
2nde Série
Poule A
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=7
and t1.group=\’A\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=7 group=A]
Poule B
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=7
and t1.group=\’B\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=7 group=B]
3ème Série A
Poule A
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=8
and t1.group=\’A\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=8 group=A]
Poule B
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=8
and t1.group=\’B\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=8 group=B]
Poule C
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=8
and t1.group=\’C\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=8 group=C]
Poule D
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=8
and t1.group=\’D\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=8 group=D]
Poule E
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=8
and t1.group=\’E\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=8 group=E]
3ème Série B
Poule A
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=9
and t1.group=\’A\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=9 group=A]
Poule B
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=9
and t1.group=\’B\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=9 group=B]
Poule C
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=9
and t1.group=\’C\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=9 group=C]
Poule D
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=9
and t1.group=\’D\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=9 group=D]
Poule E
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=9
and t1.group=\’E\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=9 group=E]
4ème Série
Poule A
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=10
and t1.group=\’A\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=10 group=A]
Poule B
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=10
and t1.group=\’B\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=10 group=B]
Poule C
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=10
and t1.group=\’C\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=10 group=C]
Poule D
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=10
and t1.group=\’D\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=10 group=D]
Poule E
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=10
and t1.group=\’E\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=10 group=E]
Poule F
[insert_php]
try
{
$bdd = new PDO(‘mysql:host=peloteouubbase1.mysql.db;dbname=peloteouubbase1;charset=utf8’, ‘peloteouubbase1’, ‘Bisquit64’);
}
catch (Exception $e)
{
die(‘Erreur : ‘ . $e->getMessage());
}
$rencontres = $bdd->query(‘SELECT t1.league_id, t1.group, t1.date, t2.title as team1, t3.title as team2, t1.home_points, t1.away_points
FROM `wp_leaguemanager_matches` t1
left join `wp_leaguemanager_teams` t2 on t1.home_team=t2.id
left join `wp_leaguemanager_teams` t3 on t1.away_team=t3.id
WHERE t1.league_id=10
and t1.group=\’F\’
order by t1.date’);
$nombre_de_boucle = 0;
$nombre_de_boucle2 = 0;
while($parties = $rencontres->fetch())
{ if ($parties[‘home_points’]>0) {
$nombre_de_boucle2++;
if ($nombre_de_boucle2 == 1) {
echo’Rencontres jouées :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘home_points’].’ | ‘.$parties[‘away_points’].’ | ‘.$parties[‘team2′].’ |
‘;
}
if ($parties[‘home_points’]==0) {
$nombre_de_boucle++;
if ($nombre_de_boucle == 1) {
echo’Rencontres à venir :’;}
echo’
| ‘.date(« d-m-Y », strtotime($parties[‘date’])).’ | ‘.$parties[‘team1′].’ | ‘.$parties[‘team2′].’ |
‘;
}
};
$rencontres->closeCursor(); // Termine le traitement de la requête
[/insert_php]
Classement :
[standings league_id=10 group=F]