php - 我无法直接从数据库中的数据将值输入到表单中

Question

如何使表单输入中的值等于从数据库中获取的数据。当我尝试从帖子 super 全局中检索值时，我得到了数组([john_doe] =>)，即一个空值

<?php print_r($_POST); ?>
<form action="" method="post">
    <?php while($subs = mysqli_fetch_assoc($result)) { ?>
        <input type="" name="john_doe" value='<?php echo $subs["menu_name"]; ?>'>
        <input type="submit" value="sumbit">
    <?php } ?>
</form>

Answer 1

您的数据库获取会出现一些问题，您可以尝试以下代码来达到您的目的

<?php
    $servername = "localhost";
    $username = "username";
    $password = "password";
    $dbname = "myDB";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 

    $sql = "**YOUR QUERY**";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // output data of each row
        while($row = $result->fetch_assoc()) {
           <input type="text" name="john_doe" value='<?php echo $row["menu_name"]              ;?>'>
           <input type="submit" value="sumbit">
    $conn->close();
    ?>