'SET NAMES utf8mb4' ) ); $sql = "SELECT * FROM `corner` WHERE `no` = '".$corner_no."' LIMIT 1;"; $resulte = $dbh->query( $sql ); $corner_res = $resulte->fetchall(PDO::FETCH_ASSOC); $sql = "SELECT * FROM `channel` WHERE `no` = '".$corner_res[0]['channel_no']."' LIMIT 1;"; $resulte = $dbh->query( $sql ); $channel_res = $resulte->fetchall(PDO::FETCH_ASSOC); $sql = "SELECT * FROM `curator` WHERE `no` = '".$corner_res[0]['charge_curator_no']."' LIMIT 1;"; $resulte = $dbh->query( $sql ); $curator_res = $resulte->fetchall(PDO::FETCH_ASSOC); $sql = "SELECT * FROM `report` WHERE `status` = 'OPEN' AND `corner_no` = '".$corner_no."' ORDER BY `open_time` DESC, `url` DESC ;"; $resulte = $dbh->query( $sql ); $report_res = $resulte->fetchall(PDO::FETCH_ASSOC); $basematch_array = array(); foreach( $corner_res[0] as $db_key => $db_data ) { $basematch_array['<-DB:corner-'.$db_key.'->'] = $db_data; } foreach( $channel_res[0] as $db_key => $db_data ) { $basematch_array['<-DB:channel-'.$db_key.'->'] = $db_data; } foreach( $curator_res[0] as $db_key => $db_data ) { $basematch_array['<-DB:curator-'.$db_key.'->'] = $db_data; } ?> <?php echo $corner_res[0]['title'] ?> | <?php echo $channel_res[0]['title'] ?> | セレブリティーライフスタイル「OK!」マガジンの日本公式WEBマガジン「OK!JAPAN」


    $db_data ) { $match_array['<-DB:report-'.$db_key.'->'] = $db_data; } if( strtotime( '-1 day', time() ) < strtotime( $report_data['open_time'] ) ) { $match_array['<-DB:report-title->'] = 'NEW!! '.$match_array['<-DB:report-title->']; } $match_array['<-DB:report-thumbnail->'] = strtr( $report_data['thumbnail'], array( ' ' => '%20' ) ); $viewText = strtr( $tempText, $basematch_array ); $viewText = strtr( $viewText, $match_array ); echo $viewText; } ?>
前の8件'; } $max_page = ceil( count( $report_res ) / 8 ); $linkstart_page = $page - 5; if( ( $linkstart_page + 10 ) > $max_page ) { $linkstart_page = $max_page - 10; } if( $linkstart_page < 1 ) { $linkstart_page = 1; } for( $i = 0; $i < 11; $i++ ) { $target_page = $linkstart_page + $i; if( $target_page > $max_page ) { break; } elseif( $target_page == $page ) { echo ''.$target_page.' '; } else { if( $target_page == 1 ) { $link_targethtml = "index.shtml"; } else { $link_targethtml = "index_".$target_page.".shtml"; } echo ''.$target_page.' '; } } if( $page != $max_page ) { $link_no = $page + 1; $link_nexthtml = "index_".$link_no.".shtml"; echo ''; } ?>

<?php echo $curator_res[0]['name'] ?> BLOGGER PROFILE

  • <?php echo $curator_res[0]['name'] ?>