php - 当我从Mysqli调用它时，将月号转换为月份短名称

Question

I am calling the data from Mysqli and in my table it appear like this 2012-10-05 I need to call it near my new to be display like this <span class="date"><strong>28</strong><span>may</span></span> no I have two values one is the day and the other is month and also I'd like it to appear as number for day and short name for month eg.Feb May

this is my PHP code

<?php
    $getNews="SELECT * FROM news";
    $QgetNews=$db->query($getNews)or die($db->error);
?>

Answer 1

You can use date() and strtotime() for that.

<?php
// $QgetNews->date = 10-05-2012
echo date('d M, Y', strtotime($QgetNews->date)); // 10 May, 2012

CodePad