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
| <?
$mabasededonnee="karaexpo";
$connection = mysql_connect("****-1","******","******");
if ( ! $connection )
die ("connection impossible");
mysql_select_db('karaexpo') or die ("pas de connection");
// requête SELECT
$requete = "SELECT id,nomcrea,nom,prenom,adresse,responsable,cp,ville,pays,tel,fax,site,mail,visite,descritpif,types,exposer,url_image1,url_image2,url_image3,url_image4,url_image5 FROM formtest1 ORDER BY id";
$envoi = mysql_query($requete);
// début du tableau ( hors boucle )
echo "<table width=\"360\" border=\"0\" align=\"left\" cellpadding=\"0\" cellspacing=\"4\"> \n";
$_GET['id'];
// début de la boucle
echo "Les Inscrits Sont :";
while($tableau = mysql_fetch_array($envoi)) {
echo "<tr> \n";
echo "<td width=\"258\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\"><a href=\"delete.php\"><img src=\"../content_fr/image/croix_rouge.gif\" border=\"0\" width=\"18\" height=\"15\" /></a></td> \n";
echo "<td width=\"258\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\">".$tableau["id"]=$id."</td> \n";
echo "<td width=\"258\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\">".$tableau["nom"]."</td> \n";
echo "<td width=\"258\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\">".$tableau["prenom"]."</td> \n";
echo "<td width=\"258\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\">".$tableau["tel"]."</td> \n";
echo "<td width=\"258\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\">".$tableau["mail"]."</td> \n";
echo "<td width=\"258\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\">".$tableau["visite"]."</td> \n";
echo "<td width=\"258\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\">".$tableau["descriptif"]."</td> \n";
echo "<td width=\"265\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\"><a href=\"http://www.kara-expo.com/content_fr/".$tableau["url_image1"]."\">Photo 1</a></td> \n";
echo "<td width=\"265\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\"><a href=\"http://www.kara-expo.com/content_fr/".$tableau["url_image2"]."\">Photo 2</a></td> \n";
echo "<td width=\"265\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\"><a href=\"http://www.kara-expo.com/content_fr/".$tableau["url_image3"]."\">Photo 3</a></td> \n";
echo "<td width=\"265\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\"><a href=\"http://www.kara-expo.com/content_fr/".$tableau["url_image4"]."\">CV</a></td> \n";
echo "<td width=\"265\" align=\"left\" valign=\"top\" bgcolor=\"#e8eff6\"><a href=\"http://www.kara-expo.com/content_fr/".$tableau["url_image5"]."\">Lettre</a></td> \n";
echo "</tr> \n";
}
// fin du tableau html ( hors boucle )
echo "</table> \n";
?> |
Partager