"",
"GOS" => "",
"HYO_C" => "",
"HYO_H" => "",
"HYO_R" => "",
"HYO_S" => "",
"HYO_F" => "",
"KAN" => "",
"KIN" => "",
"PUZ" => "",
"MIH" => "",
"POC" => "",
"KIT" => ""
);
$tStarsTag = array("",
"",
"",
"",
"",
""
);
$tShohinName = array(
"CHO" => "ちょこっとプラン",
"GOS" => "ごっそりプラン",
"HYO_C" => "表紙セット",
"HYO_H" => "表紙セット",
"HYO_R" => "表紙セット",
"HYO_S" => "表紙セット",
"HYO_F" => "表紙セット",
"KAN" => "還暦お誕生日新聞",
"KIN" => "記念日セット",
"PUZ" => "記念日パズル",
"MIH" => "見開きファイル",
"POC" => "ポケットファイル",
"KIT" => "退職記念日セット"
);
$tShohinOrder = array(
"CHO" => "ちょこっとプランの注文はこちら
",
"GOS" => "ごっそりプランの注文はこちら
",
"HYO_C" => "表紙セットの注文はこちら
",
"HYO_H" => "表紙セットの注文はこちら
",
"HYO_R" => "表紙セットの注文はこちら
",
"HYO_S" => "表紙セットの注文はこちら
",
"HYO_F" => "表紙セットの注文はこちら
",
"KAN" => "還暦お誕生日新聞の注文はこちら
",
"KIN" => "記念日セットの注文はこちら
",
"PUZ" => "記念日パズルの注文はこちら
",
"MIH" => "見開きファイルの注文はこちら
",
"POC" => "ポケットファイルの注文はこちら
",
"KIT" => "退職記念日セットの注文はこちら
"
);
$tKeyword = array(
0 => "",
1 => "誕生日プレゼント",
2 => "還暦プレゼント",
3 => "古希プレゼント",
4 => "喜寿プレゼント",
5 => "傘寿プレゼント",
6 => "米寿プレゼント",
7 => "卒寿プレゼント",
8 => "白寿プレゼント",
9 => "百寿プレゼント",
10 => "銀婚式プレゼント",
11 => "金婚式プレゼント",
12 => "ダイヤモンド婚式プレゼント",
13 => "結婚記念日プレゼント",
14 => "退職プレゼント",
15 => "その他プレゼント"
);
$tData = array();
$Connect = @mysql_connect("localhost", MYSQL_USER, MYSQL_PASS);
mysql_select_db(MYSQL_DB, $Connect);
mysql_query('SET NAMES utf8', $Connect);
$sJokenStar = "";
if(isset($_GET['s'])) {
$sJokenStar = "AND manzoku = ".$_GET['s'];
}
$sql = <<< EOT
SELECT
manzoku,
kansou,
name,
address,
chumon_bi,
shohin,
CASE
WHEN title IS NULL THEN
CASE
WHEN manzoku = 1 THEN "★5の評価です"
WHEN manzoku = 2 THEN "★4の評価です"
WHEN manzoku = 3 THEN "★3の評価です"
WHEN manzoku = 4 THEN "★2の評価です"
WHEN manzoku = 5 THEN "★1の評価です"
ELSE ""
END
ELSE title
END AS title,
CASE
WHEN keyword IS NULL THEN 0
ELSE keyword
END AS keyword
FROM
questionnaire2 AS anq_main
LEFT JOIN questionnaire_sub AS anq_sub
ON anq_main.chumon_bango = anq_sub.chumon_bango
WHERE
keisai_kyoka = 1
$sJokenStar
ORDER BY
unique_number DESC
LIMIT 2000
EOT;
$result = mysql_query($sql);
$iI = 0;
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
if($row['kansou'] == "<未解答>") {
continue;
}
//print("\n");
$tData[$iI][] = $row['manzoku'];
$tData[$iI][] = str_replace("\r", "", $row['kansou']);
$tData[$iI][] = $row['name'];
$tData[$iI][] = $row['address'];
$tData[$iI][] = $row['chumon_bi'];
$tData[$iI][] = $row['shohin'];
$tData[$iI][] = $row['title'];
$tData[$iI][] = $row['keyword'];
$iI ++;
}
mysql_close($Connect);
/***
print("\n");
***/
$pageNo = 0;
$titleAddition = "1";
if(isset($_GET['p'])) {
$titleAddition = $_GET['p'];
}
$titleAddition = "(" . $titleAddition . "ページ)";
?>
お誕生日新聞をプレゼントして良かった!お客様のレビュー・口コミのご紹介です!
first_num;
$last_num = $i_pager->last_num;
for($i = $first_num; $i <= $last_num; $i++) {
$tShohin = explode("/", $tData[$i][5]);
$sShohin = "";
$sShohinName = "";
$sShohinOrder = "";
for($j = 0; $j < count($tShohin); $j++) {
$sShohin .= $tShohinTag[$tShohin[$j]];
if(strlen($sShohinName) != 0) {
$sShohinName .= ", ";
}
$sShohinName .= $tShohinName[$tShohin[$j]];
if(strpos($sShohinOrder, $tShohinOrder[$tShohin[$j]]) === false) {
$sShohinOrder .= $tShohinOrder[$tShohin[$j]];
}
}
$sMessage = str_replace("\n", "
", trim($tData[$i][1]))."
";
$sStar = $tStarsTag[$tData[$i][0]];
$tDate = explode("-", $tData[$i][4]);
$sDate = sprintf("%d年%d月%d日", $tDate[0], $tDate[1], $tDate[2]);
$sUser = "(".$tData[$i][3]." ".$tData[$i][2]." 様のレビュー)";
$sPurchaseDate = "購入日:".$sDate;
$sTitle = $tData[$i][6];
$sKeyword = $tKeyword[$tData[$i][7]];
if(strlen($sKeyword) != 0) {
$sKeyword .= " ";
}
?>
8, // ページ番号を何個表示するか
"first_mark" => "最初", // 「最初へ」リンクの文字列
"last_mark" => "最後", // 「最後へ」リンクの文字列
"prev_mark" => "<前", // 「前へ」リンクの文字列
"next_mark" => "次>", // 「次へ」リンクの文字列
"theme" => "green", // テーマ(green blue simpleしかないです)
"radius" => "radius"); // radius で角丸(多分IE除く)
$i_pager->print_list($param);
?>
▲