Не получается переменная

Question

Знает кто, в чем проблема? р в этой строчке: if ($_GET['p']) почему-то не видится.. я не понимаю..

Весь код страницы:

<?php
    $select = mysqli_query($connect, "SELECT COUNT(*) FROM `quote`");
    if (!$select) die ('Error'. mysqli_error($connect));
    $row = mysqli_fetch_array($select);
    $count_post = $row [0];

    $today = date("F j, Y, g:i a");  
    $query = "SELECT `id`, `discription`, `author`, `data` FROM `quote` ORDER BY id DESC LIMIT 2";
    $sql = mysqli_query($connect, $query);
    $number = 0;

    if (!$_GET)
    {
        while ($news = mysqli_fetch_array($sql))
        {
    ?>
            <div class="card news border-dark mb-3" style="min-width: 100%;">
                <div class="card-header">Quotes</div>
                    <div class="card-body text-dark">
                        <input type="checkbox" class="read-more-checker" id="read-more-checker-<?php echo $number; ?>" />
                        <div class="limiter">       
                            <h5 class="card-title"><?php echo $news['id']; ?></h5>              
                            <p class="card-text"><?php echo $news['author']; ?></p>
                            <p class="card-text"><?php echo $news['discription']; ?></p>
                            <p class="card-text"><?php echo $news['data']; ?></p>
                            <div class="bottom"></div>
                        </div>
                        <label for="read-more-checker-<?php echo $number; ?>" class="read-more-button"></label>
                    </div>  
            </div>
            <?php
            $number = $number + 1;
        }
        

    echo "Page 1 ";
    }

    for ($i = 2, $ii = 2; $i < $count_post; $i = $i + 2, $ii ++)
    echo "<a href = 'index.php?p={$i}'> {$ii} </a>";

    if ($_GET['p'])
    {
        $page = (int) $_GET['p'];
        $query = "SELECT `id`, `discription`, `author`, `data` FROM `quote` ORDER BY id DESC LIMIT $page,2";
        while ($news = mysqli_fetch_array($sql))
        {
?>
        
        <div class="card news border-dark mb-3" style="min-width: 100%;">
            <div class="card-header">Quotes</div>
                <div class="card-body text-dark">
                    <input type="checkbox" class="read-more-checker" id="read-more-checker-<?php echo $number; ?>" />
                    <div class="limiter">       
                    <h5 class="card-title"><?php echo $news['id']; ?></h5>              
                    <p class="card-text"><?php echo $news['author']; ?></p>
                    <p class="card-text"><?php echo $news['discription']; ?></p>
                    <p class="card-text"><?php echo $news['data']; ?></p>
                    <div class="bottom"></div>
            </div>
            <label for="read-more-checker-<?php echo $number; ?>" class="read-more-button"></label>
        </div>  
        </div>
        <?php
            $number = $number + 1;

    echo "Page <a href = 'index.php?p={$i}'> 1 </a>";
    }
    }
?>

Answer 1

Проблема решена

$page = isset($_GET["page"]) ? (int) $_GET["page"] : 1;

    $notesOnPage = 3;

    $from = ($page - 1) * $notesOnPage;

    $today = date("F j, Y, g:i a");  
    $query = "SELECT `id`, `discription`, `author`, `data` FROM `quote` WHERE id > 0 ORDER BY id DESC LIMIT $from, $notesOnPage";
    //var_dump($query);
    $sql = mysqli_query($connect, $query);
    $number = 0;

    while ($news = mysqli_fetch_array($sql))
    {
?>

<div class="card news border-dark mb-3" style="min-width: 100%;">
    <div class="card-header">Quotes</div>
        <div class="card-body text-dark">
            <input type="checkbox" class="read-more-checker" id="read-more-checker-<?php echo $number; ?>" />
            <div class="limiter">       
                <h5 class="card-title"><?php echo $news['id']; ?></h5>              
                <p class="card-text"><?php echo $news['author']; ?></p>
                <p class="card-text"><?php echo $news['discription']; ?></p>
                <p class="card-text"><?php echo $news['data']; ?></p>
                <div class="bottom"></div>
            </div>
            <label for="read-more-checker-<?php echo $number; ?>" class="read-more-button"></label>
        </div>  
</div>

<?php
        $number = $number + 1;
    }

    $select = mysqli_query($connect, "SELECT COUNT(*) FROM `quote`");
    if (!$select) die ('Error'. mysqli_error($connect));
    $row = mysqli_fetch_array($select);
    $count_post = $row [0];

    $pages_count = ceil ($count_post / $notesOnPage);
    //var_dump($pages_count);
?>
    <div class="pagination">
<?php

    for($i = 1; $i < $pages_count; $i++){
        echo "<a href =\"?page=$i\">$i </a>";
    }
?>
</div>

БЛОГ НА HUSL

Не получается переменная

Ответы (1 шт):