Create a show more feature for a php list

Hello Freelancers, Only freelancers who add in their bid. " Localhost " will be considered. This helps us weed away the auto bidders. We would like to create a show more feature that will display 5 results each time a View More Transactions button is clicked. When the user loads the page we want to display 5 results, then if the user wants to see more they will click a button view more transactions which will load 5 more, and keep giving them the option to load more until there is no more data to show. Provided is the PHP code that will display the <li> Please add to this code. We need to add a show more transactions button also. The table structure must be created by you, it has 2 col. username varchar255 and time which is a timestamp <ul class="list-group list-group-flush tx-13" > <?php $table = 'table'; $query = sql_query($db, "SELECT * FROM `$table` WHERE `username` = 'test' ORDER BY `time` DESC"); while ($row = mysqli_fetch_assoc($query)) { $formatted_datetime = date("m/d/y, g:ia", strtotime($row['time'])); echo ' <li class="list-group-item d-flex pd-sm-x-20"> <div class="avatar d-none d-sm-block"><span class="avatar-initial rounded-circle"><i class="icon ion-md-checkmark"></i></span></div> <div class="pd-sm-l-10"> <p class="tx-medium mg-b-0"><a href=""><i class="fab fa-cc-paypal"></i> Data 1</a></p> <small class="tx-12 tx-color-03 mg-b-0">' . $formatted_datetime . '</small> </div> <div class="mg-l-auto text-right"> <p class="tx-medium mg-b-0"> $money</p> <small class="tx-12 tx-success mg-b-0">success</small><br> </div> </li>'; } ?>