Содержимое файла | Последнее изменение | Открыть журнал | RSS
| Редакция | Автор | № строки | Строка |
|---|---|---|---|
| 2 | leon | 1 | <?PHP |
| 2 | print " |
||
| 3 | <html> |
||
| 4 | <head> |
||
| 5 | <title></title> |
||
| 6 | <META HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; CHARSET=UTF-8\"> |
||
| 7 | <META NAME=\"keywords\" CONTENT=\"\"> |
||
| 8 | <META NAME=\"description\" CONTENT=\"\"> |
||
| 9 | <LINK rel=stylesheet href=\"style/menu.css\" type=\"text/css\"> |
||
| 10 | </head> |
||
| 11 | <body>"; |
||
| 12 | //Проверяем авторизацию |
||
| 13 | # session_start(); |
||
| 14 | # if ($_SESSION['$user_privileges'] < 16) |
||
| 15 | # header("Location: index.php"); |
||
| 16 | include "config.php"; |
||
| 17 | $template_id = $_GET['template_id']; |
||
| 18 | $db = mysql_connect("localhost", "linwin"); |
||
| 19 | mysql_select_db("linwin", $db); |
||
| 20 | mysql_query("SET NAMES 'utf8';", $db); |
||
| 21 | |||
| 22 | //Загружем данные шаблона |
||
| 23 | $sql = "SELECT name FROM templates WHERE id = ". $template_id; |
||
| 24 | $query=mysql_query($sql, $db); |
||
| 25 | $template_name = mysql_result($query,0,0); |
||
| 26 | |||
| 27 | //Загружаем таблицу программ входящих в шаблон |
||
| 28 | $sql = "SELECT pid FROM prog_in_temp WHERE tid = ". $template_id; |
||
| 29 | $query=mysql_query($sql, $db); |
||
| 30 | $num_record = mysql_num_rows($query); |
||
| 31 | for($i = 0; $i < $num_record; $i++) |
||
| 32 | $mas_prog_in_temp_id[$i] = mysql_result($query,$i,0); |
||
| 33 | $sql_part = "('". $mas_prog_in_temp_id[0]; |
||
| 34 | for ($i = 1; $i < count($mas_prog_in_temp_id); $i++) |
||
| 35 | { |
||
| 36 | $sql_part = $sql_part. "','". $mas_prog_in_temp_id[$i]; |
||
| 37 | } |
||
| 38 | $sql_part = $sql_part. "')"; |
||
| 39 | $sql = "SELECT id, name, description FROM program WHERE id in ". $sql_part. " ORDER BY name"; |
||
| 40 | $query = mysql_query($sql, $db); |
||
| 41 | $mas_program_id = array(); |
||
| 42 | $mas_program_name = array(); |
||
| 43 | $mas_program_description = array(); |
||
| 44 | $num_record = mysql_num_rows($query); |
||
| 45 | for ($i = 0; $i < $num_record; $i++) |
||
| 46 | { |
||
| 47 | $mas_program_id[] = mysql_result($query, $i, 0); |
||
| 48 | $mas_program_name[] = mysql_result($query, $i, 1); |
||
| 49 | $mas_program_description[] = mysql_result($query, $i, 2); |
||
| 50 | } |
||
| 51 | |||
| 52 | //Загружем таблицу урлов для программ данного шаблона |
||
| 53 | $sql = "SELECT id, pid, description,url FROM url WHERE pid in ". $sql_part; |
||
| 54 | $query = mysql_query($sql, $db); |
||
| 55 | $mas_url_id = array(); |
||
| 56 | $mas_url_pid = array(); |
||
| 57 | $mas_url_description = array(); |
||
| 58 | $mas_url_url = array(); |
||
| 59 | $num_record = mysql_num_rows($query); |
||
| 60 | for ($i = 0; $i < $num_record; $i++) |
||
| 61 | { |
||
| 62 | $mas_url_id[] = mysql_result($query, $i, 0); |
||
| 63 | $mas_url_pid[] = mysql_result($query, $i, 1); |
||
| 64 | $mas_url_description[] = mysql_result($query, $i, 2); |
||
| 65 | $mas_url_url[] = mysql_result($query, $i, 3); |
||
| 66 | } |
||
| 67 | |||
| 68 | print " |
||
| 69 | <table> |
||
| 70 | <tr><td><b>Полный список программ:</b></td><td><b>Описание программы</b></td><td><b>Связанные ссылки:</b></td></tr>"; |
||
| 71 | for ($i = 0; $i < count($mas_program_id); $i++) |
||
| 72 | { |
||
| 73 | print "<tr><td>$mas_program_name[$i]</td><td>$mas_program_description[$i]</td><td>"; |
||
| 74 | for($j = 0; $j < count($mas_url_id); $j++) |
||
| 75 | { |
||
| 76 | if ($mas_url_pid[$j] == $mas_program_id[$i]) |
||
| 77 | { |
||
| 78 | print "<a href = \"$mas_url_url[$j]\">$mas_url_description[$j]</a><br/>"; |
||
| 79 | } |
||
| 80 | } |
||
| 81 | print "</td></tr>"; |
||
| 82 | "</tr>"; |
||
| 83 | } |
||
| 84 | print " |
||
| 85 | </td> |
||
| 86 | </tr> |
||
| 87 | </table> |
||
| 88 | </body> |
||
| 89 | </html>"; |
||
| 90 | ?> |