require("./admin/common.php");
//クラスファイル取り込み
require_once("./admin/my_sql.php");
session_start();
$_SESSION['ret_url'] = "index.php";
$my_page_parts = pathinfo($_SERVER["PHP_SELF"]);
$my_page = $my_page_parts['basename'];
$title = "家具 和家具 家具の七福市 高級家具";
$search_words = "七福市,家具,りーふ";
$description = "和家具 家具の七福市 (株)りーふ の通販サイト";
$group_id = "";
$disp_order = "";
$condition = "";
//クラスインスタンス作成
$class_sql = new class_MySQL;
//アクセスカウンター更新
//$sql = "SELECT AccessDate,top,result,item_detail FROM T_Access";
$now_date_str = "'" . date( 'Y-m-d' ) . "'";
$sql = "SELECT AccessDate FROM T_Access WHERE AccessDate = " . $now_date_str;
$class_sql->sql_query($sql);
if($row = $class_sql->sql_fetch()){
$sql = "UPDATE T_Access SET top = top + 1 WHERE AccessDate = " . $now_date_str;
}else{
$sql = "INSERT INTO T_Access (AccessDate,top,result,item_detail) VALUES (" . $now_date_str . ",1,0,0)";
}
$class_sql->sql_query($sql);
//先頭メッセージ表示
$clm_no = 0;
$sql = "SELECT ItemLastUpdate FROM T_SystemInfo WHERE ID = 1";
$class_sql->sql_query($sql);
if($row = $class_sql->sql_fetch()){
$last_update ="最終更新日:" . date('Y/m/d', $row['ItemLastUpdate']);
}
$sql = "SELECT * FROM TM_Mess ORDER BY MessID";
$class_sql->sql_query($sql);
while($row = $class_sql->sql_fetch()){
if($row['MessID'] == 1){
$comment_top1 = $row['Mess'];
}else if($row['MessID'] == 2){
$top_tytle = $row['Mess'];
}else if($row['MessID'] == 3){
$top_keyword = $row['Mess'];
}
}
if($top_tytle != ""){
$title = $top_tytle;
}
if($top_keyword != ""){
$search_words = $top_keyword;
}
?>
if($description != ""){
echo "\r\n";
}
if($search_words != ""){
echo "\r\n";
}else{
echo "\r\n";
}
?>
$max_clm_no = 4;
$one_clm_w = 150;
// $comment_clm_w = 150;
if($last_update != ""){
echo "$last_update |
";
}
if($comment_top1 != ""){
echo "$comment_top1 |
";
}
// if($comment_top2 != ""){
// echo "$comment_top2 |
";
// }
//echo "
|
";
$sql = "SELECT * FROM TM_Group WHERE PCode = 0 ORDER BY DispOrder";
$class_sql->sql_query($sql);
while($row = $class_sql->sql_fetch()){
if($clm_no == 0){
echo "";
}
echo "";
$group_code = $row["GroupCode"];
$grpup_name = $row["GroupName"];
$pic_url = stripslashes($row["Picture"]);
$pic_tytle = $row["PicTytle"];
echo <<
$grpup_name |
 |
$comment1 |
〉
- 商品一覧へ - |
EOT;
echo " | ";
$clm_no += 1;
if($clm_no == $max_clm_no){
$clm_no = 0;
echo "
";
//echo "
|
";
}
}
if($clm_no > 0){
//カラム数揃ってない場合
while($clm_no < $max_clm_no){
echo " | ";
$clm_no += 1;
}
echo "";
//echo "
|
";
}
?>