setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql_long_count = $pdo->query("SELECT
count(*)
from long_work_mt
where indication_flag='t' AND top_flag='t'");
$count_long_datas = $sql_long_count->fetchAll(PDO::FETCH_ASSOC);
$page_all = $count_long_datas[0]['count'];
include __dir__.'/../layout/pagenate.html';
$sql_long = $pdo->query("SELECT
long_work_mt.id,
long_work_mt.title,
long_work_mt.update_date,
long_work_mt.index,
long_work_ct_rc.title AS icon_title,
icon FROM long_work_mt
INNER JOIN long_work_ct_rc
ON long_work_mt.sub_id=long_work_ct_rc.id
WHERE indication_flag='t' AND top_flag='t'
ORDER BY update_date DESC
LIMIT 8
OFFSET {$current_page}" );
$long_datas = $sql_long->fetchAll(PDO::FETCH_ASSOC);
for($i = 0; $i < count($long_datas); $i++){
$tmp = substr($long_datas[$i]['update_date'],0,10);
$tmp = str_replace("-", '/',$tmp);
$long_datas[$i]['update_date'] = $tmp;
}
?>
$i";
}else{
echo "- $i
";
}
$x++;
if($i == $maxpage){
break;
}
}?>
