How Insert now() function in MySQL using PHP

Question

I'm trying to do an update in MySQL from PHP with CodeIgniter, but, how can I insert a now() method? I mean, I'm using an array to insert my information, but, how can I insert the date? This is an example of my array:

$data = array(
   'name'     => $inputName,
   'lastname' => $inputLast,
   'DOBirth'  => now()
);

you need to put here NOW() and your query must be made something like this:-$insert = $mysqli->prepare("INSERT INTO tablename (column mane comma seperated ) VALUES (?, NOW())"); — Alive to die - Anant, May 11 '15 at 23:33

score 1 · Answer 1 · edited May 23 '17 at 12:06

1

NOW() is part of MySQL, not PHP, so you need to put into the query.

Try this way, which is how you handle it using PDO. This should work:

$stmt = $pdoDb->prepare('INSERT INTO tablename (name, lastname, dobirth) VALUES (:name, :lastname, NOW())');
// either bind each parameter explicitly 
$stmt->bindParam(':name', $name); 
$stmt->bindParam(':lastname', $lastname);
$stmt->execute();

source: Datetime NOW PHP mysql (+ PDO variant)

edited May 23 '17 at 12:06

Community

1
1

answered May 12 '15 at 00:05

manuelbcd

3,106
1
26
39

OP is using CodeIgniter Active Record. – spencer7593 May 12 '15 at 00:21

How Insert now() function in MySQL using PHP

1 Answers1