戻る

テーブルの全レコードを読み込む（PDO）

<?php
header("Content-type: text/html; charset=utf-8");

define("DBSERVER","localhost");
define("DBUSER","root");
define("DBPASSWORD","root");
define("DBNAME","sampledb");

//DB接続
$dsn = "mysql:host=".DBSERVER."; dbname=".DBNAME;

try{
	$dbh = new PDO($dsn, DBUSER, DBPASSWORD);
}
catch(PDOException $e) {
	die("接続エラー：" . $e->message);
}

//文字コードセット
try{
	$sth = $dbh->query("SET NAMES utf8");
}
catch(PDOException $e) {
	die("SQLエラー：" . $e->message);
}

//データ取得
$sql = "SELECT * FROM fifaranking";

try {
	$sth = $dbh->query($sql);
	
	$body = "";
	while($col = $sth->fetch(PDO::FETCH_ASSOC)){
		$body .= "<tr>";
		$body .= "<td align=\"center\">" . $col["rank"] . "</td>";
		$body .= "<td>" . $col["team"] . "</td>";
		$body .= "<td>" . $col["area"] . "</td>";
		$body .= "<td align=\"right\">" . $col["point"] . "</td>";
		$body .= "</tr>";
	}
}
catch (PDOException $e){
	die("SQLエラー：" . $e->message);
}


//DB切断
$dbh = null;
?>
<!DOCTYPE HTML>
<html lang="ja-JP">
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<table border="1">
<tr>
	<th>順位</th>
	<th>チーム</th>
	<th>地域</th>
	<th>ポイント</th>
</tr>
<?=$body?>
</table>
</body>
</html>

inserted by FC2 system