Photo Album
This is my photo album of friends, family and events. You will find photos of my handfasting ceremony, trips, conventions and much more.
Enjoy!
|
$page_count ) {
$requested_page = 1;
}
if ( $requested_page == 1 ) {
$limit = 0;
}
else {
$limit = $PAGE_LENGTH * ( $requested_page - 1 );
}
if ( $requested_page > 1 ) { $nav_prev = 1; }
if ( $requested_page < $page_count ) { $nav_next = 1; }
$result = mysqli_query($dbh, "SELECT page_name, image_url, image_full, page_id FROM photos ORDER BY page_id DESC LIMIT $limit, $PAGE_LENGTH" );
if ( $result ) {
echo '';
$rownum=0;
while( $query_data = mysqli_fetch_array( $result ) ) {
$page_name=str_replace("'","\'", $query_data['page_name']);
$img_attr = getimagesize( $query_data['image_url'] );
$html = '![' . $query_data['page_name'] . '](' . $query_data['image_url'] . ') | ';
echo $html . "\n";
if ( ++$rownum % 3==0){ echo ' ';}
}
echo ' ';
}
mysqli_free_result( $result );
$nav_string = generate_pagination( $_SERVER['PHP_SELF'], $record_count, $PAGE_LENGTH, $requested_page );
?>
|