I have modified an old file I had to read a .csv file and output just a few bits of data from the original, including some maths with prices. However, I get an error of:
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in public_html/imports/change_prices.php on line 70
Here's my script. Line 70 is:
if($matrix_band_pricing_flag != 'N') {
<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
echo "Starting"."\n";
// Load file
$handle = fopen('spicerf2.csv', "r");
// Set csv column headers
$output = "store,websites,sku,price,rrp\n";
$i=0;
// Is there data?
while($data = fgetcsv($handle, 1000, ","))
{
if($i!=0) {
// Set the variables
$sku = $data[0];
$price = $data[10];
$rrp = $data[9];
$martix_band_pricing_flag = $data[31];
// Convert trade and rrp prices to pence
$price = $price / 100;
$rrp = $rrp / 100;
// Update sales price depending upon Matrix Band Price Flag
switch($matrix_band_pricing_flag) {
case 'A' : $percent = 0.70;
break;
case 'B' : $percent = 0.70;
break;
case 'C' : $percent = 0.75;
break;
case 'D' : $percent = 0.85;
break;
case 'E' : $percent = 0.88;
break;
case 'F' : $percent = 0.60;
break;
case 'G' : $percent = 0.75;
break;
case 'H' : $percent = 0.75;
break;
case 'N' : $percent = 0.70;
break;
}
$price = $price / $percent;
$price = number_format($price, 2, '.', '');
// Display data as file runs
echo $data[0].' - '.$sku.' - '.$price.' - '.$rrp.';
echo "\n";
// Output result to csv file
if($matrix_band_pricing_flag != 'N') {
$output .= 'admin,base,"'.$sku.'","'.$price.'","'.$rrp.'"';
$output .= "\n";
}
unset($rrp);
unset($price);
unset($matrix_band_price_flag);
}
++$i;
}
file_put_contents('./update_sell_price.csv', $output);
mysql_close($conn);
echo "\n"."Done";
I just can't suss it...
