gistfile1.txt

        <?php
        //config_db.php
        $servername = "127.0.0.1";
        $username = "root";
        $password = " ";
        $dbname = "mydb";
        $datatable = "thread"; // MySQL table name
        $results_per_page = 12; // number of results per page
         
        // Create connection
        $conn = new mysqli($servername, $username, $password, $dbname);
        // Check connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        } ?>

     <?php
        include('connfig_db.php');

        if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
        $start_from = ($page-1) * $results_per_page;
        $sql = "SELECT thread.t_dp,thread.t, thread.t_id, thread.tittle, thread.t_username, thread.t_date_posting, thread.views, comments.comments, comments.comment_time, comments.comment_id, comments.c FROM ".$datatable." INNER JOIN comments ON thread.t=comments.comment_id where thread.t_type='02' LIMIT $start_from, ".$results_per_page."";
        $rs_result = $conn->query($sql); ?>