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
|
<?php
define('DB_SERVER', 'localhost'); // serveur mysql
define('DB_SERVER_USERNAME', 'root'); // nom d'utilisateur
define('DB_SERVER_PASSWORD', ''); // mot de passe
define('DB_DATABASE', 'classement'); // nom de la base
$connect = mysql_connect(DB_SERVER, DB_SERVER_USERNAME,
DB_SERVER_PASSWORD)
or die('Impossible de se connecter : ' . mysql_error());
// sélection de la base de données
mysql_select_db(DB_DATABASE, $connect);
$rq = "SELECT DISTINCT riders FROM general ORDER BY riders";
$result = mysql_query($rq) or die ("Exécution de la requête impossible");
echo "<form action='modif_classement.php' method='post'><select name='riders'>";
while ($liste=mysql_fetch_array($result))
{
extract($liste);
echo "<option value='$riders'>$riders\n";
}
echo "</select>\n";
echo "<input type='submit'"."value='Go'></form>\n";
$riders=$_POST['riders'];
if(isset($_POST['riders']))
{
$sql = "SELECT pos, pays, riders, teams, points FROM general WHERE riders='".$_POST['riders']."'" ;
$req = mysql_query($sql) or die( mysql_error() ) ;
$total = mysql_num_rows($req);
{
echo '<form method ="post" action="modif_classement.php">';
echo '<table>'."\n";
echo '<tr>';
echo '<th ><b><u>RIDERS.</u></b></th>';
echo '<th ><b><u>POS.</u></b></th>';
echo '<th><b><u>POINTS</u></b></th>';
echo '</tr>'."\n";
while($row = mysql_fetch_array($req))
{
echo '<tr>';
echo '<td>'.$riders.'</td>';
echo '<td><input type="text" name="pos" value="'.$row["pos"].'"/></td>';
echo '<td><input type="text" name="points" value="'.$row["points"].'"/></td>';
echo '</tr>'."\n";
}
echo '</table>'."\n";
echo '<input type="hidden" name="riders2" value="'.$_POST['riders'].'" /><br><center><input type="submit" name="ok" value="Modifier"/></center>';
echo '</form>';
}
}
if (isset($_POST['ok']))
{
echo $sql2= "UPDATE general SET pos='".$_POST['pos']."', points='".$_POST['points']."'
WHERE riders='$riders'";
$req2= mysql_query($sql2) or die('Erreur SQL !'.$sql2.'<br>'.mysql_error());
}
if(isset($req2))
{
echo ("Modification OK") ;
echo '<td>'.$riders.'</td>';
}
?> |
