Файл: Разработка WEB-ресурса по обмену книгами «BookTrade.org».pdf

Сделать презентацию

Скачать файл (2,64Мб)

Заказать решение

ВУЗ: Не указан

Категория: Курсовая работа

Дисциплина: Не указана

Добавлен: 25.04.2023

Просмотров: 328

Скачиваний: 2

ВНИМАНИЕ! Если данный файл нарушает Ваши авторские права, то обязательно сообщите нам.

СОДЕРЖАНИЕ

Введение

1. Техническое задание

2. Описание модулей серверной части программы и их взаимодействие

3. Описание структуры базы данных

4. Описание структуры клиентской части

4.1. Описание интерфейса пользователя

4.2. Описание интерфейса администратора

4.3. Инструкция пользователя

Заключение

Список литературы

Приложение

} while ($res = mysqli_fetch_array($wrg));

if ($_SESSION['username'] == $username) {

$sql = "DELETE FROM w_read WHERE wr_id = '$wr_id'";

if (mysqli_query($connection, $sql)) {

mysqli_close($connection);

header('Location: /booktrade.org/user.php');

exit;

}

else {

echo "Error deleting record";

}

index.php

<?php

session_start();

require('includes/connect.php');

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>BookTrade</title>

</head>

<body>

<?php

if (isset($_SESSION['username'])) {

include('includes/aheader.php');

} else {

include('includes/header.php');

}

<ul>

<a href="quotes.php"><li class="li_reg">Quotes</li></a>

<a href="reviews.php"><li class="li_reg">Users' reviews</li></a>

<a href="toffers.php"><li class="li_reg">Trade offers</li></a>

<a href="news.php"><li class="li_last">Literature news</li></a>

</ul>

<br>

<?php

if ($_SESSION['username'] == NULL) {

echo "<h3 align='center'>This site was made by book lovers for book lovers. Here you can find the latest literature news, exchange books with other users or even find new friends.<br>Our resource is not aimed at providing information, but in the search for something new. You can find something new for yourself by looking at a section with a random book, random quotes, or even a selection of random reviews!</h3>";

}

<hr>

<h5>Users online now:</h5>

<p>

<?php

$query_online = "SELECT * FROM user_info WHERE active=1";

$result_online = mysqli_query($connection, $query_online) or die("Ошибка " . mysqli_error($connection));

if($result_online) {

$rows = mysqli_num_rows($result_online);

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

$row = mysqli_fetch_row($result_online);

echo "<a href='user.php?name=$row[0]'>$row[0]</a> ";

}

</p>

<hr>

<?php

$query = ('SELECT title, text FROM (SELECT * FROM site_news ORDER BY n_id DESC LIMIT 5) AS T ORDER BY n_id ASC');

$result = mysqli_query($connection, $query) or die("Ошибка " . mysqli_error($connection));

if($result) {

$rows = mysqli_num_rows($result);

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

$row = mysqli_fetch_row($result);

echo "<h3>$row[0]</h3>";

echo "<p>$row[1]</p>";

echo "<h5>$row[3]</h5>";

echo "<br>";

}

</div>

<?php include('includes/footer.php'); ?>

</div>

</body>

</html>

addbook.php

<?php

session_start();

require('includes/connect.php');

$username = $_SESSION['username'];

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>BookTrade | Add book</title>

</head>

<body>

</body>

<?php

echo "<a href='index.php'><- Back to home page</a><br><a href='user.php?name=$username'><- Back to userpage</a>";

if ($_SESSION['rights'] > 0) {

$tbookname = $_POST['tbookname'];

$tradeinfo = $_POST['tradeinfo'];

$tauthor = $_POST['tauthor'];

if ($tbookname != NULL && $tradeinfo != NULL && $tauthor != NULL) {

$query_trade = "INSERT INTO w_trade (username, bookname, author, trade_info) VALUES ('$username', '$tbookname', '$tauthor', '$tradeinfo')";

$add_trade = mysqli_query($connection, $query_trade) or die(mysqli_error($connection));

echo "<p>You added trade offer.</p>";

}

$wbookname = $_POST['wbookname'];

$wauthor = $_POST['wauthor'];

if ($wbookname != NULL && $wauthor != NULL) {

$query_wanted = "INSERT INTO w_read (username, bookname, author) VALUES ('$username', '$wbookname', '$wauthor')";

$add_wanted = mysqli_query($connection, $query_wanted) or die(mysqli_error($connection));

echo "<p>You added $wbookname to wanted books.</p>";

}

$rbookname = $_POST['rbookname'];

if ($rbookname != NULL && $rauthor != NULL) {

$query_readed = "INSERT INTO readed (username, bookname, author) VALUES ('$username', '$rbookname', '$rauthor')";

$add_readed = mysqli_query($connection, $query_readed) or die(mysqli_error($connection));

echo "<p>You added $rbookname to readed books.</p>";

}

echo "<form action='addbook.php' id='addtrade' method='POST' name='addtrade'>

<h4>Add trade offer:</h4>

<p>Author:</p>

<p>Trade info:</p>

<p class='submit'><input class='button' id='admit' name='admit' type='submit' value='Add trade offer'></p></form><hr>";

echo "<form action='addbook.php' id='addwanted' method='POST' name='addwanted'>

<h4>Add wanted book:</h4>

<p>Author:</p>

<p class='submit'><input class='button' id='admit' name='admit' type='submit' value='Add wanted book'></p></form><hr>";

echo "<form action='addbook.php' id='addreaded' method='POST' name='addeaded'>

<h4>Add readed book:</h4>

<p>Author:</p>

<p class='submit'><input class='button' id='admit' name='admit' type='submit' value='Add readed book'></p></form><hr>";

}

</div>

</body>

addreview.php

<?php

session_start();

require('includes/connect.php');

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>BookTrade | Literature news</title>

</head>

<body>

<?php

if (isset($_SESSION['username'])) {

include('includes/aheader.php');

} else {

include('includes/header.php');

}

<ul>

<a href="quotes.php"><li class="li_reg">Quotes</li></a>

<a href="reviews.php"><li class="li_reg">Users' reviews</li></a>

<a href="toffers.php"><li class="li_reg">Trade offers</li></a>

<a href="news.php"><li class="li_last">Literature news</li></a>

</ul>

<br>

<?php

if ($_SESSION['rights'] > 0) {

$bookname = $_POST['bookname'];

$review = $_POST['review'];

$rating = $_POST['rating'];

$author = $_POST['author'];

if ($bookname != NULL && $review != NULL && $rating != NULL) {

$query = "INSERT INTO reviews (bookname, username, review, rating, author) VALUES ('$bookname', '$username', '$review', '$rating', '$author')";

$update_active = mysqli_query($connection, $query) or die(mysqli_error($connection));

echo "<p>You added review.</p>";

}

echo "<h2>Add your review!</h2>

<p>Author:</p>

<p>Your review:</p>

<p class='submit'><input class='button' id='admit' name='admit' type='submit' value='Add review!'></p></form>";

} else {

echo "<p>You haven't rights to use this page.</p>";

if ($_SESSION['username'] == NULL) {

echo "<p>You should register or log in to add your review.</p>";

}

</div>

<?php include('includes/footer.php'); ?>

</div>

</body>

</html>

adminpanel.php

<?php

session_start();

require("includes/connect.php");

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>BookTrade | Adminpanel</title>

.button {

border: solid 1px #094b9c;

background: #3986c9;

color: #fff;

height: 30px;

width: 150px;

padding: 7px 12px;

cursor: pointer;

}

.button:hover {

background: #094b9c;

}

input {

background: #fbfbfb;

font-size: 12pt;

line-height: 1;

width: 300px;

padding: 3px;

padding-left: 10px;

margin: 0 6px 5px 0;

outline: none;

border-bottom: 1px solid #d9d9d9;

border-top: 0px;

border-left: 0px;

border-right: 0px;

}

</style>

</head>

<body>

<?php

if ($_SESSION['rights'] == 2) {

$busername = $_POST['busername'];

if ($busername != NULL) {

$query = "UPDATE users SET rights='0' WHERE username='$busername'";

$update_active = mysqli_query($connection, $query) or die(mysqli_error($connection));

echo "<p>You banned $busername.</p>";

}

$unbusername = $_POST['unbusername'];

if ($unbusername != NULL) {

$query = "UPDATE users SET rights='1' WHERE username='$unbusername'";

$update_active = mysqli_query($connection, $query) or die(mysqli_error($connection));

echo "<p>You unbanned $unbusername.</p>";

}

$bookname = $_POST['bookname'];

$author = $_POST['author'];

$genre = $_POST['genre'];

if ($bookname != NULL && $author != NULL && $genre != NULL) {

$query = "INSERT INTO books (bookname, author, genre) VALUES ('$bookname', '$author', '$genre')";

$update_active = mysqli_query($connection, $query) or die(mysqli_error($connection));

echo "<p>You added book: $bookname by $author ($genre).</p>";

}

$bookid = $_POST['bookid'];

$ebookname = $_POST['ebookname'];

$eauthor = $_POST['eauthor'];

$egenre = $_POST['egenre'];

if ($bookid != NULL && $ebookname != NULL) {

$query_active = "UPDATE books SET bookname='$ebookname' WHERE book_id='$bookid'";

$update_active = mysqli_query($connection, $query_active) or die(mysqli_error($connection));

}

if ($bookid != NULL && $eauthor != NULL) {

$query_active = "UPDATE books SET author='$eauthor' WHERE book_id='$bookid'";

$update_active = mysqli_query($connection, $query_active) or die(mysqli_error($connection));

}

if ($bookid != NULL && $egenre != NULL) {

$query_active = "UPDATE books SET genre='$egenre' WHERE book_id='$bookid'";

$update_active = mysqli_query($connection, $query_active) or die(mysqli_error($connection));

}

$stitle = $_POST['stitle'];

$stext = $_POST['stext'];

$usr = $_SESSION['username'];

if ($stitle != NULL && $stext != NULL) {

$query = "INSERT INTO site_news (title, text, username) VALUES ('$stitle', '$stext', '$usr')";

$update_active = mysqli_query($connection, $query) or die(mysqli_error($connection));

echo "<p>You added site news: $stitle.</p>";

}

$ltitle = $_POST['ltitle'];

$lstext = $_POST['lstext'];

$ltext = $_POST['ltext'];

if ($ltitle != NULL && $lstext != NULL && $ltext != NULL) {

$query = "INSERT INTO lit_news (title, small_text, text, username) VALUES ('$ltitle', '$lstext', '$ltext', '$usr')";

$update_active = mysqli_query($connection, $query) or die(mysqli_error($connection));

echo "<p>You added site news: $ltitle.</p>";

}

$qtext = $_POST['qtext'];

$qbookname = $_POST['qbookname'];

if ($qtext != NULL && $qbookname != NULL) {

$query = "INSERT INTO quotes (bookname, quote_text) VALUES ('$qbookname', '$qtext')";

$update_active = mysqli_query($connection, $query) or die(mysqli_error($connection));

echo "<p>You added quote: $qtext.</p>";

}

echo "<p><a href='index.php'><- Back to home page</a></p>

<br>

<br>

<p>Unban user:</p>

<br>

<p><a href='library.php'>Library (all added books)</a>.</p>

<p>Add book to library:</p>

<br>

<p>Edit book from library:</p>

<br>

<br>

<p>Add literature news:</p>

<br>

<p>Add quote (don't forget add book to the library!):</p>

} else {

echo "You haven't rights to use this page.";

}

</div>

</body>

</html>

editnews.php

<?php

session_start();

require('includes/connect.php');

$id = $_GET['id'];

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>BookTrade | Literature news</title>

</head>

<body>

<?php

if (isset($_SESSION['username'])) {

include('includes/aheader.php');

} else {

include('includes/header.php');

}

<ul>

Смотрите также файлы

Применение и толкование гражданско-правовых норм.pdf

Субъекты и сущность предпринимательского права.pdf

Теория и методика развития дошкольника. Особенности социального развития дошкольников.pdf

Психологическая готовность ребенка дошкольника к обучению в школе.pdf

Психосемантика рекламы (Текст как объект современного лингвистического исследования).pdf

Файл: Разработка WEB-ресурса по обмену книгами «BookTrade.org».pdf

Смотрите также файлы

Информация

Списки файлов

Дополнительно