sql表如何从sql表中获取并存储到数组中并返回多个数字数组 [英] sql table how to multliply array of numbers fetched from sql table and stored into array and return

问题描述

在sql表中，如何将从sql表中获取的数字数组相乘

In a sql table how to multiply array of numbers fetched from sql table

下面的表格

Id         country       Person        Money

1           UK           john          2010
2           USA          Henry         120
3           RUS          neko          130
4           GER          suka          110
7           CAN          beater        1450
8           USA          lusi          2501

编码

SELECT Money  
FROM Customers;

如何使money列仅分隔行并与给定数相乘并存储到数组中返回

how to get a money column separate rows only and multiply with given number and stored into array return back

$number = 2;

$Arratotal =
(2010*$number,120*$number,110*$number,1450*$number,2510*$number)

return $Arratotal;

推荐答案

假定$myDatabase是mySQLi连接.

Assuming $myDatabase is a mySQLi connection.

此代码用于将钱乘以数字.

This code is used to get money multiplied by a number.

$myNumber = 2;
$qry = "SELECT (Money * {$myNumber}) AS money
    FROM Customers";
$result = $myDatabase->query($qry, MYSQLI_STORE_RESULT);

这段代码是将所有资金存储在数组$arrayTotal中.

And this code is to store all money in array $arrayTotal.

while ($row = $result->fetch_object()) {
    $arrayTotal[] = $row->money;
}

希望获得帮助.

这篇关于sql表如何从sql表中获取并存储到数组中并返回多个数字数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！