mysql pdo 커넥션

mysql pdo 커넥션

$host = 'localhost';
$database = 'database ';
$user = 'user';
$password = 'password ';


try {
	$PDO = new PDO('mysql:host='.$host.';dbname='.$database.';charset=utf8',$user,$password);
	$PDO -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	$PDO -> setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

	$sql = "select * from table_name";

	$rs = $PDO -> prepare($sql);

	$rs->execute();

	$row = $rs->fetch(PDO::FETCH_ASSOC);


	echo "<pre>";
	print_r($row);
	echo "</pre>";


} catch(PDOException $Exception) {
	die('연결실패'.$Exception->getMessage());
}