<?php
header("Content-type: text/html; charset=utf-8");
define("DBSERVER","localhost");
define("DBUSER","root");
define("DBPASSWORD","root");
define("DBNAME","sampledb");
//DB接続
if(!$con = @mysql_connect(DBSERVER, DBUSER, DBPASSWORD)){
die("MySQLに接続できませんでした！<br>");
exit();
}
//DB選択
if(!$selectdb = @mysql_select_db(DBNAME)){
die(DBNAME . "が見つかりませんでした！<br>");
exit();
}
//文字コードセット
if(!$result =@mysql_query("SET NAMES utf8;")){
echo "sqlエラー！<br>";
}
$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 >= 1000 AND point <= 1300";
if(!$result =@mysql_query($sql)){
echo "sqlエラー！<br>";
}
$body .= "【pointが1000～1300のデータ】";
$body .= $table_head;
while($col = mysql_fetch_array($result)){
$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>";
}
$body .= $table_foot;
//結果を破棄
mysql_free_result($result);
//データ取得
$sql = "SELECT * FROM fifaranking WHERE (point > 1500 OR point < 1000) AND area = '南米'";
if(!$result =@mysql_query($sql)){
echo "sqlエラー！<br>";
}
$body .= "【pointが1500以上または1000未満でareaが南米のデータ】";
$body .= $table_head;
while($col = mysql_fetch_array($result)){
$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>";
}
$body .= $table_foot;
//結果を破棄
mysql_free_result($result);
//DB切断
if(!$con = @mysql_close()){
die("MySQLとの接続を解除できませんでした！<br>");
exit();
}
?>
<!DOCTYPE HTML>
<html lang="ja-JP">
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<?=$body?>
</body>
</html>