Question

How to INSERT INTO a date ( NOW() ) with SQL in MySQL database with PHP Data Objects (PDO) in PHP

Answer 1

try 
{
    $inserted = $con->prepare("INSERT INTO users(firstname, lastname, dateadd)
        VALUES(:firstname, :lastname", NOW());

    $inserted->execute(array(
        "firstname" => $_POST['firstname'],
        "lastname" => $_POST['lastname']
    ));
}
catch (PDOException $e) 
{
    die($e->getMessage());
}

70+ SQL courses for beginners and professionals