PHP中的MySQL日期格式

Question

How can i show this as a DAY rather than full date

echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['date'] . "</td>";

i already have

date_default_timezone_set('Europe/London');

i have a similar question already asked but mistakenly put it as MYSQLi but i need MYSQL PHP support on this

the date and time is correctly set for the timezone but on viewing the PHP i want to view it as a Day

Answer 1

Use the date() function in PHP to change the date format...

date('l',strtotime($row['date']));

So your code changes to this...

echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . date('l',strtotime($row['date'])) . "</td>";

Info on date()

Date can display in many different ways...

date('Y-m-d');  //2013-06-17 format
date('z'); //day of the year
date('l'); //textual day of week

See here for details...

http://php.net/manual/en/function.date.php

UPDATE

You are having trouble with the format, so you can fix it like this...

$date = explode(" ",$row['date']);
$date2 = explode("/",$date[0]);
$displayDay = date('l',strtotime($date2[2]."-".$date2[1]."-".$date2[0]));

Then just echo that line with

echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $displayDay  . "</td>";