Chefs' list

function get_chefs() { include'db_connection.php'; try { return $conn->query("SELECT * FROM chefs"); } catch (PDOException $e) { echo 'Error:' . $e->getMessage() . "
"; return array(); } return true; } function find_chef_by_id($id = ':chef_id') { include 'db_connection.php'; $sql = 'SELECT * FROM chefs WHERE id=:chef_id'; try { $results = $conn->prepare($sql); $results->bindParam(':chef_id', $chef_id, PDO::PARAM_INT); $results->execute(); } catch(PDOException $e) { echo 'Error: ' . $e->getMessage() . '
'; return array(); } return $results->fetchAll(PDO::FETCH_ASSOC); } if ($_SERVER['REQUEST_METHOD'] == 'POST') { $name = filter_input(INPUT_POST, 'name', FILTER_SANITIZE_STRING); $country = filter_input(INPUT_POST, 'country', FILTER_SANITIZE_STRING); if(empty($name)) { $error_message = "Chef's name can not be empty"; } elseif (empty($country)) { $error_message = "Country can not be empty"; }else { if(edit_chef($name, $country)) { header('Location: index.php'); exit; } else { $error_message = "Could not update chef"; } } } include 'includes/header.php';?>

Edit chef

' . $error_message . '

'; } $chefs = get_chefs(); foreach ($chefs as $chef) { $id = find_chef_by_id($chef["id"]); ?>
" />
" />