如何使用prepare语句和while循环创建数组？

Question

I am trying to create an update page couldnt list items here is that question Cant list item values in inputs in update page

My question is how to create array with while and use it in inputs ?

here what I am trying to do, not sure if I am doing right

<?php 
        $sql = "SELECT * FROM items WHERE item_id = ? AND user_id = ?";
        if($stmt = $conn->prepare($sql)){
            $stmt->bind_param("ii", $param_item_id, $param_user_id);
            $param_item_id = $item_id;
            $param_user_id = $user_id;
            if($stmt->execute()){
                $result = $stmt->get_result();
                if($result->num_rows == 0){
                    while($row = $result->fetch_assoc()) {
                          $ids[] = $row['item_id'];
                          $names[] = $row['item_name'];
                          $titles[] = $row['item_title'];
                          $images[] = $row['item_image'];
                    } else {
                        echo "no items found";
                      }
                }
            }
        }   
?>

I want to get values from table with the query and use them in inputs 


         <input type="text" name="item_name" class="form-control" value="<?php echo $names; ?>">        
<input type="text" name="item_name" class="form-control" value="<?php echo $item_titles; ?>">
         <input type="text" name="item_name" class="form-control" value="<?php echo $images; ?>">

Answer 1

After you end your while loop and you do

$names = implode(', ', $names);

After that you can put that string in your input like so:

<input type="text" name="item_name" class="form-control" value="<?=$names ?>"> 

This put's a nice comma seperated list of all fetched names in your input field.