QUALL – blog

PHPでデータベース（MySQL）からの出力をソートする。
ロジックを備忘録。
[PHP]

//データベース設定
$server = "localhost"; //サーバー名
$user = "root"; //ユーザー名
$passwd = ""; //パスワード
$dbname = "subject"; //データベース名

mysql_connect($server, $user, $passwd);
mysql_select_db($dbname);

//パラメータによってソート項目を変更
if ($_GET['judge'] == "") {
//初期化状態の場合デフォルトは1
$_GET['judge'] = 1;
}
switch($_GET['judge'] % 10) {
case 1:
$sort = "applicantNo";
break;

case 2:
$sort = "name_1";
break;

case 3:
$sort = "birthday_year";
break;
}

if ($_GET['judge'] < 10) {
$base = 10;
$sortby = 'ASC';
} else {
$base = 0;
$sortby = 'DESC';
}

//SQL文の設定
$sql = "SELECT * FROM `applicant` ORDER BY `{$sort}` {$sortby}";

//SQL文の実行
if($db_result = mysql_query($sql)) {
echo '

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;

while ($row = mysql_fetch_array($db_result)) {
echo ‘

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo ‘

‘;
}
echo ‘

‘;
} else {
echo mysql_error();
}
mysql_close();

[/PHP]

No related posts.