function update_price($price, $card_name, $set_name, $foil = FALSE)
{
global $db;
$set_id = get_set_by_name($set_name);
if ($foil) {
$query = 'UPDATE cards SET price_foil = :price , price_date = UTC_DATE() WHERE card_name = :card_name AND set_id = :set_id';
} else {
$query = 'UPDATE cards SET price = :price WHERE card_name = :card_name AND set_id = :set_id';
}
$statement = $db->prepare($query);
$statement->bindValue(':price', $price);
$statement->bindValue(':card_name', $card_name);
$statement->bindValue(':set_id', $set_id);
try {
$statement->execute();
//echo 'Price Updated';
return true;
} catch (PDOException $ex) {
//echo $ex;
//echo 'Price Update Failed';
return false;
}
}
$setname = filter_input(INPUT_GET, 'setname', FILTER_SANITIZE_STRING);
if ($cardname == null && $setname == null) {
//error
echo 'Invalid Card Data';
} elseif ($cardname == null && $setname != null) {
//domainaddress/json?action=carddata&setname=setnamehere
$set_id = get_set_by_name($setname);
$cards = get_cards_by_set_id($set_id);
$jsonCards = json_encode($cards, JSON_UNESCAPED_UNICODE);
echo $jsonCards;
} elseif ($cardname != null && $setname == null) {
//domainaddress/json?action=carddata&cardname=cardnamehere
$cards = get_cards_by_name($cardname);
$jsonCards = json_encode($cards, JSON_UNESCAPED_UNICODE);
echo $jsonCards;
} elseif ($cardname != null && $setname != null) {
//domainaddress/json?action=carddata&cardname=cardnamehere&setname=setnamehere
$set_id = get_set_by_name($setname);
$card = get_card_details($cardname, $set_id);
$jsonCard = json_encode($card, JSON_UNESCAPED_UNICODE);
echo $jsonCard;
} else {
//error
echo 'Invalid Card Data';
}
break;
default:
$output = '<p>' . 'This is the JSON endpoint for card data stored in the database.<br>' . 'A person should be able to send a request to this endpoint in the following formats<br>' . 'domainaddress/json/?action=carddata&cardname=cardnamehere&setname=setnamehere<br>' . 'this will return json data for a single card<br>' . 'domainaddress/json/?action=carddata&cardname=cardnamehere<br>' . 'this will return json data for a list of cards with the same name<br>' . 'domainaddress/json/?action=carddata&setname=setnamehere<br>' . 'this will return json data for a list of cards from the same set<br>' . 'domainaddress/json/?action=getsets<br>' . 'this will return json data for all sets' . '</p>';
echo $output;
break;
}