$letter_arg = "&letter=" . $_GET['letter'];
$letter_where = " WHERE name LIKE '{$_GET['letter']}%'";
}
//Count recipes in query
$dbquery = $dbconnect->query("SELECT COUNT(*) FROM main {$letter_where}");
$result = $dbquery->fetch_row();
$recipe_number = $result[0];
$dbquery->close();
//Retrieve recipe names and ID's
if (!($exec_db_browse = $dbconnect->query($sql))) {
echo "<p class=\"error\">" . ERROR_BROWSE . "\n<br>" . mysqli_error();
cs_AdminFastLogout();
cs_AddFooter();
exit;
}
foodie_AlphaLinks("admin_modify.php?");
//Count recipes in query, if == 0 print that no recipes are
//available
$num_letter = mysqli_num_rows($exec_db_browse);
if ($num_letter == "0") {
echo "<p class=\"error\">" . ERROR_ADMIN_DELETE_LETTER . " {$_GET['letter']}\n";
}
echo "<table class=\"browse\">";
while ($recipe_browse_list = $exec_db_browse->fetch_object()) {
echo "<tr><td><a href=\"admin_modify.php?recipe={$recipe_browse_list->id}\">{$recipe_browse_list->name}</a></td></tr>\n";
}
echo "</table>\n";
echo "<p>" . MSG_AVAILABLE_PAGES . ": \n";
if ($_GET['offset'] >= 1) {
// bypass PREV link if offset is 0
$prevoffset = $_GET['offset'] - $setting_max_lines_page;
$sql = "SELECT id,name FROM main ORDER BY name ASC LIMIT {$_GET['offset']},{$setting_max_lines_page}";
// If letter is set, adjust SQL
if (isset($_GET['letter'])) {
$sql = "SELECT id,name FROM main WHERE name LIKE '{$_GET['letter']}%' ORDER BY name ASC LIMIT {$_GET['offset']},{$setting_max_lines_page}";
$letter_arg = "&letter=" . $_GET['letter'];
$letter_where = " WHERE name LIKE '{$_GET['letter']}%'";
}
//Count recipes in query
$dbquery = $dbconnect->query("SELECT COUNT(*) FROM main {$letter_where}");
$result = $dbquery->fetch_row();
$recipe_number = $result[0];
$dbquery->close();
if (!($query = $dbconnect->query($sql))) {
echo "<p class=\"error\">" . ERROR_BROWSE . "\n<br>" . $query->error;
}
foodie_AlphaLinks("admin_delete.php?");
//Count recipes in query, if == 0 print that no recipes are
//available
$num_letter = $query->num_rows;
if ($num_letter == "0") {
echo "<p class=\"error\">" . ERROR_ADMIN_DELETE_LETTER . " {$_GET['letter']}\n";
}
//Print browse table used to delete recipes
echo "<table class=\"browse\">";
while ($row = $query->fetch_object()) {
echo "<tr><td>\n<a href=\"admin_delete.php?recipe={$row->id}\">{$row->name}</a></td></tr>\n";
}
echo "</table>\n";
echo "<p>" . MSG_AVAILABLE_PAGES . ": \n";
if ($_GET['offset'] >= 1) {
// bypass PREV link if offset is 0
}
}
}
}
}
}
}
}
}
if (!($browse_query = $dbconnect->query($sql_db_browse))) {
echo "<p class=\"error\">" . ERROR_BROWSE . "\n<br>";
echo $browse_query->error();
} else {
//Print alpha links
if ($_GET['browse'] == 'br_letter' || $_GET['browse'] == 'br_alpha') {
foodie_AlphaLinks("browse.php?browse=br_letter&");
}
//
if ($_GET['browse'] == 'br_letter') {
$num_recipes = $browse_query->num_rows;
if ($num_recipes == "0") {
echo "<p class=\"error\">" . MSG_RECIPES_INITIAL . " {$letter}\n";
}
}
foodie_PrintBrowseTable($browse_query, $browse_parameter);
$browse_query->close();
if ($num_recipes > 0) {
//Print available pages
echo "<p>" . MSG_AVAILABLE_PAGES . ": \n";
if ($offset >= 1) {
$prevoffset = $offset - $lines_per_page;
