通过URL解析API CSV

Parse API CSV via URL

本文关键字：CSV API 解析 URL 通过      更新时间：2023-09-26

我需要处理API数据的建议。我想知道用下面的URL格式解析csv文件的最佳方法是什么。

URL: URL…com api . ./. ./. . csv/abc . . 1234 apikey = . . 123456

我想处理结果并将值插入数据库。

数据会随时间变化，所以实现需要是动态的。

数据格式如下:

"position","player.href","name.text","total","letter","days","hits","index","url"
"1","javascript:void(0);","Jamie","1","url"
"T2","javascript:void(0);","Tom","3","A","1","68","url"
"T2","javascript:void(0);","Sam","3","A","2","8","27","3","url"
"T2","javascript:void(0);","Joe","3","A","3","7","27","4","url"
"5","javascript:void(0);","Pat","2","A","4","7","28","5","url"
"T6","javascript:void(0);","Sean","1","A","5","6","29","6","url"

编辑-我不知道你不知道如何从API中提取数据。我将使用file_get_contents()或CURL来查询URL。通常

file_get_contents("URL: URL…com../..api/..csv/..1234apikey=..123456ABC");

我将通过分割"'n"来循环数据，然后将其分割为"，"。在foreach中，你可以将它放入MySQL表或任何你想做的事情。

<?php
$data = "your api data";
$splitlines = explode("'n",$data);
foreach($splitlines as $line)
{
	$linedata = explode(',',$line);
	$position = $linedata[0];
	$player = $linedata[1];
	... etc.
}

相关文章：