help - uploading image to database

[iancarr]

I am trying to upload an image within a form to my database, the form contains various text fields and one file field. (for the image) I can get it to work if i direct the image to a seperate table in the database but not into the same tabe as the rest of the data. I also tried submitting an image reference into the data table from the image table so that I can link the records together, but this doesnt work either.

Any ideas on what the usual way to do this is, or if there is obvious error in my code -

Much appreciated.

My code is:

////////
to deal with the images
/////////

$photo = addslashes(fread(fopen($FILES['file']['tmp_name'], "r"), $FILES['file']['size']));
$query = sprintf("INSERT INTO images(Image, FileType) VALUES ('%s', '%s')", $photo, $_FILES['file']['type']);

///////////
workaround due to images going to another table
//////////

$query = "INSERT INTO details('ImageId') SELECT DISTINCT 'ImageId' FROM 'images'";

///////////
an extract of the form process script
///////////

<tr valign="baseline">
<td nowrap align="right">Other_information</td>
<td><input type="text" name="other_information" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Insert photo::</td>
<td><label for="file"></label>

<input type="file" name="file" id="file" />
<input type="hidden" name="MAX_FILE_SIZE" value="200000">

            </tr>
            <tr valign="baseline">
              <td nowrap align="right">&nbsp;</td>
              <td><input type="submit" name="Submit" value="Submit"></td>
            </tr>
          </table>
          <input type="hidden" name="MM_insert" value="form1">
        </form>

[dagon]

don't put the image in the db, just put its name\location in the db and the image in a dir

[iancarr]

Hi Thanks for the advice, I did this and the upload works, problem know is that if the user dosnt want to upload a file but just wants to send the data in the other fields of the form, it crashes cos its looking for a file to upload, is there a line I can insert that checks for no file identified or file size is zero and ignores trying to do the fread and processes the rest of the form to the db.

Cheers
I

[dagon]

if(!empty($_FILES['file']['name'])){

process file
}else{
no file
}