1#@!#!123s

: / home6 / grandhou / www / album /
Filename : listing.php
back
<?php
session_start();
error_reporting(0);
include('include/configpage.php');
include('include/pdo.php');
if(strlen($_SESSION['alogin'])==0)
  { 
header('location:index.php');
}
else{
  $userid=$_GET['userid'];
  $albumlistid=$_GET['albumlistid'];
  $permalink=$_GET['permalink'];

  $sql2= mysqli_query($dbhandle,"select * from albumlist where id='".$albumlistid."'");
  while($row2=mysqli_fetch_array($sql2))
  {
  	$albumname=$row2['name'];
  }
  ?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title><?php echo $albumname;?></title>
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" >
<link rel="shortcut icon" href="favicon.ico">
<link href="album-css/album.css" rel="stylesheet" type="text/css">
<link rel="preconnect" href="https://fonts.gstatic.com">
<link href="https://fonts.googleapis.com/css2?family=Raleway:wght@400;700&display=swap" rel="stylesheet">
<link href="album-css/lightgallery.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="album-js/jquery-1.12.4.min.js"></script>
<script>
$(document).ready(function(){

	// hide #back-top first
	$("#back-top").hide();
	
	// fade in #back-top
	$(function () {
		$(window).scroll(function () {
			if ($(this).scrollTop() > 100) {
				$('#back-top').fadeIn();
			} else {
				$('#back-top').fadeOut();
			}
		});

		// scroll body to 0px on click
		$('#back-top a').click(function () {
			$('body,html').animate({
				scrollTop: 0
			}, 800);
			return false;
		});
	});

});
</script>
</head>

<body>
<div class="logo">
  <div class="home"><a href="albums.php?userid=<?php echo $userid;?>&permalink=<?php echo $permalink;?>">Back to Albums</a></div>
  <a href="albums.html"><img src="album-images/grandhouse-wedding-photography-sydeny.png" alt="grandhouse logo"></a></div>
<div class="mainwrap">
  <div class="name"> <span><?php  $sql = "select * from user where id='".$userid."'";
$result = mysqli_query($dbhandle,$sql);
while($row = mysqli_fetch_array($result))
{
  echo $row['name'];
  $permalink= $row['permalink'];
}?></span>
    <h2><?php echo $albumname;?></h2>
    <span> <?php 
  $sql1= "select file_name from album where userid='".$userid."' and albumlistid='".$albumlistid."'";
  $result1 = mysqli_query($dbhandle,$sql1);
  echo mysqli_num_rows($result1);
?> Photos</span> </div>
  <div class="album-container">
    <ul id="lightgallery">
    	 <?php 
  $sql4= "select file_name from album where userid='".$userid."' and albumlistid='".$albumlistid."'";
  $result4 = mysqli_query($dbhandle,$sql4);
  while($row4=mysqli_fetch_array($result4))
  {?>
      <li data-src="../album/album-admin/upload/<?php echo $row4['file_name'];?>"> <a href=""> <img class="img-responsive" src="../album/album-admin/upload/<?php echo $row4['file_name'];?>"  alt="<?php echo $row4['name'];?>"> </a> </li>
     <?php } ?>
    </ul>
  </div>
</div>
<div class="ayyans">Site by <a href="https://www.graffitopaints.com" title="Web Design India" target="_blank">ayyans</a> | 2021 all rights reserved Grandhouse.com.au</div>
<div id="back-top"><a href="#top"><img src="album-images/top.png" alt="go top" width="42" height="42" border="0" /></a></div>
<script src="album-js/lightgallery.js"></script> 
<script src="album-js/lg-autoplay.js"></script> 
<script src="album-js/lg-fullscreen.js"></script> 
<script src="album-js/lg-zoom.js"></script>
<script src="album-js/lg-pager.js"></script>
<script>lightGallery(document.getElementById('lightgallery'));</script>
</body>
</html>
<?php } ?>