All pastes #556749 Raw Edit

Atrex CSV Parser

public php v1 · immutable
·published 2007-06-10 18:56 UTC
rendered paste body
<?php$csv = fopen("myatrex2.csv", "rb");$rawdata = fread($csv, filesize("myatrex2.csv"));fclose($csv);$splitraw = explode("\n", $rawdata, 2);$inv = $splitraw[1];$i = 0;$j = 0;while ($i < strlen($inv)) {	if (substr($inv, $i, 2) != "\"\"") {		$items[$j]['image'] = substr($inv, $i+1, strpos($inv, "\",", $i+1) - $i);		$i += strlen($items[$j]['image']) + 2;	} else {		$items[$j]['image'] = "";		$i += 3;	}	$items[$j]['sCode'] = substr($inv, $i+1, strpos($inv, "\",", $i+1)-($i+1));	$i += strlen($items[$j]['sCode']) + 3;	$items[$j]['Mfr'] = substr($inv, $i+1, strpos($inv, "\",", $i+1)-($i+1));	$i += strlen($items[$j]['Mfr']) + 3;	$items[$j]['Descr'] = substr($inv, $i+1, strpos($inv, "\",", $i+1)-($i+1));	$i += strlen($items[$j]['Descr']) + 3;	$items[$j]['Category'] = substr($inv, $i+1, strpos($inv, "\",", $i+1)-($i+1));	$i += strlen($items[$j]['Category']) + 3;		$items[$j]['List'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['List']) + 1;	$items[$j]['OnHand'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['OnHand']) + 1;	$items[$j]['Serialized'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['Serialized']) + 1;	$items[$j]['NoDeplete'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['NoDeplete']) + 1;	$items[$j]['OnOrder'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['OnOrder']) + 1;	$items[$j]['Allocated'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['Allocated']) + 1;	$items[$j]['OnRMA'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['OnRMA']) + 1;	$items[$j]['InPreBuilt'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['InPreBuilt']) + 1;		$items[$j]['Notes'] = substr($inv, $i+1, strpos($inv, "\",", $i+1)-($i+1));	$i += strlen($items[$j]['Notes']) + 3;		$items[$j]['HasImage'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['HasImage']) + 1;	$items[$j]['PostToWeb'] = substr($inv, $i, strpos($inv, ",", $i+1)-$i);	$i += strlen($items[$j]['PostToWeb']) + 1;		$items[$j]['Url'] = substr($inv, $i+1, strpos($inv, "\",", $i+1)-($i+1));	$i += strlen($items[$j]['Url']) + 3;	$items[$j]['OnlineName'] = substr($inv, $i+1, strpos($inv, "\",", $i+1)-($i+1));	$i += strlen($items[$j]['OnlineName']) + 3;	$items[$j]['OnlineDescrHTML'] = substr($inv, $i+1, strpos($inv, "\",", $i+1)-($i+1));	$i += strlen($items[$j]['OnlineDescrHTML']) + 3;	$items[$j]['OnlineDescrTEXT'] = substr($inv, $i+1, strpos($inv, "\"\r\n", $i+1)-($i+1));	$i += strlen($items[$j]['OnlineDescrTEXT']) + 4;		/*if ($items[$j]['image'] != "") {		$img = fopen('items/'.$items[$j]['sCode'])*/		$j++;}print_r($items);echo '<table width="100%">	<tr><td>Image</td><td>Stock Code</td><td>Manufacturer</td><td>Description</td><td>Category</td><td>Price</td><td>In Stock</td><td>Name</td><td>Online Description</td></tr>';for ($i = 0; $i < count($items); $i++) {	echo '<tr><td></td><td>'.$items[$i]['sCode'].'</td><td>'.$items[$i]['Mfr'].'</td><td>'.$items[$i]['Descr'].'</td><td>'.$items[$i]['Category'].'</td><td>'.$items[$i]['List'].'</td><td>'.($items[$i]['OnHand'] - $items[$i]['OnOrder'] - $items[$i]['Allocated'] - $items[$i]['OnRMA'] - $items[$i]['InPreBuilt']).'</td><td>'.$items[$i]['OnlineName'].'</td><td>'.$items[$i]['OnlineDescrHTML'].'</td></tr>';}echo "</table>";?>