<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Document sans titre</title>
</head>
<body>
<?php
// script de connexion
$hostname_connection = "sql.free.fr";//le host
$database_connection = "*****";//nom de la table
$username_connection = "*****";//login de connexion
$password_connection = "*****";//mot de pass
$connection = mysql_connect($hostname_connection, $username_connection, $password_connection) or die('');
mysql_select_db($database_connection,$connection) or die('');
// lecture base de donnee
$requete="SELECT * FROM DB";
echo $requete."<br>";
$result=mysql_query($requete,$connection) or die('');
echo "donnee :".mysql_num_rows($result)."<br>";
//affectation valeur equivalente pour grade
$ligne=0;
while ($enreg=mysql_fetch_array($result))
{
echo "ligner traitee ".$ligne."<br>";
if ($enreg['grade']=="S"){$gradevalue=5;}
if ($enreg['grade']=="A"){$gradevalue=4;}
if ($enreg['grade']=="B"){$gradevalue=3;}
if ($enreg['grade']=="C"){$gradevalue=2;}
if ($enreg['grade']=="D"){$gradevalue=1;}
if ($enreg['grade']=="No Grade"){$gradevalue=0;}
//mise a jour vase de donnee
$requete="UPDATE DB SET gradeeq=".$gradevalue." WHERE id=".$enreg['id'];
$update=mysql_query($requete,$connection) or die('');
echo $requete;
$ligne++;
}
mysql_free_result($result);
mysql_close();
?>
</body>
</html>