upload file error

[natman3]

When I run this I get: Error, query failed I am not sure why. From what i can tell i have all my code correct. If anyone can tell me what i am doing wrong please let me know

<?php
if(isset($POST['upload']) && $FILES['userfile']['size'] > 0)
{
$fileName = $FILES['userfile']['name'];
$tmpName = $FILES['userfile']['tmp_name'];

				$fp      = fopen($tmpName, 'r');
				$content = fread($fp, filesize($tmpName));

				  for($i=0; $i<sizeof($fp); $i++) { 
				  $line = trim($fp[$i]); 

				  $arr = explode("\t", $line); 
				  #if your data is comma separated
				  # instead of tab separated, 
				  # change the '\t' above to ',' 
				 # first get a mysql connection as per the FAQ

				// Connects to the dba
				$hostname_mydba = "localhost";
				$database_mydba = "ResultsDB";
				$username_mydba = "root";
				$password_mydba = "****";
				$mydba = mysql_connect($hostname_mydba, $username_mydba, $password_mydba) or trigger_error(mysql_error(),E_USER_ERROR); 
				mysql_select_db($database_mydba);


				$query = "INSERT INTO 2004Scores (Bib, firstName, lastName, Address, City, State, Zip, Email, FinTimeOfDay ) ".
				"VALUES ('".  implode("','", $arr) ."')"; 
				fclose($fp);
				}
				mysql_query($query) or die('Error, query failed'); 
				include 'library/closedb.php';

				echo "<br>File $fileName uploaded<br>";

				} 
			?>
			<form method="post" enctype="multipart/form-data">
			<table width="350" border="0" cellpadding="1" cellspacing="1" class="box">
			<tr> 
			<td width="246">
			<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
			<input name="userfile" type="file" id="userfile"> 
			</td>
			<td width="80"><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
			</tr>
			</table>
			</form>

[devinemke]

what does [man]mysql_error[/man] have to say?

[natman3]

thanks but that did not offer much aid. I am attempting to use the browse to get a file and then before placing it anywhere I want to parse it and put it into a table. I am trying to get the script to work, but am having trouble. I am working off this scripts example but instead of grabing a file off the server i want to grab it and parse it before hand.

I am just not sure on how to use the

$fcontents = isset($POST['upload']) && $FILES['userfile']['size'] > 0)

				$fileName = $_FILES['userfile']['name'];
				$tmpName  = $_FILES['userfile']['tmp_name'];

<?

first get a mysql connection as per the FAQ

$fcontents = file ('./spreadsheet.xls');

expects the csv file to be in the same dir as this script

for($i=0; $i<sizeof($fcontents); $i++) {
$line = trim($fcontents[$i]);
$arr = explode("\t", $line);
#if your data is comma separated

instead of tab separated,

change the '\t' above to ','

  $sql = "insert into TABLENAME values ('". 
              implode("','", $arr) ."')"; 
  mysql_query($sql);
  echo $sql ."<br>\n";
  if(mysql_error()) {
     echo mysql_error() ."<br>\n";
  } 

}
?>

here is what i have writen -------------------------------

<?

first get a mysql connection as per the FAQ

			 if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0) 
			 {
				$fileName = $_FILES['userfile']['name'];
				$fcontents  = $_FILES['userfile']['tmp_name'];
			  # expects the csv file to be in the same dir as this script

				$fp      = fopen($fcontents, 'r');
				$content = fread($fp, filesize($tmpName));

				  for($i=0; $i<sizeof($fp); $i++) 
				  { 
					  $line = trim($fp[$i]); 
					  $arr = explode("\t", $line); 
					  #if your data is comma separated
					  # instead of tab separated, 
					  # change the '\t' above to ',' 

					  // Connects to the dba
					$hostname_mydba = "localhost";
					$database_mydba = "ResultsDB";
					$username_mydba = "root";
					$password_mydba = "pass";
					$mydba = mysql_connect($hostname_mydba, $username_mydba, $password_mydba) or trigger_error(mysql_error(),E_USER_ERROR); 
					mysql_select_db($database_mydba);


					$query = "INSERT INTO 2004Scores (Bib, firstName, lastName, Address, City, State, Zip, Email, FinTimeOfDay ) ".
					"VALUES ('".  implode("','", $arr) ."')"; 

					mysql_query($query) or die('Error, query failed'); 
					mysql_close($mydba);

					echo "<br>File $fileName uploaded<br>";
					}
			}
			?>

[devinemke]

Originally posted by natman3
thanks but that did not offer much aid.

meaning what? what is the exact error that mySQL is returning?

[natman3]

Column count doesn't match value count at row 1

[devinemke]

Originally posted by natman3
Column count doesn't match value count at row 1

which means that you are feeding too many or too few values to your query. your query has 9 fields specified so there must then be 9 values.

[sct1061]

Looks like whatever you're getting from the spreadsheet doesn't have the same number of values as the fields in the database that you're trying to insert.

$query = "INSERT INTO 2004Scores (Bib, firstName, lastName, Address, City, State, Zip, Email, FinTimeOfDay ) ". "VALUES ('". implode("','", $arr) ."')"; 

If you're getting an error that 'Column count doesn't match value count at row 1' for the above query, then you need to determine the contents of $arr and make sure it has the same number of values as the column names in the Insert statement.