Show sourcecode
The following files exists in this folder. Click to view.
webbsrvprg/projects/slutprojekt/class/
categoryClass.php
recipeClass.php
recipeClass.php
42 lines ASCII Windows (CRLF)
<?php
Class Recipe {
private $dbconn;
public function __construct($dbconn) {
$this->dbconn = $dbconn;
}
public function createRecipe($title, $ingredients, $instructions, $image, $user_id, $categories) {
try {
$sql = "INSERT INTO recipes (title, ingredients, instructions, image, user_id)
VALUES (:title, :ingredients, :instructions, :image, :user_id)";
$stmt = $this->dbconn->prepare($sql);
$stmt->execute([
':title' => $title,
':ingredients' => $ingredients,
':instructions' => $instructions,
':image' => $image,
':user_id' => $user_id
]);
$recipe_id = $this->dbconn->lastInsertId();
foreach ($categories as $category_id) {
$sql = "INSERT INTO recipe_categories (recipe_id, category_id) VALUES (:recipe_id, :category_id)";
$stmt = $this->dbconn->prepare($sql);
$stmt->execute([
':recipe_id' => $recipe_id,
':category_id' => $category_id
]);
}
return true;
} catch (PDOException $e) {
return "Fel vid skapande av recept: " . $e->getMessage();
}
}
}
?>