recipe.class.php - latest

<?php

class Recipe{
  protected $Conn;

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

  public function addRecipe($data){

    $query = "INSERT INTO recipes(cat_id,user_id,recipe_name,recipe_image,recipe_instructions) VALUES (:cat_id,:user_id,:recipe_name,:recipe_image,:recipe_instructions)";
    $stmt = $this->Conn->prepare($query);
    $data['user_id'] = $_SESSION['user_data']['user_id'];
    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();
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
  }

}