Show last login date on form as dd/mm/yyyy or 12-February-2014

Question

Greetings to you all!

Please I need suggestion on how to format my Php form to show last login date on form as dd/mm/yyyy or 12-February-2014. I want my form to print to the user saying: Hello and Welcome ! Your last login is dd/mm/yyyy or 12-February-2014. The last login here is the very login session he/she is in.

I am using MySQL as backend database but like you know MySQL captures date as yyyy/mm/dd but I dont want it shown that way when the user logins in.

How can I handle this please?

Thank you in advance.

Mike

@user3201606 Please let me know if my answer worked for you. Please accept my reply as correct answer if it worked for you- so that other users can benefit: from knowing that the answer works and by having the question marked as Answered — DhruvJoshi, Feb 21 '14 at 10:47

score 0 · Answer 1 · answered Feb 21 '14 at 10:39

0

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

Use like

   echo date("d/F/Y",$datevar);

or

   echo date("d-F-Y",$datevar);

answered Feb 21 '14 at 10:39

DhruvJoshi

17,041
6
41
60

Can you tell me how I can apply to Dreamweaver form – Prince Michael Feb 21 '14 at 22:55
You can add it as code. See link here http://www.ehow.com/how_8499005_embed-php-html-dreamweaver.html – DhruvJoshi Feb 22 '14 at 08:19

score 0 · Accepted Answer · edited Feb 21 '14 at 10:58

0

Use MySql DATE_FORMAT FUNCTION >> DATE_FORMAT(your_date,'%d %b %y')

for example,

DATE_FORMAT(now(),'%d %b %y') gives you 21 Feb 14

OR

DATE_FORMAT(NOW(),'%m-%d-%Y') gives you 21-2-2014

edited Feb 21 '14 at 10:58

Mario Radomanana

1,698
1
21
31

answered Feb 21 '14 at 10:49

DexJ

1,264
13
24

Can you tell me how I can apply it to Dreamweaver form – Prince Michael Feb 21 '14 at 22:56

Show last login date on form as dd/mm/yyyy or 12-February-2014

2 Answers2