If Statement to overwrite an image.

[stublackett]

Hi,

 

I've got a FORM Setup. The form has a current image and an option to add a new image (In place of that image)

 

The form fields in question are :

<input type="hidden" name="image_url" value="<?php echo $row_select_propertyimages['image_url']; ?>" />
<input type="file" name="new_image_url" class="inputfile" />

I've setup an IF Statement, to check that if new_image_url ISNT set, then to keep the current image. Otherwise, overwrite it with new_image_url. When I dont choose to upload a new file, The code works correctly.

 

The code is as follows.

if(empty($_POST['new_image_url'])) {
    $image_url = $row_select_propertyimages['image_url'];
} else {
    $image_url = $_FILES['new_image_url'];
}

 

The data then gets input to a Database. But at the moment, It is not overwriting what is currently there. Can anyone help me on this?

 

My full code is :

<?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;
}
}

$colname_select_propertyimages = "-1";
if (isset($_GET['image_id'])) {
  $colname_select_propertyimages = $_GET['image_id'];
}
mysql_select_db($database_db_connect, $db_connect);
$query_select_propertyimages = sprintf("SELECT * FROM image WHERE image_id = %s", GetSQLValueString($colname_select_propertyimages, "int"));
$select_propertyimages = mysql_query($query_select_propertyimages, $db_connect) or die(mysql_error());
$row_select_propertyimages = mysql_fetch_assoc($select_propertyimages);
$totalRows_select_propertyimages = mysql_num_rows($select_propertyimages);

mysql_select_db($database_db_connect, $db_connect);
$query_select_property = "SELECT property.property_id, property.property_name FROM property ";
$select_property = mysql_query($query_select_property, $db_connect) or die(mysql_error());
$row_select_property = mysql_fetch_assoc($select_property);
$totalRows_select_property = mysql_num_rows($select_property);

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "addproperty")) {

if(empty($_POST['new_image_url'])) {
    $image_url = $row_select_propertyimages['image_url'];
} else {
    $image_url = $_FILES['new_image_url'];
}
echo $image_url;

$updateSQL = sprintf("UPDATE image SET image_url=%s, image_desc=%s, image_disphome=%s, image_property_id=%s WHERE image_id=%s",
                       GetSQLValueString($image_url, "text"),
                       GetSQLValueString($_POST['image_desc'], "text"),
                       GetSQLValueString(isset($_POST['image_disphome']) ? "true" : "", "defined","'Y'","'N'"),
                       GetSQLValueString($_POST['image_property_id'], "int"),
                       GetSQLValueString($_POST['image_id'], "int"));

  mysql_select_db($database_db_connect, $db_connect);
  $Result1 = mysql_query($updateSQL, $db_connect) or die(mysql_error());

//  $updateGoTo = "success_editproperty.php";
//  if (isset($_SERVER['QUERY_STRING'])) {
//    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
//    $updateGoTo .= $_SERVER['QUERY_STRING'];
//  }
//  header(sprintf("Location: %s", $updateGoTo));
}
?>

 

Many Thanks in advance.