csv-to-json.php

class csvToJson{

  var $feed = "";

  function csvToJson($feed=""){
    $this->feed = $feed;
  }
  
  function setFeed($feed){
    $this->feed = $feed;
  }

  function process(){
    // Arrays we'll use later
    $keys = array();
    $newArray = array();

    // Do it
    $data = $this->csvToArray($this->feed, ',');

    // Set number of elements (minus 1 because we shift off the first row)
    $count = count($data) - 1;

    //Use first row for names
    $labels = array_shift($data);

    foreach ($labels as $label) {
      $keys[] = $label;
    }

    // Add Ids, just in case we want them later
    $keys[] = 'id';

    for ($i = 0; $i < $count; $i++) {
      $data[$i][] = $i;
    }

    // Bring it all together
    for ($j = 0; $j < $count; $j++) {
      $d = array_combine($keys, $data[$j]);
      $newArray[$j] = $d;
    }

    return json_encode($newArray);
  }


  function get(){
    $json = $this->process();
    return $json;
  }

  // Print it out as JSON
  function show(){
    $json = $this->get();
    header('Content-type: application/json');
    echo $json;
  }


  // Function to convert CSV into associative array
  function csvToArray($file, $delimiter) {
    if (($handle = fopen($file, 'r')) !== FALSE) {
      $i = 0;
      while (($lineArray = fgetcsv($handle, 4000, $delimiter, '"')) !== FALSE) {
        for ($j = 0; $j < count($lineArray); $j++) {
          $arr[$i][$j] = $lineArray[$j];
        }
        $i++;
      }
      fclose($handle);
    }
    return $arr;
  }
}

sample.csv

sample.php

<?php
include_once("./csvtojson.php");

// Set your CSV feed
$feed = "./sample.csv";
// $feed = 'https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Akse3y5kCOR8dEh6cWRYWDVlWmN0TEdfRkZ3dkkzdGc&single=true&gid=0&output=csv';

$f = new csvToJson($feed);
$f->show();