Новый файл |
0,0 → 1,27 |
<?php |
require_once dirname(__FILE__)."/lib/init.php"; |
include "./inc/header.htm"; |
?> |
<h2>niX-FILES</h2> |
<h1>Сети проекта</h1> |
<?php |
// table header |
$nets =& $db->query("SELECT * FROM networks"); |
echo "<table>"; |
echo "<tr>"; |
echo "<th>Сеть</th><th>Описание</th><th>Подсети</th><th>Ресурсы</th>"; |
while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
$res =& $db->query("SELECT * |
FROM res_net_stat |
JOIN resources ON resources.id = res_net_stat.resource_id |
WHERE res_net_stat.network_id=".$info_nets['id']); |
$reslist = ""; |
while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
$reslist .= $info_res['resource']."<br>"; |
} |
echo "<tr><td>".$info_nets['network']."</td><td></td><td></td><td>".$reslist."</td></tr>"; |
} |
// table footer |
echo "</table>"; |
include "./inc/footer.htm"; |
?> |