How to echo date parts separately

I have found place online where they answer different things, but I still don't get how I can apply it to my code.

Basically I want the month in one echo-line, and the day-number in another echo.

Is there away to do that in my code?

  <?php 
  // Connects to your Database 
  $data = mysql_query("SELECT id, title, description, location, date FROM Calendar") 
  or die(mysql_error());  
  while($row = mysql_fetch_array( $data )) 
  { 

  e开发者_Go百科cho "<article>";
  echo "<date>"; 
  echo "<h3>" .$row['date(month)'] . "</h3>";
  echo "<h4>" .$row['date(day)'] . "</h4>"; 
  echo "</date>";

  echo "</article>";
  }
  ?>   

---

You should be able to just pass the date straight through strtotime:

$month = date('m', strtotime($row['date']));
$day = date('d', strtotime($row['date']));

But this will depend on the format the date is stored in the database. This should work for a TIMESTAMP type column or a UNIX timestamp, or (for the most part) a string representation of a date.

---

Here's a way to get them ahead of time in your MySQL query, as an alternative to parsing them out later in PHP.

$data = mysql_query("SELECT id, title, description, location, DATE_FORMAT(date, '%m') AS `month`, DATE_FORMAT(date, '%d') AS `day` FROM Calendar") 
  or die(mysql_error());

Then to access them:

while($row = mysql_fetch_array( $data )) 
{ 
   echo $row['month'];
   echo $row['day'];
}

Alternatively to get the month's name instead of number, use DATE_FORMAT(date, '%M') as month

MySQL DATE_FORMAT() documentation

---

You first get the unix time of the date and then format two different strings.

---

If you want to echo date as exactly the name of the month, you can use 'F'. Like this:

$month = date('F', strtotime($row['dateRepaired']));