fawkes
Новичок
Выгружаю данные с google spreadsheet, вернется csv, который преобразуется в массив php:
Отображаю в табличном виде, например в jQuery плагине handsontable.com
У массива структура такова:
номер строки => номера столбцов и значения.
после json_encode($arr)
Все замечательно отображается в плагине!
Но если я заменю $feed, на другой файл:
ссылка на документ
тогда вот такой json!
Хотя массив верен и такой-же!
что я делаю не так?
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);
У массива структура такова:
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] =>
)
//и так далее