无法使用 PHP 和 MySQL 中的 SQL 查询获取多个数据


Can not get multiple data using the SQL query in PHP and MySQL

我需要使用 MySQL 和 PHP 在数组中获取多个数据,但我无法做到这一点。我在下面解释我的查询。

$sql = "
    SELECT s.id, s.voucher_code, s.merchant, s.date, s.receiver, s.sender, s.serial_no, s.image, s.expired_date, c.status,sup.supplier_id, sup.name, a.name AS sender_name, v.discount
    FROM db_send_evoucher_code s
    INNER JOIN db_code c ON s.voucher_code=c.total_voucher_code
    INNER JOIN db_supplier sup ON s.merchant=sup.supplier_id
    INNER JOIN medilink_admin a ON s.sender=a.admin_id
    INNER JOIN db_voucher_code v ON c.voucher_code_id=v.voucher_code_id
    WHERE s.receiver='".$userid ."' and c.status='sent'
";
$query = mysqli_query($con,$sql);
while ($row = mysqli_fetch_array($query)) {
                $data = array(
                    "data" => array(
                        "voucher_code" => $row['voucher_code'], 
                        "send_by" => $row['sender_name'],
                        "image" => $row['image'],
                        "expired_date" => $row['expired_date'],
                        "supplier_name" => $row['name'],
                        "sending_date" => $row['date'],
                        "supplier_id" => $row['supplier_id'],
                        "discount" => $row['discount'],
                        "imagepath" => $imagepath
                    )
                );
            }
echo json_encode($data, JSON_UNESCAPED_SLASHES);    

在这里,我只得到一组值,但我需要获取多个值。

你每次都在影响$data

<?php
$sql="select s.id,s.voucher_code,s.merchant,s.date,s.receiver,s.sender,s.serial_no,s.image,s.expired_date,c.status,sup. supplier_id,sup.name,a.name AS sender_name,v.discount from db_send_evoucher_code s INNER JOIN db_code c ON s.voucher_code=c.total_voucher_code INNER JOIN db_supplier sup ON s.merchant=sup.supplier_id INNER JOIN medilink_admin a ON s.sender=a.admin_id INNER JOIN db_voucher_code v ON c.voucher_code_id=v.voucher_code_id where s.receiver='".$userid ."' and c.status='sent' ";
$query=mysqli_query($con,$sql);
$data = array();
$data['data'] = array();
while($row=mysqli_fetch_array($query)){
    $data['data'][]=array("voucher_code"=>$row['voucher_code'],"send_by"=>$row['sender_name'],"image"=>$row['image'],"expired_date"=>$row['expired_date'],"supplier_name"=>$row['name'],"sending_date"=>$row['date'],"supplier_id"=>$row['supplier_id'],"discount"=>$row['discount'],"imagepath"=>$imagepath);
}
echo json_encode($data,JSON_UNESCAPED_SLASHES);