如何通过curl get从php中的api将json数据存储到数据库中？

Question

the code is as below...

$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;

This is the actual code,,, i need to get the json data and store it in the database.

Answer 1

Use below code

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

then your SQL insert functionality , go through this link http://www.kodingmadesimple.com/2014/12/how-to-insert-json-data-into-mysql-php.html