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