插入元件PDO结果阵列

Question

这是我的代码：

$stmt = $db->prepare("SELECT * FROM wishlists WHERE user_id='1'"); 
 
$stmt->execute(); 
 
$result = $stmt->fetchAll(PDO::FETCH_ASSOC); 
 
$res = array('saved_id' => "1"); 
 
array_push($result, $res); 
 
echo json_encode($result);

最终结果是：

[{"id":"1","user_id":"1","name":"San Francisco","privacy":"0","pick":"Yes"},{"saved_id":"1"}] 

但我想显示在例如第一阵列saved_id：

[{"id":"1","user_id":"1","name":"San Francisco","privacy":"0","pick":"Yes","saved_id":"1"}] 

你可以帮我吗？

Answer 1

变化

array_push($result, $res); 

要

$result = array_map(function($r) use($res){ 
    return array_merge($r, $res); 
}, $result); 

Answer 2

的情况下有预期的多个结果，最好在查询

$saved_id = 1; 
$user_id = 1; 
$stmt = $db->prepare("SELECT *, ? as saved_id FROM wishlists WHERE user_id=?"); 
$stmt->execute([$saved_id, $user_id]); 
$result = $stmt->fetchAll(PDO::FETCH_ASSOC); 
echo json_encode($result); 

注入正确的，但如果你只需要一个行，你必须使用取（）而不是使用fetchall（）;
那么你可以添加你所希望的任何元素：

$stmt = $db->prepare("SELECT * FROM wishlists WHERE user_id='1'"); 
$stmt->execute(); 
$result = $stmt->fetch(PDO::FETCH_ASSOC); 
$result['saved_id'] = "1"; 
echo json_encode($result);