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