fgetcsv()

learnphp1

I am uploading a csv file in the datbase. and i want to show an error message if the columns are more than 5.

I am counting the rows in the below script but it always prints row 1. I have spent lot of time to figure out and google it. all the examples in google looks similar to mine.

Can anyone find any issue with the below script and correct me pls

Thanks in advance


$row=1;
		$error = 'No'; //////////initialise the error flag

	while (($data = fgetcsv($handle, 1000, ",",'"')) !== FALSE) {
		if( count($data) > 5 ){
				//print_r($data);
				$error = 'Yes' ; ///////////set the error flag to yes and break the loop . validation failed
				$errorMess = 'There are more than 5 columns in row # '.$row ;
				break ;
		}
	///////////////insert the data into stagging table if the column ==5///////////////////
	//print_r($data);
	  $sqlLoad = "INSERT INTO  ratecodes_stagging ( 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);
	$row++;
	//echo $i."<br>";
	}//END while fgetcsv

wyattstorch42

Is your $error flag returning 'Yes'? If so, the break statement might be only breaking the if conditional and not the while loop. Maybe I'm wrong--breaks tend to never cooperate for me.

Just as a test, try printing out the error. If it returns 'Yes', then put the rest of the while loop under an else block and change the while statement to read:

while(($data = fgetcsv($handle, 1000, ",", '"')) !== false && $error != 'Yes') {

learnphp1

wyattstorch42;10970387 wrote:
Is your $error flag returning 'Yes'? If so, the break statement might be only breaking the if conditional and not the while loop. Maybe I'm wrong--breaks tend to never cooperate for me.

Just as a test, try printing out the error. If it returns 'Yes', then put the rest of the while loop under an else block and change the while statement to read:
while(($data = fgetcsv($handle, 1000, ",", '"')) !== false && $error != 'Yes') {

Thanks for your help but the problem i am facing is the count of the row. the loops are working fine. The fgetcsv gets the line and loops until the end if the line. my if condition will be true if the count of the row goes more than 5. At that time it should print the number of rows. it is always giving me row #1

wyattstorch42

Oh. So you're saying that it count($data) is always returning 1 instead of 5?

Can we have a preview of the CSV data that you are trying to process?

learnphp1

wyattstorch42;10970394 wrote:
Oh. So you're saying that it count($data) is always returning 1 instead of 5?

Can we have a preview of the CSV data that you are trying to process?

Pls find the data in attachemnent....even if we have 6 columns in row 2. it would bring result as 1

learnphp1

wyattstorch42;10970394 wrote:
Oh. So you're saying that it count($data) is always returning 1 instead of 5?

Can we have a preview of the CSV data that you are trying to process?

Sorry the file now

wyattstorch42

learnphp1;10970395 wrote:
Pls find the data in attachemnent....even if we have 6 columns in row 2. it would bring result as 1

Open the CSV file in a plaintext editor like Notepad. Maybe the application you're using is not using the default delimiters. When I run your code with a CSV file similar to what you have, count($data) returns 5.

learnphp1

wyattstorch42;10970562 wrote:
Open the CSV file in a plaintext editor like Notepad. Maybe the application you're using is not using the default delimiters. When I run your code with a CSV file similar to what you have, count($data) returns 5.

Thanks for your help. but i think i have confused you a little..sorry for my naive language with this.

count($data) gives correct column....but it does not give the correct row where the column increases by 5...

for example if the row 3 has 6 columns. i want to print that the row number 6 has more than 5 columns .....

hope i have explained it correctly

wyattstorch42

learnphp1;10970564 wrote:
Hi

Thanks for your help. but i think i have confused you a little..sorry for my naive language with this.

count($data) gives correct column....but it does not give the correct row where the column increases by 5...

for example if the row 3 has 6 columns. i want to print that the row number 6 has more than 5 columns .....

hope i have explained it correctly

Ooooh. Yes, I entirely misunderstood. Sorry.

Are you positive that the $row++; statement is being executed? Those SQL functions--are they being run? Also, just for debugging purposes, try echoing $row at the bottom of your while() loop to see if it increments.

I admit, you have me dumbfounded. Very simple code, no idea why it doesn't work. I can't replicate the problem on my end....