recipes.php

<?php
    session_start();
    include('static/header.php');
    include 'dbConVars.php';
    

    if(!isset($_SESSION['valid_user'])){
		echo "<h2>Please login first before continuing</h2>";
	}else{

		echo '<div class="container">
			<h3>Add Recipe</h3>
			<div>
				<form id="recipe_form" action="addRecipe.php" method="POST">
					<input type="text" name="recipe_name" placeholder="Recipe Name">
					<input type="text" name="recipe_des" placeholder="Description">
					<input type="text" name="recipe_link" placeholder="Link to Recipe">
					<input type="submit" value="Add Recipe">
				</form>
			</div>
			</br>';

			$conn = mysqli_connect($DB_HOST, $DB_USER, $DB_PASSWORD, $DB_NAME);
			if(!$conn){
				die("Database connection failure");
			}

			$query = "SELECT * FROM food_recipes";
			$result = mysqli_query($conn, $query);
			
			echo "<table class='table table-striped'>
						<thead>
							<tr>
								<th>Name</th>
								<th>Description</th>
								<th>Link to Recipe</th>
								<th>Add to List</th>
								<th>Add Ingredients</th>
							</tr>
						</thead>
						<tbody>";

			while($row = mysqli_fetch_array($result)){
				$exists = false;
				$recipeID = $row['id'];

				//check if recipe is already added to users profile
				$checkQuery = 'SELECT * FROM food_user_recipes WHERE r_id="'. $recipeID .'" AND u_id=(SELECT fu.id FROM food_users fu WHERE username="'. $_SESSION['valid_user'] . '")';
				$checkResult = mysqli_query($conn, $checkQuery);
			
				//if more than one, then already exists in users saved list
				if(mysqli_num_rows($checkResult) > 0){ 
					$exists = true;
				}


				echo "<tr>
						<td>" . $row['name'] . "</td>
						<td>" . $row['description'] . "</td>
						<td><a href='" . $row['recipes_link'] . "'>Link</a></td>
						<td>
							<form action='userLinkRecipe.php' method='POST'>
								<input type='hidden' name='recipe_id' value='" . $recipeID . "'>";

				if($exists){
					echo "<input type='submit' value='Add' disabled>";
				}else{
					echo "<input type='submit' value='Add'>";
				}
			
				echo	"</form></td>";

				echo "<td>";
				echo "<form action='linkIngredients.php' method='POST'>";
				echo "<input type='hidden' name='recipe_id' value='" . $recipeID ."'>";
				echo "<input type='hidden' name='recipe_name' value='" . $row['name'] ."'>";
				echo "<input type='submit' value='Update Ingredients'>";
				echo "</form>";
				echo "</td>";

				echo "</tr>";

			  	mysqli_free_result($checkResult);
			}
			?>

			</tbody>
			</table>
			</div>
		<?php

		mysqli_free_result($result);
		mysqli_close($conn);

	}

	include("static/footer.php"); 
?>