Processing CSV file for web projects is very usefull to show CSV Upload list, Upload data to database table, processing bulk posting etc., Here is the function to process CSV file, using this function we can convert our CSV file to PHP Mufti dimensional Array, str_getcsv() is not supported under version 5. so let we start create our own CSV to Array Function

# Desc: Function to Make PHP Array from CSV file data # Parm: $csv_path,$header_row,$preserve_keys (usefull for Database Insert) # Return: Array $output['header'], output['data']; function csv_to_array($csv_file,$preserve_keys=FALSE,$header_row=TRUE) { $fp=fopen($csv_file,"r",true); while (!feof($fp)) { $data[]=explode(",",fgets($fp, 1024)); } // Get Field Header and Unset field row from data if($header_row){ // Preserve Keys or Make array Keyas as Numberic if($preserve_keys) { foreach($data[0] as $head){javascript:void(0) $head=trim(($head)); $output['header'][$head]=ucwords($head); } }else { foreach($data[0] as $head){ $head=trim(($head)); $output['header'][]=ucwords($head); } } unset($data[0]); } // Push data into data key; $output['data']=$data; //Return array output return $output; }
![]() | Live Demo | Download Script |
Thanks for this information.Its very simple to understand.just you can see the reference for php
ReplyDelete