Skip to content

Instantly share code, notes, and snippets.

@estudijoanpuig
Last active February 27, 2021 00:17
Show Gist options
  • Save estudijoanpuig/4338381825a5f7ca0da79d0662762927 to your computer and use it in GitHub Desktop.
Save estudijoanpuig/4338381825a5f7ca0da79d0662762927 to your computer and use it in GitHub Desktop.
album de fotos b4 + fancybox
<?php
/*
Template Name: boomerang
*/
get_header(); ?>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<title>Boomerang - Template</title>
<!-- Favicons-->
<link rel="shortcut icon" href="http://koalitic.synology.me/intranet/assets/images/favicon.png">
<link rel="apple-touch-icon" href="http://koalitic.synology.me/intranet/assets/images/apple-touch-icon.png">
<link rel="apple-touch-icon" sizes="72x72" href="http://koalitic.synology.me/intranet/assets/images/apple-touch-icon-72x72.png">
<link rel="apple-touch-icon" sizes="114x114" href="http://koalitic.synology.me/intranet/assets/images/apple-touch-icon-114x114.png">
<!-- Web Fonts-->
<link href="https://fonts.googleapis.com/css?family=Poppins:400,500,600%7cPlayfair+Display:400i" rel="stylesheet">
<link href="https://use.fontawesome.com/releases/v5.0.6/css/all.css" rel="stylesheet">
<!-- Plugins-->
<link href="http://koalitic.synology.me/intranet/assets/css/plugins.min.css" rel="stylesheet">
<!-- Template core CSS-->
<link href="http://koalitic.synology.me/intranet/assets/css/template.css" rel="stylesheet">
<!-- 1. Add latest jQuery and fancybox files -->
<script src="https://cdn.jsdelivr.net/npm/jquery@3.4.1/dist/jquery.min.js"></script>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/fancyapps/fancybox@3.5.7/dist/jquery.fancybox.min.css" />
<script src="https://cdn.jsdelivr.net/gh/fancyapps/fancybox@3.5.7/dist/jquery.fancybox.min.js"></script>
</head>
<!-- Portfolio-->
<section class="module p-t-35 p-b-0">
<div class="container">
<div class="row">
<div class="col-md-12">
<ul class="filters serif">
<li><a class="current" href="#" data-filter="*">All</a></li>
<li><a href="#" data-filter=".anime">anime</a></li>
<li><a href="#" data-filter=".celebrities">celebrities</a></li>
<li><a href="#" data-filter=".porn">porn</a></li>
<li><a href="#" data-filter=".pirelli">pirelli</a></li>
<li><a href="#" data-filter=".stocking">stocking</a></li>
<li><a href="#" data-filter=".underwear">underwear</a></li>
<li><a href="#" data-filter=".photographers">photographers</a></li>
</ul>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row row-portfolio" data-columns="5">
<div class="grid-sizer"></div>
<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM `erotisme`";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
?>
<div class="portfolio-item <?php echo "$row[categoria]";?>">
<div class="portfolio-item-wrapper">
<div class="portfolio-item-img"><img src="<?php echo "$row[url_img]";?>" alt=""></div>
<div class="portfolio-item-caption">
<a data-fancybox href="<?php echo "$row[url_img]";?>" data-title="<?php echo "$row[titol]";?>" title="VEURE IMATGE AMPLIADA--<?php echo "$row[titol]";?>"><img src="https://img.icons8.com/dusk/64/000000/stack-of-photos.png"/></a>
<a href="<?php echo "$row[url_ins]";?>"><img src="https://img.icons8.com/dusk/64/000000/instagram-new.png" title="perfil instagram-<?php echo "$row[titol]";?>"/></a>
<a data-fancybox href="<?php echo "$row[url_video]";?>"><img src="https://img.icons8.com/dusk/64/000000/video-message.png" title="video si en te-<?php echo "$row[titol]";?>"/></a>
<a href="<?php echo "$row[url]";?>"><img src="https://img.icons8.com/dusk/64/000000/domain.png" title="pagina web-<?php echo "$row[titol]";?>"/></a>
<h6 class="portfolio-item-title"><?php echo "$row[titol]";?></h6>
<span class="portfolio-item-subtitle serif"><?php echo "$row[categoria]";?></span>
</div>
</div>
</div>
<?php }
} else {
echo "0 results";
}
$conn->close();
?>
</div>
</div>
</section>
<!-- Portfolio end-->
<!-- To top button--><a class="scroll-top" href="#top"><i class="fas fa-angle-up"></i></a>
<!-- Scripts-->
<script src="http://koalitic.synology.me/intranet/assets/js/custom/jquery.min.js"></script>
<script src="http://koalitic.synology.me/intranet/assets/js/custom/popper.min.js"></script>
<script src="http://koalitic.synology.me/intranet/assets/js/bootstrap/bootstrap.min.js"></script>
<script src="http://koalitic.synology.me/intranet/assets/js/custom/plugins.min.js"></script>
<script src="http://koalitic.synology.me/intranet/assets/js/custom/custom.min.js"></script>
</body>
</html>
<?php
get_footer();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment