我试图用mysqli查询显示各种结果,但我觉得我用掉了太多代码。我想知道是否有人能告诉我我是否可以循环使用多个变量。
对于这个例子,我有多个代理,代理的多列对所有代理都是相等的。我想运行查询,这样它将循环通过和代理的所有列,然后输出数据,然后转到下一个代理并执行相同的
echo "<table>
<tr><th>Van</th><th>Aantal</th></tr>";
$sql = ("SELECT SUM(Case_closed) as sum_closed FROM productie WHERE Agentnaam='Agent1' ");
$result = mysqli_query($connect, $sql) ;
$Case_closed = $result->fetch_object()->sum_closed;
echo "<tr><td>Cases closed</td>";
echo "<td>$Case_closed</td></tr>";
$sql = ("SELECT SUM(Case_handled) as sum_handled FROM productie WHERE Agentnaam='Agent1' ");
$result = mysqli_query($connect, $sql) ;
$Case_handled = $result->fetch_object()->sum_handled ;
echo "<tr><td>Cases handled</td>";
echo "<td>$Case_handled </td></tr></table>";
我用Foreach 找到了解决方案
$connect = new mysqli ('localhost', $username, $password, $database);
if (!$connect) {
die('Could not connect: ' . mysqli_error($connect));
} else {
$normal_array = array('Agent1','Agent2','Agent3');
foreach($normal_array as $value){
$s = "SELECT * FROM productie WHERE Agentname='$value' AND Date='$actual_time'";
$result = mysqli_query($connect,$s);
$row = mysqli_fetch_row($result);
Echo "</br></br><table><tr><th>$value</th><th>Ammount</th></tr>";
Echo "<tr><td>Cases closed :</td><td> " .$row[2]. "</td></tr>";
Echo "<tr><td>Cases handled :</td><td> " .$row[3]. "</td></tr>";
Echo "<tr><td>another column :</td><td> " .$row[4]. "</td></tr>";
Echo "<tr><td>another column :</td><td> " .$row[5]. "</td></tr>";
Echo "<tr><td>another column :</td><td> " .$row[6]. "</td></tr>";
Echo "<tr><td>another column :</td><td> " .$row[7]. "</td></tr>";
Echo "<tr><td>another column :</td><td> " .$row[8]. "</td></tr>";
Echo "<tr><td>another column :</td><td> " .$row[9]. "</td></tr>";
Echo "<tr><td>another column :</td><td> " .$row[10]. "</td></tr></table></br>";