(root)/trunk/program_in_section_windows_only.php @ 3 - Редакция 2
Авторство |
Последнее изменение |
Открыть журнал
| RSS
<?PHP
include "head.php";
print "<h1 align = \"center\">Нот арбайтен!</h1><br/>";
$section = $_GET['section'];
$db = mysql_connect("localhost", "linwin");
mysql_select_db("linwin", $db);
mysql_query("SET NAMES 'utf8';", $db);
$sql = "SELECT id, name FROM section";
$query = mysql_query($sql, $db);
$mas_section_id = array();
$mas_section_name = array();
$mas_prog_name = array();
$mas_prog_mswindows = array();
$mas_prog_linux= array();
$mas_prog_id = array();
$num_program = array();
$mas_prog_in_sect = array();
$num_section = mysql_num_rows($query);
for ($i = 0; $i < $num_section; $i++)
{
$mas_section_id[$i] = mysql_result($query, $i, 0);
$mas_section_name[$i] = mysql_result($query, $i, 1);
}
for ($j = 0; $j < $num_section; $j++)
{
$sql = "SELECT pid FROM prog_in_sect WHERE sid = ". $mas_section_id[$j]. ";";
$query = mysql_query($sql, $db);
$num_program[$j] = mysql_num_rows($query);
for ($i = 0; $i < $num_program[$j]; $i++)
{
$mas_prog_id[$j][$i] = mysql_result($query,$i,0);
}
for ($i = 0; $i < $num_program[$j]; $i++)
{
$sql = "SELECT name FROM program WHERE id = ". $mas_prog_id[$j][$i]. ";";
$query=mysql_query($sql, $db);
$mas_prog_name[$j][$i] = mysql_result($query,0,0);
}
}
mysql_close($db);
print "
<table align = \"center\" width = \"100%\">
<tr><td width = \"33%\"></td><td width = \"33%\"><b>Платные программы</b></td><td><b>Бесплатный программы аналоги</b></td></tr>";
for ($j = 0; $j < $num_section; $j++)
{
print "<tr><td><br/></td><td></td><td></td></tr>";
print "<tr><td width = \"33%\"><b>$mas_section_name[$j]</b></td><td width = \"33%\">";
print "</td><td>";
for($i=0; $i < $num_program[$j]; $i++)
{
echo $mas_prog_name[$j][$i]. "<br/>";
}
print "</td></tr>";
}
print "</table>";
include "foot.php";
?>