时间戳

首页 > 解决方案 > 如何从 2 个查询的结果中创建一个数组？

php - 如何从 2 个查询的结果中创建一个数组？

问题描述

我正在尝试从 2 个查询的结果创建一个数组，并将其全部发送到前端，但我被困在需要将第二个查询的结果推送到数组的地步，我试过了使用array_push但不起作用。

假设我们有这个例子，我需要包括$query2结果$return_arr

有任何想法吗？

<?php
header('Access-Control-Allow-Origin: *');

include "config.php";

$return_arr = array();


$query1 = "SELECT * FROM balance WHERE class='income' ORDER BY id DESC";
$query2 = "SELECT * FROM balance WHERE class='expense' ORDER BY id DESC";


$result1 = mysqli_query($conn,$query1);


while($row = mysqli_fetch_array($result1)){
    
    $id = $row['id'];
    $description = $row['description'];
    $date = $row['date'];
    $euro = $row['euro'];
    $who = $row['who'];
    $class = $row['class'];
    


    $return_arr[] = array("id_income" => $id,
                    "description_income" => $description,
                    "date_income" => $date,
                    "euro_income" => $euro,
                    "who_income" => $who,
                    "class_income" => $class
                    );


}


// Encoding array in JSON format
echo json_encode($return_arr);

标签： phpmysqlsql

解决方案

您还可以使用OR运算符

$query = SELECT * FROM balance WHERE class = "income" OR class = "expense" ORDER BY class, id DESC;

$result = mysqli_query($conn,$query);
$array = mysqli_fetch_array($result,MYSQLI_ASSOC);

您获取的记录将已经是$array中的数组格式

这在处理包含 1000 行记录的表时会更有效

推荐阅读