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

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

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

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

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

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

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

Добавлен: 25.04.2023

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

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

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

СОДЕРЖАНИЕ

Введение

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

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

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

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

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

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

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

Заключение

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

Приложение

$query = "SELECT author FROM `books` WHERE bookname='$bookname'";

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

do {

$author = $myrow['author'];

} while ($myrow = mysqli_fetch_array($result));

<br>

<h3><a href="quotes.php">Get another quote!</a></h3>

</div>

</body>

</html>

read_mes.php

<?php

session_start();

require('includes/connect.php');

$u_name = $_SESSION['username'];

$id_mess=(int)$_GET['id'];

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

<html>

<head>

<title>BookTrade | <?php echo $username; ?></title>

</head>

<body>

<?php

$db_user = 'root';

$db_name = 'booktrade.org';

$db_pass = '';

$db = new PDO('mysql:dbname='.$db_name.'; host=localhost',$db_user,$db_pass);

$db->exec("SET CHARACTER SET utf8");

$sql="select * from messages where u_to = :u_to and m_id = :id_mess";

$sth=$db->prepare($sql);

$sth->bindParam(':u_to',$u_name,PDO::PARAM_STR);

$sth->bindParam(':id_mess',$id_mess,PDO::PARAM_INT);

$sth->execute();

$res=$sth->fetch(PDO::FETCH_ASSOC);

$sql="update messages set flag = 1 where u_to = :u_to and m_id = :id_mess";

$sth=$db->prepare($sql);

$sth->bindParam(':u_to',$u_name,PDO::PARAM_STR);

$sth->bindParam(':id_mess',$id_mess,PDO::PARAM_INT);

$sth->execute();

if($res['m_id']<>''){

echo '<p>Sent by: '.$res['u_from'].'</p>';

echo '<div>'.$res['message'].'</div>Date: '.$res['data'];

echo '<p><a href="pm.php?name='.$res['u_from'].'">Answer</a></p>';

}else{

echo "Message doesn't exist or was sent to another user.";

}

</div>

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

</div>

</body>

</html>

register.php

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

<html>

<head>

<title>BookTrade | Registration</title>

</head>

<body>

<h1>Registration</h1>

<?php

require('includes/connect.php');

if (isset($_POST['username']) && isset($_POST['password'])) {

$username = $_POST['username'];

$email = $_POST['email'];

$password = $_POST['password'];

$query = "INSERT INTO users (username, email, password, rights) VALUES ('$username', '$email', '$password', 1)";

$result = mysqli_query($connection, $query);

if ($result) {

$fullname = $_POST['fullname'];

$age = $_POST['age'];

$location = $_POST['location'];

$userinfo = $_POST['userinfo'];

$active_date = time();

$query_all = "INSERT INTO user_info (username, fullname, age, location, userinfo, active_date) VALUES ('$username', '$fullname', '$age', '$location', '$userinfo', '$active_date')";

$result_all = mysqli_query($connection, $query_all);

$smsg = "Account successfully created";

echo "<a href='login.php' align=center>Log in</a><br><a href='index.php' align=center>Home page</a>";

} else {

$fsmsg = "Account with that name already created.";

}

if(isset($smsg)) { ?><div class="alert" role="alert"> <?php echo $smsg; ?> </div> <?php }

if(isset($fsmsg)) { ?><div class="alert" role="alert"> <?php echo $fsmsg; ?> </div> <?php }

<p><label for="user_login">Login*:<br>

<p><label for="user_pass">Password*:<br>

<p><label for="user_location">Location:<br>

<p><label for="user_info">Personal info:<br>

<p class="regtext">Have an account? <a href="login.php">Log in</a>!</p>

</form>

</div>

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

</body>

</html>

reviews.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 | Reviews</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) {

echo "<p align='center'><a href='addreview.php'>Add your review!</a></p><br>";

}

echo "<table align=center border=0px><tr><td><img src='graphics/reviews.png' width=400px></tr></td></table>";

$query = "SELECT * FROM `reviews` ORDER BY RAND() LIMIT 10";

$result = mysqli_query($connection, $query) or die;

if($result) {

$rows = mysqli_num_rows($result);

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

$row = mysqli_fetch_row($result);

$id = $row[0];

echo "<h4>«$row[1]» by $row[2]</h4>";

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

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

echo "<p align=right>$row[5]/10</p>";

echo "<h5 align='right'>$row[6]</h5>";

$author = $row[3];

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

echo "<p align=center><a href='editreview.php?id=$id'>Edit review</a></p>";

}

echo "<hr>";

}

</div>

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

</div>

</body>

</html>

toffers.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 | Trade offers</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) {

echo "<p align='center'><a href='addbook.php'>Add your trade offer!</a></p><br>";

}

echo "<table align=center border=0px><tr><td><img src='graphics/trade.png' width=300px></tr></td></table>";

$query = ('SELECT username, bookname, author, trade_info, date FROM (SELECT * FROM w_trade ORDER BY item_id DESC LIMIT 100) AS T ORDER BY item_id ASC');

$result = mysqli_query($connection, $query) or die;

if($result) {

$rows = mysqli_num_rows($result);

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

$row = mysqli_fetch_row($result);

$id = $row[0];

echo "<h4>«$row[1]» by $row[2]</h4>";

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

echo "<h5 align='right'>$row[4]</h5>";

echo "<h5 align='center'><a href='pm.php?name=$row[0]'>Send mail to $row[0]</a></h5><hr>";

}

