'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;
}
?>
| | セレブリティーライフスタイル「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;
}
?>