$_POST & $_FILES Uploading files

[padanaram]

I am uploading files to a database, although i was told that it is faster to upload gif's and jpg's to a directory on the server. I am having problems uploading the files to the database.

I am using a file for field and a max image size field on the html form and am uploading 2 images at one time, using php 4.2.2. When I run the script I am able to do database inserts, but the images don't upload. I am only using a file text box on the form, should I be using more on the form?

Here is my php code to check the image type.

<PHP>

function picture1($type, $picture1, $ext, $connection)
{
//get info about the image being uploaded
list($type, $ext) = getimagesize($picture1);

switch ($type)
{
case 1:
$ext = ".gif";
break;
case 2:
$ext = ".jpg";
break;
case 3:
$ext = ".swf";
break;
default:
echo "Sorry, but the file you uploaded was not a GIF, JPG, or SWF file.<br>";echo "Please hit your browser's 'back' button and try again.";
}
}
</PHP>

Here is how I do my validation and how I use the $_POST array. I am not validating the images here.

<PHP>
// Clean and trim the POSTed values MAY not need this or may have to do this another way

foreach($_POST as $varname => $value)
$pageFormVars[$varname] = clean($value, 512);

// Validate the home, about, and native anmerican categories apges
if (($id == 1) || ($id == 3) || ($id >= 5) && ($id <= $cat))
{
// Validate pgtitle
if (empty($pageFormVars["pgtitle"]))
// The pgtitle for the home page cannot be NULL
$errorString .= "\n<br>The pgtitle field cannot be blank.";

// Validate pgdesc
if (empty($pageFormVars["pgdesc"]))
// The pgdesc for the home page cannot be NULL
$errorString .= "\n<br>The pgdesc field cannot be blank.";
</PHP>

Here is how I do my picture upload.

<PHP>

// update picture 1
if (is_uploaded_file($FILES["picture1"]["pic1"]))
{
picture1($type, $picture1, $ext, $connection);
if (!($result = @ mysql_query ("UPDATE picture set
picture1 = '{$FILE["pageFormVars"]["picture1"]}'
WHERE picid = {$pageid}", $connection)))
showerror();
}

</PHP>

[Kudose]

Well...here are a few suggesstions.

First, are you using an enctype of multipart/form-data on your form tag?
Second, are you storing the image as binary in a BLOB field?
Thrid, your upload code should look something like this:

<?php
error_reporting(0);
//upload picture 1
$path = "/home/user/public_html/images/"; //set you own absolute path
$tmp_name = $_FILES['picture1']['tmp_name'];
$fname = $_FILES['icture1']['name'];
if(is_uploaded_file($tmp_name))
  if(move($tmp_name, $path.$fname))
    if(mysql_query("UPDATE picture SET picture1='".$fname."' WHERE picid='".$pageid."'"))
      echo 'Successfully uploaded the image and updated the database.';
    else
      echo 'Could not update the database, but the image was uploaded.';
  else
    echo 'Could not move the uploaded file.';
else
  echo 'Could not upload the file.';    

?>

[padanaram]

I am still having problems with uploading images. I also have a few more posts in here. I don't have registered globals on and so far have not been able to upload images at all.

Greg