Show Day or Month From MySQL

Question

i have problem to show only day or month from dob in mysql. i did these steps,

first added a table in database:

ALTER TABLE `dle_users` ADD `dob` DATE NOT NULL;

second added this code in php file:

$dob = $db->super_query( "SELECT dob FROM dle_users");
$tpl->set("{dob}", $dob);

in profile page i got correct result like this: 1372-07-08 (its a persian date)

problem is, i need to show only day or month, not full date

i tried this ways:

$dob = date("m", $row['dob']);    
$tpl->set("{dob}", $dob);

but it does not work! how i can fix this?

thank u :)

Please edit out your second question, and post it separately. — Sara, Oct 13 '12 at 03:54

score 2 · Accepted Answer · edited May 23 '17 at 12:12

2

I don't know which framework or cms you using but you in core php should try it like this

$dob = date("m", strtotime($row['dob']));    
$tpl->set("{dob}", $dob);

and for daycounting you should check out this link

$date1 = "2007-03-24";
$date2 = "2009-06-26";

$diff = abs(strtotime($date2) - strtotime($date1));

$years = floor($diff / (365*60*60*24));
$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));

printf("%d days\n", $days);

edited May 23 '17 at 12:12

Community

1
1

answered Oct 13 '12 at 03:55

Pragnesh Chauhan

8,363
9
42
53

1

You can use PHP Function http://www.php.net/manual/en/datetime.diff.php just to get the day differents . Sample PHP Script format('%R%a days'); ?> – iDroid Oct 13 '12 at 04:07

jmoreno · Answer 2 · 2012-10-13T05:08:45.260

1

If what you want from the database is the month, then use the Month function to get the month. Likewise for getting the number of days until another date.

The DB is just as capable as the front end at simple calculation, there's no reason not to do it on the DB end most of the time.

edited Oct 13 '12 at 05:08

answered Oct 13 '12 at 03:56

jmoreno

12,752
4
60
91

Show Day or Month From MySQL

2 Answers2