Format dd/mm/yyyy

Question

Hey guys i show in my page in a table the date of birth from 209 employers.

So i have the next code:

<table id="tabla1" style="border: 1px #000000 solid;" width="%100" cellspacing="2" cellpadding="2" align="center">

<tbody>
<tr>
<td class="tdcolor" align="left"><b>Data_naixement</b></td>
</tr>

<?php
if($rows){
while($post = mysqli_fetch_assoc($result)) {

<tr > 
<td style="font-family: arial;padding-left: 20px;"><?php echo $post["Data_Naixement"]; ?></td>
</tr>
}
}else{
echo "not found";
}
?>

</tbody>
</table>

My code show the date in format YYYY/mm/dd but i want in dd/mm/YYYY How can i do this format?

So i was testing the next code but doestn work good because print only the same date for all employers.

echo $post  ["Data_Naixement"] =$tiempo;
 $date = new DateTime($tiempo);

<td style="font-family: arial;padding-left: 20px;"><?php echo $date->format('d-m-Y'); ?></td>

Please do a search before asking a question. You would be surprised at how many already have very good answers — RiggsFolly, Jan 26 '18 at 09:34
There is also this thig called a manual [The PHP Manual](http://php.net/docs.php) Its even been written in more than one language — RiggsFolly, Jan 26 '18 at 09:36

user2342558 · Answer 1 · 2018-01-26T09:23:18.810

0

Use the date() and strtotime() functions:

$ddMMYYYY = date('d/m/Y', strtotime($post["Data_Naixement"]));

edited Jan 26 '18 at 09:23

answered Jan 26 '18 at 09:20

user2342558

5,567
5
33
54

Format dd/mm/yyyy

1 Answers1