Разработка автоматизированной обучающей системы с функцией контроля знаний

<a style="margin-left: 4px; float: right;" href="article_delete.php?id=<?php

echo $row ['id_article']; ?>" onclick="if(!confirm('Вы действительно

хотите удалить статью \'\'<?php echo $row ['title']; ?>\'\'?')) return false;">

<img width="16" title="Удалить" alt="Удалить" src="img/delete.png" >

</a>

<a style="float: right;" href="?page=articles&obj=edit_article&id=<?php

echo $row ['id_article']; ?>" ><img width="16" title="Редактировать"

alt="Редактировать" src="img/edit.png" ></a>

</div><?php

}

if (!$num)

echo "Нет ни одной статьи";

}

?>

</form>

<?php

}

elseif ($obj == 'add_article') {

?>

<div>

<button style="width: 100px;"onclick="location='<?php echo $_SERVER

['HTTP_REFERER']; ?>'">Назад</button>

</div>

<style type="text/css">

form{

padding: 4px;

}

form *{

width: 100%;

margin-bottom: 4px;

}

</style>

<form action="article_add.php" method="post">

<div>Название:</div>

<input name='title' type='text' required="required" >

<div>Содержание:</div>

<textarea rows="10" name="body"></textarea>

<input type="submit" name="submit" value="Добавить" >

</form><?php

}