</div>

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

</div>

</body>

</html>

user.php

<?php

session_start();

require('includes/connect.php');

$username = $_GET['name'];

if ($username == NULL) {

$username = $_SESSION['username'];

}

$id = $_SESSION['id'];

$query = "SELECT * FROM `user_info` WHERE username='$username'";

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

do {

$fullname = $myrow['fullname'];

$age = $myrow['age'];

$location = $myrow['location'];

$userinfo = $myrow['userinfo'];

$active = $myrow['active'];

} while ($myrow = mysqli_fetch_array($result));

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

<html>

<head>

<title>BookTrade | <?php echo $username; ?></title>

</head>

<body>

<?php

echo "<p>ID: $id</p>

<p>Username: $username</p>

<p>Full name: $fullname</p>

<p>From $location</p>

<p>$userinfo</p>";

if ($active == 1) {

echo "<p>User is online</p>";

} else {

echo "<p>User is offline</p>";

}

if ($_GET['name'] != $_SESSION['username']) {

echo "<p><a href='pm.php?name=$username'>Private mail</a></p>";

}

if ($_GET['name'] == $_SESSION['username'] && $_SESSION['rights'] != 0) {

echo "<p><a href='addbook.php'>Add book to readed, wanted or trade offers</a></p>";

}

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

echo "<p><a href='useredit.php'>Edit profile</a></p>";

}

echo "<h3 align='center'>$username's trade offers:</h3>";

$query_trade = "SELECT * FROM `w_trade` WHERE username='$username'";

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

if(isset($result_trade)) {

$rows = mysqli_num_rows($result_trade);

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

$row = mysqli_fetch_row($result_trade);

echo "<h4>«$row[2]» by $row[3]</h4><p>$row[4]</p>";

echo "<h5 align='right'>$row[5]</h5>";

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

echo "<h5 align=center><a href='includes/delete.php?id=$row[0]'>Remove an offer</a></h5>";

}

echo "<hr><h3 align='center'>$username's wanted books:</h3>";

$query_wanted = "SELECT * FROM `w_read` WHERE username='$username'";

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

if(isset($result_wanted)) {

$rows = mysqli_num_rows($result_wanted);

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

$row = mysqli_fetch_row($result_wanted);

if ($row[0] != NULL) {

echo "<h4>«$row[2]» by $row[3]</h4>";

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

echo "<h5 align=center><a href='includes/deletew.php?id=$row[0]'>Remove a wanted book</a></h5>";

}

echo "<hr><h3 align='center'>$username's readed books:</h3>";

$query_readed = "SELECT * FROM `readed` WHERE username='$username'";

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

if(isset($result_readed)) {

$rows = mysqli_num_rows($result_readed);

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

$row = mysqli_fetch_row($result_readed);

if ($row[0] != NULL) {

echo "<h4>«$row[2]» by $row[3]</h4>";

}

echo "<hr><h3 align='center'>$username's reviews:</h3>";

$query_reviews = "SELECT * FROM `reviews`";

$result_reviews = mysqli_query($connection, $query_reviews) or die(mysqli_error($connection));

if(isset($result_reviews)) {

$rows = mysqli_num_rows($result);

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

$row = mysqli_fetch_row($result_reviews);

if ($row[0] != NULL) {

echo "<h4>«$row[1]» by $row[2]</h4>";

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

echo "<p align='right'>$row[5]/10</p>";

echo "<h5 align='right'>$row[6]</h5>";

$author = $row[3];

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

echo "<p align=center><a href='editreview.php?id=$id'>Edit review</a></p>";

}

} else {

echo "<p>$username didn't add anything to this section yet.</p>";

break;

}

</div>

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

</div>

</body>

</html>

useredit.php

<?php

session_start();

require('includes/connect.php');

$username = $_SESSION['username'];

$id = $_SESSION['id'];

$query = "SELECT * FROM `user_info` WHERE username='$username'";

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

do {

$fullname = $myrow['fullname'];

$age = $myrow['age'];

$location = $myrow['location'];

$userinfo = $myrow['userinfo'];

} while ($myrow = mysqli_fetch_array($result));

$cfullname = $_POST['fullname'];

$cage = $_POST['age'];

$clocation = $_POST['location'];

$cuserinfo = $_POST['userinfo'];

if ($cfullname != NULL) {

$query_active = "UPDATE user_info SET fullname='$cfullname' WHERE username='$username'";

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

}

if ($cage != NULL) {

$query_active = "UPDATE user_info SET age='$cage' WHERE username='$username'";

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

}

if ($clocation != NULL) {

$query_active = "UPDATE user_info SET location='$clocation' WHERE username='$username'";

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

}

if ($cuserinfo != NULL) {

$query_active = "UPDATE user_info SET userinfo='$cuserinfo' WHERE username='$username'";

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

}

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

<html>

<head>

<title>BookTrade | <?php echo $username; ?></title>

</head>

<body>

<?php

echo "<p>ID: $id</p>

<p>$username</p>

<p>Изменить отображаемое имя:</p>

<p>Возраст:</p>

<p>Место жительства:</p>

<p>Информация о Вас:</p>

<p><textarea class='input' id='userinfo' name='userinfo' cols='50' rows='5' placeholder='$userinfo'></textarea></p>";

</form>

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

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

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

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

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

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

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

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

Информация

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

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