예제 #1
0
<?php

include_once "models/Chef_Table.class.php";
include_once "models/Recipe_Table.class.php";
$chefTable = new Chef_Table($db);
$recipeTable = new Recipe_Table($db);
$isChefClicked = isset($_GET['chef_id']);
$isRecipeClicked = isset($_GET['recipe_id']);
if ($isChefClicked) {
    $chefId = $_GET['chef_id'];
    $chefData = $chefTable->getChef($chefId);
    $recipesByChef = $recipeTable->getAllByChefId($chefId);
    $displayPage = (include_once "views/single_chef.php");
} elseif ($isRecipeClicked) {
    $recipeId = $_GET['recipe_id'];
    $recipeData = $recipeTable->getRecipe($recipeId);
    $chefOfRecipe = $chefTable->getChefOfRecipe($recipeId);
    $displayPage = (include_once "views/single_recipe.php");
} else {
    $allChefs = $chefTable->getAllChefs();
    $allRecipes = $recipeTable->getAllRecipes();
    $displayPage = (include_once "views/all_chefs.php");
    $displayPage .= (include_once "views/all_recipes.php");
}
return $displayPage;
예제 #2
0
파일: search.php 프로젝트: mdnetto/recipes
echo $page;
$button = $_GET['submit'];
$search = $_GET['search'];
$dbInfo = "mysql:host=localhost;dbname=recipes";
$dbUser = "******";
$dbPassword = "";
$db = new PDO($dbInfo, $dbUser, $dbPassword);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
if (!$button) {
    echo "you didn't submit a keyword";
} else {
    if (strlen($search) <= 1) {
        echo "Search term too short";
    } else {
        echo "You searched for <b> {$search} </b> <hr size='1' > </ br > ";
        $chefTable = new Chef_Table($db);
        $construct = $chefTable->joinChefsToRecipes($search);
        $rows = $construct->rowCount();
        if ($rows == 0) {
            echo "Sorry, there are no matching result for <b> {$search} </b>. </br> </br>\n                    1. Try more general words. for example: 'chicken' or 'meat loaf' </br>\n                    2. Try different words with similar  meaning </br>";
        } else {
            echo "<h2>{$rows} results found!</h2>";
            while ($run = $construct->fetchObject()) {
                $title = $run->title;
                $desc = $run->description;
                $first_name = $run->first_name;
                $last_name = $run->last_name;
                $recipe_id = $run->recipe_id;
                $chef_id = $run->chef_id;
                $recipe_url = "index.php?recipe_id={$recipe_id}";
                $chef_url = "index.php?chef_id={$chef_id}";