} $photo = Photograph::find_by_id($_GET['id']); if ($photo && $photo->destroy()) { $session_admin->message("The photo {$photo->filename} was deleted."); unlink($photo->filename); redirect_to('admin_index.php'); } else { $session_admin->message("The photo could not be deleted."); redirect_to('admin_index.php'); } break; case 'idd': if (empty($_GET['id'])) { $session_admin->message("No photograph ID was provided."); redirect_to('admin_index.php'); } $photo2 = Photograph2::find_by_id($_GET['id']); if ($photo2 && $photo2->destroy()) { $session_admin->message("The photo {$photo2->filename} was deleted."); unlink($photo2->filename); redirect_to('admin_index.php'); } else { $session_admin->message("The photo could not be deleted."); redirect_to('admin_index.php'); } break; } } if (isset($database)) { $database->close_connection(); }
require_once 'includes/initialize.php'; if (!$session->is_logged_in()) { redirect_to("login.php"); } $max_file_size = 1048576; // expressed in bytes // 10240 = 10 KB // 102400 = 100 KB // 1048576 = 1 MB // 10485760 = 10 MB if (isset($_POST['submit']) && $_FILES['file_upload']['size'] != 0 && $_FILES['file_upload2']['size'] != 0) { $photo = new Photograph(); $photo->attach_file($_FILES['file_upload']); $photo->description = $_POST['description']; $photo->category = $_POST['category']; $photo2 = new Photograph2(); $photo2->attach_file($_FILES['file_upload2']); $photo2->category = $_POST['category']; if ($photo->save() && $photo2->save()) { // Success $session->message("Photographs uploaded successfully."); redirect_to('index.php'); } else { // Failure $message = join("<br />Errror", $photo->errors); } } ?> <!DOCTYPE html> <html>
$total_count = mysql_result($total_count, 0); $pagination = new Pagination($page, $per_page, $total_count); // Instead of finding all records, just find the records // for this page $sql = "SELECT * FROM photographs "; $sql .= "WHERE category = '{$category}' "; $sql .= "ORDER BY `photographs`.`id` DESC "; $sql .= "LIMIT {$per_page} "; $sql .= "OFFSET {$pagination->offset()}"; $photos = Photograph::find_by_sql($sql); $sql2 = "SELECT * FROM photographs2 "; $sql2 .= "WHERE category = '{$category}' "; $sql2 .= "ORDER BY `photographs2`.`id` DESC "; $sql2 .= "LIMIT {$per_page} "; $sql2 .= "OFFSET {$pagination->offset()}"; $photos2 = Photograph2::find_by_sql($sql2); //$sql3 ="UPDATE photographs SET likes = likes + 1 where id ='28'"; //$sql3 ="SELECT likes FROM photographs where id ='28'"; //$likesomething = Photograph::find_all($sql3,0); // Need to add ?page=$page to all links we want to // maintain the current page (or store $page in $session) ?> <?php include 'indexPictureArea.php'; ?> <br><br> <div id="pagination" style="clear: both;"><center> <?php if ($pagination->total_pages() > 1) { if ($pagination->has_previous_page()) { echo "<a id='previousPage' href=\"categoryQuery.php?category={$category}&page=";
<?php require_once "includes/initialize_admin.php"; if (!$session_admin->is_admin_logged_in()) { redirect_to("admin_login.php"); } // Find all the photos $photos = Photograph::find_all(); $photos2 = Photograph2::find_all(); ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Login</title> <?php require 'links.php'; ?> </head> <body> <style> td{ height:500px; } #cssTable td {text-align:center; vertical-align:middle;} </style>