$val){ $arg = filter_input_array(INPUT_GET,FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_BACKTICK | FILTER_FLAG_STRIP_HIGH); } include("../lib/common.cgi"); require_once("../lib/htmltemplate.php"); include("./common/site.php"); include("./common/cm.php"); include("/home/politician-cafe/lib/auth.php"); include("./common/navi.php"); include("./common/footer.php"); //ここまで //公約政治家情報 $sql_s1 = "SELECT * FROM giin where g_id = '{$arg['gid']}' ;"; //echo "{$sql_s1}
"; $result_s1 = mysqli_query($cnn,$sql_s1); while ($data_s1 = mysqli_fetch_assoc($result_s1)){ $namae = "{$data_s1['g_name_1']}"."{$data_s1['g_name_2']}"; //選挙区文 if($data_s1['g_se_id'] != "0"){ $sql_s1s = "SELECT * FROM senkyo_kind where se_id = '{$data_s1['g_se_id']}';"; //echo "{$sql_s1s}
"; $result_s1s = mysqli_query($cnn,$sql_s1s); while ($data_s1s = mysqli_fetch_assoc($result_s1s)){ $data_s1['se_name'] = $data_s1s['se_name']; //何県の知事? if(($data_s1['g_se_id'] == "14" || $data_s1['g_se_id'] == "15" || $data_s1['g_se_id'] == "16" || $data_s1['g_se_id'] == "17" || $data_s1['g_se_id'] == "1002" || $data_s1['g_se_id'] == "1003" || $data_s1['g_se_id'] == "1004" || $data_s1['g_se_id'] == "1005") && $data_s1['g_a1_id'] != "0"){ $sql_s1s2 = "SELECT * FROM area_1 where a1_id = '{$data_s1['g_a1_id']}';"; //echo "{$sql_s1s2}"; $result_s1s2 = mysqli_query($cnn,$sql_s1s2); while ($data_s1s2 = mysqli_fetch_assoc($result_s1s2)){ $data_s1['f_name'] = $data_s1s2['a1_name']; } } //市町村? if(($data_s1['g_se_id'] == "19" || $data_s1['g_se_id'] == "20" || $data_s1['g_se_id'] == "21" || $data_s1['g_se_id'] == "22" || $data_s1['g_se_id'] == "23" || $data_s1['g_se_id'] == "24" || $data_s1['g_se_id'] == "25"|| $data_s1['g_se_id'] == "1006" || $data_s1['g_se_id'] == "1007" || $data_s1['g_se_id'] == "1008" || $data_s1['g_se_id'] == "1009" || $data_s1['g_se_id'] == "1010" || $data_s1['g_se_id'] == "1011"|| $data_s1['g_se_id'] == "26") && $data_s1['g_a2_id'] != "0"){ $sql_s1s3 = "SELECT * FROM area_2 where a2_id = '{$data_s1['g_a2_id']}';"; //echo "{$sql_s1s3}"; $result_s1s3 = mysqli_query($cnn,$sql_s1s3); while ($data_s1s3 = mysqli_fetch_assoc($result_s1s3)){ $data_s1['f_name'] = $data_s1s3['a2_name']; } } } } $arg['data_s1'][] = $data_s1; } // 現在のページを取得 // デバッグ用 //var_dump($_GET); // 現在のページを取得 $page = isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0 ? (int)$_GET['page'] : 1; //var_dump($_GET['page'], $page); // ← ここで確認 //$arg['page'] = $_GET['page']; //var_dump($arg['page']); // ← ここで確認 //print_r($arg['page']); $limit = 20; // 1ページあたりの件数 $offset = ($page - 1) * $limit; // オフセット(ページ番号に基づいて) // 総件数と総ページ数の計算 $sql_count = "SELECT COUNT(*) AS total FROM koudou WHERE ko_g_id = '{$arg['gid']}' AND ko_f = '1'"; $count_result = mysqli_query($cnn, $sql_count); $total_rows = mysqli_fetch_assoc($count_result)['total']; $total_pages = ceil($total_rows / $limit); // 総ページ数 if ($total_rows > 0) { $arg['kodoaru'] = 1; } if($total_rows > 20){ if($arg['page'] == ""){ $arg['page'] = 1; } $arg['hukusu_p'] = 1; } if ($total_rows > $limit) { $arg['tochu'] = 1; } // 1ページあたりの表示するリンク数(最大) $max_links = 10; // ページリンクの表示範囲を設定 $start_page = max(1, $page - floor($max_links / 2)); // 現在のページを中心に前後5ページ $end_page = min($total_pages, $start_page + $max_links - 1); // 最大10個のリンクを表示 // 1ページ目かどうか、最終ページかどうかを判定 $is_first_page = ($page == 1); $is_last_page = ($page == $total_pages); // $arg['pages'] の設定 if ($is_first_page) { $arg['pages'] = 1; // 最初のページ $arg['n_pages'] = $page + 1; } elseif ($is_last_page) { $arg['pages'] = 9; // 最後のページ $arg['p_pages'] = $page - 1; } else { $arg['pages'] = 2; // 中間のページ $arg['p_pages'] = $page - 1; $arg['n_pages'] = $page + 1; } // ページリンクを$arg['hoge']に格納 $pagination = ''; // ページタイトルの設定 if ($page > 1) { $arg['site_master']['title'] = "{$namae}の活動・発言の{$page}ページ目|政治家情報サイト「先生の通信簿」"; } else { $arg['site_master']['title'] = "{$namae}の活動・発言|政治家情報サイト「先生の通信簿」"; } $pagination .= ''; $pagination .= ''; // $arg['pager']にページリンクを格納 $arg['pager'] = $pagination; //ページ送りEND //活動のリストを出す $sql_k1 = "SELECT * FROM koudou,user WHERE ko_j_id = j_id AND ko_f = '1' AND ko_g_id = '{$arg['gid']}' ORDER BY ko_date DESC,ko_id DESC LIMIT {$limit} OFFSET {$offset}"; $result_k1 = mysqli_query($cnn, $sql_k1); $rows_k1 = mysqli_num_rows($result_k1); if($rows_k1 > 0){ $arg['ka_aru'] = "1"; } while ($data_k1 = mysqli_fetch_assoc($result_k1)){ //$data_k1['ko_title'] // 「【」「】」「*」を削除 $data_k1['ko_text'] = str_replace(['【', '】', '*'], '', $data_k1['ko_text']); //コメント数を出す $sql_k1com = "SELECT kr_id FROM koudou_re where kr_ko_id = '{$data_k1['ko_id']}' and kr_f = '1' ;"; //echo "{$sql_s1}
"; $result_k1com = mysqli_query($cnn,$sql_k1com); $data_k1['rows_k1com'] = mysqli_num_rows($result_k1com); //本文を短くするかもっす //$data_k1['ko_text'] = mb_strimwidth("{$data_k1['ko_text']}", 0, 150, "...", 'UTF-8'); //画像の有無 $filename_1 = "/home/politician-cafe/www/action_img/{$data_k1['ko_sess']}_1.jpg"; //echo "{$filename_1}
"; if (file_exists($filename_1)) { $data_k1['img_jpg_1'] = "1"; }else{ $data_k1['img_jpg_1'] = "0"; } //画像の有無END $arg['data_k1'][] = $data_k1; } include("/home/politician-cafe/lib/giin_pv.php"); //include("/home/politician-cafe/lib/kouyaku_pv.php"); //print_r($arg); htmltemplate::t_include("./tmpl/politician_activity.html",$arg);