query($query);
if (!$result) {
die('Requête invalide : ' . mysqli_error($dbhandle));
}
while($row = $result->fetch_array(MYSQLI_ASSOC)){
$year = $row["year"];
$loc1A = utf8_encode($row["loc1"]);
$loc2A = utf8_encode($row["loc2"]);
$loc3A = utf8_encode($row["loc3"]);
$loc4A = utf8_encode($row["loc4"]);
$loc5A = utf8_encode($row["loc5"]);
}
$query="SELECT `loc1`,`loc2`,`loc3`,`loc4`,`loc5`,`loc1C`,`loc2C`,`loc3C`,`loc4C`,`loc5C`,`loc1D`,`loc2D`,`loc3D`,`loc4D`,`loc5D`,`loc1E`,`loc2E`,`loc3E`,`loc4E`,`loc5E` FROM `bateaux_loc` WHERE `nom` LIKE '".$NOMBAT."'";
$result = $dbhandle->query($query);
if (!$result) {
die('Requête invalide : ' . mysqli_error($dbhandle));
}
while($row = $result->fetch_array(MYSQLI_ASSOC)){
/* tarif location*/
$loc1B = $row["loc1"];
$loc2B = $row["loc2"];
$loc3B = $row["loc3"];
$loc4B = $row["loc4"];
$loc5B = $row["loc5"];
/*tarif skipper*/
$loc1C = $row["loc1C"];
$loc2C = $row["loc2C"];
$loc3C = $row["loc3C"];
$loc4C = $row["loc4C"];
$loc5C = $row["loc5C"];
/*tarif nettoyage*/
$loc1D = $row["loc1D"];
$loc2D = $row["loc2D"];
$loc3D = $row["loc3D"];
$loc4D = $row["loc4D"];
$loc5D = $row["loc5D"];
/*montant total*/
$loc1E = $row["loc1E"];
$loc2E = $row["loc2E"];
$loc3E = $row["loc3E"];
$loc4E = $row["loc4E"];
$loc5E = $row["loc5E"];
}
$query="SELECT `titre`,`type`,`description`,`prop`,`prop_comment`,`prop1`,`prop2`,`prop3`,`skipper`,`p_embark` FROM `bateaux_desc` WHERE `nom` LIKE '".$NOMBAT."'";
$result = $dbhandle->query($query);
if (!$result) {
die('Requête invalide : ' . mysqli_error($dbhandle));
}
while($row = $result->fetch_array(MYSQLI_ASSOC)){
/* tarif location*/
$titre = utf8_encode($row["titre"]);
$description = utf8_encode($row["description"]);
$prop = utf8_encode($row["prop"]);
$prop_comment = utf8_encode($row["prop_comment"]);
$skipper = utf8_encode($row["skipper"]);
$p_embark = utf8_encode($row["p_embark"]);
$type = utf8_encode($row["type"]);
$prop1 = utf8_encode($row["prop1"]);
$prop2 = utf8_encode($row["prop2"]);
$prop3 = utf8_encode($row["prop3"]);
}
$query="SELECT `agencement` FROM `typesBateaux` WHERE `type` LIKE '".$type."'";
$result = $dbhandle->query($query);
if (!$result) {
die('Requête invalide : ' . mysqli_error($dbhandle));
}
while($row = $result->fetch_array(MYSQLI_ASSOC)){
$agInt = utf8_encode($row["agencement"]);
}
$query="SELECT `plan`,`depart`,`in1`,`in2`,`in3`,`in4`,`in5`,`in6`,`in7`,`in8`,`in9` FROM `bateaux_photos` WHERE `nom` LIKE '".$NOMBAT."'";
$result = $dbhandle->query($query);
if (!$result) {
die('Requête invalide : ' . mysqli_error($dbhandle));
}
while($row = $result->fetch_array(MYSQLI_ASSOC)){
$plan = utf8_encode($row["plan"]);
$depart = utf8_encode($row["depart"]);
$in1 = utf8_encode($row["in1"]);
$in2 = utf8_encode($row["in2"]);
$in3 = utf8_encode($row["in3"]);
$in4 = utf8_encode($row["in4"]);
$in5 = utf8_encode($row["in5"]);
$in6 = utf8_encode($row["in6"]);
$in7 = utf8_encode($row["in7"]);
$in8 = utf8_encode($row["in8"]);
$in9 = utf8_encode($row["in9"]);
}
$query="SELECT `tarification` FROM `allBateaux`";
$result = $dbhandle->query($query);
if (!$result) {
die('Requête invalide : ' . mysqli_error($dbhandle));
}
while($row = $result->fetch_array(MYSQLI_ASSOC)){
$tarification = utf8_encode($row["tarification"]);
}
$query="SELECT `persTop`,`starsTop`,`pers2`,`stars2`,`pers3`,`star3`,`auto1`,`auto1s`,`auto2`,`auto2s`,`auto3`,`auto3s` FROM `bateaux_notation` WHERE `nom` LIKE '".$NOMBAT."'";
$result = $dbhandle->query($query);
if (!$result) {
die('Requête invalide : ' . mysqli_error($dbhandle));
}
while($row = $result->fetch_array(MYSQLI_ASSOC)){
/* tarif location*/
$persTop = $row["persTop"];
$starsTop = $row["starsTop"];
$pers2 = $row["pers2"];
$stars2 = $row["stars2"];
$pers3 = $row["pers3"];
$stars3 = $row["star3"];
$auto1 = $row["auto1"];
$auto1s = $row["auto1s"];
$auto2 = $row["auto2"];
$auto2s = $row["auto2s"];
$auto3 = $row["auto3"];
$auto3s = $row["auto3s"];
$user = ' :';
$auto1 = $auto1.$user;
$auto2 = $auto2.$user;
$auto3 = $auto3.$user;
if(empty($auto1s))
{
$auto1="";
}
if(empty($auto2s))
{
$auto2="";
}
if (empty($auto3s))
{
$auto3="";
}
}
$star=" ";
for($i=0;$i<$starsTop;$i++)
{
$starsTopNotation.=$star;
}
for($i=0;$i<$stars2;$i++)
{
$stars2Notation.=$star;
}
for($i=0;$i<$stars3;$i++)
{
$stars3Notation.=$star;
}
for($i=0;$i<$auto1s;$i++)
{
$auto1Notation.=$star;
}
for($i=0;$i<$auto2s;$i++)
{
$auto2Notation.=$star;
}
for($i=0;$i<$auto3s;$i++)
{
$auto3Notation.=$star;
}
mysqli_close($dbhandle);
?>
Location de Voilier en Corse avec skipper: un voilier, le Dufour 425
Croisières & Location de voilier et de catamatarans en CORSE
Son agencement intérieur: