Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
2 | leon | 1 | <?PHP |
2 | include "head.php"; |
||
3 | print "<h1 align = \"center\">Нот арбайтен!</h1><br/>"; |
||
4 | $section = $_GET['section']; |
||
5 | $db = mysql_connect("localhost", "linwin"); |
||
6 | mysql_select_db("linwin", $db); |
||
7 | mysql_query("SET NAMES 'utf8';", $db); |
||
8 | $sql = "SELECT id, name FROM section"; |
||
9 | $query = mysql_query($sql, $db); |
||
10 | $mas_section_id = array(); |
||
11 | $mas_section_name = array(); |
||
12 | $mas_prog_name = array(); |
||
13 | $mas_prog_id = array(); |
||
14 | $num_program = array(); |
||
15 | $mas_prog_in_sect = array(); |
||
16 | $num_section = mysql_num_rows($query); |
||
17 | for ($i = 0; $i < $num_section; $i++) |
||
18 | { |
||
19 | $mas_section_id[$i] = mysql_result($query, $i, 0); |
||
20 | $mas_section_name[$i] = mysql_result($query, $i, 1); |
||
21 | } |
||
22 | for ($j = 0; $j < $num_section; $j++) |
||
23 | { |
||
24 | $sql = "SELECT pid FROM prog_in_sect WHERE sid = ". $mas_section_id[$j]. ";"; |
||
25 | $query = mysql_query($sql, $db); |
||
26 | $num_program[$j] = mysql_num_rows($query); |
||
27 | for ($i = 0; $i < $num_program[$j]; $i++) |
||
28 | { |
||
29 | $mas_prog_id[$j][$i] = mysql_result($query,$i,0); |
||
30 | } |
||
31 | for ($i = 0; $i < $num_program[$j]; $i++) |
||
32 | { |
||
33 | $sql = "SELECT name FROM program WHERE id = ". $mas_prog_id[$j][$i]. ";"; |
||
34 | $query=mysql_query($sql, $db); |
||
35 | $mas_prog_name[$j][$i] = mysql_result($query,0,0); |
||
36 | } |
||
37 | } |
||
38 | mysql_close($db); |
||
39 | print " |
||
40 | <table width = \"100%\"> |
||
41 | <tr> |
||
42 | <td width = \"33%\"></td><td width = \"33%\"><b>Платные программы</b></td><td width = \"33%\"><b>Бесплатный программы аналоги</b></td> |
||
43 | </tr>"; |
||
44 | for ($j = 0; $j < $num_section; $j++) |
||
45 | { |
||
46 | print "<tr><td><br/></td></tr>"; |
||
47 | print "<tr><td><b>$mas_section_name[$j]</b></td><td>"; |
||
48 | for($i=0; $i < $num_program[$j]; $i++) |
||
49 | { |
||
50 | if ($mas_prog_payment[$j][$i]) |
||
51 | echo $mas_prog_name[$j][$i]. "<br/>"; |
||
52 | } |
||
53 | print "</td><td>"; |
||
54 | for($i=0; $i < $num_program[$j]; $i++) |
||
55 | { |
||
56 | if (!$mas_prog_payment[$j][$i]) |
||
57 | echo $mas_prog_name[$j][$i]. "<br/>"; |
||
58 | } |
||
59 | print "</td></tr>"; |
||
60 | } |
||
61 | print " |
||
62 | </table> |
||
63 | </tr> |
||
64 | </table>"; |
||
65 | include "foot.php"; |
||
66 | ?> |