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
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Document sans titre</title>
</head>
<body>
<?php
//connexion au serveur:
$cnx = mysql_connect( "localhost", "root", "root" );
//sélection de la base de données:
$db= mysql_select_db( "info" );
//requête SQL:
$sql = "SELECT *
FROM personnes
ORDER BY denomination" ;
//exécution de notre requête SQL:
$requete = mysql_query( $sql, $cnx ) or die( "ERREUR MYSQL numéro: ".mysql_errno()."<br>Type de cette erreur: ".mysql_error()."<br>\n" );
//récupération avec mysql_fetch_assoc(), et affichage de nos résultats :
echo( "<form method=\"post\" action=\"\">\n" );
echo( "<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\">\n" );
echo( "<tr>
<td><div align=\"center\">id</div></td>
<td><div align=\"center\">denomination</div></td>
<td><div align=\"center\">Valeur</div></td>
<td><div align=\"center\">Poids</div></td>
</tr>" );
while( $result = mysql_fetch_assoc( $requete ) )
{
echo( "<tr>\n" );
echo( "<td><div align=\"center\">".$result["id"]."</div></td>\n" );
echo( "<td><div align=\"center\">".$result["denomination"]."</div></td>\n" );
echo( "<td><input name=\"poids\" type=\"text\" id=\"poids\" value=".$result['valeur']." /></td>\n" );
echo( "<td><input name=\"valeur\" type=\"text\" id=\"valeur\" value=\"$nb1\" /></td>\n" );
echo( "</tr>\n" );
}
echo( "</table>\n" );
echo( "<input type=\"submit\" value=\"Calculer\" />\n" );
echo( "</form>\n" );
?>
<?
$total = ($_POST['poids']) * $_POST['valeur'];
echo 'Résultat : '.$total;
?>
</body>
</html> |
Partager