1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
<!DOCTYPE HTML>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="description" content=""/>
<meta http-equiv="lang" content="fr"/>
<meta name="revisit-after" content="15 days"/>
<meta name="robots" content="index, follow"/>
<meta name="Rating" content="General"/>
<meta name="Robots" content="All"/>
<link rel="shortcut icon" href=""/>
<link rel="stylesheet" href="../css/style.css" type="text/css" media="screen,projection"/>
<link rel="stylesheet" href="../css/video-js.css" type="text/css" media="screen,projection">
<script type="text/javascript" src="../js/video.js"></script>
<script type="text/javascript" src="../js/jquery.js"></script>
<script type="text/javascript" src="../js/function.js"></script>
<script>
_V_.options.flash.swf = "../swf/video-js.swf"
</script>
<script type="text/javascript">
function changevid(video)
{
document.getElementById("sourcevid").src=video;
}
</script>
</head>
<body>
<?php include('header.php'); ?>
<div id="main">
<div class="videow">
<video id="videoPL" class="video-js vjs-default-skin" controls preload="auto" width="1280" height="720" data-setup='{"example_option":true}'>
<source id="sourcevid" src="" type='video/mp4' />
</video>
<?php
try
{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$bdd = new PDO('mysql:host=localhost;dbname=videooow', 'root', '', $pdo_options);
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
$req = $bdd->query('SELECT video_match.journee_id, video_match.date, video_match.score, video_match.idvideo,
equipe1.id AS equipe1_id,
equipe1.nom AS equipe1_nom,
equipe2.id AS equipe2_id,
equipe2.nom AS equipe2_nom
FROM video_match
JOIN ligue ON ligue.id = video_match.ligue_id
JOIN video_journee ON video_journee.id = video_match.journee_id
JOIN video_equipe AS equipe1 ON equipe1.id = video_match.equipe1_id
JOIN video_equipe AS equipe2 ON equipe2.id = video_match.equipe2_id
WHERE ligue.id = 1
ORDER BY video_match.journee_id');
$i = null;
$j = 1;
while($donnees = $req->fetch())
{
if($i == null)
{
$i = $donnees['journee_id'];
echo '<div class="match" name="match" id="day'.$j.'" style="display: block;">';
$j++;
}
if ($i != $donnees['journee_id'])
{
echo '</div><div class="match" name="match" id="day'.$j.'" style="display: none;">';
$i = $donnees['journee_id'];
}
?>
<div class="matchx">
<table>
<tr>
<div class="date"><?php echo $donnees['date']; ?></div>
</tr>
<tr>
<td class="gauche"><span class="teamone"><?php echo $donnees['equipe1_nom']; ?></span></td>
<td class="centre"><a href="video/<?php echo $donnees['idvideo']; ?>" onclick="changevid(this.href); return false;" target="_blank" title="Regarder les buts" class="score"><?php echo $donnees['score']; ?></a></td>
<td class="droite"><span class="teamtwo"><?php echo $donnees['equipe2_nom']; ?></span></td>
</tr>
</table>
</div>
<?php
}
echo '</div>';
?>
</div>
</div>
<div id="footer">
<br />
</div>
</body>
</html> |
plusieurs liens video pour un lecteur unique
Répondre avec citation
Partager