note 89675 deleted from function.fgetcsv by danbrown

Note Submitter: jaimthorn at yahoo dot com Reason: integrated ---- Although the previous version worked fine, here's a more versatile version of a function I posted earlier. Space constraints prevent me from sharing ith you how it works... :( define('ON_COLLISION_OVERWRITE', 1); define('ON_COLLISION_SKIP' , 2); define('ON_COLLISION_ABORT' , 3); /** * Reads a CSV file and stores it as a lookup table, implemented as a PHP hash table. * * @param string $csv_file the CSV file to read. * @param string $sep_input the character that is used in the CSV file as field separator. * @param string $sep_index the character that separates the fields used to construct the hash table's index. * @param array $index_by the array containing the columns to index the lookup table by, and the function to pre-process those columns with. * @param integer $on_collision a constant that determines what to do when an index is already in use. * @param integer $rec_len the maximum length of a record in the input file. * @return mixed an error number or the resulting hash table. */ function read_lookup_table_from_csv( $csv_file , $separator_input = ';' , $separator_index = '|' , $index_by = array(0 => '') , $on_collision = ON_COLLISION_ABORT , $rec_len = 1024 ) { $handle = fopen($csv_file, 'r'); if($handle == null || ($data = fgetcsv($handle, $rec_len, $separator_input)) === false) { // Couldn't open/read from CSV file. return -1; } $names = array(); foreach($data as $field) { $names[] = trim($field); } $indexes = array(); foreach($index_by as $index_in => $function) { if(is_int($index_in)) { if($index_in < 0 || $index_in > count($data)) { // Index out of bounds. fclose($handle); return -2; } $index_out = $index_in; } else { // If a column that is used as part of the key to the hash table is supplied // as a name rather than as an integer, then determine that named column's // integer index in the $names array, because the integer index is used, below. $get_index = array_keys($names, $index_in); $index_out = $get_index[0]; if(is_null($index_out)) { // A column name was given (as opposed to an integer index), but the // name was not found in the first row that was read from the CSV file. fclose($handle); return -3; } } $indexes[$index_out] = $function; } if(count($indexes) == 0) { // No columns were supplied to index by. fclose($handle); return -4; } $retval = array(); while(($data = fgetcsv($handle, $rec_len, $separator_input)) !== false) { $index_by = ''; foreach($indexes as $index => $function) { $index_by .= ($function ? $function($data[$index]) : $data[$index]) . $separator_index; } $index_by = substr($index_by, 0, -1); if(isset($retval[$index_by])) { switch($on_collision) { case ON_COLLISION_OVERWRITE : $retval[$index_by] = array_combine($names, $data); case ON_COLLISION_SKIP : break; case ON_COLLISION_ABORT : return -5; } } else { $retval[$index_by] = array_combine($names, $data); } } fclose($handle); return $retval; }