File "ajout.php"

Full Path: /home/analogde/www/videos/powerball/ajout.php
File size: 1.95 KB
MIME-type: text/html
Charset: 8 bit

 
Open Edit   Advanced Editor   Back 
<html>
<title>HOMESITE Patrice DELPY - Ajout d'un enregistrement dans la base powerball</title>
<body>
<?

// connexion avec la base
$db_type   = "mysql";
$db_user   = "analogde";
$db_pass   = "rainbow";
$db_name   = "analogde";
$db_host    = "sql2";

$db_link=mysql_connect($db_host,$db_user,$db_pass);



// rcupration des donnes
  while (list($var, $value) = each($HTTP_GET_VARS))
    {
      $tab_asso["$var"] = $value;
    }

switch ($tab_asso[ok]) 
{
// enregistrement des informations saisies
case 1;

$idmax=mysql_db_query("analogde","select max(id) from powerball",$db_link);
$idmax_r=mysql_result($idmax,0,"max(id)");  $n=$idmax_r+1;
$requete=mysql_query("insert into powerball values($n,'$nom','$prenom','$main_gauche','$main_droite','$endurance')");
// lien pour retourner au tableau principal
echo "<p align=center><h1 align=center>Enregistrement russi.<br><br><a href='powerball.php'>Retour</a></p>";

//echo "<META http-equiv='refresh' content='5'; URL=powerball.php>";

break;

// affichage du formulaire
default;
echo "<blockquote><table border=0><form method='get' action='ajout.php'><input type='hidden' name=ok value=1>
	<td>Nom</td><td><input type='text' name=nom  size=10 maxlenght=15></td>
  <td align=right>Prnom</td><td><input type='text' name=prenom  size=10 maxlenght=15></td><tr>
	<td>Gauche</td><td><input type='text' name=main_gauche  size=10 maxlenght=15></td>
	<td align=right>Droite</td><td><input type='text' name=main_droite  size=10 maxlenght=15></td><tr>
	<td>Endurance</td><td><input type='text' name=endurance size=10 maxlenght=15></td>
	
	
      </table></blockquote>";
// cration des liens : modifier ou effacer - l'entre correspondante
echo "<table align=center><tr><td><input type='submit' value='Ajouter'></td><td><input type='reset' value='Tout effacer'></td></form><td><form method=get action='powerball.php'><input type=submit value='Annuler'></td></form></table>";
break;
}
// referme la connexion
MYSQL_CLOSE($db_link);
?>
</body>
</html>