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
| <?php
require_once ('code/connexion.php');
if ($stmt = mysqli_prepare($mysqli, "SELECT nom, race,pere,mere,pere_de_mere,texte,photo,lien_youtube FROM chevaux_a_vendre "))
{
mysqli_stmt_execute($stmt);
/* Insertion de la variable */
mysqli_stmt_bind_result($stmt, $nom, $race,$pere,$mere,$pere_de_mere,$texte,$photo,$lien_youtube);
/* Récupération des valeurs */
while (mysqli_stmt_fetch($stmt))
{
echo "Nom: $nom","<br/>","Race: $race","<br/>", "Père: $pere","<br/>","Mère: $mere","<br/>","Père de mère: $pere_de_mere","<br/>",$texte,"<br/>","<br/>";
if(!empty($photo))
{
echo"<img src='photo_galerie/$photo'width='420' height='' /><br/>";
}
else
{
echo"<br/><br/>";
}
if(!empty($lien_youtube))
echo"<iframe width='420' height='315' src='http://www.youtube.com/embed/$lien_youtube', frameborder='0' allowfullscreen></iframe><br/>";
echo"<hr>";
}
/* Fermeture du traitement */
mysqli_stmt_close($stmt);
}
?> |
Partager