https://www.w3schools.com/php/func_mysqli_fetch_assoc.asp
https://mrszeto.net/ict/web-ict/student2024.sql

<?php
$con = mysqli_connect("localhost","root","","test");

if (!$con) {
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
	exit();
}

$sql = "SELECT * FROM student WHERE class like '1A'";
$result = mysqli_query($con, $sql);
$nrows = mysqli_num_rows($result);

//----------
echo "<ol>";
while ($row = mysqli_fetch_assoc($result)) {
	echo "<li>{$row["id"]} - {$row["class"]} {$row["name"]}</li>";
}
echo "</ol>";

//----------
mysqli_data_seek($result,0);
echo "<ul>";
while ($row = mysqli_fetch_row($result)) {
	echo "<li>{$row[0]} - {$row[4]} - {$row[2]} {$row[1]}</li>";
}
echo "</ul>";

mysqli_free_result($result);
mysqli_close($con);
?>