解析错误:语法错误，第6行出现意外的T_STRING

I keep getting a

我越来越

Parse error: syntax error, unexpected T_STRING in /newref-exec.php on line 6

I have read loads of different solutions to this problem but non seem to work

我读过很多关于这个问题的不同解决方案，但似乎都行不通

<?php
// connect to database
 require($DOCUMENT_ROOT . "connect.php");
// check for blank entries
if ($_POST[doi2] == "NULL"){
    echo "No Data to add";
    }
    else
    {
    $sql="INSERT INTO ref (uid, date, doi, title, year, journal)
    VALUES 
    ('1','CURDATE ()','$_POST[doi2]','$_POST[title2]','$_POST[year2]','$_POST[journal2]')";
    if (!mysqli_query($link,$sql,$con))
        {
        die('The Reference could not be added, beacuse of SQL Error:' . mysql_error());
        }
        echo "New Reference Added";
    }
?>

2 个解决方案

#1

This line, the key needs to have quotes,

这一行，键需要有引号，

if ($_POST['doi2'] == "NULL"){

Also, if you want to check for empty entries, you need to probably do this,

同样，如果你想检查空条目，你可能需要这样做，

if ($_POST['doi2'] == ""){ //checking "NULL", checks for a string 'NULL'

#2

Rewrite the code in the below way.

以以下方式重写代码。

<?php
// connect to database
 require($DOCUMENT_ROOT . "connect.php");
// check for blank entries
if ($_POST['doi2'] == null){
    echo "No Data to add";
} else {
        $doi2 = $_POST['doi2'];
        $title2 = $_POST['title2'];
        $year2 = $_POST['year2'];
        $journal2 = $_POST['journal2'];

        $sql="INSERT INTO ref(uid, date, doi, title, year, journal) VALUES('1', 'CURDATE()', '$doi2', '$title2', '$year2', '$journal2')";
        if (!mysqli_query($link, $sql, $con))
        {
            die('The Reference could not be added, beacuse of SQL Error:' . mysql_error());
        }
        echo "New Reference Added";
}
?>

#1