Проблема с json или google spreadsheet ...

fawkes

Новичок
Выгружаю данные с google spreadsheet, вернется csv, который преобразуется в массив php:
PHP:
    $feed = 'https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Asdu6mIw5FxldG83TWdDaUVOczFOQlVvRzFOampZMXc&single=true&gid=0&output=csv';


            $keys = array();
            $newArray = 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;
            }

         $data = csvToArray($feed, ',');
        echo '<pre>';
        print_r($data);
Отображаю в табличном виде, например в jQuery плагине handsontable.com
У массива структура такова:
PHP:
Array
(
    [0] => Array
        (
            [0] => 
            [1] => value 1 - 2
            [2] => 
            [3] => 
            [4] => 
        )

    [1] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => value 2 - 5
        )

    [2] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => 
        )

    [3] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => 
        )

    [4] => Array
        (
            [0] => 
            [1] => 
            [2] => value 5 - 5
            [3] => 
            [4] => 
        )
номер строки => номера столбцов и значения.
после json_encode($arr)
PHP:
[["","value 1 - 2","","",""],["","","","","value 2 - 5"],["","","","",""],["","","","",""],["","","value 5 - 5","",""],["","","","",""],["","","","",""],["value 8 - 1","","value 8 - 2","",""],["","","","","value1"],["","value 10 - 2","","",""],["","","value 11 - 3","",""],["","","","",""],["","","","",""],["","","","",""],["","","","","value 15 - 5"],["","","value 16 - 3","",""],["value 17 - 1","value 17 - 2","value 17 - 3","",""],["","","","value 18 - 4",""],["","","","",""],["value 20 - 1","","","",""]]
Все замечательно отображается в плагине!
Но если я заменю $feed, на другой файл:
PHP:
 $feed = 'https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=0Asdu6mIw5FxldGNKR0gxNlVhaVY2SF9zYm5NcW85V3c&single=true&gid=0&output=csv';
ссылка на документ
тогда вот такой json!
PHP:
[["","","","","","","","","","","","","","","","","","","",""],["\u0437\u0430 3 \u0441\u0435\u043c\u0435\u0441\u0442\u0440","","","","","","","","","","","","","","","","","","",""],["\u041a\u0443\u0440\u0441 2","","\u0413\u0440\u0443\u043f\u043f\u0430 \u041f-219","","","","","","","","","","","","","2012 \/ 2013 \u0443\u0447\u0435\u0431\u043d\u044b\u0439 \u0433\u043e\u0434","","","",""],["","","","","","","","","","","","","","","","","","","",""],["\u2116 \u043f\/\u043f","\u0424.\u0418.\u041e. \u0441\u0442\u0443\u0434\u0435\u043d\u0442\u0430","\u041d\u0430\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0438\u0435 \u0434\u0438\u0441\u0446\u0438\u043f\u043b\u0438\u043d","","","","","","","","","\u041f\u043e\u0441\u0435\u0449\u0430\u0435\u043c\u043e\u0441\u0442\u044c ","","","","\u0418\u043c\u0435\u044e\u0449\u0438\u0435\u0441\u044f \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0430\u0442\u0438\u0432\u043d\u044b\u0435 \u0432\u0437\u044b\u0441\u043a\u0430\u043d\u0438\u044f","\u041a\u043e\u044d\u0444\u0444\u0438\u0446\u0438\u0435\u043d\u0442 \u0441\u0442\u0438\u043f\u0435\u043d\u0434\u0438\u0438","","\u041f\u0440\u0438\u043c\u0435\u0447\u0430\u043d\u0438\u044f","\u0420\u0435\u0448\u0435\u043d\u0438\u0435 \u0430\u0442\u0442\u0435\u0441\u0442\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u043a\u043e\u043c\u0438\u0441\u0441\u0438\u0438"]
Хотя массив верен и такой-же!
PHP:
Array
(
    [0] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => 
            [5] => 
            [6] => 
            [7] => 
            [8] => 
            [9] => 
            [10] => 
            [11] => 
            [12] => 
            [13] => 
            [14] => 
            [15] => 
            [16] => 
            [17] => 
            [18] => 
            [19] => 
        )

    [1] => Array
        (
            [0] => за 3 семестр
            [1] => 
            [2] => 
            [3] => 
            [4] => 
            [5] => 
            [6] => 
            [7] => 
            [8] => 
            [9] => 
            [10] => 
            [11] => 
            [12] => 
            [13] => 
            [14] => 
            [15] => 
            [16] => 
            [17] => 
            [18] => 
            [19] => 
        )

    [2] => Array
        (
            [0] => Курс 2
            [1] => 
            [2] => Группа П-219
            [3] => 
            [4] => 
            [5] => 
            [6] => 
            [7] => 
            [8] => 
            [9] => 
            [10] => 
            [11] => 
            [12] => 
            [13] => 
            [14] => 
            [15] => 2012 / 2013 учебный год
            [16] => 
            [17] => 
            [18] => 
            [19] => 
        )

    [3] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => 
            [5] => 
            [6] => 
            [7] => 
            [8] => 
            [9] => 
            [10] => 
            [11] => 
            [12] => 
            [13] => 
            [14] => 
            [15] => 
            [16] => 
            [17] => 
            [18] => 
            [19] => 
        )

    [4] => Array
        (
            [0] => № п/п
            [1] => Ф.И.О. студента
            [2] => Наименование дисциплин
            [3] => 
            [4] => 
            [5] => 
            [6] => 
            [7] => 
            [8] => 
            [9] => 
            [10] => 
            [11] => Посещаемость  
            [12] => 
            [13] => 
            [14] => 
            [15] => Имеющиеся административные взыскания
            [16] => Коэффициент стипендии
            [17] => 
            [18] => Примечания
            [19] => Решение аттестационной комиссии
        )

    [5] => Array
        (
            [0] => 
            [1] => 
            [2] => Элементы высшей математики
            [3] => Операционные системы
            [4] => Основы программирования
            [5] => История
            [6] => Технические средства информатизации
            [7] => Речь и культура делового общения
            [8] => Иностранный язык
            [9] => Физическая культура
            [10] => Архитектура компьютерных систем
            [11] => ВСЕГО пропущено
            [12] => по уважительной причине 
            [13] => по неуважительной причине 
            [14] => Опоздания
            [15] => 
            [16] => 
            [17] => 
            [18] => 
            [19] => 
        )

    [6] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => 
            [5] => 
            [6] => 
            [7] => 
            [8] => 
            [9] => 
            [10] => 
            [11] => 
            [12] => 
            [13] => 
            [14] => 
            [15] => 
            [16] => Социальная
            [17] => Академическая
            [18] => 
            [19] => 
        )

    [7] => Array
        (
            [0] => 1
            [1] => Абеляшев П.С.
            [2] => 
            [3] => 
            [4] => 4
            [5] => 
            [6] => 
            [7] => 5
            [8] => 
            [9] => 
            [10] => 
            [11] => 
            [12] => 
            [13] => 
            [14] => 
            [15] => 
            [16] => 
            [17] => 
            [18] => 
            [19] => 
        )
//и так далее
что я делаю не так?
 

fawkes

Новичок
Это проблема с кодировкой? А какая тогда там кодировка, чтобы мне ее преобразовать в utf8?
Ведь функции определения кодировки в пхп написаны плохо и этому есть подтверждение на хабре.
 

fawkes

Новичок
Вопрос исчерпан, все работает )
токо криво отображается
 
Сверху