使用 php 将出生日期添加到 mysql 数据库

我修改了表单和php脚本，但我仍然没有结果。现在，当我填写表单然后按下按钮时，我只是在Apache Web服务器中出现一个白屏，这是新代码：

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Insert</title>
    </head>
    <body>
        <form action="insertform3.php" method="post">
            Name: <input type="text" name="name"><br>
            Phone: <input type="text" name="phonenumber"><br>
            Birhtday: <input type="date" name="birthday"><br>
        <input type="submit" name="submit">
    </form>
</body>
</html>

这是PHP形式：

<?php
define('HOST', 'localhost');
define('USER', 'root'); 
define('PASS', 'password');
define('DBNAME', 'database');
$db = new mysqli(HOST, USER, PASS, DBNAME);
if ($db->connect_errno) {
    echo "Failed to connect to MySQL: (" . $db->connect_errno . ") " .    $db->connect_error;
}

if ($_POST['submit']) {
    $name        = $_POST['name'];
    $phonenumber = $_POST['phonenumber'];
    $birthday = $_POST['birthday'];
     if (!empty($name) && !empty($phonenumber) && !empty($birthday)) {
        $query = "INSERT INTO form_data (name,phonenumber,birthday) 
            VALUES(?,?,?)";
        $conn  = $db->prepare($query);
        if ($conn->execute(array(
             $name,
             $phonenumber,
             $birthday
        ))) {
            header('location: http://localhost/insertform-2.html');
        } else {
        echo 'error';
        }
        $db->close();
    }
}
?>

   <?php
define('HOST', 'localhost');
define('USER', 'root');
define('PASS', 'xxxxxxxxx');
define('DBNAME', 'database');
$db = new mysqli(HOST, USER, PASS, DBNAME);
if ($db->connect_errno) {
    echo "Failed to connect to MySQL: (" . $db->connect_errno . ") " . $db->connect_error;
}

if ($_POST['submit']) {
    $name        = $_POST['name'];
    $phonenumber = $_POST['phonenumber'];
    $birthday    = $_POST['birthday'];
    if (!empty($name) && !empty($phonenumber)) {
        $query = "INSERT INTO formdatabase (name,phonenumber,bithday) 
                VALUES(?,?,?)";
        $conn  = $db->prepare($query);
        if ($conn->execute(array(
            $name,
            $phonenumber,
            $birthday
        ))) {
            header('location: http://localhost/insertform-2.html');
        } else {
            echo 'error';
        }
        $db->close();
    }
}
?>

您必须确保以正确的格式 yyy-mm-dd 输入出生日期，并在数据库中将出生日期设置为键入 DATE。

$name = $_POST['name'];
$phonenumber = $_POST['phonenumber'];
$birthdate = $_POST['birthdate'];
if (!empty($name) && !empty($phonenumber) && !empty($birthdate)) {
    $query = "INSERT INTO formdatabase (name,phonenumber) 
        VALUES($name,$phonenumber,$birthdate)";

相关内容

最新更新

热门标签：