PHP 使用来自 sqldb 的数据遍历变量

Question

我正在制作过去一年每个月的总贷方和借方的html比较表。我正在从sql数据库表中获取数据，并使用以下代码来隔离每个月的数据。

使用以下代码，我能够获取数据并显示在我的 html 页面上。但是我每个月都必须编写单独的类似代码。这只是一个示例表，我有多个用于不同贷方、借方类别的相似代码。所以每次我都必须像$credit0,$credit1....$credit11一样复制它

我是 php 的新手，这就是我有限的知识是如何来的。有没有更好的方法可以做到这一点，而不是每个月编写多个类似的代码？

<?php
//setting initial variable values are 0
$credit0 =$credit1 =$credit2 = 0;
$debit0  =$debit1  =$debit2 = 0;
//Getting 12 months details in Y-M format and assigning to different variable
$month0 = date("Y-M");
$month1 = date("Y-M", strtotime("-1 months"));
$month2 = date("Y-M", strtotime("-2 months"));
$month3 = date("Y-M", strtotime("-3 months"));
$month4 = date("Y-M", strtotime("-4 months"));
$month5 = date("Y-M", strtotime("-5 months"));
$month6 = date("Y-M", strtotime("-6 months"));
$month7 = date("Y-M", strtotime("-7 months"));
$month8 = date("Y-M", strtotime("-8 months"));
$month9 = date("Y-M", strtotime("-9 months"));
$month10 = date("Y-M", strtotime("-10 months"));
$month11 = date("Y-M", strtotime("-11 months"));
//Get the date details from sqldb and assgning to variable in Y-M format
$month_check= date('Y-M', strtotime($data['date'])); 
//each loop with the data from sqldb
foreach ($datas as $data){
if ($month_check == $month0)  {
if ($data['entry_type'] ==  'Credit') { $credit0 =  $credit0 + $data['amount']; }
if ($data['entry_type'] ==  'Debit' ) { $debit0  =  $debit0  + $data['amount']; }   
}
if ($month_check == $month1)  {
if ($data['entry_type'] ==  'Credit') { $credit1 =  $credit1 + $data['amount']; }
if ($data['entry_type'] ==  'Debit' ) { $debit1  =  $debit1  + $data['amount']; }   
}
if ($month_check == $month2)  {
if ($data['entry_type'] ==  'Credit') { $credit2 =  $credit2 + $data['amount']; }
if ($data['entry_type'] ==  'Debit' ) { $debit2  =  $debit2  + $data['amount']; }   
}
.
.
.
.
.
same format upto $month11
}
echo '<table"> 
<thead>
<tr>
<th>Month</th>
<th>Total Credit</th>
<th>Total Debit</th>
</tr> 
</thead>
<tbody>
<tr>
<td>'.$month0.'</td>
<td>'.$credit0.'</td>
<td>'.$debit0.'</td>
</tr>
<tr>
<td>'.$month1.'</td>
<td>'.$credit1.'</td>
<td>'.$debit1.'</td>
</tr>
<tr>
<td>'.$month2.'</td>
<td>'.$credit2.'</td>
<td>'.$debit2.'</td>
</tr>
.
.
.
.
upto $month11
</tbody>
</table>';
//I have multiple similar tables for different categories
?>

更新：使用循环，我尝试了以下方法，但它无法正常工作

<?php
$credit0 =$credit1 =$credit2 = 0;
$debit0  =$debit1  =$debit2 = 0;
$month0 = date("Y-M");
$month1 = date("Y-M", strtotime("-1 months"));
$month2 = date("Y-M", strtotime("-2 months"));
$month3 = date("Y-M", strtotime("-3 months"));
$month4 = date("Y-M", strtotime("-4 months"));
$month5 = date("Y-M", strtotime("-5 months"));
$month6 = date("Y-M", strtotime("-6 months"));
$month7 = date("Y-M", strtotime("-7 months"));
$month8 = date("Y-M", strtotime("-8 months"));
$month9 = date("Y-M", strtotime("-9 months"));
$month10 = date("Y-M", strtotime("-10 months"));
$month11 = date("Y-M", strtotime("-11 months"));
$months = array($month0,$month1,$month2,$month3,$month4,$month5,$month6,$month7,$month8,$month9,$month10,$month11);
$nums = array(0,1,2,3,4,5,6,7,8,9,10,11);
foreach  (array_combine($months, $nums) as $month => $num) {
$month_check= date('Y-M', strtotime($data['date'])); 
foreach ($datas as $data){
if ($month_check == $month)  {
if ($data['entry_type'] ==  'Credit') { $credit.$num =  $credit.$num + $data['amount']; }
if ($data['entry_type'] ==  'Debit' ) { $debit.$num  =  $debit.$num  + $data['amount']; }   
}
}
echo '<table"> 
<thead>
<tr>
<th>Month</th>
<th>Total Credit</th>
<th>Total Debit</th>
</tr> 
</thead>
<tbody>
<tr>
<td>'.$month.$num.'</td>
<td>'.$credit.$num.'</td>
<td>'.$debit.$num.'</td>
</tr>
</tbody>
</table>';
}

?>

Answer 1

首先是这个：

$month0 = date("Y-M");
$month1 = date("Y-M", strtotime("-1 months"));
$month2 = date("Y-M", strtotime("-2 months"));
$month3 = date("Y-M", strtotime("-3 months"));
$month4 = date("Y-M", strtotime("-4 months"));
$month5 = date("Y-M", strtotime("-5 months"));
$month6 = date("Y-M", strtotime("-6 months"));
$month7 = date("Y-M", strtotime("-7 months"));
$month8 = date("Y-M", strtotime("-8 months"));
$month9 = date("Y-M", strtotime("-9 months"));
$month10 = date("Y-M", strtotime("-10 months"));
$month11 = date("Y-M", strtotime("-11 months"));
$months = array($month0,$month1,$month2,$month3,$month4,$month5,$month6,$month7,$month8,$month9,$month10,$month11);
$nums = array(0,1,2,3,4,5,6,7,8,9,10,11);

变成这样：

$months = array();
$nums = array();
for($i=0; $i<12; $i++) {
$month = date("Y-M", strtotime("-".$i." months"));
array_push($months, $month);
array_push($nums, $i);
}

而且我真的不明白你到底想用你的其余代码做什么：|