<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
          <table id="tablecorps">
            <tr valign="baseline">
            	<td nowrap="nowrap" align="right">Nom:</td>
				<td><select name="tra_id" STYLE="width:150px">
					<?php 
					do 
					{  
						echo '<option value="'.$row_travaux['id'].'">'.$row_travaux['nom'].'</option>';
					} 
					while ($row_travaux = mysql_fetch_assoc($travaux));
					?>
				</select></td>
            </tr>
            <tr>
            	<td nowrap="nowrap" align="right">Photo:</td>
                <td><label><input name="photo" type="file" id="photo" onchange="test_image()" size="32"/></label></td>
            </tr>
            <tr valign="baseline">
            	<td nowrap="nowrap" align="right">&nbsp;</td>
            	<td><input type="submit" value="Ajouter" /></td>
            </tr>
          </table>
          <input type="hidden" name="id" value="" />
          <input type="hidden" name="MM_insert" value="form1" />
        </form>

<?php require_once('../../Connections/conn.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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']);
}

// Test si le formulaire a bien été envoyé
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) 
{
	//récupère et redimensionne la photo
	$photodir='../../gallery/images/';
	$photo="";	
	
	$type_photo = $_FILES['photo']['type'];
	//vérifie que la photo soit au bon format
	if(!(strstr($type_photo,'jpg') or strstr($type_photo,'jpeg') or strstr($type_photo,'bmp') or strstr($type_photo,'gif') or strstr($type_photo,'png')))
	{
		exit("L'image n'est pas compatible ou est trop lourde.");
	}
	//vérifie que l'upload s'est bien passée
		$the_image=$photodir.$_FILES['photo']['name'];
		$the_image_big=$photodir."big_".$_FILES['photo']['name'];
		
		$i="";
		while(file_exists($the_image_big)){
			$i+=1;
			$the_image=$photodir.$i.$_FILES['photo']['name'];
			$the_image_big=$photodir."big_".$i.$_FILES['photo']['name'];
		}
		
		if(move_uploaded_file($_FILES['photo']['tmp_name'], $the_image))
		{
		$photo=$i.$_FILES['photo']['name'];
				
		list($width, $height, $type, $attr) = getimagesize($photodir.$photo);
				
		// si la vignette est horizontale
		if($width>=$height)
		{
			creation_vignette($photo , 96 , 250 , $photodir , $photodir , "small_");
			creation_vignette($photo , 400 , 1000 , $photodir , $photodir , "big_");
		}
		// si la vignette est verticale
		if($width<=$height)
		{
			creation_vignette($photo , 96 , 250 , $photodir , $photodir , "small_");
			creation_vignette($photo , 400 , 1000 , $photodir , $photodir , "big_");
		}
		//efface l'originale
		if($photo!="") 
		{
			chmod($photodir.$photo,0777);
	  		unlink($photodir.$photo);
		}
	}
	$insertSQL = sprintf("INSERT INTO photos (id, photo) VALUES (%s, %s)",
                       GetSQLValueString($_POST['id'], "int"),
                       GetSQLValueString($photo, "text"));
					   
  mysql_select_db($database_conn, $conn);
  $Result1 = mysql_query($insertSQL, $conn) or die(mysql_error());

  $insertGoTo = "gestion_photos_travaux.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_conn, $conn);
$query_travaux = "SELECT * FROM travaux ORDER BY nom ASC";
$travaux = mysql_query($query_travaux, $conn) or die(mysql_error());
$row_travaux = mysql_fetch_assoc($travaux);
$totalRows_travaux = mysql_num_rows($travaux);
?>