如何通过curlget将json数据从php中的api存储到数据库中 - how to store json data into the database from api in php by curl get?

how to store json data into the database from api in php by curl get?

代码如下。。。

$url = 'http://tools.vcommission.com/api/coupons.php?apikey=a7f66abd541c5667ebb8b234f6345df00dbc5dc856d8e7bcd02bb6d636f902fc';
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_TIMEOUT, 5);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$data = curl_exec($ch);
curl_close($ch);
echo $data;

这是实际的代码，，，我需要获取json数据并将其存储在数据库中。

使用以下代码

$data = curl_exec($ch);    
curl_close($ch);   
$json = json_decode($data , true);

然后您的SQL插入功能，通过此链接http://www.kodingmadesimple.com/2014/12/how-to-insert-json-data-into-mysql-php.html