global $strDesc; global $fileUpload; global $fileUpload_name; global $fileUpload_size; global $fileUpload_type; // Make sure both a description and // file have been entered if(empty($strDesc) || $fileUpload == "none") die("You must enter both a description and file"); // Database connection variables $dbServer = "localhost"; $dbDatabase = "mcmembers"; $dbUser = "root"; $dbPass = "TMGData1"; $fileHandle = fopen($fileUpload, "r"); $fileContent = fread($fileHandle, $fileUpload_size); $fileContent = addslashes($fileContent); $sConn = mysql_connect($dbServer, $dbUser, $dbPass) or die("Couldn't connect to database server"); $dConn = mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase"); $dbQuery = "UPDATE mem SET MemPicture='".$fileContent."',MemPictureType='".$fileUpload_type."') WHERE MemID=13"; // $dbQuery .= "('$fileContent', '$fileUpload_type')"; mysql_query($dbQuery) or die("Couldn't add file to database"); echo "

File Uploaded

"; echo "The details of the uploaded file are shown below:

"; echo "File name: $fileUpload_name
"; echo "File type: $fileUpload_type
"; echo "File size: $fileUpload_size
"; echo "Uploaded to: $fileUpload

"; echo "Add Another File";