The NOW() function with code igniter

Question

I want to post the now() function in my mysqli but there is no output. When I use the time ('NOW()') I get 838:59:59.

<?php
public function ajax_add()
{
    $this->_validate();
    $data = array(
        'datum' => date('Y-m-d'),
        'firma' => $this->input->post('firma'),
        'naam' => $this->input->post('naam'),
        'telefoonnummer' => $this->input->post('telefoonnummer'),
        'opdrachtgever' => $this->input->post('opdrachtgever'),
        'werkzaamheden' => $this->input->post('werkzaamheden'),
        'aangemeld' => $this->input->post('aangemeld'),
        'pasnummer' => $this->input->post('pasnummer'),
        'aangemeld' => time('NOW()')
        );
    $insert = $this->person->save($data);
}
?>

What am I missing?

@S.Spieker The OP has it mixed up, it's nothing to do with jQuery at all — MackieeE, Apr 21 '16 at 15:25

score 1 · Accepted Answer · answered Apr 21 '16 at 15:24

1

Remove aangemeld from the $data array and set it like this:

$this->db->set('aangemeld', 'NOW()', FALSE);

Then call your save()

answered Apr 21 '16 at 15:24

Amir

98
1
1
5

score 0 · Answer 2 · answered Apr 21 '16 at 09:55

I guess here is the problem with your this line

'aangemeld' => time('NOW()')

time() method doesn't have any parameters.

If you want to pass now as an unix timestamp you should use just

time()

If you want you can pass like this:

date("d/m/Y H:i:s");

score 0 · Answer 3 · answered Apr 21 '16 at 10:07

0

Use

 date('Y-m-d H:i:s')

instead of

'aangemeld' => time('NOW()')

For current timestamp

time() dont have parameters.

answered Apr 21 '16 at 10:07

Jatin Raikwar

406
5
17

The NOW() function with code igniter

3 Answers3