Диссертация (1167217), страница 73
Текст из файла (страница 73)
$_SESSION['login_user_firstname'] . " " .$_SESSION['login_user_famname'] . "| <a href='logout.php'>Выйти</a>";// Продолжение работы зарегистрированного пользователяif ((isset($_POST['setid']) && isset($_POST['cards2']))) {$setid = $_POST['setid'];$query = "SELECT * FROM lexsets WHERE setid=$setid";$result = $conn->query($query);if (!$result) die($conn->error);455else {$row = $result->fetch_array(MYSQLI_ASSOC);$setname = $row['setname'];}echo "<div class='cmain'>";echo "<table><tr>";echo "<td><form method='post' action='showwords.php'><inputtype='hidden' name='setid' value='" .
$setid . "'><input type='hidden'name='setname' value='" . $setname . "'>";echo "<input type='submit' class='custombutton'value='НАЗАД'></form></td>";echo "<td><form method='post' action='dlcards2.php'><input type='hidden'name='setid' value='" . $setid . "'><input type='hidden' name='setname' value='" .$setname . "'><input type='hidden' name='cards2' value='yes'>";echo "<input type='submit' class='custombutton' value='Загрузитьнабор'></form></td>";echo "</tr></table>";$query = "SELECT * FROM words WHERE refsetid=$setid";$result = $conn->query($query);if (!$result) die($conn->error);elseif ($result->num_rows == 0) {echo "<h3 class='center'>Набор \"" .
$setname . "\" (0)</h3>";}elseif ($result->num_rows > 0) {echo "<h3 class='center'>Набор \"" . $setname . "\" (" .$result->num_rows . ")</h3>";// Обработка строки БД с порядком расположения пунктов карточки//$cards2 = "mainword:1-1,phonetics:1-2,transl:2-1,grammar:22,forms:3,examples:2-3,extra:3,levels:3,parts:3";//$s1arr = getCards2($cards2)[0];//$s2arr = getCards2($cards2)[1];$sarr = getCards2($cards2);$s1arr = $sarr[0];$s2arr = $sarr[1];echo "<table class='cards1'>";$counter = 0;$side1 = $side2 = "";foreach ($result as $row) {$counter++;foreach ($s1arr as $s1) {$side1 .= $row[$s1] .
"<br>";}foreach ($s2arr as $s2) {$side2 .= $row[$s2] . "<br>";}echo "<tr><td>" . $counter . "(" . $row['wordid'] .")<br><br>" . $side1 . "</td><td>" . $side2 . "</td></tr>";$side1 = $side2 = "";$hiddenButtons .= "";}456echo "</table>";}$result->close();$conn->close();} // if (isset($_POST['setid']))else {echo <<<_END<script>window.location.href ="http://agoroz.bget.ru/mysets.php";</script>_END;}} // if ($_SESSION['login_user'])// Что выводить для НЕзарегистрированного пользователя////////////////////////////////////////////////else {echo <<<_END<script>window.location.href ="http://agoroz.bget.ru/login.php";</script>_END;}?></div><a href="#0" class="cd-top">Top</a><a id="markB"></a> <!-- site footer --></body></html>ФАЙЛ SHOWWORDS.PHP<?phprequire_once 'config.php';session_start();?><!DOCTYPE html><html><head><meta charset="UTF-8"><title>Show Words</title><link rel="stylesheet" type="text/css" href="css/main2.css"><link rel="stylesheet" type="text/css" href="css/jquery.dataTables.min.css"><script type="text/javascript" src='http://code.jquery.com/jquerylatest.min.js'></script><script type="text/javascript" src="js/jquery.dataTables.min.js"></script><script type="text/javascript" src="js/nav.js"></script><script src="js/main.js"></script><script>$(document).ready(function() {$("#markZero").replaceWith(siteHead);$("#markA").replaceWith(navBar);$("#markB").replaceWith(siteFooter);$('#dtab').DataTable( {"searching": false,"paging": false,457"info": false});});function clickTheButton(buttonId) {$("#"+buttonId).click();}</script><style></style></head><body><a id="markZero"></a> <!-- site head --><a id="markA"></a> <!-- Nav bar --><?php// Что выводить для зарегистрированного пользователя////////////////////////////////////////////////if ($_SESSION['login_user']) {isexpired();// Проверено, не истекла ли сессияecho "<p class='right'>" .
$_SESSION['login_user_firstname'] . " " .$_SESSION['login_user_famname'] . "| <a href='logout.php'>Выйти</a>";// Продолжение работы зарегистрированного пользователя$conn = new mysqli($hn, $un, $pw, $db);if ($conn->connect_error) die($conn->connect_error);if ((isset($_POST['setid']) && isset($_POST['setname'])) ||(isset($_SESSION['setidfromdel']) && isset($_SESSION['setnamefromdel']))) {if (isset($_SESSION['setidfromdel']) &&isset($_SESSION['setnamefromdel'])) {$setid = $_SESSION['setidfromdel'];$setname = $_SESSION['setnamefromdel'];unset($_SESSION['setidfromdel']);unset($_SESSION['setnamefromdel']);}else {$setid = $_POST['setid'];$setname = $_POST['setname'];}echo "<div class='cmain'>";echo "<table><tr>";echo "<td><form action='newword.php' method='post'><input type='hidden'name='newword' value='yes'><input type='hidden' name='setid' value='" .
$setid ."'><input class='custombutton' type='submit' value='Добавить'></form></td>";echo "<td><form action='showcards1.php' method='post'><inputtype='hidden' name='cards1' value='yes'><input type='hidden' name='setid' value='". $setid . "'><input class='custombutton' type='submit' value='Карточки1'></form></td>";echo "<td><form action='showcards2.php' method='post'><inputtype='hidden' name='cards2' value='yes'><input type='hidden' name='setid' value='". $setid .
"'><input class='custombutton' type='submit' value='Карточки2'></form></td>";echo "<td><form action='changeshowcards2.php' method='post'><inputtype='hidden' name='setid' value='" . $setid . "'><input type='hidden'name='setname' value='" . $setname . "'><input type='hidden' name='changecards2'458value='yes'><input class='custombutton' type='submit' value='<=Настроить'></form></td>";echo "<td><form action='trainerk2.php' method='post'><inputtype='hidden' name='setid' value='" . $setid . "'><input type='hidden'name='setname' value='" .
$setname . "'><input type='hidden' name='trainerk2'value='yes'><input class='custombutton' type='submit' value='Тренажер К21'></form></td>";echo "<td><form action='trainerk22.php' method='post'><inputtype='hidden' name='setid' value='" . $setid . "'><input type='hidden'name='setname' value='" . $setname . "'><input type='hidden' name='trainerk2'value='yes'><input class='custombutton' type='submit' value='Тренажер К22'></form></td>";echo "<td><form action='saveset.php' method='post'><input type='hidden'name='setid' value='" .
$setid . "'><input type='hidden' name='setname' value='" .$setname . "'><input type='hidden' name='saveset' value='yes'><inputclass='custombutton' type='submit' value='Сохранить в файл'></form></td>";echo "</tr></table>";$query = "SELECT * FROM words WHERE refsetid=$setid";$result = $conn->query($query);if (!$result) die($conn->error);elseif ($result->num_rows == 0) {echo "<h3 class='center'>Набор \"" . $setname . "\" (0)</h3>";}elseif ($result->num_rows > 0) {echo "<h3 class='center'>Набор \"" .
$setname . "\" (" .$result->num_rows . ")</h3>";echo "<table id='dtab' class='display' cellspacing='0'width='100%'><thead><tr><th>id</th><th>setid</th><th>Единица</th><th>ФП</th><th>Перевод</th><th>ГП</th><th>Формы</th><th>Примеры</th><th>Дополнительно</th><th>Частьречи</th><th>Действия</th></tr></thead><tbody>";foreach ($result as $row) {echo "<tr><td>" . $row['wordid'] . "</td><td>" .$row['refsetid'] . "</td><td>" .
$row['mainword'] . "</td><td>" .$row['phonetics'] . "</td><td>" . $row['transl'] . "</td><td>" . $row['grammar'] ."</td><td>" . $row['forms'] . "</td><td>" . $row['examples'] . "</td><td>" .$row['extra'] . "</td><td>" . $row['parts'] . "</td><td><formaction='deleteword.php' method='post' onsubmit=\"return confirm('Удалитьединицу?');\"><input type='hidden' name='delword' value='yes'><input type='hidden'name='wordid' value='" . $row['wordid'] . "'><input class='custombutton'type='submit' value='Удалить'></form><form action='editword.php'method='post'><input type='hidden' name='editword' value='yes'><inputtype='hidden' name='wordid' value='" . $row['wordid'] .
"'><inputclass='custombutton' type='submit' value='Редактировать'></form></td></tr>";$hiddenButtons .= "";}echo "</tbody></table>";}$result->close();$conn->close();} // if (isset($_POST['setid']))else {echo <<<_END459<script>window.location.href ="http://agoroz.bget.ru/mysets.php";</script>_END;}} // if ($_SESSION['login_user'])// Что выводить для НЕзарегистрированного пользователя////////////////////////////////////////////////else {echo <<<_END<script>window.location.href ="http://agoroz.bget.ru/login.php";</script>_END;}?></div><a href="#0" class="cd-top">Top</a><a id="markB"></a> <!-- site footer --></body></html>ФАЙЛ SQLTEST900.PHP<!DOCTYPE html><html><head><meta charset="UTF-8"><title>Index</title><link rel="stylesheet" type="text/css" href="css/main2.css"><script type="text/javascript" src="js/jquery.js"></script><script type="text/javascript" src="js/nav.js"></script><script src="js/main.js"></script><script>$(document).ready(function() {$("#markZero").replaceWith(siteHead);$("#markA").replaceWith(navBar);$("#markB").replaceWith(siteFooter);});</script><style></style></head><body><a id="markZero"></a> <!-- site head --><a id="markA"></a> <!-- Nav bar --><div class="cmain"><?php // sqltest.phprequire_once 'login.php';$conn = new mysqli($hn, $un, $pw, $db);if ($conn->connect_error) die($conn->connect_error);if (isset($_POST['delete']) && isset($_POST['uemail'])){$uemail = mysql_entities_fix_string($conn, $_POST['uemail']);$query = "DELETE FROM users WHERE uemail='$uemail'";$result = $conn->query($query);if (!$result) echo "DELETE failed: $query<br>" .460$conn->error .
"<br><br>";}if (isset($_POST['uname']) && $_POST['uname'] != '' &&isset($_POST['ufname']) && $_POST['ufname'] != '' &&isset($_POST['urating']) &&isset($_POST['uemail']) && $_POST['uemail'] != ''){$uname = mysql_entities_fix_string($conn, $_POST['uname']);$ufname = mysql_entities_fix_string($conn, $_POST['ufname']);$urating = mysql_entities_fix_string($conn, $_POST['urating']);$uemail = mysql_entities_fix_string($conn, $_POST['uemail']);$query = "INSERT INTO users VALUES" ."(NULL, '$uname', '$uemail', '$ufname', '$urating')";$result = $conn->query($query);if (!$result) echo "INSERT failed: $query<br>" .$conn->error .