Learn PHP

 <?php // Database connection $host = 'localhost'; $db = 'demp_p'; $user = 'root'; $pass = 'root'; $conn = new mysqli($host, $user, $pass, $db); if ($conn->connect_error) {     die("Connection failed: " . $conn->connect_error); } // Configuration $limit = 5; // Number of records per page $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; $start = ($page > 1) ? ($page * $limit) - $limit : 0; // Count total records // $totalQuery = $conn->query("SELECT COUNT(*) as count FROM items"); // print_r($totalQuery->fetch_assoc(MYSQLI_ASSOC));die; $total = 100; // $total = $totalQuery->fetch_assoc()['count']; $pages = ceil($total / $limit); // Fetch records // $query = $conn->prepare("SELECT * FROM items LIMIT ?, ?"); // $query->bind_param("ii", $start, $limit); // $query->execute(); // $result = $query->get_result(); // $items = $result->fetch_all(MYSQLI_ASSOC);