php - 无法将 html 表单数据插入 phpmyadmin 数据库

Question

我在将表单数据插入数据库时​​遇到问题。它成功连接到数据库，但数据没有插入到我的 MySQL 数据库中。希望你能帮忙!提前致谢!

这是表单代码:

<form id="score" method="post" action="process.php">
 <fieldset>
        <div class="box1">
    <legend>Your details</legend>
    <ol>
        <li>
            <label for=name>Name</label>
            <input id=name name=name type=text placeholder="First and last name" required autofocus>
        </li>
        <li>
            <label for=email>Email</label>
            <input id=email name=email type=email placeholder="example@domain.com" required>
        </li>
        <li>
            <label for=phone>Phone (country code if overseas)</label>
            <input id=phone name=phone type=tel placeholder="Eg. +447500000000" required>
        </li>
    </ol>
    </div>
</fieldset>
<fieldset style="border: none;">
    <button type=submit>Continue</button>
</fieldset>
</form>

这是 php 代码(文件名 process.php):

<?php
if( $_POST )
{
$con = mysql_connect("localhost","database_user","password");

if (!$con)
{
    die('Could not connect: ' . mysql_error());
}

mysql_select_db("database_name", $con);


$insert_query = "insert into feedback(
                name,
                phone,
                email
                    ) values (
            ".$_POST['name'].",
            ".$_POST['phone'].",
            ".$_POST['email'].")";

($insert_query);

echo "<h2>Thank you for your feedback!</h2>";

mysql_close($con);
}
?>

Answer 1

你错过了 mysql_query 函数:

这样使用:

$retval = mysql_query( $insert_query, $con );
if(! $retval )
{
  die('Could not enter data: ' . mysql_error());
}

引用 link