php - php代码中意外的T变量，无法弄清楚为什么

Question

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center。




7年前关闭。




我看不到错误的出处，并且已经检查了分号，也看不到任何遗漏。我是php的新手，将不胜感激。实际错误为:

Parse error: syntax error, unexpected T_VARIABLE in /home/sam/public_html/query.php on line 54

以下是第54行:

$sql = "UPDATE Users SET Datecreated='".$date."' WHERE Username='".$usernamec."'";

这是完整的代码:

<?php  session_start();

include 'connect.php';

echo "Hello World!";

echo '$_SESSION[page]';

$_SESSION['loggedon']=12345;
$username=$_POST['username'];
$password=$_POST['password'];

$sql = "SELECT * FROM 'Users' WHERE 'Username'='".$username."'";
$result = @mysql_query( $sql );
while ($row= @mysql_fetch_assoc($result))
    {
    if (($username=$row['Username'])&&($password=$row['Password']))
    {
        $_SESSION['loggedon']=$row['AccessLevel'];
        $_SESSION['userid']=$row['UserID'];}}


if ($_SESSION['loggedon']==12345)
    {
    $sql = "SELECT * FROM 'RedundantUsers' WHERE 'Username'='".$username."'";
    $result = @mysql_query( $sql );
    while ($row= @mysql_fetch_assoc($result))
        {   
            $_SESSION['loggedon']=$row['AccessLevel'];
            $_SESSION['userid']=$row['UserID'];


            $userid    =$row['UserID'];
            $forename  =$row['Forename'];
            $surname   =$row['Surname'];
            $email     =$row['Email'];
            $usernamec =$row['Username'];
            $access    =$row['AccessLevel'];


            $sql = "INSERT INTO 'Users' ('UserID', 'Forename', 'Surname', 'Email', 'Username', 'AccessLevel')
                    VALUES ('$userid', '$forename', '$surname', '$email', '$usernamec', '$access')";

                if (!@mysql_query($sql))    
                    {
                    die('Error: ' . mysql_error());
                        }
               $sql = "DELETE * FROM 'RedundantUsers' WHERE 'Username'='".$usernamec."'"; }}

    date_default_timezone_set('UTC');

        $date = date("Y-m-d H:i:s");    

            $sql = "UPDATE 'Users' SET 'Datecreated'='".$date."' WHERE 'Username'='".$usernamec."'";

                if (!@mysql_query($sql))    
                    {
                    die('Error: ' . mysql_error());
                        }


                    echo $_SESSION['loggedon']; 

header('Location: /'.$_SESSION['page']);

?>

如果它对您有帮助，请访问connect.php:

<?php
$dbhost = '*****';
$dbuser = '*****'; 
$dbpass = '*****';  
$conn = @mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to local MySQL')
$dbname = '******';
@mysql_select_db($dbname);      
?>

最佳答案

在第54行(发生错误的地方)

更改
echo $_SESSION[loggedon];
至
echo $_SESSION['loggedon'];
这意味着您忘记了在 session 值中包含'。除非值是已定义的常数，否则应始终包含单引号。

更新

<?php  session_start();

include 'connect.php';

echo "Hello World!";

echo $_SESSION['page'];

    $_SESSION['loggedon']=12345;
    $username=$_POST['username'];
    $password=$_POST['password'];

    $sql = "SELECT * FROM Users WHERE Username='".$username."'";
    $result = mysql_query($sql) or die(mysql_error());
    while ($row= mysql_fetch_array($result))
        {

        if (($username=$row['Username'])&&($password=$row['Password']))
        {
            $_SESSION['loggedon']=$row['AccessLevel'];
            $_SESSION['userid']=$row['UserID'];}}


    if ($_SESSION['loggedon']==12345)
        {
        $sql = "SELECT * FROM RedundantUsers WHERE Username='".$username."'";
        $result = mysql_query($sql);
        while ($row= mysql_fetch_array($result))
            {   
                $_SESSION['loggedon']=$row['AccessLevel'];
                $_SESSION['userid']=$row['UserID'];


                $userid    =$row['UserID'];
                $forename  =$row['Forename'];
                $surname   =$row['Surname'];
                $email     =$row['Email'];
                $usernamec =$row['Username'];
                $access    =$row['AccessLevel'];




                $sql = "INSERT INTO Users (UserID, Forename, Surname, Email, Username, AccessLevel)
                        VALUES ('$userid', '$forename', '$surname', '$email', '$usernamec', '$access')";

                    if (!mysql_query($sql))    
                        {
                        die('Error: ' . mysql_error());
                            }
                   $sql = "DELETE * FROM RedundantUsers WHERE Username='".$usernamec."'"; }}

        date_default_timezone_set('UTC');

            $date = date("Y-m-d H:i:s");  
            global $usernamec;          

                $sql = "UPDATE Users SET Datecreated='".$date."' WHERE Username='".$usernamec."'";

                    if (!@mysql_query($sql))    
                        {
                        die('Error: ' . mysql_error());
                            }


                        echo $_SESSION[loggedon];   

    header('Location: /'.$_SESSION[page]);

    ?>

