PHP将日期插入mysql数据库

Question

我希望能够将 child 添加到数据库中，该数据库连接到他们的 parent (拥有成员 ID MID)。我相信错误在于日期格式(至少我是这么认为的)，我也尝试过使用 strtotime($dob)，但这并没有改变任何东西。

   $name = htmlspecialchars($_GET['Name']);
   $dob = $_GET['DOB'];
   $newDOB = date("Y-m-d", $dob);
   $mid = $_GET['mid'];

   if(isset($_GET['Name'], $_GET['DOB'], $_GET['mid']))
       $alert = true;
   if(!empty($name) && !empty($newDOB) && !empty($mid))
       add_family_member($mid, $newDOB, $name);

添加成员的函数:

function add_family_member($mid, $dob, $name)
{
    global $con;
    $sql = "INSERT INTO Children(MID, DOB, Name) VALUES(?, ?, ?)";
    $stmt = $con->prepare($sql);
    if($stmt)
    {
        $b = $stmt->bind_param("iss", $mid, $dob, $name);
        if($b)
        {
            $e = $stmt->execute();
            if($e)
                return true;
        }
    }

    return false;
}

Answer 1

function add_family_member($mid, $dob, $name)
{
    global $con;
    $sql = "INSERT INTO Children(MID, DOB, Name) VALUES(:mid, :dob, :name)";
    $stmt = $con->prepare($sql);
    if($stmt)
    {
        return $stmt->execute(array(
             'mid' => $mid,
             'dob' => $dob,
             'name' => $name
        ));           
    }

    return false;
}

参见http://www.php.net/manual/en/pdostatement.execute.php更多示例