意外的“如果”（T_IF）

我一直收到這個 T_IF 錯誤，但我找不到任何語法錯誤。最初我有“;” 在 sql 的 "" 內部，但在修復此錯誤后，錯誤仍在繼續。我已經嘗試清除快取以確保這不是問題，但沒有運氣。

<?php
require_once 'requires-requires.php';
require 'requires-vars.php';

$mainUser = $row[user];

$coinUser = $mainUser;
$coinExperience = 0;
$coinCoins = 0;
$coinLevels = 0;

$coinUser = mysql_real_escape_string($coinUser);
$coinExperience = mysql_real_escape_string($coinExperience);
$coinCoins = mysql_real_escape_string($coinCoins);
$coinLevels = mysql_real_escape_string($coinLevels);

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $servername = "localhost";
    $user = "username";
    $pass = "password";
    $dbname = "databasename";
    $conn = new mysqli($servername, $user, $pass, $dbname);

    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    $usercheck = $conn->query("SELECT user FROM coinchaser WHERE user = '$coinUser'");
    $rows_count_value = mysqli_num_rows($usercheck);

    if($rows_count_value != 0){
        $usernameMatchErr = "You Have Already Joined This Game";
    } else {
    $sql = "INSERT INTO coinchaser (user, experience, levels, coins) VALUES ('$coinUser', '$coinExperience', '$coinLevels', '$coinCoins')";

    if ($conn->query($sql) === TRUE) {
        echo "Record updated successfully";
    } else {
        echo "Error updating record: " . $conn->error;
    }
    $conn->close();
        }
}

?>

    <div class="wrapper">
        <h2>GAMES</h2>
        <p> Game: Description </p>

        <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post">
            <div class="form-group">
                <input type="submit" class="btn btn-primary" value="Coin Chaser">
            </div>    
        </form>
    </div>
    
</body>
</html>

編輯：從頁面添加完整代碼。$row[user] 來自包含的檔案之一。這是在我嘗試添加下面的代碼之前作業的，所以我知道它很好。問題仍然存在于代碼的以下部分：

    $sql = "INSERT INTO coinchaser (user, experience, levels, coins) VALUES ('$coinUser', '$coinExperience', '$coinLevels', '$coinCoins')";

    if ($conn->query($sql) === TRUE) {

As far as debugging the php, I was having issues attempting to do so on this laptop. I have been mainly doing javascript/html/css on this laptop and had forgotten that php needed to be installed on it for the debugging to work properly. I am dusting off my older laptop to see if I can get it to boot up to do a quick php debug on it.

I do plan to put the actual backend operations on their own page. For some reason, I find it simpler to see it working all together on a single page atm as I am still learning sql and trying to become more familiar and comfortable with it rather than bouncing between two pages back and forth trying to find any syntax errors I might have made.

EDIT (SOLVED): I solved the issue. I have no idea why, but for some reason it didn't like the database column named "user" being named "user". My spelling was correct, no syntax issue. I simply went into the database, changed the column name to "username", returned to the file and change "user" to "username" and it worked perfectly.

uj5u.com熱心網友回復：

我解決了這個問題。我不知道為什么，但出于某種原因，它不喜歡名為“user”的資料庫列被命名為“user”。我的拼寫正確，沒有語法問題。我只是進入資料庫，將列名更改為“用戶名”，回傳到檔案并將“用戶”更改為“用戶名”，它完美地作業。

標籤：mysql sql if-statement

上一篇：為什么在這里使用if是錯誤的，在golang中，remove-duplicates-from-sorted-array

下一篇：當陣列是C中的struct型別時，如何檢查條目陣列的第一個條目是否為空？