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
|
<?php
error_reporting(E_ALL);
$serveur = "localhost";
$base = "aaaaaa";
$user = "bbbb";
$pass = "cccccc";
$mysqli = new mysqli($serveur, $user, $pass, $base);
if ($mysqli->connect_error) {
echo 'connexion impossible... :'.$mysqli->connect_error;
}
else {
echo 'connexion réussie : '.$mysqli->host_info;
}
$requete = "SELECT * FROM lampes ";
$resultat = $mysqli->query($requete) or die ('Erreur '.$requete.' '.$mysqli->error);
?>
<HTML>
<BODY>
<H1>Récupération OK <H1>
<TABLE border="5">
<?php
echo "<TR><form method='post' action='page4.php'>";
echo "<TH> Id lampe </TH>";
echo "<TH> Etat </TH>";
echo "<TH> Vario </TH>";
echo "<TH> Nom </TH>";
echo "</TR>";
while ($row = $resultat->fetch_assoc()) {
echo "<TR>";
echo "<TD>" . $row['id_lampe'] . " </TD>";
echo "<TD>" . $row['what_lampe'] . " </TD>";
echo "<TD>" . $row['what_vario'] . "</TD>";
echo "<TD>" . $row['lib_lampe'] . " </TD>";
echo "<TH><INPUT type='text' name='nom' size='8' maxlength='30'></TD>";
echo "<TH><INPUT type='submit' value='modifier'></TD>";
echo "</TR>";
}
?>
</BODY>
</HTML>
<?php
// Connexion à MySQL
$mysqli = new mysqli($serveur, $user, $pass, $base);
if(isset($_POST['modifier'])) {
// Réecriture des variables
$id_lampe=$_POST['id_lampe'];
$lib_lampe=$_POST['lib_lampe'];
// Requête de modification d'enregistrement
$Modifier="UPDATE lampe SET
lib_lampe='$lib_lampe'
WHERE id_lampe=$id_lampe";
?>
<?php
// 6. Libération de la mémoire occupée par le résultat de la requête
mysql_free_result($resultat);
// 7. Déconnexion
mysql_close($mysqli);
?> |
Partager