File "_ajout.php"

Full Path: /home/analogde/www/videos/powerball/_ajout.php
File size: 3.39 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";


// authentification et connexion
  $connexion = mysql_connect($db_host,$db_user,$db_pass); 
  if(!$connexion)  
    { echo "Dsol, y a un blme, connexion au serveur $db_host impossible\n";
      exit; 
    }

   // pointe sur la base
   $db = mysql_select_db($db_name,$connexion); 
   if(!$db)
      {  echo "Dsol accs a la base $db_name impossible\n";
      }


// 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);
//$result = MYSQL_QUERY("select * from powerball order by main_gauche desc");
//$number = MYSQL_NUM_ROWS($result);
$idmax_r=mysql_result($idmax,0,"max(id)"); 
$n=$idmax_r+1;


//$requete=mysql_db_query($sql_bdd,"select max(id) from forum",$db_link) or die(mysql_error());
//$idmax=mysql_result($requete,0,"max(id)");



echo "valeur de idmax === $idmax";
echo " <BR> "; 
echo "valeur de n === $n";
echo " <BR> "; 





$requete=mysql_query("insert into powerball values($n,'$nom','$prenom','$main_gauche','$main_droite','$endurance')");


// lien pour retourner au tableau principal

if(!$requete) 
  { echo "Dsol, y a un blme: la requte n'a pas t excute .... \n";
      exit; 
  }

echo "<p align=center><h1 align=center>Enregistrement russi.<br><br><a href='powerball.php'>Retour</a></p>";
break;



// affichage du formulaire
default;
          
          
/*echo "	<blockquote><table border=0><td width='81'><div align='center'>Candidat</div>
<div align='center'><strong>SCORE</strong></div>
<form method='get' action='ajout.php'><input type='hidden' name=ok value=1>
    

	Nom<tr>
	<td>Nom:</td>
	<td width=180><input type='text' name=nom  size=30 maxlenght=60></td>
	<tr>
	<td>Pr&eacute;nom:</td>
	<td><input type='text' name=prenom size=30 maxlenght=5></td>
	<tr>
   	  <td>Main gauche </td>
   	  <td><input type='text' name=main_gauche size=30 maxlenght=5></td>
    <tr>
	<td>Main droite </td><td><input type='text' name=main_droite size=30 maxlenght=15></td>
	<tr>
	<td>Endurance</td><td><input type='text' name=endurance size=30 maxlenght=30></td>
</table>*/ 
	     
	     

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>Prnom</td>
      	<td><input type='text' name=prenom  size=10 maxlenght=15></td>
      	
	<td>Gauche</td>
	<td><input type='text' name=main_gauche  size=10 maxlenght=15></td>
	
	<td>Droite</td>
	<td><input type='text' name=main_droite  size=10 maxlenght=15></td>
	
	<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();

?>

</body>

</html>