'102' and r_id <> '70' */ //echo "{$sql_s1}
"; $result_s1 = pg_exec($sql_s1); $rows_s1 = pg_numrows($result_s1); // 抜き出したデータが何件あるか数える呪文 //echo "{$rows_s1}"; if($rows_s1 < 1){ $arg['datazero_new'] = "1"; $datazero_new = "ZERO"; }else{ $arg['dataaru_new'] = "1"; } $sw_c_1 = "0"; while($sw_c_1 < $rows_s1){ $kaw_s1 = pg_fetch_array($result_s1,$sw_c_1); $arg['data_s1'][$sw_c_1] = pg_fetch_array($result_s1,$sw_c_1); //echo "$hoge"; if(strlen("{$arg['data_s1'][$sw_c_1][d_bosyu]}") > 100){ $arg['data_s1'][$sw_c_1][d_bosyu] = mb_substr("{$arg['data_s1'][$sw_c_1][d_bosyu]}",0,100); $arg['data_s1'][$sw_c_1][d_bosyu] = "{$arg['data_s1'][$sw_c_1][d_bosyu]}"." ..."; } $sw_c_1++; } //print_r($arg['data_s1']); //オススメ $sql_s2 = "select m_name, d_id, d_bosyu, a1_name, a1_name_2, a2_name, r_name, d_sess, a1_name, s_name, d_appeal, k_name, d_kyuyo_gaku, d_sess from main,data,area_1,area_2,kyuyo,saiyou,rui where m_yusen_f = '1' and d_m_id = m_id and d_kyuyo = k_id and d_saiyou = s_id and d_r_id = r_id and d_area_2 = a2_id $sql_kaw and a1_id = d_area_1 and d_hyouji = '1' and d_mail_ch = '1' order by RANDOM() limit 14 "; //echo "$sql_s2"; $result_s2 = pg_exec($sql_s2); $rows_s2 = pg_numrows($result_s2); // 抜き出したデータが何件あるか数える呪文 if($rows_s2 == 0){ $arg[datazero] = "1"; } $sw_c_2 = "0"; while($sw_c_2 < $rows_s2){ $kaw_s2 = pg_fetch_array($result_s2,$sw_c_2); $arg['data_s2'][$sw_c_2] = pg_fetch_array($result_s2,$sw_c_2); //echo "$hoge"; if(strlen("{$arg['data_s2'][$sw_c_2][d_bosyu]}") > 16){ $hoge = $arg['data_s2'][$sw_c_2][d_kyuyo_gaku]; $arg['data_s2'][$sw_c_2][d_kyuyo_gaku] = number_format($hoge); $arg['data_s2'][$sw_c_2][d_bosyu] = mb_substr("{$arg['data_s2'][$sw_c_2][d_bosyu]}",0,16); $arg['data_s2'][$sw_c_2][d_bosyu] = "{$arg['data_s2'][$sw_c_2][d_bosyu]}"." ..."; $arg['data_s2'][$sw_c_2][d_appeal]= str_replace("\r\n", "", $arg['data_s2'][$sw_c_2][d_appeal]); $arg['data_s2'][$sw_c_2][d_appeal] = str_replace("\r", "", $arg['data_s2'][$sw_c_2][d_appeal]); $arg['data_s2'][$sw_c_2][d_appeal]= str_replace("\n", "", $arg['data_s2'][$sw_c_2][d_appeal]); if(strlen("{$arg['data_s2'][$sw_c_2][d_appeal]}") > 120){ $arg['data_s2'][$sw_c_2][d_appeal] = mb_substr("{$arg['data_s2'][$sw_c_2][d_appeal]}",0,120); $arg['data_s2'][$sw_c_2][d_appeal] = "{$arg['data_s2'][$sw_c_2][d_appeal]}"." ....."; } //画像表示 $img_pass_1 = "$site_web_dir"."/s_img/{$kaw_s2[d_sess]}_1.jpg"; $filename_1 = "$img_pass_1"; if (file_exists($filename_1)) { // echo "$filename_1 が存在します"; $arg['data_s2'][$sw_c_2]['d_img_1'] = 1; } else { // echo "$filename_1 は存在しません {$kaw_s1[d_sess]}"; } } $sw_c_2++; } //print_r($arg['data_s1']); //echo "{$bmode_kaw}::::::1111"; //echo "{$datazero}"; include("../common/header.php"); include("../common/footer.php"); include("../common/google_cm_2019.php"); htmltemplate::t_include("./tmpl/index.html",$arg);