Edit Form

[cswales]

I have a php form that displays information from a database based on a mysql query.

Four of the form fields are images that are stored both in the db and in a folder on the host.

What I want to do is to be able to update the images in each of these field, for example, click an update button that allows you to reselect a new image when submitted this would delete the original image and replace with the new.
I know how to unlink the file to remove the images but cannot find a way to do what I need.

Any help is appreciated.

[mihey]

There is not enought information about your script. I would like to know if you are using MySQL ou other type of DB?

Anyway, to choose new images you nedd to create a form lwith these fields:

Image1: <input type="file" name="image1" ><input type='hidden' name='old_image1' value="$oldimage1">
Image2: <input type="file" name="image2" ><input type='hidden' name='old_image2' value="$oldimage2">
Image3: <input type="file" name="image3" ><input type='hidden' name='old_image3' value="$oldimage3">
Image4: <input type="file" name="image4" ><input type='hidden' name='old_image4' value="$oldimage4">
<input type='hidden' value='$id' name='id_of_the_record'>

Don´t forget to put in the <form> tag: enctype="multipart/form-data".

Then you have 2 steps:

1. Delete the old files
2. Put the new files inside of the directory and save the names of the files to the database.

Firstly you verify if was choosed a new image 1:

if($image1!=""){ ..... }

If $image1 is not empty you unlink the old image which name is $old_image1. Then you use UPDATE query to save the new image name to DB.

You repeat the same with the other images.

To put the new image you can use that:

if (copy ($image1,"$directory".strtolower($image1_name))) {
echo "success";
}else{
echo "failed";
}

So it will be something like that for image1:

$directory = "mydirectory/";

if($image1!=""){

if(unlink("$directory".$old_image1."")){

if (copy ($image1,"$directory".strtolower($image1_name))) {
echo "success";
}else{
echo "failed";
}

}

//here you need to put your UPDATE query, my example is MySQL

$sSQL = UPDATE images SET image1='$image1_name' WHERE id=$id_of_the_record

mysql_query($sSQL) or die(mysql_error()."<br>".$sSQL);

}

[cswales]

This is what I have:

if (isset($POST["op"]) && ($POST["op"]=="UpdateProperty"))
{
foreach ($FILES["PROPERTYPHOTOONENEW"]["error"] as $key => $error)
{
if ($error == UPLOAD_ERR_OK) {
$tmp_name = $FILES["PROPERTYPHOTOONENEW"]["tmp_name"][$key];
$name = $FILES["PROPERTYPHOTOONENEW"]["name"][$key];
move_uploaded_file($tmp_name, "$ImagePath/".$POST['PROPERTYREF']."-$name");
$PROPERTYPHOTOONENEW = "".$POST['PROPERTYREF']."-$name";
chmod("$ImagePath/".$POST['PROPERTYREF']."-$name",0755);
}
}

What I want to do is run this if the PROPERTYONEPHOTONEW is not empty. If the PROPERTYONEPHOTONEW field is empty then I want to set $PROPERTYPHOTOONENEW variable to $PROPERTYPHOTOONE. Does this make sense?

What is happening is that when the form updates even if I have not selected a file for any of the images the file names in the database are overwritten with the word 'Array'.

I can supply full code if required.