Answers for "how to fetch starting 4 values from aray in php"

fetch row in php

$sql = "SELECT Lastname, Age FROM Persons ORDER BY Lastname";
$result = $mysqli -> query($sql);
while ($row = $result -> fetch_row()) {
    //statements
  }

store fetched data into array php

<?php
$host='localhost';
$username='root';
$password='';
$conn=mysqli_connect($host,$username,$password,"student");
$category = mysqli_query($conn,"SELECT * FROM subcategory");
$category_id = [];
$i=0;
while($db_category  = mysqli_fetch_array($category)) {
    $category_id[]=$db_category["category_id"];
    
}
/* print_r($category_id); */
$category_name= mysqli_query($conn,"SELECT * FROM category where id IN ('" . implode("',' ",$category_id) . "')");
    $i=0;
while($db_category_name  = mysqli_fetch_array($category_name)) {
    echo $db_category_name["category_name"].'<br>';
    
}
?>