j'ai trouvé
voilà le code
<?php require_once('../Connections/conn.php');
//images
if( isset($_POST['Submit']) and $_FILES['photo_produit']['name']!="")
{
$size = 150; // the thumbnail weight
$filedir = '/home/sites/site15/web/images/produit/'; // the directory for the original image
$thumbdir = '/home/sites/site15/web/images/produit/petites/'; // the directory for the thumbnail image
$prefix = ''; // the prefix to be added to the original name
$maxfile = '2000000';
$mode = '0777';
$userfile_name = $_FILES['photo_produit']['name'];
$userfile_tmp = $_FILES['photo_produit']['tmp_name'];
$userfile_size = $_FILES['photo_produit']['size'];
$userfile_type = $_FILES['photo_produit']['type'];
if (isset($_FILES['photo_produit']['name']))
{
$prod_img = $filedir.$userfile_name;
$prod_img_thumb = $thumbdir.$prefix.$userfile_name;
move_uploaded_file($userfile_tmp, $prod_img);
chmod ($prod_img, octdec($mode));
$sizes = getimagesize($prod_img);
$aspect_ratio = $sizes[0]/$sizes[1]; //le 0 largeur 1 hauteur
if ($sizes[0] <= $size)
{
$new_width = $sizes[0];
$new_height = $sizes[1];
}else{
$new_width = $size;
$new_height =
abs($new_width/$aspect_ratio); //abs (absolu) car pixel doit valeur
entiere
}
$destimg=ImageCreateTrueColor($new_width,$new_height) or die('Problem In Creating image');
$srcimg=ImageCreateFromJPEG($prod_img) or die('Problem In opening Source Image');
ImageCopyResized($destimg,$srcimg,0,0,0,0,$new_width,$new_height,ImageSX($srcimg),ImageSY($srcimg))
or die('Problem In resizing');
ImageJPEG($destimg,$prod_img_thumb,90) or die('Problem In saving');
imagedestroy($destimg);
}
} else $userfile_name = "visuelnondisponible.jpg";
//bases
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO produits (nom_produit,
description_produit, photo_produit, categorie_produit) VALUES (%s, %s,
%s, %s)",
GetSQLValueString($_POST['nom_produit'], "text"),
GetSQLValueString($_POST['description_produit'], "text"),
GetSQLValueString($userfile_name, "text"),
GetSQLValueString($_POST['categorie_produit'], "int"));
mysql_select_db($database_conn, $conn);
$Result1 = mysql_query($insertSQL, $conn) or die(mysql_error());
}
mysql_select_db($database_conn, $conn);
$query_cate = "SELECT id_categorie, nom_categorie FROM categories";
$cate = mysql_query($query_cate, $conn) or die(mysql_error());
$row_cate = mysql_fetch_assoc($cate);
$totalRows_cate = mysql_num_rows($cate);
mysql_select_db($database_conn, $conn);
$query_prod = "SELECT * FROM produits";
$prod = mysql_query($query_prod, $conn) or die(mysql_error());
$row_prod = mysql_fetch_assoc($prod);
$totalRows_prod = mysql_num_rows($prod);
?>
<link href="../style.css" rel="stylesheet" type="text/css" />
<form action="<?php echo $editFormAction;
?>" method="POST" enctype="multipart/form-data" name="form1" >
<div align="center">
<table width="498" border="0" cellspacing="5" cellpadding="0">
<tr>
<td colspan="2"><div align="center" class="titre">Ajout
d'un article </div></td>
</tr>
<tr>
<td width="158"><div align="center">nom du produit
</div></td>
<td width="325"><div align="center">
<p align="left">
<input name="nom_produit" type="text" id="nom_produit" size="32"
/>
<br />
</p>
</div></td>
</tr>
<tr>
<td><div align="center">Description du produit
</div></td>
<td>
<div align="left">
<textarea name="description_produit" cols="50" rows="5"
id="description_produit"></textarea>
</div></td></tr>
<tr>
<td><div align="center">Photo du produit
</div></td>
<td>
<div align="left">
<input type="file" name="photo_produit" value=""
/>
</div></td></tr>
<tr>
<td><div align="center">Catégorie du produit
</div></td>
<td>
<div align="left">
<select name="categorie_produit" id="categorie_produit">
<?php
do {
?>
<option value="<?php echo
$row_cate['id_categorie']?>"><?php echo
$row_cate['nom_categorie']?></option>
<?php
} while ($row_cate = mysql_fetch_assoc($cate));
$rows = mysql_num_rows($cate);
if($rows > 0) {
mysql_data_seek($cate, 0);
$row_cate = mysql_fetch_assoc($cate);
}
?>
</select>
</div></td></tr>
<tr>
<td> </td>
<td>
<div align="left">
<input type="submit" name="Submit" value="Ajouter l' article"
/>
</div></td></tr>
</table>
<BR >
</div>
<p>
<input type="hidden" name="MM_insert" value="form1">
</form>
<div align="center">
<?php
mysql_free_result($cate);
mysql_free_result($prod);
?>
<table width="324" height="111" border="0" cellpadding="0" cellspacing="0">
<tr>
<td
width="324"><p class="texteencadre">Pour ajouter une photo au
format jpeg (uniquement ) , sans dépasser un format de 500
pixels par 500 pixels , cliquer sur parcourir puis
sélectionner votre image sur le disque dur et cliquer sur
ouvrir .Ensuite remplisser le formulaire normalement et ajouter
l'article . </p>
<p class="texteencadre">Si vous souhaitez modifer votre image
prise avec un appareil photo ,utliser adobe photoshop ou Gimp(gratuit)
pour redimensionner votre image et la compressser sans
dépasser 500 pixels par 500 pixels. </p>
<p align="center"><a href="index.php">Retour administration
du site</a></p></td>
</tr>
</table>
</div>