Untitled

<html>
<head>
<meta charset="utf-8";>
<title>db</title>
</head>
<body>
<?php
$host = 'localhost';
$user = 'root';
$password = '';
$db_name = 'test';

    $link = mysqli_connect($host, $user, $password, $db_name) or die(mysqli_error($link));


     mysqli_query($link, "SET NAMES 'utf8'");

        //$query = "INSERT INTO workers SET name='Никита', age=26, salary=300 ";
        //$query = "INSERT INTO workers (name,age,salary) VALUES ('Петр',31,1000) , ('Ярослав',30,1200)";
        //$query = "DELETE FROM workers WHERE age=23";
        //$query = "UPDATE workers SET salary=5000 WHERE salary=1000";
        //$query = "SELECT COUNT(*) as count FROM workers WHERE salary<4300 and salary>1000";

        $query = "SELECT * FROM workers WHERE id>0 ";


        $result = mysqli_query($link, $query) or die(mysqli_error($link));

        //$count = mysqli_fetch_[$result];


    //var_dump('<br>',$data);

    echo '<table border="1" cellpadding="0" cellspacing="0" width="300" height="300">';

    echo '<tr>
        <th>id</th>
        <th>name</th>
        <th>age</th>
        <th>salary</th>
    </tr>';

    $row = mysqli_fetch_assoc($result);


            echo "<tr>";

        echo "<td>".$row['id']."</td>";
        echo "<td>".$row['name']."</td>";
        echo "<td>".$row['age']."</td>";
        echo "<td>".$row['salary']."</td>";

        echo "</tr>";


    echo "</table>";


?>
</body>
</html>