itslibro/add_book_handle.php at main · Abviol/itslibro · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<?php
ini_set('session.save_path', getcwd() . '\sessions');
session_start();
include 'db_connect.php';


function wholeWordTruncate($s, $characterCount)
{
   $return = $s;

   if (preg_match("/^.{1,$characterCount}\b\W*/su", $s, $match))
      return $match[0];
   else
      return mb_substr($return, 0, $characterCount);

}

function count_words_in_txt($path)
{
   $f = fopen($path, 'r');
   $text = '';
   $row_count = 1;
   while (!feof($f)) {
      $str = fgets($f);
      if ($str != '') {
         $str_in = $str;
         $str_out = '';
         while ($str_in !== '') {
            $match = wholeWordTruncate($str_in, 135);
            $i = iconv_strlen($match);
            $str_in = mb_substr($str_in, $i);
            $str_out .= $match . '\n';
            $row_count++;
         }
         $str_out = str_replace('\n', '<br>', $str_out);
         $str = str_replace('<b</p><p style="margin-bottom: 15px;">', '', $str);
         $row_bool = true;
         if ($str_out !== '' && $row_bool != false) {
            $text .= '<p style="margin-bottom: 15px;">' . substr($str_out, 0, -2) . '</p>';
            $row_bool = false;
         } else {
            $row_bool = true;
         }
      }
   }
   fclose($f);
   return str_word_count($text);
}

$b_name = $_POST['b_name'];
$original_name = $_POST['original_name'];
$author = $_POST['author'];
$data_writed = $_POST['data_writed'];
$genres = $_POST['genres'];
$category = $_POST['category'];
$b_description = $_POST['b_description'];
$cover = $_FILES['cover'];
$text = $_FILES['text'];
$date_published = date("Y-m-d");

$_SESSION['b_name'] = $b_name;
$_SESSION['original_name'] = $original_name;
$_SESSION['author'] = $author;
$_SESSION['data_writed'] = $data_writed;
$_SESSION['genres'] = $genres;
$_SESSION['category'] = $category;
$_SESSION['b_description'] = $b_description;

if ($b_name == "" || $original_name == "" || $data_writed == "" || $author == "" || $genres == "" || $b_description == "" || $category == "" || empty($cover['tmp_name']) || empty($text['tmp_name'])) { //все ли поля  заполнены?
   $_SESSION['message'] = 'Усі поля повинні бути заповнені!';
   header('Location: add_book.php');
} else {
   if (!is_numeric($data_writed)) {
      $_SESSION['message'] = "Рік написання має бути числом";
      header('Location: add_book.php');
   } else {
      $check_book = mysqli_query($link, "SELECT * FROM books WHERE b_name = '$b_name' AND original_name = '$original_name' AND author = '$author'");
      if (mysqli_num_rows($check_book) > 0) { //чи є вже на сайті така книга?
         $_SESSION['message'] = "Така книга вже є на сайті!";
         header('Location: add_book.php');
      } else {

         $id_publisher = $_SESSION['id_user'];

         $word_count = count_words_in_txt($text['tmp_name']);

         //добавление книги в базу данных
         $q = "INSERT INTO books (id_publisher, b_name, original_name, author, picture, data_writed, data_published, genres, words_count, b_description, category, views_count, in_list_count, rating, ratings_count) VALUES ('" . $id_publisher . "', '" . $b_name . "', '" . $original_name . "', '" . $author . "', '" . $path_cover . "', '" . $data_writed . "', '" . $date_published . "', '" . $genres . "', '" . $word_count . "', '" . $b_description . "', '" . $category . "', '0', '0', '0', '0')";
         mysqli_query($link, $q);

         $q = "SELECT * FROM books ORDER BY id_book DESC LIMIT 1";
         $id_book = mysqli_query($link, $q);
         $id_book = mysqli_fetch_assoc($id_book);

         //завантаження .txt файлу до папки сайту Itslibro/books/
         $text_info = pathinfo($text['name']);
         $text_ext = $text_info['extension'];
         $path_book = 'books/' . $id_book['id_book'] . '.txt';
         move_uploaded_file($text['tmp_name'], $path_book);

         //получение данных о загруженной картинке
         $cover_info = pathinfo($cover['name']);
         $cover_ext = $cover_info['extension'];
         $path_cover = 'img/covers/' . $id_book['id_book'] . '.' . $cover_ext;
         move_uploaded_file($cover['tmp_name'], $path_cover);

         $q = "UPDATE books SET picture = '$path_cover' WHERE id_book = '" . $id_book['id_book'] . "'";
         mysqli_query($link, $q);

         header('Location: admin_page.php');
         $_SESSION['message'] = "Книгу успішно додано до бази даних сайту!";

         unset($_SESSION['b_name']);
         unset($_SESSION['original_name']);
         unset($_SESSION['author']);
         unset($_SESSION['data_writed']);
         unset($_SESSION['genres']);
         unset($_SESSION['category']);
         unset($_SESSION['b_description']);
      }
   }
}
?>