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
|
<?php
$champs=array("id","tb_e_mail","tb_pw","tb_etablissement","tb_responsable","tb_adresse","tb_cp","tb_ville","tb_telephone","tb_fax","tb_date","tb_w1_lundi","tb_w1_mardi","tb_w1_mercredi","tb_w1_jeudi","tb_w1_vendredi","tb_w1_samedi","tb_w1_dimanche","tb_w2_lundi","tb_w2_mardi","tb_w2_mercredi","tb_w2_jeudi","tb_w2_vendredi","tb_w2_samedi","tb_w2_dimanche","tb_type","tb_descriptif");
if(isset($_POST['sendetablissement'])) $geturl=$_POST['sendetablissement'];
else $geturl="";
// connexion à la base
$connect2 = mysql_connect('localhost','root', '') or die('Erreur de connexion '.mysql_error());
// sélection de la base
mysql_select_db('myresto',$connect2) or die('Erreur de selection '.mysql_error());
// on écrit la requête sql
$query2 = "SELECT * FROM tb_resto WHERE ".$champs[3]." LIKE 'restaurant'";
$resultat2=mysql_query($query2) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$nb = mysql_num_rows($resultat2);
if ($nb < 1) {
echo 'Pas de résultats !';
}else{
while($restaurants=mysql_fetch_array($resultat2))
{
echo '"<table width="100%" border="1" cellspacing="0" cellpadding="0">"';
echo '"<tr>"';
echo '"<td></td>"';
echo '"<td></td>"';
echo '"</tr>"';
echo '"<tr>"';
echo '"<td> </td>"';
echo '"<td> </td>"';
echo '"</tr>"';
echo '"</table>"';
}
}
mysql_close($connect2); // on ferme la connexion
?> |
Partager