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
| <?php
include "connect.inc.php"; //connexion à la base
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang="fr-fr">
<head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<title>index.html</title>
</head>
<body>
<div align="center"><strong>TEST PHOTO</strong></div>
<hr>
<?PHP
$id = $_POST['id'];
echo "$id<br/>";
$requete = "SELECT nom,prenom,photo FROM t_trombinoscope WHERE id = '$id'";
$query = pg_query($db,$requete);
$nom = pg_fetch_result($query, 0, 0);
$prenom = pg_fetch_result($query, 0, 1);
$photo = pg_fetch_result($query, 0, 2);
echo "Nom : $nom<br/>";
echo "Prenom : $prenom<br/>";
echo "Num photo : $photo<br/>";
//echo $photo;
pg_query($db, "begin");
$handle = pg_lo_open($db, $photo, "r");
$data = pg_lo_read_all($handle);
pg_query($db, "commit");
echo $dphoto;
?>
</body>
</html> |
Partager