Counting CSV Fields

chrislive

I am creating a CSV Import for an application and basically want to be able to upload any CSV file, select the tables and fields to insert to and then click go.

I have most of this working (quite basic flow but it does the job)

one thing I got lost on though was this.

I want to upload ANY csv and to loop through the fields (seperated by say pipe) but I want to be able to count how many fields are in the flat file.

I know about explode using something like this

		foreach($data as $key=>$element) {
		    $element = trim($element);
		    $pieces = explode("|", $element);
		    $field0 = $pieces[0];
		    $field1 = $pieces[1];
		    $field2 = $pieces[2];
}

but how do i count how many $pieces[#] there are??

leatherback

Hi Chris,

Have a look at a script I posted in database: Need script to upload csv to mysql db

THere is a script that will get your CSV into an array, and will count the number of lines.

If ytou need the number of values in a line, you could take the file-array, for the first line, and use :

$file[0]array_count_values

kburger

fgetcsv() might help.

chrislive

I looked into array_count_values and could not get it working very well (im still a learning developer really)

but this is the script I came up with.. long winded I know 🙁


$data = "$element";

$result = count_chars($data, 0);

for ($i=0; $i < count($result); $i++) {
   if ($result[$i] != 0)
   if (chr($i) == "$seperator"){
           $file_fields = $result[$i];
   }
}

a better idea from anyone?