Uploading CSV to MySQL

[opoohwan]

When I upload the CSV the browser comes back with a blank page on "uploadcsv.php"

the following is the page where you upload the csv from "testcsv"

<?php require_once("includes/session.php"); ?>
<?php include("includes/functions.php"); ?>
<?php require_once("includes/connect.php"); ?>
<form action="process/uploadcsv.php" enctype="multipart/form-data" method="post" style="padding-top: 27px;">
   Choose CSV File:<br /> <input type="file" name="file" value="" /><br />
   <p><input type="submit" name="submit" value="Submit Policy or Procedure" /></p>
</form>
<?php
if (isset($_GET['complete'])) {
echo "upload complete";}
?>

the following my my process page "uploadcsv.php"

<?php require_once("../includes/session.php"); ?>
<?php include("../includes/functions.php"); ?>
<?php require_once("../includes/connect.php"); ?>
<?php $author = $_SESSION['id'];?>
<?php
   define ("FILEREPOSITORY","./");

   if (is_uploaded_file($_FILES['file']['tmp_name'])) {

     $name = test;
     $result = move_uploaded_file($_FILES['file']['tmp_name'], FILEREPOSITORY."../csvtemp/$name.csv");
     if ($result != 1) { echo "no joy";
     } else {//didn't work
		$handle = fopen("../csvtemp/test.csv", "r");

		//loop conent of csv file, using comma as a delemiter
		while (($data = fgetcsv($handle, 1000, ",")) !== false) {
			$times = 1;
			if ($times == 1) {
				$cat1 = $data[0];
				$cat2 = $data[1];
				$cat3 = $data[2];
				$cat4 = $data[3];
				$cat5 = $data[4];
				$cat6 = $data[5];
				$cat7 = $data[6];
				$cat8 = $data[7];
				$times = $times + 1;
				}else{
					$info1 = $data[0];
					$info2 = $data[1];
					$info3 = $data[2];
					$info4 = $data[3];
					$info5 = $data[4];
					$info6 = $data[5];
					$info7 = $data[6];
					$info8 = $data[7]; 
					$times = $times + 1;
					$query = "Insert INTO StoreSales (
					'{$cat1}', '{$cat2}', '{$cat3}', '{$cat4}', '{$cat5}', '{$cat6}', '{$cat7}', '{$cat8}', Author
					) VALUES (
					'{$info1}', '{$info2}', '{$info3}', '{$info4}', '{$info5}', '{$info6}', '{$info7}', '{$info8}', '{$author}' 
					)";	
					if (mysql_query($query, $connection)) {
						//success
						header("Location: ../testcsv.php?complete=yes");
						exit;
						} else {
							//didn't work
							echo "<p>please try again.</p>";
							echo "<p>" . mysql_error() . "</p>";
							}
						}
					}

	}
  			} //endIF
			fclose($handle);
?>

any idea?

[opoohwan]

More info:

The CSV is uploaded to the server so that is not the problem. My assumtion is that the error happens when the data from the CSV file is attempting to update the database. No information is added into the database from this code.

[opoohwan]

Found the error (well one of them). I had to move the $times part of the loop. the correct code looked like this.

<?php require_once("../includes/session.php"); ?>
<?php include("../includes/functions.php"); ?>
<?php require_once("../includes/connect.php"); ?>
<?php $author = $_SESSION['id'];?>
<?php
   define ("FILEREPOSITORY","./");

   if (is_uploaded_file($_FILES['file']['tmp_name'])) {

     $name = test;
     $result = move_uploaded_file($_FILES['file']['tmp_name'], FILEREPOSITORY."../csvtemp/$name.csv");
     if ($result != 1) { echo "no joy";
     } else {//didn't work
		$handle = fopen("../csvtemp/test.csv", "r");
			$times = 1;
		//loop conent of csv file, using comma as a delemiter
		while (($data = fgetcsv($handle, 1000, ",")) !== false) {
			if ($times == 1) {
				$cat1 = $data[0];
				$cat2 = $data[1];
				$cat3 = $data[2];
				$cat4 = $data[3];
				$cat5 = $data[4];
				$cat6 = $data[5];
				$cat7 = $data[6];
				$cat8 = $data[7];
				$times++;
				}else{
					$info1 = $data[0];
					$info2 = $data[1];
					$info3 = $data[2];
					$info4 = $data[3];
					$info5 = $data[4];
					$info6 = $data[5];
					$info7 = $data[6];
					$info8 = $data[7]; 
					$times++;
					$query = "Insert INTO StoreSales (
					`{$cat1}`, `{$cat2}`, `{$cat3}`, `{$cat4}`, `{$cat5}`, `{$cat6}`, `{$cat7}`, `{$cat8}`, `Author`
					) VALUES (
					'{$info1}', '{$info2}', '{$info3}', '{$info4}', '{$info5}', '{$info6}', '{$info7}', '{$info8}', '{$author}' 
					)";	
					if (mysql_query($query, $connection)) {

						} else {
							//didn't work
							echo "<p>please try again.</p>";
							echo "<p>" . mysql_error() . "</p>";
							echo $query;
							}
						}
					}

	}
  			}
			 //endIF
			fclose($handle);
			//success
						header("Location: ../testcsv.php?complete=yes");
						exit;
?>

[Kudose]

Turning on [man]error_reporting[/man] will show you any errors PHP is generating.

You could also be getting a blank page because you have nothing between the conditional braces of a successful query (although I think your page would redirect ... better code formatting maybe?)