如何在结果查询之后添加其他数据 - How can I add other data after the resulting query

How can I add other data after the resulting query

我有这个查询。

 $stmt = $this->getconnection()->prepare("SELECT * FROM detailuser where id = ?");
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

，我想在添加日期后的结果中添加金额，但我不知道如何添加金额。金额在另一个表中，我在第一个表(detailuser)上没有引用

$amount = 100;

$rec = array(
                'data'=>$result,

            );
echo json_encode($rec);
{"data":[{"firstname":"Alex","friendname":"Alice","amount_due":"600.00","dateadded"
:"2015-09-14 13:30"},{"firstname":"Annie","friendname":"Karren","amount_due":"600
.00","dateadded":"2015-09-14 13:30"},{"firstname":"Helen","friendname":"Alice","amount_due":"600.00","dateadded":"2015-09-14 13:30"}]}

提前感谢

您可以准备一个SELECT语句来获取所有行，并在该语句中添加您的虚拟列。

SELECT *, 100 AS 'amount' FROM table_name

你也可以遍历你的结果集而不是滥用你的SELECT语句。

foreach ( $result as $row ){
    $row['amount'] = 100;
}
//encode and output

使用PDO准备然后fetchAll()结果!

$stmt= $dbh->prepare("SELECT firstname, friendname, amount_due, dateadded, "100" AS amount FROM yourTable");
$stmt->execute();
$result = $stmt->fetchAll();