adding datetime in mysql with codeigniter php

Question

how do i add datetime ( not current timestamp) but any date and time in 'datetime' field of mysql database in the format 2011-03-18 18:37:06 from php ? does jquery calendar allow time as well or what is the easy way to do so ? any help would be greatly appreceated. Thanks

The Silencer · Accepted Answer · 2011-07-01 13:57:47Z

3

86400 seconds in a day, times number of days.. and add it to current time.

$nextWeek = time()+86400*7;
echo date("Y-m-d H:i:s", $nextWeek);

answered Jul 1, 2011 at 13:57

The Silencer

7876 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ross · Accepted Answer · 2011-03-18 16:13:01Z

1

<?php echo date("Y-m-d H:i:s"); ?>

not sure how this is CI related.

answered Mar 18, 2011 at 16:13

Ross

18k7 gold badges46 silver badges65 bronze badges

2 Comments

jondavidjohn Over a year ago

"( not current timestamp) but any date and time..."

ktm Over a year ago

yes not current timestamp for example i want to add date and time for 1 week later or after 25 days later

Collectives™ on Stack Overflow

adding datetime in mysql with codeigniter php

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related