Tuesday, August 4, 2009

how to read a csv file in php 5

php provides fgetcsv(resource handle[,int length[,string delimiter[,string enclosure[,string escape]]]]) functions. the length is the number of character that will be read in one line, delimiter will be the end character in a line, enclosure will wrap a field, escape string will esacape double quotes.

it will return an array containing datas of the csv file.
following a source code to parse a csv file.

$row = 1;
$filename="keywords.csv";
if(pathinfo($filename,PATHINFO_EXTENSION)=="csv")
{
$handle = fopen($filename, "r");
echo "table cellpadding='3' cellspacing='3'";
while (($data = fgetcsv($handle)) !== FALSE) {
$num = count($data);
$row++;
echo "tr";
for ($c=0; $c < $num; $c++) {
echo "td".$data[$c]."/td";
}
echo "/tr";
}
echo "/table";
fclose($handle);
}
See the book OpenCart 1.4 Template Design Cookbook.
See the book Joomla Mobile Development Beginners Guide




List of my works:

Opencart Extensions:

  1. Product Based Quantity Wise Shipping: Find it here.
  2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
  3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
  4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
  5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
  6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

  1. OpenCart 1.4 Template Design Cookbook.
  2. Joomla Mobile Development Beginners Guide

No comments: