<?php
$connexion=connectR() OR die('Connexion impossible : ' . mysql_error()); //connexion à la base
$db=mysql_select_db("FRINGUES", $connexion); //Connexion a la base de données FRINGUES
$query = "INSERT INTO livre VALUES ('$Pseudo','$Email','$Commentaires');";
$result= mysql_query($query);
mysql_close($connexion);
 
$nb = mysql_numrows($result);
 
$i=1;
 
while ($i<$nb)
{
$Pseudo = mysql_result($result,$i,"Pseudo" );
$Email = mysql_result($result,$i,"Email" );
$Commentaires = mysql_result($result,$i,"Commentaires" );
 
echo("Pseudo: $Pseudo<BR>" );
echo("E-Mail: $Email<BR>" );
echo("Commentaires: $Commentaires<P>" );
 
$i++;
}
 
 
 
?>

FORM ACTION="livreor2.php" METHOD=POST>
<table>
<tr><td>Nom :</td>
    <td><input type=text name=nom size=25 ></td>
<td rowspan=2><input type=submit value=Envoyer></td></tr>
<tr><td>Mail :</td>
    <td><input type=text name=mail size=25 ></td></tr>
<tr><td>Message:</td><td colspan=2>
        <textarea name=message rows=4 cols=47></textarea>
    </td></tr>
</table>
</form>
 
<?php
 
$connexion=connectR() OR die('Connexion impossible : ' . mysql_error()); //connexion à la base
$db=mysql_select_db("FRINGUES", $connexion); //Connexion a la base de données FRINGUES
$query = "SELECT * FROM livre"; //requete de selection
$result= mysql_query($query);
 
 
$nb = mysql_numrows($result);
 
$i=0;
 
while ($i<$nb)
{
$Pseudo = mysql_result($result,$i,"Pseudo" );
$Email = mysql_result($result,$i,"Email" );
$Commentaires = mysql_result($result,$i,"Commentaires" );
 
echo("<b><i>Pseudo</i></b>: $Pseudo<BR>" );
echo("<b><i>E-Mail</i></b>: $Email<BR>" );
echo("<b><i>Commentaires</i></b>: $Commentaires<P>" );
 
$i++;
}
 
 
mysql_close($connexion); //fermuture de la base
?>

function connectR()
{
   $hote="localhost";
   $login="Sabibien";
   $mdp="sabibien";
   return mysql_connect($hote, $login, $mdp);