dongye9820
2018-04-15 21:07
浏览 126
已采纳

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

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; ?>">

图片转代码服务由CSDN问答提供 功能建议

我正在尝试创建一个更新页面无法列出项目 是那个问题 不能在更新页面的输入中列出项目值 < p>我的问题是如何用while创建数组并在输入中使用它?

这里我要做的是什么,不确定我做得对吗 \ n

 &lt;?php 
 $ sql =“SELECT * FROM items WHERE item_id =?AND user_id =?”; 
 if($ stmt = $ conn-&gt; prepare($ sql)){  
 $ stmt-&gt; bind_param(“ii”,$ param_item_id,$ param_user_id); 
 $ param_item_id = $ item_id; 
 $ param_user_id = $ user_id; 
 if($ stmt-&gt; execute()){  
 $ result = $ stmt-&gt; get_result(); 
 if($ result-&gt; num_rows == 0){
 while($ row = $ result-&gt; fetch_assoc()){
 $ ids  [] = $ row ['item_id']; 
  $ names [] = $ row ['item_name']; 
 $ titles [] = $ row ['item_title']; 
 $ images [] = $ row ['item_image']; 
} else {
  echo“找不到任何项目”; 
} 
} 
} 
} 
?&gt; 
 
我希望从查询中获取表中的值,并在输入中使用它们
 
 
&lt;  input type =“text”name =“item_name”class =“form-control”value =“&lt;?php echo $ names;  ?&gt;“&gt; 
&lt; input type =”text“name =”item_name“class =”form-control“value =”&lt;?php echo $ item_titles;  ?&gt;“&gt; 
&lt; input type =”text“name =”item_name“class =”form-control“value =”&lt;?php echo $ images;  ?&gt;“&gt; 
   
 
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongtanghuan1885 2018-04-15 21:11
    已采纳

    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.

    点赞 评论

相关推荐 更多相似问题