Диссертация (1167217), страница 74
Текст из файла (страница 74)
"<br><br>";}echo <<<_END<form action="sqltest.php" method="post"><pre>Фамилия <input type="text" name="uname">Имя <input type="text" name="ufname">Рейтинг <input type="text" name="urating">Эл. почта <input type="text" name="uemail"><input type="submit" value="ДОБАВИТЬ ЗАПИСЬ"></pre></form>_END;$query = "SELECT * FROM users";$result = $conn->query($query);if (!$result) die ("Database access failed: " . $conn->error);$rows = $result->num_rows;for ($j = 0 ; $j < $rows ; ++$j){$result->data_seek($j);$row = $result->fetch_array(MYSQLI_ASSOC);echo <<<_END<pre>ID: $row[id]Фамилия: $row[uname]Имя: $row[ufname]Рейтинг: $row[urating]Эл. почта: $row[uemail]</pre><form action="sqltest.php" method="post"><input type="hidden" name="delete" value="yes"><input type="hidden" name="uemail" value="$row[uemail]"><input type="submit" value="УДАЛИТЬ ЗАПИСЬ"></form>_END;}$result->close();$conn->close();function mysql_entities_fix_string($conn, $string){return htmlentities(mysql_fix_string($conn, $string));}function mysql_fix_string($conn, $string)461{if (get_magic_quotes_gpc()) $string = stripslashes($string);// $string = preg_replace('/\W*/', '', $string); // убирает русск.
буквыreturn $conn->real_escape_string($string);}/*function get_post($conn, $var){return $conn->real_escape_string($_POST[$var]);}*/?></div><a href="#0" class="cd-top">Top</a><a id="markB"></a> <!-- site footer --></body></html>ФАЙЛ TRAINERK2<?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,"info": false});$( ".clickable" ).click(function( event ) {$(this).next().toggleClass("whitetext");});});function clickTheButton(buttonId) {$("#"+buttonId).click();}function aster(wordid, num) { // id слова и сколько будет новы1 уровеньсложности$.ajax({462type: 'POST',url: 'aster.php',data: { wordid: wordid, num: num },beforeSend: function() {var h = $('button').height();$('#' + wordid).html("<img width='" + h + "' height='" + h +"' src='/img/spinner.gif'>");},/*complete: function() {$('#' + wordid).html("");},*/success: function(data){$('#' + wordid).html(data);}});}</script><style></style></head><body><a id="markZero"></a> <!-- site head --><a id="markA"></a> <!-- Nav bar --><?php// Что выводить для зарегистрированного пользователя////////////////////////////////////////////////if ($_SESSION['login_user']) {isexpired();// Проверено, не истекла ли сессия// Получение из БД порядка расположения пунктов карточки$conn = new mysqli($hn, $un, $pw, $db);if ($conn->connect_error) die($conn->connect_error);$email = $_SESSION['login_user'];$query = "SELECT * FROM users WHERE uemail='$email'";$result = $conn->query($query);if (!$result) die($conn->error);else {$row = $result->fetch_array(MYSQLI_ASSOC);$cards2 = $row['cards2'];}echo "<p class='right'>" .
$_SESSION['login_user_firstname'] . " " .$_SESSION['login_user_famname'] . "| <a href='logout.php'>Выйти</a>";// Продолжение работы зарегистрированного пользователяif ((isset($_POST['setid']) && isset($_POST['trainerk2']))) {$setid = $_POST['setid'];$query = "SELECT * FROM lexsets WHERE setid=$setid";$result = $conn->query($query);if (!$result) die($conn->error);else {$row = $result->fetch_array(MYSQLI_ASSOC);$setname = $row['setname'];}463echo "<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 "</tr></table>";$query = "SELECT * FROM words WHERE refsetid=$setid ORDER BY Rand()";$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>";$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>";}$aster = '';for ($i=0; $i<$row['levels']; $i++) {$aster .= '*';}echo "<tr><td class='clickable'>" . $side1 . "</td><tdclass='whitetext'>" . $side2 . "</td><td style='border: none;'><span id='" .$row['wordid'] . "'>" . $aster . "</span><br><button onclick='aster(" .$row['wordid'] . ", 1)'>*</button><button onclick='aster(" . $row['wordid'] .
",2)'>* *</button><button onclick='aster(" . $row['wordid'] . ", 3)'>* **</button></td></tr>";$side1 = $side2 = "";$hiddenButtons .= "";}echo "</table>";}$result->close();$conn->close();} // if (isset($_POST['setid']))464else {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>ФАЙЛ TRAINERK22.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,"info": false});$( ".clickable" ).click(function( event ) {$(this).next().toggleClass("whitetext");});});465function clickTheButton(buttonId) {$("#"+buttonId).click();}function aster(wordid, num) { // id слова и сколько будет новы1 уровеньсложности$.ajax({type: 'POST',url: 'aster.php',data: { wordid: wordid, num: num },beforeSend: function() {var h = $('button').height();$('#' + wordid).html("<img width='" + h + "' height='" + h +"' src='/img/spinner.gif'>");},/*complete: function() {$('#' + wordid).html("");},*/success: function(data){$('#' + wordid).html(data);}});}</script><style></style></head><body><a id="markZero"></a> <!-- site head --><a id="markA"></a> <!-- Nav bar --><?php// Что выводить для зарегистрированного пользователя////////////////////////////////////////////////if ($_SESSION['login_user']) {isexpired();// Проверено, не истекла ли сессия// Получение из БД порядка расположения пунктов карточки$conn = new mysqli($hn, $un, $pw, $db);if ($conn->connect_error) die($conn->connect_error);$email = $_SESSION['login_user'];$query = "SELECT * FROM users WHERE uemail='$email'";$result = $conn->query($query);if (!$result) die($conn->error);else {$row = $result->fetch_array(MYSQLI_ASSOC);$cards2 = $row['cards2'];}echo "<p class='right'>" .
$_SESSION['login_user_firstname'] . " " .$_SESSION['login_user_famname'] . "| <a href='logout.php'>Выйти</a>";// Продолжение работы зарегистрированного пользователяif ((isset($_POST['setid']) && isset($_POST['trainerk2']))) {$setid = $_POST['setid'];$query = "SELECT * FROM lexsets WHERE setid=$setid";466$result = $conn->query($query);if (!$result) die($conn->error);else {$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 .
![](https://s.studizba.com/z.php?f=/templates/si/i/noavatar.png&w=100&h=100&t=1"){kind=avatar}
