Skip to content

Instantly share code, notes, and snippets.

@sanasol

sanasol/gist:2905199

Created June 10, 2012 12:05
Show Gist options
  • Save sanasol/2905199 to your computer and use it in GitHub Desktop.
Save sanasol/2905199 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.aw
<?php
switch($_GET["subact"]){
case "dep":
echo "<h1 class=\"h1title\">Отделы</h1>";
echo "<p><a href=\"adminpanel.php?act=library&subact=add_dep\">Добавить отдел</a></p>";
echo "<table style=\"border: 1px solid gray;\" cellspacing=\"5px\">";
$query = mysql_query("select `id`, `title` from `department` order by `id` desc", $dblink);
$count = mysql_num_rows($query);
if($count >= 1)
{
while($row = mysql_fetch_array($query))
{
echo "<tr><td width=\"50%\">{$row["title"]}</td><td><a href=\"adminpanel.php?act=library&subact=edit_dep&id={$row["id"]}\">Редактировать</a></td><tr>";
}
}
else
{
echo "<tr><td>У вас еще нет ни одного отдела</td></tr>";
}
echo "</table>";
break;
case "prog":
echo "<h1 class=\"h1title\">Программы</h1>";
echo "<p><a href=\"adminpanel.php?act=library&subact=add_prog\">Добавить программу</a></p>";
echo "<table style=\"border: 1px solid gray;\" cellspacing=\"5px\">";
$query = mysql_query("select `programs`.`id`, `programs`.`title`, `department`.`title` as dep from `programs` left join `department` on `department`.`id`=`programs`.`id_department` order by `programs`.`id_department` asc", $dblink) or die(mysql_error());
$count = mysql_num_rows($query);
if($count >= 1)
{
echo "<tr><td>Программа</td><td>Отдел</td><td></td></tr>";
while($row = mysql_fetch_array($query))
{
echo "<tr><td>{$row["title"]}</td><td>{$row["dep"]}</td><td><a href=\"adminpanel.php?act=library&subact=edit_prog&id={$row["id"]}\">Редактировать</a></td><tr>";
}
}
else
{
echo "<tr><td>У вас еще нет ни одной программы</td></tr>";
}
echo "</table>";
break;
case "book":
echo "<h1 class=\"h1title\">Книги</h1>";
break;
case "add_dep":
if(isset($_POST["submit_lib"]))
{
if(library::departament("add", $_POST))
{
echo "Отдел создан!";
}
else
{
echo "Ошибка!";
}
}
else
{
?>
<h1 class="h1title">Добавить отдел</h1>
<form name="department_adder" action="adminpanel.php?act=library&subact=add_dep" method="post">
<table class="addformtable" style="font-size: 0.8em;">
<tr>
<td><label for="title">Название</label></td>
<td>
<input type="text" name="title" size="120" maxsize="200">
</td>
</tr>
<tr>
<td><label for="text_date">Описание</label></td>
<td>
<input type="text" name="text_date" size="120" maxsize="250">
</td>
</tr>
<tr>
<td style="text-align: right"><input type="submit" name="submit_lib" value="Опубликовать &rarr;" /></td>
</tr>
</table>
</form>
<?php
}
break;
case "edit_dep":
if(isset($_POST["submit_lib"]))
{
if(library::departament("edit", $_POST))
{
echo "Отдел сохранен!";
}
else
{
echo "Ошибка!";
}
}
else
{
$query = mysql_query("select `id`, `title`, `description` from `department` where `id`='{$_GET["id"]}'", $dblink);
$row = mysql_fetch_assoc($query);
?>
<h1 class="h1title">Редактировать отдел</h1>
<form name="department_adder" action="adminpanel.php?act=library&subact=edit_dep" method="post">
<table class="addformtable" style="font-size: 0.8em;">
<tr>
<td><label for="title">Название</label></td>
<td>
<input type="hidden" name="id" value="<?php echo $row["id"];?>">
<input type="text" name="title" size="120" maxsize="200" value="<?php echo $row["title"];?>">
</td>
</tr>
<tr>
<td><label for="text_date">Описание</label></td>
<td>
<input type="text" name="text_date" size="120" maxsize="250" value="<?php echo $row["description"];?>">
</td>
</tr>
<tr>
<td style="text-align: right"><input type="submit" name="submit_lib" value="Сохранить &rarr;" /></td>
</tr>
</table>
</form>
<?php
}
break;
////////////////////////
case "add_prog":
if(isset($_POST["submit_lib"]))
{
if(library::programm("add", $_POST))
{
echo "Программа создана!";
}
else
{
echo "Ошибка!";
}
}
else
{
?>
<h1 class="h1title">Добавить программу</h1>
<form name="department_adder" action="adminpanel.php?act=library&subact=add_prog" method="post">
<table class="addformtable" style="font-size: 0.8em;">
<tr>
<td><label for="title">Название</label></td>
<td>
<input type="text" name="title" size="120" maxsize="200">
</td>
</tr>
<tr>
<td><label for="title">Отдел</label></td>
<td>
<select name="dep_id">
<?php
$query = mysql_query("select `id`, `title` from `department` order by `id` asc", $dblink);
$count = mysql_num_rows($query);
if($count >= 1)
{
while($row = mysql_fetch_array($query))
{
echo "<option value=\"{$row["id"]}\">{$row["title"]}</option>";
}
}
else
{
echo "<option>У вас еще нет ни одного отдела</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td><label for="text_date">Описание</label></td>
<td>
<input type="text" name="text_date" size="120" maxsize="250">
</td>
</tr>
<tr>
<td style="text-align: right"><input type="submit" name="submit_lib" value="Опубликовать &rarr;" /></td>
</tr>
</table>
</form>
<?php
}
break;
case "edit_prog":
if(isset($_POST["submit_lib"]))
{
if(library::programm("edit", $_POST))
{
echo "Программа сохранена!";
}
else
{
echo "Ошибка!";
}
}
else
{
$query = mysql_query("select `id`, `title`, `description` from `programs` where `id`='{$_GET["id"]}'", $dblink);
$row = mysql_fetch_assoc($query);
?>
<h1 class="h1title">Редактировать программу</h1>
<form name="department_adder" action="adminpanel.php?act=library&subact=edit_prog" method="post">
<table class="addformtable" style="font-size: 0.8em;">
<tr>
<td><label for="title">Название</label></td>
<td>
<input type="hidden" name="id" value="<?php echo $row["id"];?>">
<input type="text" name="title" size="120" maxsize="200" value="<?php echo $row["title"];?>">
</td>
</tr>
<tr>
<td><label for="title">Отдел</label></td>
<td>
<select name="dep_id">
<?php
$query_1 = mysql_query("select `id_department` from `programs` where `id`='{$_GET["id"]}'", $dblink);
$row1 = mysql_fetch_assoc($query_1);
$query2 = mysql_query("select `id`, `title` from `department` order by `id` asc", $dblink);
$count2 = mysql_num_rows($query2);
if($count2 >= 1)
{
while($row2 = mysql_fetch_array($query2))
{
if($row2["id"] == $row1["id_department"])
{
echo "<option value=\"{$row2["id"]}\" selected>{$row2["title"]}</option>";
}
else
{
echo "<option value=\"{$row2["id"]}\">{$row2["title"]}</option>";
}
}
}
else
{
echo "<option>У вас еще нет ни одного отдела</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td><label for="text_date">Описание</label></td>
<td>
<input type="text" name="text_date" size="120" maxsize="250" value="<?php echo $row["description"];?>">
</td>
</tr>
<tr>
<td style="text-align: right"><input type="submit" name="submit_lib" value="Сохранить &rarr;" /></td>
</tr>
</table>
</form>
<?php
}
break;
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment