I don't know how to create a $_SESSION with this :
$query = $db->prepare('INSERT INTO pro(reference, date_add) VALUES ( :reference, NOW() ) ');
$query->execute(array(
':reference' => $_POST['reference']
));
$_SESSION['reference'] = $_POST['reference'];
$_SESSION['date_add'] = ?
My date isn't post before, so how to create a session for my date ?
Thanks for your help !
This will give you the same result:
//MySQL datetime format (same as NOW())
$date = date("Y-m-d H:i:s");
$query = $db->prepare('INSERT INTO pro(reference, date_add) VALUES ( :reference, :date ) ');
$query->execute(array(
':reference' => $_POST['reference'],
':date' => $date
));
$_SESSION['reference'] = $_POST['reference'];
$_SESSION['date_add'] = $date
Maybe can work this
$query = $db->prepare('INSERT INTO pro(reference, date_add) VALUES ( :reference, :date_add ) ');
$query->execute(array(
':reference' => $_POST['reference'],
':date_add' => time()
));
$_SESSION['reference'] = $_POST['reference'];
$_SESSION['date_add'] = time();