No Image Uploaded When Page Refreshed

I have built an admin section where you can edit the text of some blocks on the home page, and also update a single image.

When you are on the page where you are going to upload the image, if you upload the image, it will successfully upload and be inserted into the database (as the image name). If you go off the page, the image is still linked in the database.

However if you enter this edit page for the home page, or refresh the page, it will enter nothing in the database. This means the image is no longer linked in the database, and no image shows up on the home page.

Here is the code:

[php]<?php
//define a maxim size for the uploaded images in Kb
define (“MAX_SIZE”,“1000”);

//This function reads the extension of the file. It is used to determine if the
// file is an image by checking the extension.
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return “”; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

//This variable is used as a flag. The value is initialized with 0 (meaning no
// error found)
//and it will be changed to 1 if an errro occures.
//If the error occures the file will not be uploaded.
$errors=0;
//checks if the form has been submitted
if(isset($_POST[‘update_showcase_image’]))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES[‘image’][‘name’];
//if it is not empty
if ($image)
{
//get the original name of the file from the clients machine
$filename = stripslashes($_FILES[‘image’][‘name’]);
//get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
//if it is not a known extension, we will suppose it is an error and
// will not upload the file,
//otherwise we will do more tests
if (($extension != “jpg”) && ($extension != “jpeg”) && ($extension !=
“png”) && ($extension != “gif”))
{
//print error message
echo ‘

Unknown extension!

’;
$errors=1;
}
else
{
//get the size of the image in bytes
//$_FILES[‘image’][‘tmp_name’] is the temporary filename of the file
//in which the uploaded file was stored on the server
$size=filesize($_FILES[‘image’][‘tmp_name’]);

//compare the size with the maxim size we defined and print error if bigger
if ($size > MAX_SIZE*1024)
{
echo ‘

You have exceeded the size limit!

’;
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=time().’.’.$extension;
//the new name will be containing the full path where will be stored (images
//folder)
$newname="…/…/…/RAINBOW/images/uploaded/".$image_name;
//we verify if the image has been uploaded, and print error instead
$copied = copy($_FILES[‘image’][‘tmp_name’], $newname);
if (!$copied)
{
echo ‘

Copy unsuccessfull!

’;
$errors=1;
}}}}
?> <?php //If no errors registred, print the success message if(isset($_POST['update_showcase_image']) && !$errors) { echo ""; $con = mysql_connect("SECRET","SECRET","SECRET"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("SECRET", $con); mysql_query("UPDATE areas SET content = '$newname' WHERE area = 'showcase_image'"); mysql_close($con); }

?>

Showcase Image:

[/php]

Well, normally, you do not use the “copy” to move temporary files to the live folder. Most programmers use the “move_uploaded_file” function for this. This function is designed to move the temporary file and rename it to the filename and place it in the folder of your choice. For some reason, I have seen where the “copy” function does not do this correctly. Try it instead of “copy” and let us know if it works.

Oh, also, in your database update, you are using a query with " WHERE area = ‘showcase_image’ ".
So, this means that there is only ONE row of possible data updated in the table. Is this the way it is supposed
to be? If there are more than one row of data with this WHERE value, you would only be updating the first
row of data. Did that make sense? In other words, does the “areas” table have only one row of data with
the column “area” equal to “showcase_image”?

Not sure if these comments will help, but, somewhere to start with… Let us know…

Sponsor our Newsletter | Privacy Policy | Terms of Service