How to list BD query

Question

Good night!
How do I list a query in the database?
I have a bank where you store singers and their songs...
I wanted to list Spotify style, listing numerally according to the amount of content in the database.

Answer 1

I see my example in db:

Code:

<?php
    $mysqli = new mysqli("host", "user", "senha", "db");

    if (mysqli_connect_errno()) {
        printf("Connect failed: %s\n", mysqli_connect_error());
        exit();
    }

    $count = 1;

    if ($sth = $mysqli->query("SELECT * FROM artistas")){
        while ($row = $sth->fetch_assoc()){
            echo $count . " - " . $row['cantor'] . "<br>";
            $count++;
        }
    }

Upshot: