是这样的数据库 - 0000-00-00 00:00:00

Question

it is such that I have trouble lying 2 inputs together in a and after just it into the database

the problem is when it comes to the database looks like this 0000-00-00 00:00:00

this is how I have chosen to keep the date and time apart to make it simple as possible.

function tilmeldAdmin()
{
    if ($stmt = $this->mysqli->prepare('INSERT INTO `tilmeldt` (`title`, `info`, `Dato`,  `antal`, `opret_navn`, `opret_email`, `opret_id`) VALUES (?, ?, ?, ?, ?, ?, ?)')) { 
        $stmt->bind_param('sssissi', $title, $info, $Dato, $antal, $opret_navn, $opret_email, $opret_id);
        $title = $_POST["title"];
        $info = $_POST["info"];
        $Dato = $_POST["dob"] . $_POST["time"];//Here is error when it should be entered into the database (Everything else works just fine with no problems)
        $antal = $_POST["antal"];
        $opret_navn = $_SESSION["navn"];
        $opret_email = $_SESSION["mail"];
        $opret_id = $_SESSION["id"];
        $stmt->execute();
        $stmt->close();
    }
}

Answer 1

Assuming you are getting the date in YYYY-mm-dd format and the time in HH:ii:ss your issues is you are missing a space between the two elements.

$Dato = $_POST["dob"] .' '. $_POST["time"];

If you are being provided the date in a relatively sane manner you can use strtotime to get the date in the format you want.

$Dato = date("Y-m-d H:i:s", strtotime($_POST["dob"]." ".$_POST["time"]));