<?php

// fetch cards from API
$request = curl_init();

curl_setopt($request, CURLOPT_URL, "https://omgvamp-hearthstone-v1.p.mashape.com/cards");
curl_setopt($request, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($request, CURLOPT_HTTPHEADER, array(
    'X-Mashape-Key: vP9aUIq3qjmshvSbCqqor958lCYtp1cA2GejsnLRVlMTPVCL73'
));
$response = curl_exec($request);
curl_close($request);

// $data holds card data in array
$data = json_decode($response, true);

// SQL stuff
$servername = 'localhost';
$dbname = 'hearthstone';
$username = 'root';
$password = '';
$dbh = new PDO("mysql: host=$servername; dbname=$dbname", $username, $password);

// Prepare a statement to insert a card
$sql = 'INSERT INTO cards (cardId, name, cardSet, type, rarity, cost, playerClass, img) VALUES (:cardId, :name, :cardSet, :type, :rarity, :cost, :playerClass, :img);';
$sth = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));

// Loop through cards and run statement to insert
foreach $data as $card {
    $sth->execute(array(':cardId' => $card['id'], ':name' => $card['name'], ':cardSet' => $card['cardSet'], ':type' => $card['type'], ':rarity' => $card['rarity'], ':cost' => $card['cost'], ':playerClass' => $card['playerClass'], ':img' => $card['img']));
}

?>