elseif ($obj == 'edit_article') {

?>

<div>

<button style="width: 100px;"onclick="location='<?php echo $_SERVER

['HTTP_REFERER']; ?>'">Назад</button>

</div>

<style type="text/css">

form{

padding: 4px;

}

form *{

width: 100%;

margin-bottom: 4px;

}

</style>

<?php

$id = $_GET ['id'];

$row = mysql_fetch_array(mysql_query("SELECT * FROM `article`

WHERE `id_article`='$id'"));

?>

<form action="article_edit.php" method="post">

<input name="id" type="hidden" value="<?php echo $id; ?>" />

<div>Название:</div>

<input name='title' value='<?php echo $row ['title']; ?>' type='text'

required="required">

<div>Контент:</div>

<textarea rows="10" name="body">

<?php echo $row ['body']; ?>

</textarea>

<input type="submit" name="reset" style="width: 48%;" value="Отмена" >

<input type="submit" name="edit" style="float: right; width: 48%;"

value="Изменить" >

</form>

<?php

}

?>

_import.php

<script type="text/javascript">

$('#breadcrumbs').html("Импорт");

</script>

<b>Импорт информации о демографическом состоянии

региона</b><br>

Импортируемый Excel файл должен иметь следующую структуру:

<table>

<thead>

<th>Код региона</th>

<th>Год</th>

<th>Численность населения, чел.</th>

<th>Рождаемость, чел.</th>

<th>Миграция, %</th>

</thead>

<tr>

<td>.</td>

<td>.</td>

<td>.</td>

<td>.</td>

<td>.</td>

</tr>

</table>

В первой строке должны содержаться заголовки столбцов. <br>

Данные должны находиться, начиная со второй строки.

<br><br><br>

<form action="import.php" method="post" enctype="multipart/form-data">

<input type="file" name="file" />

<input type="submit" name="submit" value="Импортировать" />

</form>

_parameters.php

<script type="text/javascript">

$('#breadcrumbs').html("Расчетные параметры");

</script>

<?php

$result = mysql_query("SELECT * FROM `parameter`");

if($result)

{

$row = mysql_fetch_array($result);

}

?>

<form action="set_parameters.php" method="post">

<table>

<tr><th>Параметр</th><th>Значение, %</th></tr>

<tr><td>Рождаемость -> 9 </td><td><input type="number" name="Bto9"

value="<?php echo $row ['Bto9'] ?>" min="0" max="100"/></td></tr>

<tr><td>9 -> 11 </td><td><input type="number" name="9to11"

value="<?php echo $row ['9to11'] ?>" min="0" max="100" /></td></tr>

<tr><td>9 -> НПО </td><td><input type="number" name="9toNPO"

value="<?php echo $row ['9toNPO'] ?>" min="0" max="100" /></td></tr>

<tr><td>9 -> CПО </td><td><input type="number" name="9toSPO"

value="<?php echo $row ['9toSPO'] ?>" min="0" max="100" /></td></tr>

<tr><td>11 -> CПО</td><td><input type="number" name="11toSPO"

value="<?php echo $row ['11toSPO'] ?>" min="0" max="100" /></td></tr>

<tr><td>11 -> ВПО</td><td><input type="number" name="11toVPO"

value="<?php echo $row ['11toVPO'] ?>" min="0" max="100" /></td></tr>

</table>

<input type="submit" name="submit" value="Сохранить" />

</form>

_rss_chanel.php

<script type="text/javascript">

init_tinymce();

</script>

<script type="text/javascript">

$('#breadcrumbs').html("Каналы новостей");

</script>

<?php

$obj = $_GET ['obj'];

if (!isset($obj)) { ?>

<style type="text/css">

div.row{

padding: 4px;

}

div.row:hover{

background-color: #cbe7A0;

}

</style>

<button

onclick="location='index.php?page=rss_chanel&obj=add_chanel'">Добавит

ь канал новостей</button>

<?php

$result = mysql_query("SELECT * FROM `chanel`");

if ($result) {

$num = mysql_num_rows($result);

for ($i = 0; $i < $num; $i++) {

$row = mysql_fetch_array($result);

?>

<div class="row">

<a href="?page=rss_chanel&obj=edit_chanel&id=<?php echo $row

['id_chanel']; ?>" ><?php echo ($i + 1) . ") " . $row ['name'] . " "; ?></a>

<a style="margin-left: 4px; float: right;" href="chanel_delete.php?id=<?php

echo $row ['id_chanel']; ?>" onclick="if(!confirm('Вы действительно

хотите удалить канал \'\'<?php echo $row ['name']; ?>\'\'?')) return false;">

<img width="16" title="Удалить" alt="Удалить" src="img/delete.png" >

</a>

<a style="float: right;" href="?page=rss_chanel&obj=edit_chanel&id=<?php

echo $row ['id_chanel']; ?>" ><img width="16" title="Редактировать"

alt="Редактировать" src="img/edit.png" ></a>

</div><?php

}

if (!$num)

echo "Нет ни одного канала";

}

}

elseif ($obj == 'add_chanel') {

?>

<div>

<button style="width: 100px;"onclick="location='<?php echo $_SERVER

['HTTP_REFERER']; ?>'">Назад</button>

</div>

<style type="text/css">

form{

padding: 4px;

}

form *{

width: 100%;

margin-bottom: 4px;

}

</style>

<form action="chanel_add.php" method="post">

<div>Название:</div>

<input name='name' type='text' required="required" >

<div>Ссылка:</div>

<input name='link' type='text' required="required" >

<input type="submit" name="submit" value="Добавить" >

</form><?php

}

elseif ($obj == 'edit_chanel') {

?>

<div>

<button style="width: 100px;"onclick="location='<?php echo $_SERVER

['HTTP_REFERER']; ?>'">Назад</button>

</div>

<style type="text/css">

form{

padding: 4px;

}

form *{

width: 100%;

margin-bottom: 4px;

}

</style>



<?php

$id = $_GET ['id'];

$row = mysql_fetch_array(mysql_query("SELECT * FROM `chanel`

WHERE `id_chanel`='$id'"));

?>

<form action="chanel_edit.php" method="post">

<input name="id" type="hidden" value="<?php echo $id; ?>" />

<div>Название:</div>

<input name='name' value='<?php echo $row ['name']; ?>' type='text'

required="required">

<div>Ссылка:</div>

<input name='link' value='<?php echo $row ['link']; ?>' type='text'

required="required" >

<input type="submit" name="reset" style="width: 48%;" value="Отмена" >

<input type="submit" name="edit" style="float: right; width: 48%;"

value="Изменить" >

</form>

<?php

}

?>

Article_add.php

<?php

session_start();

include_once 'connect.php';

$title = $_POST ['title'];

$body = $_POST ['body'];

if (!empty($title))

{

if( !mysql_query("INSERT INTO `article`(`title`,`body`,`date`,`id_user`)

VALUES('$title', '$body', NOW(), '$_SESSION [id]')") )

die("Ошибка добавления: ".mysql_error());

}

else

die("Пустое название каталога");

header("Location: index.php?page=articles");

?>

Article_delete.php

<?php

include_once 'connect.php';

$id = $_GET ['id'];

if(!mysql_query("DELETE FROM `article` WHERE `id_article`='$id'"))

die("Ошибка при удалении");

header("Location: index.php?page=articles");

?>

Article_update.php

<?php

if (isset($_POST ['edit'])) {

include_once 'connect.php';

$id = $_POST ['id'];

$title = $_POST ['title'];

$body = $_POST ['body'];

mysql_query("UPDATE `article` SET `title`='$title', `body`='$body'

WHERE `id_article`='$id'");

}

header("Location: index.php?page=articles");

?>

Chanel_add.php

<?php

include_once 'connect.php';

$name = $_POST ['name'];

$link = $_POST ['link'];

if (!empty($name))

{

if( !mysql_query("INSERT INTO `chanel`(`name`,`link`)

VALUES('$name', '$link')") )

die("Ошибка добавления: ".mysql_error());

}

else

die("Пустое название каталога");

header("Location: index.php?page=rss_chanel");

?>

Chanel_delete.php

<?php

include_once 'connect.php';

$id = $_GET ['id'];

if(!mysql_query("DELETE FROM `chanel` WHERE `id_chanel`='$id'"))

die("Ошибка при удалении");



header("Location: index.php?page=rss_chanel");

?>

Chanel_edit.php

<?php

if (isset($_POST ['edit'])) {

include_once 'connect.php';

$id = $_POST ['id'];

$name = $_POST ['name'];

$link = $_POST ['link'];

mysql_query("UPDATE `chanel` SET `name`='$name', `link`='$link'

WHERE `id_chanel`='$id'");

}

header("Location: index.php?page=rss_chanel");

?>

Edit_article.php

<?php

include_once 'connect.php';

$id = $_GET ['id'];

$data = mysql_fetch_array(mysql_query("SELECT body FROM article

WHERE id_article = '$id'"));

$data = $data [0];

?>

<form method="post" action="update_article.php">

<textarea name="data" rows="15" cols="80" ><?php echo $data;

?></textarea>



<input name="id_article" type="hidden" value="<?php echo $id; ?>" />

<button style="margin-top: 4px;" type="submit"

onclick="loadPage('proc.php?act=show&obj=article', 'center'); return false;"

>Отмена</button>

<button name="save" type="submit" style="float: right; margin-top:

4px;">Редактировать</button>

</form>

Import.php

<?php

# импорт ОКЗ из Excel файла

include 'connect.php';

require "phpexcel/PHPExcel.php";

require "phpexcel/PHPExcel/IOFactory.php";

require "phpexcel/PHPExcel/Worksheet.php";

echo $input_fn = $_FILES ['file'] ['tmp_name'];

$inputFileType = PHPExcel_IOFactory::identify($input_fn);

$reader = PHPExcel_IOFactory::createReader($inputFileType);

$reader->setReadDataOnly(true);

$phpExcel = new PHPExcel();

$phpExcel = $reader->load($input_fn);



//$sheet = new PHPExcel_Worksheet();

$sheet = $phpExcel->getActiveSheet();

$max_row = $sheet->getHighestRow();

$max_column = $sheet->getHighestColumn();

$cell_value = array();

$coord = "";

for ($j = 2; $j <= $max_row; $j++)

{

for ($i = "A"; $i <= $max_column; $i++)

{

$coord = "" . $i . $j;

$cell_value [$i] = $sheet->getCell($coord)->getValue();

}

$region_code = $cell_value ['A'];

$result = mysql_query("SELECT `id_region` FROM `region` WHERE

`code`='$region_code'");

$row = mysql_fetch_array($result);

$id_region = $row [0];

$year = $cell_value ['B'];

$population = $cell_value ['C'];

$birth = $cell_value ['D'];

$migration = $cell_value ['E'];

mysql_query("INSERT INTO `demography`(`year`,`population`,`birth`,

`migration`, `id_region`)

VALUES('$year', '$population','$birth', '$migration','$id_region')") or

die(mysql_error());

$cell_value = array();

}

?>

Index.php

<?php

session_start();

#защита от несанкционированного доступа

if(!isset($_SESSION ['id']) || $_SESSION ['type'] != 'user')

return;

include 'connect.php';

include 'modules.php';

?>

<!DOCTYPE html>

<html>

<head>

<?php mod_head(); ?>

</head>

<body id="body">

<!-- Главная оболочка -->

<divid="wrapper_main">

<!-- Заголовок страницы -->

<div id="top"><?php mod_top(); ?></div>



<!-- Содержание страницы -->

<divid="wrapper_content">

<!-- Левая колонка -->

<divid="left">

<div class="module">

<ul id="menu">

<li id="articles" onclick="location='index.php?page=articles'"><a

href="index.php?page=articles">Новости</a></li>

<li id="rss_chanel" onclick="location='index.php?page=rss_chanel'"><a

href="index.php?page=rss_chanel">Каналы новостей</a></li>

<li id="import" onclick="location='index.php?page=import'"><a

href="index.php?page=import">Импорт данных</a></li>

<li id="parameters" onclick="location='index.php?page=parameters'"><a

href="index.php?page=parameters">Рассчетные параметры</a></li>

<li id="out" onclick="location='out.php'"><a

href="out.php">Выход</a></li>

</ul>

<script type="text/javascript">

var items = jQuery("ul#menu li");

var key_selection = 0;

for(var i = 0; i < items.length; i++)

{

if(items [i].id == '<?php echo $_GET ['page']; ?>')

{

key_selection = 1;

items [i].style.backgroundColor = '#eaf3f7';

}

}

</script>

<?php if(!isset($_GET ['page'])){ ?><script type="text/javascript" >

document.getElementById('articles').style.backgroundColor = '#eaf3f7';

</script><?php } ?>

</div>

</div>

<div id="breadcrumbs"></div>

<div id="center">

<?php

if (isset($_GET ['page']))

require '_' . $_GET ['page'] . '.php';

else

require '_articles.php';

?>

</div>

</div>

</div>

<!-- Нижняя часть -->

<div id="footer"><?php mod_footer(); ?></div>

</body>

</html>

<?php mysql_close(); ?>

Modules.php

?<?php

function mod_head() { ?>

<title>Компонент администрирования</title>

<meta name="Resource-Type" content="Document" />

<meta name="keywords" content="" lang="en"/>

<meta name="keywords" content="" lang="ru"/>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

<meta http-equiv="pragma" content="no-cache" />

<meta http-equiv="content-language" content="ru">

<link rel="icon" type="image/x-icon" href="img/icon.png" />

<link rel="stylesheet" type="text/css" href="css/template.css"/>

<script type="text/javascript" src="js/tiny_mce/tiny_mce.js"></script>

<script type="text/javascript" src="js/jquery.js"></script>

<script type="text/javascript" src="js/my.js"></script>

<?php

}

functionmod_top() {?>

Компонент администрирования

<?php

}



function mod_footer() {

$begYear = 2012;

echo '<b>'.$begYear;

$curYear = date("Y");

if( $begYear < $curYear )

echo '-'.$curYear;

echo ' г.</b>';

}

?>

Out.php

<?php

session_start();

$params = session_get_cookie_params();

if (!setcookie("PHPSESSID", "", $params ['lifetime'], $params ['path'],

$params ['domain'], $params ['secure']))

echo "Не удалось снять куки!";

else {

$_SESSION = array();

session_destroy();

}

header("Location: ../index.php");

?>

Set_parameter.php

<?php

include 'connect.php';

$_Bto9 = $_POST ['Bto9'];

settype($_Bto9, "float");

$_9to11 = $_POST ['9to11'];

settype($_9to11, "float");

$_9toNPO = $_POST ['9toNPO'];

settype($_9toNPO, "float");

$_9toSPO = $_POST ['9toSPO'];

settype($_9toSPO, "float");

$_11toSPO = $_POST ['11toSPO'];

settype($_11toSPO, "float");

$_11toVPO = $_POST ['11toVPO'];

settype($_11toVPO, "float");

mysql_query("UPDATE `parameter` SET `Bto9`='$_Bto9',

`9to11`='$_9to11',

`9toNPO`='$_9toNPO',

`9toSPO`='$_9toSPO',

`11toSPO`='$_11toSPO',

`11toVPO`='$_11toVPO'");

header("Location: index.php?page=parameters");

?>

Update.article.php

<?php

include_once 'connect.php';

$id_article = $_POST ['id_article'];

$data = $_POST ['data'];

if(mysql_query("UPDATE `article` SET `body`='$data' WHERE `id_article`

= '$id_article'")){

?>

<script type="text/javascript">

location.href = "index.php?goto=article";

</script>

<?php

}

?>

Размещено на Allbest.ru