HEX

File: /var/www/html/autoload.php
<?php
$db_username = 'root';
$db_password = '';
$db_name = 'mimi';
$db_host = 'localhost';
$items_per_group = 5;
$mysqli = new mysqli($db_host, $db_username, $db_password,$db_name);

//sanitize post value
$group_number = filter_var($_POST["group_no"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);

//throw HTTP error if group number is not valid
if(!is_numeric($group_number)){
    header('HTTP/1.1 500 Invalid number!');
    exit();
}

//get current starting point of records
$position = ($group_number * $items_per_group);

//Limit our results within a specified range.
$results = $mysqli->query("SELECT newsid,title,picture FROM reporta ORDER BY newsid ASC LIMIT $position, $items_per_group");

if ($results) {
    //output results from database
   
    while($obj = $results->fetch_object())
    {
        echo '<li id="item_'.$obj->newsid.'">'.$obj->newsid.' - <strong>'.$obj->title.'</strong></span> &mdash; <span class="page_message">'.$obj->picture.'</span></li>';
    }

}
unset($obj);
$mysqli->close();
?>