Thank you so much! It worked the new code I have is:
<?php
$db = new PDO('mysql:host=localhost;dbname=test_wp166;charset=utf8', 'test_wp7474', '*****');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
foreach($db->query('SELECT...