17'C 비
서울 강남구
list.skin.php
<?php
if ($is_category && $list[$i]['ca_name']) {
if($list[$i]['ca_name']=='진행중'){
$new_date = strtotime((date("Y-m-d H:i:s")));
$wr_1_date = strtotime((date("Y-m-d H:i:s",strtotime($list[$i]['wr_1'])) ));
if($new_date-($wr_1_date*1)>0){
$sql = " update {$write_table}
set ca_name = '종료'
where wr_id = '{$list[$i]['wr_id']}' ";
sql_query($sql);
}
}
$sql = " select * from {$write_table} where wr_id = '{$list[$i]['wr_id']}' ";
$ca_name_list = sql_fetch($sql);
?>
<a href="<?php echo $list[$i]['ca_name_href'] ?>" class="bo_cate_link"><?php echo $ca_name_list['ca_name'] ?></a>
<?php } ?>
view.skin.php
<header>
<h2 id="bo_v_title">
<?php
if ($category_name) {
if($view['ca_name']=='진행중'){
$new_date = strtotime((date("Y-m-d H:i:s")));
$wr_1_date = strtotime((date("Y-m-d H:i:s",strtotime($view['wr_1'])) ));
if($new_date-($wr_1_date*1)>0){
$sql = " update {$write_table}
set ca_name = '종료'
where wr_id = '{$view['wr_id']}' ";
sql_query($sql);
}
}
$sql = " select * from {$write_table} where wr_id = '{$view['wr_id']}' ";
$ca_name_view = sql_fetch($sql);
?>
<span class="bo_v_cate"><?php echo $ca_name_view['ca_name']; // 분류 출력 끝 ?></span>
<?php } ?>
<span class="bo_v_tit">
<?php
echo cut_str(get_text($view['wr_subject']), 70); // 글제목 출력
echo "<br>".cut_str(get_text($view['wr_1']), 20); // 글제목 출력
?></span>
</h2>
</header>
write.skin.php
<label for="wr_1" class="sound_only">종료시간</label>
<input type="datetime-local" name="wr_1" value="<?php echo $write[wr_1] ?>" id="wr_1" class="frm_input half_input" size="50" placeholder="종료시간">