Не получается с кодировкой в mysql бд

$host = "localhost";
$user = "Dreika";
$password = "Dreika";
$db = "redactor";
header( 'Content-Type: text/html; charset=utf8' );
mysql_connect( 'localhost', 'Dreika', 'Dreika' );
mysql_select_db( 'redactor' );
 mysql_set_charset( 'utf8' );

DEFINE('HOST','localhost'); //хост
DEFINE('USER','admin'); //юзер
DEFINE('PASS',1234); //пароль
DEFINE('DB_NAME','имя_базы_данных');
try {
$db = new PDO('mysql:host='.HOST.';dbname='.DB_NAME,USER,PASS); // подключение к БД
$res = $db->query("SELECT * FROM `table_name`");
while($row = $res->fetch(PDO::FETCH_ASSOC)) {
print_r($row);
}
} 
catch (PDOException $e) {
echo $e->getMessage();
}

DEFINE('HOST','localhost'); //хост
DEFINE('USER','admin'); //юзер
DEFINE('PASS',1234); //пароль
DEFINE('DB_NAME','имя_базы_данных');
$link = mysqli_connect(HOST,USER,PASS,DB_NAME);
$res = mysqli_query($link,"SELECT * FROM `table_name`");
while($row = mysqli_fetch_assoc($res)) {
print_r($row);
}
mysqli_free_result($res);
mysqli_close($link);

DEFINE('HOST','localhost'); //хост
DEFINE('USER','admin'); //юзер
DEFINE('PASS',1234); //пароль
DEFINE('DB_NAME','имя_базы_данных');
$db = new mysqli(HOST,USER,PASS,DB_NAME);
if(!mysqli_connect_errno()) {
$res = mysqli->query("SELECT * FROM `table_name`");
while($row = $res->fetch_assoc()) {
print_r($row);
}
$res->close();
}
$db->close();

try {
}
catch {
}

mysqli_real_escape_string($link,$var);

$db = new PDO ....
$user = " ' or 1=1 -- f ";
$pass = 'qwerty';
$db->prepare("SELECT * FROM `table` Where `login`=:user AND `pass`=:pass");
$db->execute(array('user'=>$user,'pass'=$pass));