<?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 team LIKE 'ア%'"; if(!$result =@mysql_query($sql)){ echo "SQLエラー!<br>"; } $body .= "【teamがアで始まるデータ】"; $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 team LIKE '%ラン%'"; if(!$result =@mysql_query($sql)){ echo "SQLエラー!<br>"; } $body .= "【teamにランを含むデータ】"; $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 team LIKE '%アイ'"; if(!$result =@mysql_query($sql)){ echo "SQLエラー!<br>"; } $body .= "【teamがアイで終わるデータ】"; $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>