본문 바로가기
프로그램/PHP

[PHP]날짜 요일 구하기

by 주원대디 2013. 2. 1.

[PHP] 날짜 요일 구하기

<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>