表单值未提交

Question

I have the following PHP Code

<form action="admin.php" method="post">

    <?php
    $conn=mysqli_connect("localhost","root","vravi","mrconnect");
    if(!$conn)
    {
        echo "error establishing the connection";
    }
    $sql="select UserID,UserEmail from Users order by UserID";
    $result=mysqli_query($conn,$sql);


    if(mysqli_num_rows($result)>0)
    {
        while($row=mysqli_fetch_assoc($result))
       {

          echo $row["UserID"];
          echo  $row["UserEmail"]." ".'<input type=\"text\" name=\"name[]\"/>'."</br>";     
        }
        echo '<button type=\"submit\" name=\"submit\"   value=\"submit\">'.Submit.'</button></br>';
    }
    ?>
</form>

which gives the following output in the browser.

Now I have two questions.

1)When I try insert some values in one of the textboxes and click submit button in the bottom, The values are not getting submitted.

below is my admin.php php file.

<?php
if(isset($_POST['submit']))
{
    echo "submitted";
}
else
{
    echo "not submitted";
}


?>

2)Now the second question is that, I also want my email id to get submitted through the form, but it is just a normal text, can anyone tell me how do we do that?

Answer 1

There are a few things that could change:

1. You don't need to escape double quotes when they are between single quotes
2. Use name="name['.$row["UserID"].']"
3. Change the <button... to <input type="submit"...

Your page will then look like this:

<form action="admin.php" method="post">
    <?php
    $conn=mysqli_connect("localhost","root","vravi","mrconnect");
    if(!$conn) { echo "error establishing the connection"; }

    $sql="select UserID,UserEmail from Users order by UserID";
    $result=mysqli_query($conn,$sql);

    if(mysqli_num_rows($result)>0) {
        while($row=mysqli_fetch_assoc($result)) {
            echo $row["UserID"] . ' ' . $row["UserEmail"] ." ";
            echo '<input type="text" name="name['.$row["UserID"].']" />'."<br />";
        }
        echo '<button type="submit" name="submit" value="submit">Submit</button></br>';
    }
    ?>
</form>

Then, when the form is submitted to admin.php, you can loop the name.

<?php
if( $_SERVER['REQUEST_METHOD'] == 'POST' ) {
    foreach( $_POST['name'] as $data => $value ) {
        echo $data . ': ' . $value . '<br />';
        // will output    2:  12
    }
}
?>

In my example it will echo the user id and the submitted value. You could ofcourse also save it to a database.