프로그램/PHP
[PHP]날짜 요일 구하기
by 주원대디
2013. 2. 1.
<table>
<?
$SQL = "Select *,date_format(regdate,'%Y') as year, date_format(regdate,'%m') as month, date_format(regdate,'%d') as day from dbname where 1 order by regdate desc";
$result = mysql_query($SQL);
while($row = mysql_fetch_array($result)){
$week = date("w", mktime(0,0,0,$row[month],$row[day],$row[year]));
switch($week){
case 0 : $week_day = "(일)"; $bgcolor='#c8c8c8'; break;
case 1 : $week_day = "(월)"; $bgcolor='#d3ecf6'; break;
case 2 : $week_day = "(화)"; $bgcolor='#d3ecf6'; break;
case 3 : $week_day = "(수)"; $bgcolor='#d3ecf6'; break;
case 4 : $week_day = "(목)"; $bgcolor='#d3ecf6'; break;
case 5 : $week_day = "(금)"; $bgcolor='#d3ecf6'; break;
case 6 : $week_day = "(토)"; $bgcolor='#c8c8c8'; break;
default: $bgcolor='#d3ecf6';
}
echo "<tr bgcolor=\"{$bgcolor}\" align=\"center\">
<td align=\"center\">{$row[year]}-{$row[month]}-{$row[day]} {$week_day}</td>
</tr> ";
}
?>
</table>