<?php
define('DSN', 'mysql:host=localhost;dbname=test;charset=utf8');
define('USER', 'root');
define('PASS', '');
try {
$pdo = new PDO(DSN, USER, PASS);
$pdo->query('set names utf8');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (PDOException $e) {
echo $e->getMessage();
exit;
}
try {
$sql="select * from user";
$res=$pdo->query($sql);
foreach ($res as $key => $value) {
echo 'id:'.$value['id'].'<br>';
echo 'name:'.$value['username'].'<br>';
echo 'password:'.$value['password'].'<br>';
echo '<hr>';
}
} catch (PDOException $e) {
echo $e->getMessage();
exit;
}
?>