Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$mysqli->query("create table User (id int, login varchar(255))");
$mysqli->query("insert User (id, login) VALUES (1, 'Vasya')");
$mysqli->query("insert User (id, login) VALUES (2, 'Petya')");
$result = $mysqli->query("SELECT id, login FROM User");
$data = $result->fetch_all(MYSQLI_ASSOC);
?>
<?php foreach ($data as $row): ?>
<tr>
<td><?= htmlspecialchars($login) ?></td>
</tr>
<?php endforeach ?>