php-按国家/地区分隔表

大佬教程收集整理的这篇文章主要介绍了php-按国家/地区分隔表，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

我需要帮助以$row [‘citizenship’]分隔$results.

>我不知道如何遍历结果.
>我对PHP的限制不仅限于此.

因此,我希望得到一些广泛的支持.

我希望能够做到这一点,但是问题是我不知道如何通过循环将其分开：

---------------------------------------------------------------------
|citizen ID | Citizen Name | Citizenship| Date    | User IP         |
---------------------------------------------------------------------
| 123455    | Any Name     | Albania    |12/01/12 | 123.1234.123.121|
| 123455    | Any Name  2  | Albania    |12/01/12 | 123.1234.123.121|
---------------------------------------------------------------------

---------------------------------------------------------------------
|citizen ID | Citizen Name | Citizenship| Date    | User IP         |
---------------------------------------------------------------------
| 123455    | Any Name  3  | ArgenTina  |12/01/12 | 123.1234.123.121|
| 123455    | Any Name  4  | ArgenTina  |12/01/12 | 123.1234.123.121|
---------------------------------------------------------------------

这是我的PHP页面如下：

$con=MysqLi_connect("localhost","citizens","password","citizens");
// check connection
if (MysqLi_connect_errno())
  {
  echo "Failed to connect to MysqL: " . MysqLi_connect_error();
  }

$color ="#ffffff";
$color3 ="#6CC";
$fontsize ="2";
$color3 ="#69C";

echo "<center><table border='3' cellspacing='0' celLPADding='2' class='sortable' bordercolor='#6699FF' width='100%'>
<tr>
<th >CitizenID</th>
<th>Citizen Name</th>
<th>Citizenship</th>
<th>Date Entry</th>
<th>IP of Admin</th>
</tr>";

$results = MysqLi_query($con,"SELECT * FROM `data` ORDER BY citid ASC");
while($row = MysqLi_fetch_array($results))
  {

echo "<tr>";
echo "<td align='center' valign='middle' width='75px' bgcolor='" . $color3 . "'><font size='" . $fontsize . "'><a href='http://www.erepublik.com/en/citizen/profile/" . $row['citid'] . "' target='_blank'>".$row['citid']."</a></td>";
echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['citname'] . "</td>";
echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['citizenship'] . "</td>";
echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['date'] . "</td>";
echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['user_ip'] . "</td>";
echo "</tr>";
  }
echo "</table>";
echo "<br>";

MysqLi_close($con);

解决方法:

更改

$results = MysqLi_query($con,"SELECT * FROM `data` ORDER BY citid ASC");

至

$results = MysqLi_query($con,"SELECT * FROM `data` ORDER BY Citizenship ASC, Citizen_Name ASC"); 
// make sure to SELEct correct column name for Citizenship & Citizen_Name.

然后在while循环中检查“公民身份”值是否正在更改&如果公民身份发生变化,请添加新行.

while($row = MysqLi_fetch_array($results))
  {

    if($row['citizenship'] <> $current_citizenship){
        $current_citizenship = $row['citizenship'];
        echo "<tr>";
        echo "<td align='middle' colspan="5" valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['citizenship'] . "</td>";
        echo "</tr>";
    }

    echo "<tr>";
    echo "<td align='center' valign='middle' width='75px' bgcolor='" . $color3 . "'><font size='" . $fontsize . "'><a href='http://www.erepublik.com/en/citizen/profile/" . $row['citid'] . "' target='_blank'>".$row['citid']."</a></td>";
    echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['citname'] . "</td>";
    echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['citizenship'] . "</td>";
    echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['date'] . "</td>";
    echo "<td align='left' valign='middle' bgcolor='" . $color . "'><font size='" . $fontsize . "'>" . $row['user_ip'] . "</td>";
    echo "</tr>";

}

大佬总结

以上是大佬教程为你收集整理的php-按国家/地区分隔表全部内容，希望文章能够帮你解决php-按国家/地区分隔表所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。