[RESOLVED] Uploading images and putting file name in a text field

[turtleton09]

I think I'm along the right track with this, but seem to be going wrong somewhere.

What I'm trying to do is have a form to upload info into a table. Each record also has an attached image, the file name needing to be in a file name field to point to the image.

So I have my form :

<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="form1" id="form1">

where edit form action is pointing to a confirmation page.

My input file field :

<input name="Image" type="file" size="55"> 
<input type="hidden" name="MAX_FILE_SIZE" value="25000" />

The code in the confirmation page to move the file to the relevant folder :

<?php
move_uploaded_file ($_FILES['Image'] ['tmp_name'], 
"/pathtofolder/{$_FILES['Image'] ['name']}")
?>

But the place I think I'm going wrong is the insert record code :

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO Carpets (CarpetRef, Carpet, Price, Image, Description, `Size`) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['CarpetRef'], "text"),
                       GetSQLValueString($_POST['Carpet'], "text"),
                       GetSQLValueString($_POST['Price'], "double"),
			  GetSQLValueString($_FILES['Image']['name'], "text"),
                       GetSQLValueString($_POST['description'], "text"),
                       GetSQLValueString($_POST['Size'], "text"));

The record is being added, but the file isn't uploading...

Anyone spot where I've gone wrong?

Cheers,
Iain

[NogDog]

Don't know if this would make any difference, but I believe the max file size hidden field is supposed to come before the file input field in your HTML form.

[sneakyimp]

When the record gets added, does the Image field have any value in it or is it empty?

Also, you should realize that if your /pathtofolder/ path starts with a slash then you may be copying it somewhere else on your server.

[turtleton09]

Thanks for the replies - this was driving me nuts for most of today. I eventually noticed that whenever I changed a page and uploaded it to test, I had to refresh the permissions for the folder in my site's control panel.

So it was probably fine, had I just done that, but because I wasn't doing that, was then trying to correct code that was probably OK, then screwing it up, and getting into a right old muddle.

I eventually got it working, once I had the insert code and the code to move the file in the same page - I had for a while the code to move the file in the confirmation page.

Was just one of those annoying things I had working fine in a simple couple of test pages, but for one reason or another couldn't get quite right in my actual pages.

Got there in the end thank goodness!