index.php

<?php
    require ('connect.php');

    $query = "SELECT * FROM fish";
    $statement = $db->prepare($query); // Returns a PDOStatement object.
    $statement->execute(); // The query is now executed.
    $fish= $statement->fetchAll();


    // Work on pagination later. 
    $total = $db->query('SELECT COUNT(*) FROM fish')->fetchColumn();

    $limit = 10;
    
    $pages = ceil($total/$limit);

    session_start();
   
?>

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Liger Aquariums</title>
    <link rel="stylesheet" href="style.css" type="text/css">
</head>
<body>
    <div id="wrapper">
        <div id="header">
            <h1><a href="index.php">Liger Aquariums - Home page</a></h1>
        </div> <!-- END div id="header" -->
        
<?php require 'menu.php' ?> 

<div id="all_blogs">
            <?php $i = 0 ?><br>
            <form class="search" action="search.php">
                <input type="text" placeholder="Search common name" name="search">
                <button type="submit">Search</button>
            </form>
            
            <?php foreach(array_reverse($fish) as $curent): ?>
                <div class = "fish_post">           

                    <h2><?= $curent['commonName'] ?> </h2>

                    <div class="noprint">
                        <?= $urlFancy = $curent['commonName']?>
                        <?= $urlFancy = str_replace(' ', '-', $urlFancy)?>
                    </div>

                    <?php if($curent['image']): ?>

                        <!-- Work on the alt -->
                        <img src="data:image/gif;base64,<?php echo base64_encode($curent['image'])?>"  alt="test" /> <br>

                    <?php endif ?>
                    
                    <?php if(isset($_SESSION['role']) && $_SESSION['role'] == 'a'): ?>
                        <p>
                            Date: <?=  $curent['date'] ?> <a href="edit.php?id=<?=$curent['fish_id']?>&p=<?=$urlFancy?>">edit </a> <br>
                        </p>
                    <?php else: ?>
                        <p>
                            Date: <?= $curent['date'] ?>
                        </p>
                    <?php endif ?>

                        <div class = "fish_content">

                            Tank Mates: <?= $curent['Tankmates'] ?> <br>
                            Aggression level: <?= $curent['Aggression'] ?> <br>
                            Full grown size: <?= $curent['Size'] ?>" <br>
                            pH: <?= $curent['pH'] ?> <br>
                            Water temperature: <?= $curent['Water_Temperature'] ?> F <br>
                            Swim position: <?= $curent['swimPosition'] ?> <br>

                            <a href="show.php?id=<?=$curent['fish_id']?>&p=<?=$urlFancy?>">Read More </a>

                        </div>
                </div>
                
                <?php $i++ ?>

                <?php if($i == 20) break; ?>

            <?php endforeach ?>
         
            
      
</div> <!-- END div id="wrapper" -->

<div id="footer">
            Liger Aquariums 2021
        </div> <!-- END div id="footer" -->
    </div>
</body>
</html>