Forming an Array in a Loop with an SQL Query in PHP

Of course, manually iterating through all employees is not very convenient. Let a loop do it for us:

php<?php
  for ($data = []; $row = mysqli_fetch_assoc($res); $data[] = $row);
  var_dump($data); // here will be an array with the result
?>

Let's figure out how this loop works.

In each iteration of the loop, the mysqli_fetch_assoc function sequentially reads each row of the result, writing it to the $data array.

As soon as the rows in $res run out, mysqli_fetch_assoc will return NULL and the loop will finish its work. The obtained result will be in a two-dimensional array $data.

Задание 1

Using the described loop, get and display an array of all employees via var_dump.

Задание 2

From the obtained result, get the first employee. Display their name via echo.

Задание 3

From the obtained result, get the second employee. Display their name and age via echo.

Задание 4

From the obtained result, get the third employee. Display their name, age, and salary via echo.