php - 从 PHP 网页添加 MySQL 条目

Question

我正在开发一个 Web 应用程序，允许用户通过 Web 表单向 MySQL 数据库添加条目。 Web 表单发布到同一页面，一些 PHP 代码捕获该数据并将其发送到 MySQL。不管出于什么原因，没有任何东西能够进入 MySQL。这是我到目前为止不起作用的代码:

    <?php
    include("config.inc.php");
    $Name=$_POST['AddName'];
    $Group=$_POST['AddGroup'];
    $Grade=$_POST['AddGrade'];
    $Position=$_POST['AddPosition'];
    $Email=$_POST['AddEmail'];
    $HomeAddress=$_POST['AddHomeAddress'];
    $City=$_POST['AddCity'];
    $State="SC";
    $Zip=$_POST['AddZIP'];
    $CellPhone=$_POST['AddCellNumber'];
    $HomePhone=$_POST['AddHomeNumber'];
    $FirstPeriod=$_POST['AddFirstPeriod'];
    $SecondPeriod=$_POST['AddSecondPeriod'];
    $ThirdPeriod=$_POST['AddThirdPeriod'];
    $FourthPeriod=$_POST['AddFourthPeriod'];
    $FifthPeriod=$_POST['AddFifthPeriod'];
    $SixthPeriod=$_POST['AddSixthPeriod'];
    $SeventhPeriod=$_POST['AddSeventhPeriod'];
    $Homeroom=$_POST['AddHomeroom'];
    $dbpassword=$_POST['AddPassword'];

    $con = mysql_connect("127.0.0.1","$username","******");
    if (!$con)
      {
      die();
      }        

    mysql_select_db("$database", $con);
    $sql="INSERT INTO names     (Name,Grp,Grade,Position,Email,HomeAddress,City,State,Zip,CellPhone,HomePhone,FirstPeriod,SecondPeriod,ThirdPeriod,FourthPeriod,FifthPeriod,SixthPeriod,SeventhPeriod,Homeroom)
    VALUES('$Name','$Group','$Grade','$Position','$Email','$HomeAddress,'$City','$State','$Zip','$CellPhone','$HomePhone','$FirstPeriod','$SecondPeriod','$ThirdPeriod','$FourthPeriod','$FifthPeriod','$SixthPeriod','$SeventhPeriod','$Homeroom')";

    if (!mysql_query($sql,$con))
      {
      die();
      }
    echo "1 record added";

    mysql_close($con)
    ?>
            </body>
    </html>

Answer 1

试试这个，看看它说了什么:

if (!mysql_query($sql,$con))
{
    die(mysql_error());
}