Can anyone point out/help as to why my script is not working for uploading an image to a directory and the name of the image to the database. At the moment once I submit the form, it goes to the script page but remains blank, i look in the database and nothing has happened...I have used a similar script on another one of my sites and it has worked but I have adjusted it slightly to this one.

Help would be greatly appreciated, as i can'd the root of the problem at all

Here is the form

PHP Code:

<form  action="uploadimage.php"  method="post" enctype="multipart/form-data" > 
<input type="file" name="image" /> 
<br /> 
<input type="hidden" name="MAX_FILE_SIZE" value="100000" /> 
<br /> 
<input type="submit" id="submit" value="Upload"> 

</form> 


and here is the uploadimage.php script

PHP Code:

<?php 

include "include/conn.php"; 

include "include/session.php"; 
?> 

<?php 


// Check to see if the type of file uploaded is a valid image type 
function is_valid_type($file) 
{ 
        
        $valid_types = array("image/jpg", "image/jpeg", "image/bmp", "image/gif"); 

        if (in_array($file['type'], $valid_types)) 
                return 1; 
        return 0; 
} 


function showContents($array) 
{ 
        echo "<pre>"; 
        print_r($array); 
        echo "</pre>"; 
} 




$TARGET_PATH = "images/"; 

// Get POSTed variables 

$image = $_FILES['image']; 


$image['name'] = mysql_real_escape_string($image['name']); 


$TARGET_PATH .= $image['name']; 

// Make sure all the fields from the form have inputs 
if ($image['name'] == "" ) 
{ 
        $_SESSION['error'] = "All fields are required"; 
        header("Location: addvox.php"); 
        exit; 
} 

// Verify file is an image 
if (!is_valid_type($image)) 
{ 
        $_SESSION['error'] = "You must upload a jpeg, gif, or bmp"; 
        header("Location: addvox.php"); 
        exit; 
} 



// move file into the directory and the path name into the database 
if (move_uploaded_file($image['tmp_name'], $TARGET_PATH)) 
{ 
         
        $sql = "INSERT INTO images(image) VALUES ({$image['name']}) "; 
        $result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error()); 
        header("Location: addvox.php"); 
        exit; 
} 
else 
{ 
         
        $_SESSION['error'] = "Could not upload file.  Check read/write persmissions on the directory"; 
      
        exit; 
} 
?>

THANK U!

I'm just going to take some troubleshooting guesses here... so no errors?

is the script connected to an sql database connection to user mysql_real_escape_string?

is the images/ folder chmodded?

i would try to put a echo 'hello'; somewhere near the top and keep testing the page... and moving it down until you can't see it to see how far the script has gone... assuming you had php errors on and it shows nothing

Well, it seems like it's failing here:

if (move_uploaded_file($image['tmp_name'], $TARGET_PATH))

So I'd guess that it has to do with your folder permissions... you should check 1) that it's uploading to the correct path, and 2) that the folder is chowned and chmodded properly.

Try this first:

$TARGET_PATH = dirname(__FILE__) . "/images/";

I havent got any folder permissions on as im just testing it locally, i mean the image is being moved into the folder, its just not working with the database.

I made the change you said and now I get an error saying 'Could not insert data into DB: Unknown column 'caparo' in 'field list''.

ive worked it out, it was the was the select statement cheers guys