<?php
//Connecting to DB
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Could not connect to the Krecipes database-server!');
mysql_select_db($dbname);
function unescape_and_decode($string)
{
$result = str_replace(";@", ";", $string);
$string = utf8_decode($string);
return $string;
}
//Versions for footer
$query = "SELECT ver,generated_by FROM db_info";
$result = mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_NUM);
$ver = unescape_and_decode($row[0]);
$generated_by = unescape_and_decode($row[1]);
?>
</h2>
<?php
// Get recipes listed by category
$query = "SELECT id,name FROM categories WHERE parent_id=-1 ORDER BY name";
$result = mysql_query($query);
$number = mysql_num_rows($result);
$i = 0;
if ($number == 0) {
print "{$no_db_listings}";
} elseif ($number > 0) {
while ($i < $number) {
$id = mysql_result($result, $i, "id");
$name = mysql_result($result, $i, "name");
$name = unescape_and_decode($name);
$uppercase_begin = strtoupper($name[0]);
if ($uppercase_begin != $at) {
$cat_list .= "<hr />\n";
$cat_list .= "<a name=\"{$uppercase_begin}\">\n";
$cat_list .= "<p class=\"index_header\">{$uppercase_begin}</p>\n";
$cat_index .= " [ <a href=\"#{$uppercase_begin}\">{$uppercase_begin}</a> ] ";
}
$at = $uppercase_begin;
$cat_list .= "<a href=\"view_cat.php?id={$id}&cat_name=" . urlencode($name) . "\">{$name}</a><p></p>";
$i++;
}
}
print $cat_index;
print $cat_list;
?>
$name = mysql_result($result, $i, "name");
$name = unescape_and_decode($name);
print "<a href=\"view_cat.php?id={$id}&cat_name=" . urlencode($cat_name . "->" . $name) . "\">{$name}</a><p></p>";
$i++;
}
?>
<hr />
<h2><?php
echo "{$lng_cat_recipes}";
?>
:</h2>
<?php
$query = "SELECT r.id,r.title,cl.category_id,cl.recipe_id FROM recipes r,\n category_list cl WHERE cl.category_id={$cat_id} AND cl.recipe_id=r.id";
$result = mysql_query($query);
$number = mysql_num_rows($result);
$i = 0;
if ($number == 0) {
print "{$no_cat_listings}";
} elseif ($number > 0) {
while ($i < $number) {
$id = mysql_result($result, $i, "r.id");
$title = mysql_result($result, $i, "r.title");
$title = unescape_and_decode($title);
print "<a href=\"view_recipe.php?id={$id}\">{$title}</a><p></p>";
$i++;
}
}
require 'footer.php';
if ($ingredient_group_id != -1) {
$command = "SELECT name FROM ingredient_groups WHERE id={$ingredient_group_id}";
$g_result = mysql_query($command);
$ingredient_group = mysql_result($g_result, 0, "name");
}
$ingredient_amount = mysql_result($result, $i, "il.amount");
$ingredient_amount_offset = mysql_result($result, $i, "il.amount_offset");
$ingredient_amount_display = $ingredient_amount;
if ($ingredient_amount_offset > 0) {
$ingredient_amount_display .= "-" . ($ingredient_amount_offset + $ingredient_amount);
}
$ingredient_list_id = mysql_result($result, $i, "il.id");
$ingredient_unit_id = mysql_result($result, $i, "u.id");
$ingredient_units = mysql_result($result, $i, "u.name");
$ingredient_name = unescape_and_decode($ingredient_name);
$ingredient_units = unescape_and_decode($ingredient_units);
$command = "SELECT pl.prep_method_id,p.name FROM prep_methods p, prep_method_list pl WHERE pl.ingredient_list_id={$ingredient_list_id} AND p.id=pl.prep_method_id ORDER BY pl.order_index";
$prep_method = "";
$p_result = mysql_query($command);
$p_number = mysql_num_rows($p_result);
$j = 0;
while ($j < $p_number) {
if ($j != 0) {
$prep_method .= ", ";
}
$prep_method .= mysql_result($p_result, $j, "p.name");
$j++;
}
if ($prep_method != "") {
$prep_method = "; " . $prep_method;
}
<?php
// Read title, yield, instructions and prep_time
$query = "SELECT instructions,yield_amount,yield_amount_offset,yield_type_id,title,prep_time FROM recipes WHERE\nid={$recipe_id}";
$result = mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_NUM);
$recipe_instructions = str_replace("\n", "<br />", unescape_and_decode($row[0]));
$recipe_yield_amount = unescape_and_decode($row[1]);
$recipe_yield_amount_offset = unescape_and_decode($row[2]);
$recipe_yield_type_id = unescape_and_decode($row[3]);
$recipe_title = unescape_and_decode($row[4]);
$recipe_preptime = unescape_and_decode($row[5]);
mysql_free_result($result);
//Simple check to see if recipe exists
if ($row == 0) {
die("{$no_exist_recipe}");
}
// Read yield type
$query = "SELECT name FROM yield_types WHERE id={$recipe_yield_type_id}";
$result = mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_NUM);
$recipe_yield_type = $row[0];
$recipe_yield = $recipe_yield_amount;
if ($recipe_yield_amount_offset > 0) {
$recipe_yield .= "-" . ($recipe_yield_amount_offset + $recipe_yield_amount);
}
$recipe_yield .= " {$recipe_yield_type}";
mysql_free_result($result);
// Read authors
$command = "SELECT al.author_id,a.name FROM author_list al, authors a WHERE recipe_id={$recipe_id} AND al.author_id=a.id";
$result = mysql_query($command);
