recipe.class.php

<?php

class Recipe{
  protected $Conn;

  public function __construct($Conn){
    $this->Conn = $Conn;
  }

  public function addRecipe($data){

    $query = "INSERT INTO recipes (recipe_name, recipe_image, recipe_instructions, cat_id, user_id) VALUES (:recipe_name, :recipe_image, :recipe_instructions, :cat_id, :user_id)";
    $stmt = $this->Conn->prepare($query);

    $data['user_id'] = $_SESSION['user_data']['user_id'];
    $data['recipe_image'] = $_FILES['recipe_image']['tmp_name'];

    return $stmt->execute($data);
  }

  public function getRecipesForCat($cat_id) {

    $query = "SELECT * FROM recipes WHERE cat_id = :cat_id";
    $stmt = $this->Conn->prepare($query);
    $stmt->execute(array(':cat_id'=>$cat_id));
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
  }

  public function getRecipesForUser($user_id){

    $query = "SELECT recipe_id, recipe_name, recipe_instructions FROM recipes WHERE user_id = :user_id";
    $stmt = $this->Conn->prepare($query);
    $stmt->execute(array(':user_id'=>$user_id));
    return $stmt->fetchAll(PDO::FETCH_ASSOC);

  }

}