include 'db-credentials.php';
$loggedName = "";
if (isset($_SESSION['loggedin'])) {
$loggedName = $_SESSION['username'];
}
//connect to db
$conn = connectToDb($servername, $username, $password, $dbname);
//get recipe id
$recipeId = $_GET['recipe_id'];
//get recipe name
$recipeName = getRecipeNameFromDB($conn, $recipeId);
if ($recipeName == '') {
header('Location: fail.php');
}
//get pic name
$photoNamePrev = getImageNameFromDB($conn, $recipeId);
//get number of ingredients
$numberIngredients = getNumberOfIngredientsFromDB($conn, $recipeId);
//get each ingredient - format: ingredient1, ingredient2, ingredient3...
$ingredientList = getAllIngredientsFromDB($conn, $recipeId);
//get number of steps
$numberSteps = getNumberOfStepsFromDB($conn, $recipeId);
$stepList = getAllStepsFromDB($conn, $recipeId);
//get tags
$numberTags = getNumberOfTagsFromDB($conn, $recipeId);
$tagList = getAllTagsFromDB($conn, $recipeId);
//get flag count
$flagCount = getFlagCount($conn, $recipeId);
//get rating
$rating = getRecipeRating($conn, $recipeId);
$ratingCount = getRecipeRating($conn, $recipeId);
$recipeName = getRecipeName($conn);
$allSteps = getAllSteps($conn);
$privacy = getPrivacy();
updateRecipe($conn, $recipeName, $author, $allSteps, $privacy, $recipeId);
//fixFlag($conn, $oldRecipeId);
//if error in inserting recipe into db
if ($recipeId < 0) {
exit("Sorry, could not access database when adding recipe. Please try again.");
}
$photoPath = NULL;
//check if image uploaded here
if (checkImageUploaded()) {
$photo = getImageTmpName();
$photoPath = getImagePath($recipeId);
if (is_dir("images/" . $recipeId)) {
$imagePth = getImageNameFromDB($conn, $recipeId);
unlink($imagePth);
rmdir("images/" . $recipeId);
}
if (!mkdir("images/" . $recipeId, 0777, true)) {
exit('Could not upload image to server.');
}
if (!move_uploaded_file($photo, "images/" . $photoPath)) {
exit('Could not create space on server for image.');
}
if (!updateImagePathInDB($conn, "images/" . $photoPath, $recipeId)) {
exit('Could not connect image to account.');
}
}
$numFriends = countFriends();
$success = addFriendsToDB($conn, $numFriends, $recipeId);
