forked from aqibos/CookbookNetwork
/
view-cookbook.php
83 lines (65 loc) · 2.27 KB
/
view-cookbook.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<?php
session_start() ;
include 'recipe-search-handler.php' ;
$cookbook_id = $_GET["cookbook_id"] ;
function printCookbook($cookbook_id)
{
$conn = getConn() ;
$sql = " SELECT cb_title FROM cookbook
WHERE cookbook_id = '$cookbook_id'" ;
$result = $conn -> query($sql) ;
$row = $result -> fetch_assoc() ;
echo '<h1>'.$row["cb_title"].'</h1>' ;
$sql = " SELECT * FROM recipe
WHERE recipe_id in (
SELECT recipe_id FROM recipe_list
WHERE cookbook_id = '$cookbook_id')";
$result = $conn -> query($sql) ;
printResult($result) ;
}
function isOwner($cookbook_id)
{
$conn = getConn() ;
$user_id = $_SESSION['userid'];
$sql= "SELECT user_id FROM Cookbook_list WHERE user_id = '$user_id' AND cookbook_id ='$cookbook_id'";
if ($conn->query($sql) != true) //unsuccessful query
header('Location: fail.php');
$result = $conn -> query($sql);
$row = $result->fetch_assoc();
if(count($row) == 1)
return true;
else
return false;
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="description" content="A virtual cookbook that allows user's to view, create and share recipes.">
<meta name="keywords" content="recipe, cookbook, food, ingredients">
<meta name="author" content="Cookbook Network Inc.">
<link rel="stylesheet" type="text/css" href="page_style.css">
<link href='http://fonts.googleapis.com/css?family=Tangerine:700' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=IM+Fell+Double+Pica' rel='stylesheet' type='text/css'>
</head>
<body>
<img class="background-image" src="images/delicious-pizza-food-1440x900.jpg" height="700"/>
<div class="background-image"></div>
<div class="navigation-bar">
<?php include 'check-menu.php'?>
</div>
<div class="content">
<?php printCookbook( $cookbook_id);?>
<p class="center">
<?php
if (isset($_SESSION['loggedin']) && isOwner($cookbook_id) )
{
echo "<a href='edit-cookbook.php?cookbook_id=$cookbook_id';>Edit Cookbook</a>";
}
?>
</p>
</div>
<div class="footer"><p>© Cookbook Network, 2015. All Rights Reserved.</p></div>
</body>
</html>