两文件 PHP 联系表

Question

pswindex.php 部分似乎工作正常，但处理程序抛出内部服务器错误（500）。

索引.php

    <div id="contact">
        <h1>Contact us</h1>
        <form id="ContactForm" method="post" action="submit.php">
            <p>
                <label>Name<span>(optional)</span></label>
                <input id="name" name="name" class="inplaceError" maxlength="120" type="text" autocomplete="on"/>`enter code here`
                <span class="error" style="display:none;"></span>
            </p>
            <p>
                <label>Email<span>(optional)</span></label>
                <input id="email" name="email" type="text" />
            </p>
            <p>
                <label>Subject<span>(optional)</span></label>
                <input id="website" name="website" />
            </p>
            <p>
                <label>Your message<br /> <span>700 characters allowed</span></label>
                <textarea id="message" name="message" cols="6" rows="5"></textarea>
            </p>
            <p class="submit">
                <input id="send" type="submit" value="Submit" name="submit"/>
                <span id="loader" class="loader" style="display:none;"></span>
            </p>
    <input id="newcontact" name="newcontact" type="hidden" value="1"></input>
        </form>

submit.php -->


if(isset($_POST['submit'])) {
   $name = $_POST['name'];
   $email = $_POST['email'];
   $website = $_POST['website']; //subject
   $message = $_POST['message'];

   $connection = mysql_connect ("localhost", "root", "pswd") or die ('DB connection fail:' .mysql_error());
   mysql_select_db ("contactform");
   $query = "INSERT INTO contact (pk_contact, name, email, website, message, added_date)VALUES ('NULL','$name','$email','$sub','$msg','NULL')";
   //good to know about the quotes, but the page still insist there's an error
   mysql_query($query) or die ('Error uploading DB');
   mysql_close($connection);
   echo "<span id="success_message" class="success">YAY! It worked.</span>";
} else {
   echo "<span class='error'>Try again.</span>";
}

Answer 1

我认为您的查询字符串有错误。它应该看起来像

$query = "INSERT INTO contact (name, email, website, message, added_date)VALUES ('$name','$email','$sub','$msg',NULL)";

双引号正在分解你的字符串，并且不同的部分没有被连接。

Answer 2

正如米克西托提到的。您需要删除 NULL 周围的引号。

 $query = "INSERT INTO contact (pk_contact, name, email, website, message, added_date)VALUES (NULL,'$name','$email','$sub','$msg',NULL)";

假设您已设置 mysql 表，因此 added_date 字段是 mysql 时间戳格式，尝试在表中输入 'NULL' 将导致 mysql 错误。

还要确保 mysql 表允许在 pk_contact 和 added_date 字段中输入空值。