<?php

// Create MySQL login values and
// set them to your login information.
$username = '**********';
$password = '**************';
$host = 'localhost';
$database = '*****************';

// Make the connect to MySQL or die
// and display an error.
$link = mysql_connect($host, $username, $password);
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

// Select your database
@mysql_select_db ($database)or die ('Unable to Select Database ' . mysql_error());

// set up the strings i want ....
// You can use $_GET or $_POST dependent on the form type, or $_REQUEST which will
// accept either method ;-)

    $MGJPartNo=mysql_real_escape_string($_REQUEST['MGJPartNo']);
    $OEMPartNo=mysql_real_escape_string($_REQUEST['OEMPartNo']);
    $DrgNo=mysql_real_escape_string($_REQUEST['DrgNo']);
    $IQty=mysql_real_escape_string($_REQUEST['IQty']);
    $SuitableFor=mysql_real_escape_string($_REQUEST['SuitableFor']);
    $ReplacedBy=mysql_real_escape_string($_REQUEST['ReplacedBy']);
    $MasterGroup=mysql_real_escape_string($_REQUEST['MasterGroup']);
    $SubGroup=mysql_real_escape_string($_REQUEST['SubGroup']);
    $Description=mysql_real_escape_string($_REQUEST['Description']);
    $Dimensions=mysql_real_escape_string($_REQUEST['Dimensions']);
    $Size=mysql_real_escape_string($_REQUEST['Size']);
    $PicFileName1=mysql_real_escape_string($_REQUEST['PicFileName1']);
    $PicFileName2=mysql_real_escape_string($_REQUEST['PicFileName2']);
    $Pic2Size=mysql_real_escape_string($_REQUEST['Pic2Size']);
    $data = ''; // For Unique Picture

     // Create the query and insert
      // into our database.
 // See if UniquePicture exists
if (isset($_FILES['UniquePicture']) && $_FILES['UniquePicture']['size'] > 0) {

      // Temporary file name stored on the server
      $tmpName  = $_FILES['UniquePicture']['tmp_name'];
      // Read the file
      $fp      = fopen($tmpName, 'r');  // if WAMP use 'rb'
      $data = fread($fp, filesize($tmpName));
      $data = addslashes($data);
      fclose($fp);
}

      $query = "INSERT INTO MGJ_Parts (MGJ_Part_No, OEM_Part_No, Drg_No, Suitable_For, Replaced_By,
       Master_Group, Sub_Group, Description, Dimensions, Size, Pic_File_Name1, Pic_File_Name2,
       Pic2_Size, Unique_Picture, Inner_Qty)
       VALUES ('$MGJPartNo', '$OEMPartNo', '$DrgNo', '$SuitableFor', '$ReplacedBy', '$MasterGroup',
       '$SubGroup', '$Description', '$Dimensions', '$Size', '$PicFileName1', '$PicFileName2',
       'Pic2Size', '$data', '$IQty')";

//print $query;
      $result = mysql_query($query, $link);
      if (!$result) {
    die('Invalid query: ' . mysql_error());
		}

      // All okay ?
      print "Record Added :-)";

// Close our MySQL Link
mysql_close($link);

?>