<?php

function getRecord($pdo, $from, $where ){
  $conn = $pdo;
  try {
    $sql = "SELECT * FROM $from WHERE id = $where";
    $stmt = $conn->prepare($sql);
    $stmt->execute();
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
    $record = $stmt->fetch();
  } catch (PDOException $e) {
    echo "Error in $from: Not Found";
  }
  return $record;
}

function isThisBound($pdo, $where, $item_id, $user_id){
  $conn = $pdo;
  try {
    if($where === "list"){
      $item = "beer_id";
    }else $item = "brewery_id";
    $sql = "SELECT * FROM $where WHERE $item=$item_id AND user_id=$user_id";
    $stmt = $conn->prepare($sql);
    $stmt->execute();
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
    if($stmt->rowCount() == 1)return true;
    else return false;
  } catch (PDOException $e) {
    echo "Error in $where: Not Found";
  }
}

function getRating($pdo, $beer, $user){
  $conn = $pdo;
  try {
    $sql = "SELECT * FROM list WHERE  beer_id = $beer AND user_id = $user";
    $stmt = $conn->prepare($sql);
    $stmt->execute();
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
    $rating = $stmt->fetch();
  } catch (PDOException $e) {
    echo "Error in $from: Not Found";
  }
  return $rating;
}