How to fetch date(d,m,y) from phpmyadmin in php?

Question

I want to fetch date format from (y,m,d) to (d,m,y).In my database I already insert data like date and images so many around 400 images.I dun want to insert again.

The following is to fetch from database.

<?              
                            $sql = "SELECT * FROM  ShowFillter GROUP BY Image_Date order by Image_Date desc";
                            $objQuery = mysql_query($sql) or die ("Error Query [".$sql."]");
                            while($objResult1 = mysql_fetch_array($objQuery))
                            {
                        ?>
                        <li class="filter" data-filter="<?=$objResult1['Image_Date'];?>">
                            <a href="#">
                                <?=$objResult1['Image_Date'];?></a>
                        </li>

                        <? 
                            }    
                        ?>

The following is i tried it out to fetch from database.But It only show (Year ,Month,day) format.

<?              
                            $sql = "SELECT * FROM  ShowFillter GROUP BY DATE_FORMAT(Image_Date, '%d/%m/%Y') order by DATE_FORMAT(Image_Date, '%d/%m/%Y') desc";
                            $objQuery = mysql_query($sql) or die ("Error Query [".$sql."]");
                            while($objResult1 = mysql_fetch_array($objQuery))
                            {
                        ?>
                        <li class="filter" data-filter="<?=$objResult1['Image_Date'];?>">
                            <a href="#">
                                <?=$objResult1['Image_Date'];?></a>
                        </li>

                        <? 
                            }    
                        ?>

Here is the result Is it possible to fetch (day,month,year) format? If its possible ,guide me please.

Thanks :)

code image will not help to check the problem. put your code here in text. — Dave, Sep 12 '16 at 06:39
First of all, I'd suggest you not to use `mysql_* ` functions as they are deprecated. Another thing, do you want to format the date in query or php code? — A J, Sep 12 '16 at 06:39
Also http://stackoverflow.com/questions/10637581/mysql-date-format-dd-mm-yyyy-select-query also 1000 other dupes. — PeeHaa, Sep 12 '16 at 07:11

score 2 · Answer 1 · edited Sep 12 '16 at 09:53

2

You can also try this in your query, so the date is already formatted.

SELECT id, Image_Id, Image_Name, Image_Type, DATE_FORMAT(Image_Date, '%d,%m,%y') AS Image_Date, `status` 
FROM ShowFilter 
GROUP BY Image_Date 
ORDER BY Image_Date DESC

Read date_format

edited Sep 12 '16 at 09:53

PeeHaa

71,436
58
190
262

answered Sep 12 '16 at 06:46

A J

3,970
14
38
53

Chris · Answer 2 · 2016-09-12T07:09:06.057

0

You can correct the output in php using strtotime and date:

$new_Image_Date = date("d,m,Y", strtotime($objRsult1['Image_Date']));

strtotime takes the string that's returned from your query and parses it into a timestamp. You can then convert it to the correct format using date.

So your snippet would ultimately be something like:

<?              
  $sql = "SELECT * FROM  ShowFillter GROUP BY DATE_FORMAT(Image_Date, '%d/%m/%Y') order by DATE_FORMAT(Image_Date, '%d/%m/%Y') desc";
  $objQuery = mysql_query($sql) or die ("Error Query [".$sql."]");
  while($objResult1 = mysql_fetch_array($objQuery))
  {
?>
<li class="filter" data-filter="<?=date("d,m,Y", strtotime($objResult1['Image_Date']));?>">
   <a href="#">
     <?=date("d,m,Y", strtotime($objResult1['Image_Date']));?>
   </a>
</li>
<? 
  }    
?>

Check the references below if you need more info:

strtotime() doc page

date() doc page

edited Sep 12 '16 at 07:09

answered Sep 12 '16 at 06:42

Chris

57,622
19
111
137

It show me like that photo [link](https://postimg.org/image/fpplmsutv/) but i think its near to get solution. – Soul Coder Sep 12 '16 at 07:05
Well that's how your code was :) I guess you would just use `$objResult1['Image_Name']` inside a `div` or `img` tag to display the picture. For example `` – Chris Sep 12 '16 at 07:08
1

you save my life ,i got that thanks :) – Soul Coder Sep 12 '16 at 07:12

iliaz · Accepted Answer · 2016-09-12T07:08:40.583

-1

When you print your image date do:

<?=date('d-m-Y', strtotime($objResult1['Image_Date])); ?>

This will echo 27-12-2013

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

edited Sep 12 '16 at 07:08

answered Sep 12 '16 at 06:44

iliaz

395
2
10

[link](https://postimg.org/image/fpplmsutv/) but its not still correct to me ,i believe its near to get correct Thanks – Soul Coder Sep 12 '16 at 07:06
I corrected a typo in the array key. It was geting 1/1/1970 because it was null. Try again – iliaz Sep 12 '16 at 07:10
u saved my life,i got that thanks :) – Soul Coder Sep 12 '16 at 07:12
do people just randomly downvote!? – iliaz Sep 12 '16 at 08:37

How to fetch date(d,m,y) from phpmyadmin in php?

3 Answers3