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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
| <?
$bienimage = $_FILES['bienimage'];
$img_type = $_FILES['bienimage']['type'];
$bienimage2 = $_FILES['bienimage2'];
$img_type2 = $_FILES['bienimage2']['type'];
$bienimage3 = $_FILES['bienimage3'];
$img_type3 = $_FILES['bienimage3']['type'];
$bienimage4 = $_FILES['bienimage4'];
$img_type4 = $_FILES['bienimage4']['type'];
$bienimage5 = $_FILES['bienimage5'];
$img_type5 = $_FILES['bienimage5']['type'];
$bienimage6 = $_FILES['bienimage6'];
$img_type6 = $_FILES['bienimage6']['type'];
$bienimage7 = $_FILES['bienimage7'];
$img_type7 = $_FILES['bienimage7']['type'];
$bienimage8 = $_FILES['bienimage8'];
$img_type8 = $_FILES['bienimage8']['type'];
$bienimage9 = $_FILES['bienimage9'];
$img_type9 = $_FILES['bienimage9']['type'];
$bienimage10 = $_FILES['bienimage10'];
$img_type10 = $_FILES['bienimage10']['type'];
$bienvideo = $_FILES['bienvideo'];
$img_typevid = $_FILES['bienvideo']['type'];
$img1 = file_get_contents ($_FILES['bienimage']['tmp_name']);
$img2 = file_get_contents ($_FILES['bienimage2']['tmp_name']);
$img3 = file_get_contents ($_FILES['bienimage3']['tmp_name']);
$img4 = file_get_contents ($_FILES['bienimage4']['tmp_name']);
$img5 = file_get_contents ($_FILES['bienimage5']['tmp_name']);
$img6 = file_get_contents ($_FILES['bienimage6']['tmp_name']);
$img7 = file_get_contents ($_FILES['bienimage7']['tmp_name']);
$img8 = file_get_contents ($_FILES['bienimage8']['tmp_name']);
$img9 = file_get_contents ($_FILES['bienimage9']['tmp_name']);
$img10 = file_get_contents ($_FILES['bienimage10']['tmp_name']);
$vid1 = file_get_contents ($_FILES['bienvideo']['tmp_name']);
{if ($neonom =="")
{include("neonom_form.inc");
exit();
}
else
{ $biennom = trim($neonom);
$biennom = ucfirst(strtolower(strip_tags($biennom)));
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>ajout d'un bien/title>
</head>
<body>
<? include("misc.inc");
$connection = mysql_connect($host,$user,$password) or die ("connexion au serveur impossible");
$db = mysql_select_db($database,$connection) or die ("sélection de la base de donnée impossible");
//nettoyer les infos
$query = "insert into bien (biennom,bientype,biendescription,bienprix,bienimage,bienvideo,bienville,biendatecrea,bienreference,biensouscategorie,bienimage2,bienimage3,bienimage4,bienimage5,bienimage6,bienimage7,bienimage8,bienimage9,bienimage10,bienpiece,bienchambre,biensurfacehab,biensurfacesejour,bienexposejour,bienjardin,bienetage,biennbetage,biencodeetage,bienanneeconstr,biencuisine,bientypechauff,biennaturechauff,biensurfcarre,bienwc,biensalledebain,biensalledeau,bienparkinginterieur,bienparkingexterieur,bienbox,biencave,bienascenseur,bienbalcon,bienterrasse,bienchargesmens,bientravaux,bientaxehab,bientaxefonc,bieninfocompl,biendesign1,biendesign2,biendesign3,biendesign4,biendesign5,biendesign6,biendesign7,biendesign8,biendesign9,biendesign10,biendesign11,biendesign12,biendesign13,biendesign14,biendesign15,bienm1,bienm2,bienm3,bienm4,bienm5,bienm6,bienm7,bienm8,bienm9,bienm10,bienm11,bienm12,bienm13,bienm14,bienm15,bientextepub,img_type,img_type2,img_type3,img_type4,img_type5,img_type6,img_type7,img_type8,img_type9,img_type10,img_typevid) values ('$biennom','$categorie','$biendescription','$bienprix','".addslashes($img1)."','".addslashes($vid1)."','$bienville','$biendatecrea','$bienreference','$biensouscategorie','".addslashes($img2)."','".addslashes($img3)."','".addslashes($img4)."','".addslashes($img5)."','".addslashes($img6)."','".addslashes($img7)."','".addslashes($img8)."','".addslashes($img9)."','".addslashes($img10)."','$bienpiece','$bienchambre','$biensurfacehab','$biensurfacesejour','$bienexposejour','$bienjardin','$bienetage','$biennbetage','$biencodeetage','$bienanneeconstr','$biencuisine','$bientypechauff','$biennaturechauff','$biensurfcarre','$bienwc','$biensalledebain','$biensalledeau','$bienparkinginterieur','$bienparkingexterieur','$bienbox','$biencave','$bienascenseur','$bienbalcon','$bienterrasse','$bienchargesmens','$bientravaux','$bientaxehab','$bientaxefonc','$bieninfocompl','$biendesign1','$biendesign2','$biendesign3','$biendesign4','$biendesign5','$biendesign6','$biendesign7','$biendesign8','$biendesign9','$biendesign10','$biendesign11','$biendesign12','$biendesign13','$biendesign14','$biendesign15','$bienm1','$bienm2','$bienm3','$bienm4','$bienm5','$bienm6','$bienm7','$bienm8','$bienm9','$bienm10','$bienm11','$bienm12','$bienm13','$bienm14','$bienm15','$bientextepub','$img_type','$img_type2','$img_type3','$img_type4','$img_type5','$img_type6','$img_type7','$img_type8','$img_type9','$img_type10','$img_typevid')";
$result = mysql_query($query) or die('Erreur SQL !<br>'.$query.'<br>'.mysql_error());
$biensid = mysql_insert_id();
echo " le bien suivant a été ajouté au catalogue :<br>
echo "<a href='selectionbien.php'>Ajoutez un autre bien</a>\n";
?> |
Partager