关于php - php代码中意外的T变量，无法弄清楚为什么，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/16002834/

上一篇：error-handling - 如何在 React Native 应用程序中报告不同的错误？

下一篇：error-handling - 有没有更好的方法来捕获clojurescript中的javascript错误？

相关文章：

php - 在 PHP 中更改 the_post_thumbnail 的输出

php - 插入查询-存储时间

php - 按最大日期选择 account_id

php - Flexigrid 中的多重删除

sql - 在数据库中创建表时出错

python - 当我在python的if语句中组合按位和逻辑运算符时，出现语法错误，提示语法无效

php - MySQL - 照片评论、投票、关键字、++，在单个表中？

java - MySQL 在使用 coalesce() 更新重复键时插入会调用 java 中的语法错误

php - 不明白为什么我会收到: syntax error, unexpected T_STRING [closed]

python - 为什么我的脚本会引发TypeError : 'int' object is not subscriptable

Answer 1

在第54行(发生错误的地方)

更改
echo $_SESSION[loggedon];
至
echo $_SESSION['loggedon'];
这意味着您忘记了在 session 值中包含'。除非值是已定义的常数，否则应始终包含单引号。

更新

<?php  session_start();

include 'connect.php';

echo "Hello World!";

echo $_SESSION['page'];

    $_SESSION['loggedon']=12345;
    $username=$_POST['username'];
    $password=$_POST['password'];

    $sql = "SELECT * FROM Users WHERE Username='".$username."'";
    $result = mysql_query($sql) or die(mysql_error());
    while ($row= mysql_fetch_array($result))
        {

        if (($username=$row['Username'])&&($password=$row['Password']))
        {
            $_SESSION['loggedon']=$row['AccessLevel'];
            $_SESSION['userid']=$row['UserID'];}}


    if ($_SESSION['loggedon']==12345)
        {
        $sql = "SELECT * FROM RedundantUsers WHERE Username='".$username."'";
        $result = mysql_query($sql);
        while ($row= mysql_fetch_array($result))
            {   
                $_SESSION['loggedon']=$row['AccessLevel'];
                $_SESSION['userid']=$row['UserID'];


                $userid    =$row['UserID'];
                $forename  =$row['Forename'];
                $surname   =$row['Surname'];
                $email     =$row['Email'];
                $usernamec =$row['Username'];
                $access    =$row['AccessLevel'];




                $sql = "INSERT INTO Users (UserID, Forename, Surname, Email, Username, AccessLevel)
                        VALUES ('$userid', '$forename', '$surname', '$email', '$usernamec', '$access')";

                    if (!mysql_query($sql))    
                        {
                        die('Error: ' . mysql_error());
                            }
                   $sql = "DELETE * FROM RedundantUsers WHERE Username='".$usernamec."'"; }}

        date_default_timezone_set('UTC');

            $date = date("Y-m-d H:i:s");  
            global $usernamec;          

                $sql = "UPDATE Users SET Datecreated='".$date."' WHERE Username='".$usernamec."'";

                    if (!@mysql_query($sql))    
                        {
                        die('Error: ' . mysql_error());
                            }


                        echo $_SESSION[loggedon];   

    header('Location: /'.$_SESSION[page]);

    ?>