validation within a csv file

learnphp1

I want to put a validation on a csv file. saying if it exceeds more than 5 columns than dont insert. but i also want to give a message to the user on telling them which row does not pass the validation.

My code is below. but it always gives row#1



 while (($data = fgetcsv($handle, 1000, ",",'"')) !== FALSE) {
		if( count($data) > 5 ){
				$error = 'Yes' ;
				$errorMess = 'There are more than 5 columns in row # '.$i ;
				break ;
		}
		  $sqlLoad = "INSERT INTO  ratecodes_TEST 	  ( package_name,package_table,plan_name,plan_code,package_hierachy  )
					  VALUES ('".addslashes($data[0])."','".addslashes($data[1])."','".addslashes($data[2])."','".addslashes($data[3])."',
					  '".addslashes($data[4])."')";
		  $resultSqlLoad = es_query($sqlLoad);


$i++;
//echo $i;
}//END while fgetcsv

Thanks in Advance

bradgrafelman

Inside that if() statement, do a [man]print_r/man on $data and show us what the output is.

learnphp1

bradgrafelman;10969792 wrote:
Inside that if() statement, do a [man]print_r/man on $data and show us what the output is.

i added the print_r function...but does not print anything


 while (($data = fgetcsv($handle, 1000, ",",'"')) !== FALSE) {
		if( count($data) > 5 ){
				print_r($data);
				$error = 'Yes' ;
				$errorMess = 'There are more than 5 columns in row # '.$i ;
				break ;
		}

bradgrafelman

If nothing at all is printed, then the code in that if() statement isn't being executed.

learnphp1

bradgrafelman;10969803 wrote:
If nothing at all is printed, then the code in that if() statement isn't being executed.

Ok...what i did is i edited the file to make the if condition true and i got the following result

Array ( [0] => Bundled [1] => WB [2] => 'Yes' Light [3] => HU [4] => 20 [5] => ) There are more than 5 columns in row # 1

But th row was not 1st...it was 10th

I want to get the number of correct number of rows