<?php

include "db_connection.php";   //Includes mysql connection information

// database connection
$dblink = mysql_connect($dbhostname,$dbusername, $dbpassword) OR DIE ("Unable to connect to database! Please try again later.");
@mysql_select_db($dbname, $dblink);


// Do this process if user has browse the file and click the submit button
if ($_FILES) {
  $image_types = Array ("image/bmp",
                        "image/jpeg",
                        "image/pjpeg",
                        "image/gif",
                        "image/x-png");

  @$userfile  = addslashes (fread (fopen ($_FILES["userfile"]["tmp_name"], "r"), filesize ($_FILES["userfile"]["tmp_name"])));
  $file_name = $_FILES["userfile"]["name"];
  $file_size = $_FILES["userfile"]["size"];
  $file_type = $_FILES["userfile"]["type"];

  if (in_array (strtolower ($file_type), $image_types)) {
    $sql = "INSERT INTO wcsubmittal (camname, country, state, city, sdesc, url, link, gmt, weather, catagory, added, email, addeddate, imagedate, imagetype, imagesize, image_name, image) VALUES ('$camname', '$country', '$state', '$city', '$sdesc', '$url', '$imageurl', '$timezone', '$metar', '$catagory', '$fullname', '$email', NOW(), NOW(), '$file_type', '$file_size', '$file_name', '$userfile')"; 
    @mysql_query ($sql, $dblink);

exit();
  }
}

// Do this process if user has browse the 
// file and click the submit button

?>