Date

[obrienkev]

Hi all,

I have created a form whereby the user enters details. Then those details are inserted into a database.

How do I insert the date of the message into the database too???

Thank you.

Kevin.

[Mordecai]

[man]date/man/[man]time/man, or if they enter a date, [man]strtotime/man.
When in doubt, check the manual.

[Blag]

You can use this.....

$Full_Day = date('Y') . '-' . date('n') . '-' . date('w');

So you got this: 2004-6-18.

Blag :evilgrin:

[nemonoman]

Easiest is to use the database's date functions...saves building PHP stuff.

INSERT INTO myTable
SET mydate=NOW()

Easier yet create a TIMESTAMP column

If you DON'T reference the column your SQL, the date-time is automatically updated:

myTable
myName varchar(25)
myTimestamp(14)

INSERT INTO myTable
SET myName='Nemo Noman'

Note that myTimestamp column ISN'T included in the insert.

The record will say:
myName='Nemo Noman'
myTimestamp=20040620090520 <<generated automatically

means: 2004-06-20 09:05:20

[drawmack]

if you're in mysql you can create a timestamp field and then index it, this will make it change automatically when a record is added.

However mysql and php timestamps are different so you'll probably find this function handy if you do that:

<?php
    function calc_working_date($start,$num) {
        $months = array('January','February','March','April','May','June','July','August','September','October','November','December');
        $weekend = array('sat','sun');
        $date_ary = explode('-',$start);
        $start = $months[intval($date_ary[0])-1] . ' ' . $date_ary[1] . ', ' . $date_ary[2];
        $start_time = strtotime($start);

    $cur_time = $start_time;
    $i = 0;
    while($i < $num) {
        if(!in_array(strtolower(date('D',$cur_time)),$weekend)) {
            $i++;
        }
        $cur_time = $cur_time + 86400;
    } //end while

    $retval = date('n-d-Y',$cur_time);
    return $retval;
} //end calc_working_days
?>