Hi all,
When I run the below script it gives the Error message each time. The file path seems correct and not sure why files won't upload.
Error Message displays this...
Error
Debugging Info...
Array ( [xls] => Array ( [name] => Movement Proof.xls [type] => application/vnd.ms-excel [tmp_name] => C:\WINDOWS\TEMP\php779.tmp [error] => 0 [size] => 143360 ) )
// $fileName is original file name
$fileName = $_FILES['xls']['name'];
// $tmpName is where file went on server
$tmpName = $_FILES['xls']['tmp_name'];
// $fileSize is size in bytes
$fileSize = $_FILES['xls']['size'];
// $fileType is mime type e.g. image/gif
$fileType = $_FILE['xls']['type'];
// $fileError is any error encountered
$fileError = $_FILE['xls']['error'];
/* End Declaring Variables */
// Error Checking
if ($fileError > 0)
{
echo 'Error: ';
switch ($fileError)
{
case 1: echo 'File exceeded upload_max_filesize';
break;
case 2: echo 'File exceeded max_file_size';
break;
case 3: echo 'File only partially uploaded';
break;
case 4: echo 'No file uploaded';
break;
}
exit;
}
// put the file into folder
$uploaddir = 'uploads/excel/';
$uploadfile = $uploaddir . basename($fileName);
if (move_uploaded_file($tmpName, $uploadfile))
{
echo '<p>File Successfully Uploaded!</p><br />';
// check if a file already in database
$result = mssql_query('SELECT name FROM excel') or die('Select File Error');
$num_results = mssql_num_rows($result);
if ($num_results >0)
{
echo 'File already present';
$query = "UPDATE excel SET name='$fileName', file_date={fn NOW()}";
$result = mssql_query($query) or die('Update Error');
}
else
{
// insert data into database
$query = "INSERT INTO excel(name, file_date) values('$fileName', {fn NOW()})";
$result = mssql_query($query) or die('Insert Error');
}
}
else
{
echo 'Error<br />';
print_r($_FILES['upload_xls']);
echo 'Debugging Info...<br /><br />';
print_r($_FILES);
}
