เออเร่อแบบนี้เกิดจากอะไรเหรอคะ ?

กระทู้คำถาม

PHP MySQL Database HTML5

แก้ได้แล้วค่ะ แต่อยากทราบว่าทำยังไงให้userแก้ได้แต่ข้อมูลตัวเองคะ T T

input_information.php
[Spoil] คลิกเพื่อดูข้อความที่ซ่อนไว้<!DOCTYPE html>
<html>
<head>
<title>Enter Information about interesting University</title>
</head>
<body>
<table>
    <form method="POST" action="save_information.php">
    <?php
    $mysqli = NEW MySQLi('127.0.0.1:3307','root','','webpro');
    $resultUniversity = $mysqli->query("SELECT universityID,universityName FROM university");
    $resultFaculty = $mysqli->query("SELECT facultyID,facultyName FROM faculty");
    $resultUserID = $mysqli->query("SELECT userID,username FROM member");

//$userID = "SELECT userID FROM member WHERE userID = '".$_SESSION['userID']."'";
//$q = mysqli_query($connect, $userID);
//$rows = mysqli_fetch_array($q);
/*
        <tr>
            <td><label>User ID: <?php echo $rows['userID']; ?></label></td>
            <input type="hidden" name="userID" value="<?=$userID; ?>">
        </tr>
*/
    ?>
        <tr>
            <td><label>UserID:</label></td>
            <td>
                <select name="university">
                    <option value=""><-- Please Select your UserID --></option>
                    <?php
                    while($rows = $resultUserID->fetch_assoc())
                    {
                        $userID = $rows['userID'];
                        $username = $rows['username'];
                        echo "<option value='$userID'>$username</option>";
                    }
                    ?>
                </select>
            </td>
        </tr>
<tr>
            <td><label>University:</label></td>
            <td>
                <select name="university">
                    <option value=""><-- Please Select your University --></option>
                    <?php
                    while($rows = $resultUniversity->fetch_assoc())
                    {
                        $universityID = $rows['universityID'];
                        $universityName = $rows['universityName'];
                        echo "<option value='$universityID'>$universityName</option>";
                    }
                    ?>
                </select>
            </td>
        </tr>

<tr>
            <td><label>Faculty:</label></td>
            <td>
                <select name="faculty">
                    <option value=""><-- Please Select your Faculty --></option>
                    <?php
                    while($rows = $resultFaculty->fetch_assoc())
                    {
                        $facultyID = $rows['facultyID'];
                        $facultyName = $rows['facultyName'];
                        echo "<option value='$facultyID'>$facultyName</option>";
                    }
                    ?>
                </select>
            </td>
        </tr>
        <tr>
            <td></td>
            <td><input type="submit" name="" value="submit"></td>
        </tr>
    </form>
</table>
</body>
</html>

save_information.php
[Spoil] คลิกเพื่อดูข้อความที่ซ่อนไว้<?php
require_once "config.php";

$userID = $_POST["user"];
$universityID = $_POST["university"];
$facultyID = $_POST["faculty"];

    $inforQuery = "INSERT INTO `information` (`informationID`, `userID`, `universityID`, `facultyID`)
    VALUES (NULL, '$userID', '$universityID', '$facultyID')";

    $resultInfor = mysqli_query($connect, $inforQuery);


    if (!$resultInfor)
    {
        die ("Could not successfully run the query $inforQuery ".mysqli_error($connect));
    }
    else
    {
        echo "Insert successfully.<br><b>";
        echo "<a href=index.php'>INDEX</a><br><br>";
    }


mysqli_close($connect);
?>

แก้ไขข้อความเมื่อ