$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;