Upload Artwork for []

Category

Create/manage artwork category

Title *

required />

Picture

Format: PNG, BMP, GIV, JPG or JPEG

Date Posted

Detail *

"; if(isset($_REQUEST['editing'])){ $select_id = mysqli_escape_string($conn, $_REQUEST['update_id']); print ""; print ''; }else{ print ' '; } ?>

Record

"; // print the random numbers while($info = mysqli_fetch_array($result)) { $id=$info['id']; $artist_id=$info['artist_id']; $image_name=$info['image_name']; $title=$info['title']; $date_day=$info['date_day']; $date_month=$info['date_month']; $date_year=$info['date_year']; $body=$info['body']; $posted_by=$info['posted_by']; $category=$info['category']; $limit_body = substr($body, 0, 100)."..."; if($image_name != ""){ $img = "

"; }else{ $img = 'no picture'; } $query_artist = "SELECT * FROM artist WHERE id = '$artist_id'"; $result_artist = mysqli_query($conn,$query_artist) or die(mysqli_error($conn)); $data = mysqli_fetch_array($result_artist); $name=$data['name']; if($category != ""){ $query_num = "SELECT * FROM series WHERE id='$category'"; $result_num = mysqli_query($conn,$query_num) or die(mysqli_error($conn)); $info = mysqli_fetch_array($result_num); $series_id=$info['id']; $series_name =$info['series_name']; }else{ $series_name = ""; } print " "; } //close up ther table print "

Id	Artist	Image	Title	Series	Date	Body
$id	$name	$img	$title	$series_name	$date_day/$date_month/$date_year	$limit_body	"; print "Edit \| Delete"; print "

"; $query = "SELECT COUNT(id) AS numrows FROM artworks WHERE artist_id='$artist_id_val'"; $result = mysqli_query($conn,$query) or die(mysqli_error($conn)); $row = mysqli_fetch_array($result); $numrows = $row['numrows']; // how many pages we have when using paging? $maxPage = ceil($numrows/$rowsPerPage); // print the link to access each page $self = $_SERVER['PHP_SELF']; $nav = ''; for($page = 1; $page <= $maxPage; $page++) { if ($page == $pageNum) { $nav .= " $page "; // no need to create a link to current page } else { $nav .= " $page "; } } // creating previous and next link // plus the link to go straight to // the first and last page if ($pageNum > 1) { $page = $pageNum - 1; $prev = " [Prev] "; $first = " [First Page] "; } else { $prev = ' '; // we're on page one, don't print previous link $first = ' '; // nor the first page link } if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " [Next] "; $last = " [Last Page] "; } else { $next = ' '; // we're on the last page, don't print next link $last = ' '; // nor the last page link } // print the navigation link echo $first . $prev . $nav . $next . $last; // and close the database connection // include '../conn/closedb.php'; ?>