note 86251 added to function.fgetcsv

Here's something I put together this morning. It allows you to read rows from your CSV and get values based on the name of the column. This works great when your header columns are not always in the same order; like when you're processing many feeds from different customers. Also makes for cleaner, easier to manage code.

So if your feed looks like this:

product_id,category_name,price,brand_name, sku_isbn_upc,image_url,landing_url,title,description
123,Test Category,12.50,No Brand,0,http://www.paperpear.com, http://www.paperpear.com/landing.php, Some Title,Some Description

You can do:
<?php
while ($o->getNext())
{
   $dPrice = $o->getPrice();
   $nProductID = $o->getProductID();
   $sBrandName = $o->getBrandName();
}
?>

If you have any questions or comments regarding this class, they can be directed to [email protected] as I probably won't be checking back here.

<?php
	define('C_PPCSV_HEADER_RAW',		0);
	define('C_PPCSV_HEADER_NICE',		1);
	
	class PaperPear_CSVParser
	{
		private $m_saHeader = array();
		private $m_sFileName = '';
		private $m_fp = false;
		private $m_naHeaderMap = array();
		private $m_saValues = array();
		
		function __construct($sFileName)
		{
			//quick and dirty opening and processing.. you may wish to clean this up
			if ($this->m_fp = fopen($sFileName, 'r'))
			{
				$this->processHeader();
			}
		}
	
  		function __call($sMethodName, $saArgs)
		{
			//check to see if this is a set() or get() request, and extract the name
			if (preg_match("/[sg]et(.*)/", $sMethodName, $saFound))
    		{
    			//convert the name portion of the [gs]et to uppercase for header checking
    			$sName = strtoupper($saFound[1]);
    			
    			//see if the entry exists in our named header-> index mapping
      			if (array_key_exists($sName, $this->m_naHeaderMap))
      			{
      				//it does.. so consult the header map for which index this header controls
      				$nIndex = $this->m_naHeaderMap[$sName];
      				if ($sMethodName{0} == 'g')
      				{
      					//return the value stored in the index associated with this name
      				   	return $this->m_saValues[$nIndex];
      				}
      				else
      				{
      					//set the valuw
      					$this->m_saValues[$nIndex] = $saArgs[0];
      					return true;
      				}
      			}
    		}
    		
    		//nothing we control so bail out with a false
      		return false;
  		}		
  		
  		//get a nicely formatted header name. This will take product_id and make
  		//it PRODUCTID in the header map. So now you won't need to worry about whether you need
  		//to do a getProductID, or getproductid, or getProductId.. all will work.
		public static function GetNiceHeaderName($sName)
		{
			return strtoupper(preg_replace('/[^A-Za-z0-9]/', '', $sName));
		}

		//process the header entry so we can map our named header fields to a numerical index, which
		//we'll use when we use fgetcsv().
		private function processHeader()
		{
			$sLine = fgets($this->m_fp);
                        //you'll want to make this configurable
			$saFields = split(",", $sLine);
			
			$nIndex = 0;
			foreach ($saFields as $sField)
			{
				//get the nice name to use for "get" and "set".
				$sField = trim($sField);
				
				$sNiceName = PaperPear_CSVParser::GetNiceHeaderName($sField);
				
				//track correlation of raw -> nice name so we don't have to do on-the-fly nice name checks
				$this->m_saHeader[$nIndex] = array(C_PPCSV_HEADER_RAW => $sField, C_PPCSV_HEADER_NICE => $sNiceName);
				$this->m_naHeaderMap[$sNiceName] = $nIndex;
				$nIndex++;
			}
		}
		
		//read the next CSV entry
		public function getNext()
		{
			//this is a basic read, you will likely want to change this to accomodate what
			//you are using for CSV parameters (tabs, encapsulation, etc).
			if (($saValues = fgetcsv($this->m_fp)) !== false)
			{
				$this->m_saValues = $saValues;
				return true;
			}
			return false;
		}
	}
	
	
	//quick example of usage
	$o = new PaperPear_CSVParser('F:\foo.csv');
	while ($o->getNext())
	{
		echo "Price=" . $o->getPrice() . "\r\n";
	}
	
?>
----
Server IP: 209.41.74.194
Probable Submitter: 76.28.182.137
----
Manual Page -- http://www.php.net/manual/en/function.fgetcsv.php
Edit        -- https://master.php.net/note/edit/86251
Del: integrated  -- https://master.php.net/note/delete/86251/integrated
Del: useless     -- https://master.php.net/note/delete/86251/useless
Del: bad code    -- https://master.php.net/note/delete/86251/bad+code
Del: spam        -- https://master.php.net/note/delete/86251/spam
Del: non-english -- https://master.php.net/note/delete/86251/non-english
Del: in docs     -- https://master.php.net/note/delete/86251/in+docs
Del: other reasons-- https://master.php.net/note/delete/86251
Reject      -- https://master.php.net/note/reject/86251
Search      -- https://master.php.net/manage/user-notes.php