用户表单-更新查询PHP的数据

Question

我有一个关于存储$variable数据和以后在html脚本中使用的基本问题，谁可以帮助我？现在，没有存储变量$gset。

<?php
                
// Update Strictness value
if(isset($_POST['strictness'])){
    $gset = $_POST['strictness'];
    $strictnessUpdate = "UPDATE users SET strictness = '$gset' WHERE user_id = 1";
    mysqli_query($conn, $strictnessUpdate);
    echo "strictness value updated";
}

?>

<form method="POST" class="form-align" action="">
    <h5 class="my-6">Current Strictness :</h5> <?php echo $gset; ?><br>
    <select name="strictness" required>
        <option value=""></option>
        <option value="15">15</option>
        <option value="31">31</option>
    </select>
    <input type="submit" name="substrict" value="CHANGE">
</form>

Answer 1

            <?php
            
            $_grabStrictness ="SELECT strictness FROM users WHERE id = 1";

            $gs_query = mysqli_query($conn, $_grabStrictness);
            $gs_result = mysqli_fetch_array($gs_query);

            if ($gs_result > 0) {
                while ($result = mysqli_fetch_array($gs_query)) {
                    $gset = $result['strictness'];
                }
            }
            
            if(isset($_POST['strictness'])){
                $gset = $_POST['strictness'];
                $strictnessUpdate = "UPDATE users SET strictness = '$gset' WHERE user_id = 1";
                mysqli_query($conn, $strictnessUpdate);
                echo "strictness value updated";
            }

            ?>

            <form method="POST" class="form-align" action="setStrictness(<?php $conn ?>)">
                <h5 class="my-6">Current Strictness :</h5> <?php echo $gset; ?><br>
                <select name="strictness" required>
                    <option value=""></option>
                    <option value="15">15</option>
                    <option value="31">31</option>
                </select>
                <input type="submit" name="substrict" value="CHANGE">
            </form>