登录到主页后，display clientId的语法错误

Question

我正在尝试将用户登录到系统后的客户端。尽管我没有实现这一目标。

我遇到的错误是：

解析错误：语法错误，意外''（t_encapsed_and_whitespace）， 期望标识符（T_STRING）或变量（T_Variable）或数字 （t_num_string）

我的代码是：

session_start();
if(isset($_SESSION['Username']) && !empty($_SESSION['Username'])) {
    echo 'Set and not empty, and no undefined index error!';
}

$Server = "mydb";
$user = "user";
$password = "password";
$database = "database";
$table = "users";
$connectionInfo = array( "Database"=>$database,"UID"=>$user, "PWD"=>$password);
$link = sqlsrv_connect($Server, $connectionInfo);
$query = "SELECT "clientid" FROM "users" WHERE "Username" = '.$_SESSION['Username']'";
if($result = $mysqli->query($query)){
    While($row = $result->fetch_assoc()){
        echo "<b>User ID:</b>".row['clientid'];
    }
    $result->free();
}
else
{
    echo "No results found";
}
?>
<form action="#" method="post">
    <div class="form-group">
        <label>Company's Name: <?php echo $_SESSION["clientid"];?></label>

    </div>

和我的login.php文件是：

<?php
session_start();
$inputuser = $_REQUEST['Username'];
$inputpass = $_REQUEST['Password'];
$Server = "mydb";
$user = "user";
$password = "parrword";
$database = "database";
$table = "users";
$connectionInfo = array( "Database"=>$database,"UID"=>$user, "PWD"=>$password);
$link = sqlsrv_connect($Server, $connectionInfo);
if ($link === false) {
    echo "Connection failed. n";
    die(print_r(sqlsrv_errors(), true));
}
$query = "SELECT "Username" FROM "users" WHERE "Username" = '$inputuser'";
$querypass = "SELECT "Password" FROM  "users" WHERE "Password"  ='$inputpass'";
$result = sqlsrv_query($link,$query);

if ($result === false) {
    die(print_r(sqlsrv_errors(), true));
}
$resultpass = sqlsrv_query($link,$querypass);
if ($resultpass === false) {
    die(print_r(sqlsrv_errors(), true));
}
$row = sqlsrv_fetch_array($result);
$rowpass = sqlsrv_fetch_array($resultpass);
$serveruser = $row["Username"];
$serverpass = $rowpass["Password"];

if ($serveruser And $serverpass) {
    $_SESSION["Username"] = $_REQUEST["Username"];
    header('Location: index.php');
}
else {  
    header('Location: FailedPage.html');
}
?>

任何帮助都是有用的！

谢谢！

Answer 1

不需要帮助，我设法解决了我的问题，这很简单，我只是把会话弄乱了。

我基本上在我的login.php文件中创建一个查询，以通过检查我从登录页面给出的用户名获取客户端

然后，我将会话设置为与clientId相等，在index.php中，我刚刚调用了会话，并且它起作用。

我要感谢任何试图回答我的问题的人。