<?php
$host = "localhost";
$user = "UserName";
$password = "Password";
$dbName = "DatabaseName";
// Connect to the database
$dbh = new PDO("mysql:host=$host;dbname=$dbName", $user, $password);
$sql = "
SELECT
Language, Percentage
FROM countrylanguage
WHERE CountryCode = 'RUS'
ORDER BY Percentage DESC";
foreach ($dbh->query($sql) as $row) {
echo $row[0] . ": " . $row[1], "\n";
}
$dbh = null;