php - Web 表单正在向数据库提交空白数据

Question

我正在尝试使用 PHP 将数据从 Web 表单发送到我的数据库。用户在文本框中输入他们的full_name、contact_number 和best_time_to_call 详细信息。当方框填满相关信息并点击提交时，数据会完美地添加到数据库中，只是列是空白的。我该如何解决这个问题？

HTML

 <form name="frmContact" action="<?php $_PHP_SELF ?>" id="frmCallContact" method="POST">
    enter code here<table width="100%" border="0" cellspacing="1" cellpadding="0" class="TableFormat">
        <tr>
         <th align="left" valign="top" colspan="2">Call me back</td>
       </tr>         
       <tr>
         <td align="right" valign="top">Full Name:</td>
         <td><input type="text" name="FullName" id="FullName_R" style="width:250px;" title="Please enter your full name"/></td>
       </tr>
       <tr>
         <td align="right" valign="top">Contact Number:</td>
         <td><input type="text" name="ContactNumber" id="ContactNumber_R" style="width:250px;" /></td>
       </tr>
     <tr>
         <td align="right" valign="top">Best Time to Call:</td>
         <td><input type="text" name="BestTime" id="BestTime_R" style="width:250px;"  title="Please enter your best time to call"/></td>
       </tr>
       <tr>
         <td align="right" valign="top">&nbsp;</td>
         <td><!--<a name="submit" href="#"><img src="/img/bn_submit.png" width="93" height="28" /></a>--><input type="submit" name="Submit" value="Submit">
       </tr>
     </table>
</form>

PHP

    <?php
    require_once($_SERVER['DOCUMENT_ROOT'].'/inc/bootstrap.php');
    include("config/cn.php");
    $template['template']="page";

    if($_POST){


    // Data pulled from input form
    $full_name = $_POST['full_name'];
    $contact_number = $_POST['contact_number'];
    $best_time_to_call = $_POST['best_time_to_call'];


    $enter_sql = "INSERT INTO contact (full_name,contact_number,best_time_to_call) VALUES('$full_name','$contact_number','$best_time_to_call')";
    /*print($enter_sql);*/

    $enter_query = mysql_query($enter_sql) or die(mysql_error());

    header('Location: /thankyou.php');
    exit;
} 

?>

Answer 1

<?php
    require_once($_SERVER['DOCUMENT_ROOT'].'/inc/bootstrap.php');
    include("config/cn.php");
    $template['template']="page";

    if($_POST){


    // Data pulled from input form
    $full_name = $_POST['FullName'];
    $contact_number = $_POST['ContactNumber'];
    $best_time_to_call = $_POST['BestTime'];


    $enter_sql = "INSERT INTO contact (full_name,contact_number,best_time_to_call) VALUES('$full_name','$contact_number','$best_time_to_call')";
    /*print($enter_sql);*/

    $enter_query = mysql_query($enter_sql) or die(mysql_error());

    header('Location: /thankyou.php');
    exit;
} 

?>