[RESOLVED] Empty Fields Problem + Database Insertion

[obrienkev]

Hi all,

I have a number of browse file fields:

<input type="file" name="splits" id="splits" size="22" />
<input type="file" name="mergers" id="mergers" size="22" />
<input type="file" name="spin_offs" id="spin_offs" size="22" />

Then here's the php code to loop through and put files into database...However, if the user selects only one of the browse fields I don't want anything to go into the other two tables.
e.g. The user selects a file for the splits field. Then only data should be inserted into the splits table.

How do I do this?

Thanks.

foreach ($_FILES as $key => $value)
{

// Set variables
$fileName = $value[name];
$fileType = $value[type];
$fileSize = $value[size];

$fp = fopen($value[tmp_name], 'rb');
$content = fread($fp, $fileSize);
$content = addslashes($content);
fclose($fp);


$tables = array(
            "splits" => "splits",
            "mergers" => "mergers",
            "spin_offs" => "spin_offs");

$table = $tables[$key];

$query = "INSERT INTO $table (name, size, type, content, file_date) ".
                 "VALUES ('$fileName', '$fileSize', '$fileType', '$content', NOW())";
$result = mysql_query($query) or die(mysql_error());
} // end foreach clause

[devinemke]

you need to check the "error" index in each subarray of $_FILES. specifically error code "4" means that no file was uploaded.

[obrienkev]

Nice one. Forgot about that. Cheers devinemke

[obrienkev]

Actually spoke too soon...

If I have three browse fields(A, B, C) and B is left empty, then C also becomes empty.

I know it is because of the exit but if I omit exit then it will perform the query on the empty field.

Any ideas?

foreach ($_FILES as $key => $value)
{

// Set variables
$fileName = $value[name];
$fileType = $value[type];
$fileSize = $value[size];
$fileError = $value[error];

// error checking
if ($fileError > 0)
{
	echo 'Problem: ';
	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;
} // end error checking

// read file contents
$fp = fopen($value[tmp_name], 'rb');
$content = fread($fp, $fileSize);
$content = addslashes($content);
fclose($fp);


$tables = array(
                "mergers" => "mergers",
                "spin_offs" => "spin_offs",
                "rights" => "rights",
		"splits" => "splits");

$table = $tables[$key];

$query = "INSERT INTO $table (name, size, type, content, file_date) ".
                 "VALUES ('$fileName', '$fileSize', '$fileType', '$content', NOW())";
$result = mysql_query($query) or die(mysql_error());

} // end foreach clause

[devinemke]

obrienkev wrote:

I know it is because of the exit but if I omit exit then it will perform the query on the empty field.

don't exit. simply conditionally run the query if there are no errors:

<?php
if ($fileError == 0)
{
	// do the query
}
else
{
	// spit out an error message
}
?>

[obrienkev]

Thanks again!! Works well.

foreach ($_FILES as $key => $value)
{

// Set variables
$fileName = $value[name];
$fileType = $value[type];
$fileSize = $value[size];
$fileError = $value[error];

// if no error perform query
if ($fileError == 0)
{
// read file contents
$fp = fopen($value[tmp_name], 'rb');
$content = fread($fp, $fileSize);
$content = addslashes($content);
fclose($fp);


$tables = array(
                "mergers" => "mergers",
                "spin_offs" => "spin_offs",
                "rights" => "rights",
		"splits" => "splits");

$table = $tables[$key];

$query = "INSERT INTO $table (name, size, type, content, file_date) ".
                 "VALUES ('$fileName', '$fileSize', '$fileType', '$content', NOW())";
$result = mysql_query($query) or die(mysql_error());

} // end if ($fileError == 0)

// error checking
else	if ($fileError > 0)
{
	echo 'Problem: ';
	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; 
			 }
} // end error checking

} // end foreach clause