<?php include('../include/20200331/header.php'); ?>
<style>
.footer { display:none; }
.datum {color:#ccc;font-size:14px;}
a { color:#fff;padding:2px; }
a:hover {color:#000;background-color: #ff63b1;text-decoration:none;padding:2px;}
.current { color:#91718E; }
</style>

<?php

function OpenCon()
 {
$servername = "127.0.0.1:3307";
$username = "adminNatas";
$password = "19simone19";
$dbname = "logoos";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
 return $conn;
}
 
 function CloseCon($conn)
 {
 $conn -> close();
 };
 $connect = OpenCon(); 
?>
			<section class="color-11">
				<nav class="cl-effect-11" style="border-bottom:4px solid #ff63b1;">
							<i class="fas fa-angle-double-right" style="color:#ff63b1;"></i><a href="index.php" 
							data-hover="random">random domein</a>	
				<?php 
				
				$query_domein = "SELECT * FROM `domeinen` GROUP BY `domein` ORDER BY `domein`";
				$result_domein = mysqli_query($connect, $query_domein);

				foreach($result_domein as $row)
				{ 					
					?>				
							<i class="fas fa-angle-double-right" style="color:#ff63b1;"></i><a href="index.php?Domein=<?php echo $row['domein']; ?>" 
							data-hover="<?php echo $row['domein']; ?>" 
							<?php if ($_GET['Domein'] == $row['domein']) { echo ' class="current" '; } ?>>
							<?php echo $row['domein']; ?>
							</a>
				<? 
				}?>
				
			
				</nav>
			</section>
			
			<section class="content">
<?php			
$query_bericht = "SELECT * FROM domeinen WHERE domein LIKE '".$_GET['Domein']."%' ORDER BY domein";


$query_random = "SELECT * FROM domeinen ORDER BY RAND() LIMIT 4";

			if ($_GET['Domein'] != '')
			{
							$result_bericht = mysqli_query($connect, $query_bericht);				
                            foreach($result_bericht as $row_bericht)
                            {
                            	 $datum_split = explode("-",$row_bericht['datum']);
                            	 $jaar = $datum_split['0'];
                            	 $maand = $datum_split['1'];
                            	 $dag = $datum_split['2'];
                            	 $datum = $dag.'/'.$maand.'/'.$jaar;
                            	 
                            ?>	
								
								<div style="float:left;width:400px;margin-left:50px;height:460px;"><h2 class="datum"><?php echo $datum; ?> <a href="https://<?php echo $random['domein']; ?>" target="_blank" style="color:#91718E;font-size:14px;"><i class="fas fa-angle-double-right" style="color:#ff63b1;"></i></a></h2>
								<figure><img src="<?php echo $row_bericht['url_logo']; ?>" width="350" />
								<figcaption style="color:#ff63b1;"><h2><?php echo $row_bericht['omschrijving']; ?></h2></figcaption></figure></div>         
<?php			
							}
 				} else { 
 							$result_random = mysqli_query($connect, $query_random); 					
 							foreach($result_random as $random)
	                        { 							
                             	 $datum_split = explode("-",$random['datum']);
                            	 $jaar = $datum_split['0'];
                            	 $maand = $datum_split['1'];
                            	 $dag = $datum_split['2'];
                            	 
                            	 $datum = $dag.'/'.$maand.'/'.$jaar;
                            ?>	
								
								<div style="float:left;width:400px;margin-left:50px;height:460px;"><h2 class="datum"><?php echo $datum; ?> <a href="https://<?php echo $random['domein']; ?>" target="_blank" style="color:#91718E;font-size:14px;"><i class="fas fa-angle-double-right" style="color:#ff63b1;"></i></a></h2>
								
								<figure><img src="<?php echo $random['url_logo']; ?>" width="350" />
								<figcaption style="text-align:right;color:#ff63b1;"><h5><?php echo $random['omschrijving']; ?></h5></figcaption></figure></div>   
	                            	
	                            	
	                            	
 						<?php	}
								            
																		
				}
?>
</section>

<?php include('../include/20190923/footer.php'); 
?>