戻る

条件にあったレコードのみ取り出す（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);
}


$table_head = "<table border=\"1\">";
$table_head .= "<tr>";
$table_head .= "<th>順位</th>";
$table_head .= "<th>チーム</th>";
$table_head .= "<th>地域</th>";
$table_head .= "<th>ポイント</th>";
$table_head .= "</tr>";

$table_foot = "</table>";

$body = "";

//データ取得
$sql = "SELECT * FROM fifaranking WHERE point >= 1500";


//データ取得
$sql = "SELECT * FROM fifaranking WHERE point >= 1500";

$body .= "【Pointが1500以上のデータ】";
$body .= $table_head;

try {
	$sth = $dbh->query($sql);
	
	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);
}

$body .= $table_foot;


//データ取得
$sql = "SELECT * FROM fifaranking WHERE point < 820";

$body .= "【Pointが820未満のデータ】";
$body .= $table_head;

try {
	$sth = $dbh->query($sql);
	
	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);
}

$body .= $table_foot;


//データ取得
$sql = "SELECT * FROM fifaranking WHERE area = '北中米'";

$body .= "【areaが北中米であるデータ】";
$body .= $table_head;

try {
	$sth = $dbh->query($sql);
	
	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);
}

$body .= $table_foot;


//データ取得
$sql = "SELECT * FROM fifaranking WHERE area <> 'ヨーロッパ'";

$body .= "【areaがヨーロッパでないデータ】";
$body .= $table_head;

try {
	$sth = $dbh->query($sql);
	
	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);
}

$body .= $table_foot;

//DB切断
$dbh = null;
?>
<!DOCTYPE HTML>
<html lang="ja-JP">
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<?=$body?>
</body>
</html>

inserted by FC2 system