Image info wont go into database


#1

Can someone help me with this? Everything else goes into the database fine, except for:

product_image (the filename)
product_size (the size of the image)
product_type (the type of image)

[code]<?php
// This page allows users to upload files to the server.

// Check to see if the user is signed in
if (isset($_SESSION[‘artist_id’])) {

$counter = 1; // Number of files to allow for.

if (isset($_POST['submitted'])) { // Handle the form.

	//require_once ('../mysql_connect.php'); // Connect to the database.
	
	for ($i = 0; $i < $counter; $i++) { // Handle each uploaded file.
	
		// Create index names to refer to the proper upload and description.
		$filename = 'product' . ($i+1);
		//$description = 'description' . $i;
	
		// Check for a file.
		if (isset($_FILES[$filename]) && ($_FILES[$filename]['error'] != 4)) {
			
			// Add the record to the database.
			$query = "INSERT INTO products (product_image, product_imagesize, product_imagetype, product_ipaddress, product_date, product_artist_id, product_title, product_shortdescription, product_description, product_price, product_size, product_approved, product_featured) VALUES ('{$_FILES[$filename]['name']}', {$_FILES[$filename]['size']}, '{$_FILES[$filename]['type']}', '".$_SERVER['REMOTE_ADDR']."', NOW(), '".$_SESSION['artist_id']."','".$_POST['product_title']."','".$_POST['product_shortdescription']."','".$_POST['product_description']."','".$_POST['product_price']."','".$_POST['product_size']."','n','n')";
			$result = mysql_query ($query) or die('failed to add product to database' . mysql_error());
		
			if ($result) {
				
				// Return the product_id from the database.
				$product_id = mysql_insert_id();
				
				
				// Move the file over.
				if (move_uploaded_file($_FILES[$filename]['tmp_name'], "uploads/$product_id-{$_FILES[$filename]['name']}")) {
				
					echo '<p>File number ' . ($i + 1) . ' has been uploaded!</p>';
					
				} else { // File could not be moved.
				
					echo '<p><font color="red">File number ' . ($i + 1) . ' could not be moved.</font></p>';
		
					// Remove the record from the database.
					$query = "DELETE FROM products WHERE product_id = $product_id";
					$result = mysql_query ($query);
					
					// Add more detailed error reporting, if desired.
					
				}
				
			} else { // If the query did not run OK.
				echo '<p><font color="red">Your submission could not be processed due to a system error. We apologize for any inconvenience!</font></p>'; 
				// Print the query and invoke the mysql_error() function to debug.
			}
			
		} else {
			// no file was uploaded
			$query = "INSERT INTO products (product_image, product_imagesize, product_imagetype, product_ipaddress, product_date, product_artist_id, product_title, product_shortdescription, product_description, product_price, product_size, product_approved, product_featured) VALUES ('', 0, '', '".$_SERVER['REMOTE_ADDR']."', NOW(), '".$_SESSION['artist_id']."','".$_POST['product_title']."','".$_POST['product_shortdescription']."','".$_POST['product_description']."','".$_POST['product_price']."','".$_POST['product_size']."','n','n')";
			
			$result = mysql_query ($query);
		
			if (!$result) {
				echo '<p><font color="red">Your submission could not be processed due to a system error. We apologize for any inconvenience!</font></p>'; 
			} else {
				echo '<p>Product has been successfully uploaded!</p>';
			}
		}// End of if (isset($the_file)...
		
	} // End of FOR loop.
	
	mysql_close(); // Close the database connection.
		
} // End of the main Submit conditional.
?>

			
		

<div class="titletext">Add a product</div><br />
<form enctype="multipart/form-data" action="product_add.php" method="post">
	<input type="hidden" name="MAX_FILE_SIZE" value="524288">
	
	<?php // Create the inputs.
	for ($i = 0; $i < $counter; $i++) {
		?>
		
			<table>
				<tr>
					<td width="120"><font color="#FF0033">*</font>Title/Name:</td>
					<td width="200"><input type="text" name="product_title" size="30" maxlength="50" /></td>
				</tr>
				<tr>
					<td width="120"><font color="#FF0033">*</font>Short Description:</td>
					<td width="200"><textarea name="product_shortdescription" cols="23" rows="2"></textarea></td>
				</tr>
				<tr>
					<td width="120"><font color="#FF0033">*</font>Description:</td>
					<td width="200"><textarea name="product_description" cols="23" rows="5"></textarea></td>
				</tr>				
				<tr>
					<td width="120"><font color="#FF0033">*</font>Price:</td>
					<td width="200"><input type="text" name="product_price" size="30" maxlength="10" /></td>
				</tr>
				<tr>
					<td width="120"><font color="#FF0033">*</font>Size:</td>
					<td width="200"><input type="text" name="product_size" size="30" maxlength="20" /></td>
				</tr>
				<tr>
					<td width="120">Image:</td>
					<td width="200"><input type="file" name="product1" /></td>
				</tr>
	
		</table>
	<?php 
	
	}
	?>
	
	<input type="hidden" name="submitted" value="TRUE" />
	<div align="center"><input type="submit" name="submit" value="Submit" /></div>

</form>
<?php }else{ echo "Please Login"; } ?>[/code]