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