(root)/trunk/create_index.php - Редакция 2
Авторство |
Последнее изменение |
Открыть журнал
| RSS
<?PHP
print "
<html>
<head>
<title></title>
<META HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; CHARSET=UTF-8\">
<META NAME=\"keywords\" CONTENT=\"\">
<META NAME=\"description\" CONTENT=\"\">
<LINK rel=stylesheet href=\"style/menu.css\" type=\"text/css\">
</head>
<body>";
//Проверяем авторизацию
# session_start();
# if ($_SESSION['$user_privileges'] < 16)
# header("Location: index.php");
include "config.php";
$template_id = $_GET['template_id'];
$db = mysql_connect("localhost", "linwin");
mysql_select_db("linwin", $db);
mysql_query("SET NAMES 'utf8';", $db);
//Загружем данные шаблона
$sql = "SELECT name FROM templates WHERE id = ". $template_id;
$query=mysql_query($sql, $db);
$template_name = mysql_result($query,0,0);
//Загружаем таблицу программ входящих в шаблон
$sql = "SELECT pid FROM prog_in_temp WHERE tid = ". $template_id;
$query=mysql_query($sql, $db);
$num_record = mysql_num_rows($query);
for($i = 0; $i < $num_record; $i++)
$mas_prog_in_temp_id[$i] = mysql_result($query,$i,0);
$sql_part = "('". $mas_prog_in_temp_id[0];
for ($i = 1; $i < count($mas_prog_in_temp_id); $i++)
{
$sql_part = $sql_part. "','". $mas_prog_in_temp_id[$i];
}
$sql_part = $sql_part. "')";
$sql = "SELECT id, name, description FROM program WHERE id in ". $sql_part. " ORDER BY name";
$query = mysql_query($sql, $db);
$mas_program_id = array();
$mas_program_name = array();
$mas_program_description = array();
$num_record = mysql_num_rows($query);
for ($i = 0; $i < $num_record; $i++)
{
$mas_program_id[] = mysql_result($query, $i, 0);
$mas_program_name[] = mysql_result($query, $i, 1);
$mas_program_description[] = mysql_result($query, $i, 2);
}
//Загружем таблицу урлов для программ данного шаблона
$sql = "SELECT id, pid, description,url FROM url WHERE pid in ". $sql_part;
$query = mysql_query($sql, $db);
$mas_url_id = array();
$mas_url_pid = array();
$mas_url_description = array();
$mas_url_url = array();
$num_record = mysql_num_rows($query);
for ($i = 0; $i < $num_record; $i++)
{
$mas_url_id[] = mysql_result($query, $i, 0);
$mas_url_pid[] = mysql_result($query, $i, 1);
$mas_url_description[] = mysql_result($query, $i, 2);
$mas_url_url[] = mysql_result($query, $i, 3);
}
print "
<table>
<tr><td><b>Полный список программ:</b></td><td><b>Описание программы</b></td><td><b>Связанные ссылки:</b></td></tr>";
for ($i = 0; $i < count($mas_program_id); $i++)
{
print "<tr><td>$mas_program_name[$i]</td><td>$mas_program_description[$i]</td><td>";
for($j = 0; $j < count($mas_url_id); $j++)
{
if ($mas_url_pid[$j] == $mas_program_id[$i])
{
print "<a href = \"$mas_url_url[$j]\">$mas_url_description[$j]</a><br/>";
}
}
print "</td></tr>";
"</tr>";
}
print "
</td>
</tr>
</table>
</body>
</html>";
?>