PHP - mysql select query example

    
        $db = mysqli_connect('host', 'dbUser', 'dbPassword', 'dbName');
        $query = $db->query("SELECT * FROM `country`");
        while($row = $query->fetch_assoc()) {
            echo $row['id'] . '|' . $row['name'] . '
' . PHP_EOL; } // output // 1|France // 2|Russia // 3|Italy // 4|Spain