function IsAuthorIdExists($CONNECTION, $ids)
{
if (!is_array($ids)) {
return FALSE;
}
$query = mysqli_query($CONNECTION, 'SELECT * FROM authors WHERE
author_id IN(' . implode(',', $ids) . ')');
if (HasErrorWithDataBase($CONNECTION)) {
return FALSE;
}
if (mysqli_num_rows($query) == count($ids)) {
return TRUE;
}
return FALSE;
}
$title = "User's comments";
require "includes/config.php";
require "includes/header.php";
$USER_ID = NULL;
if (isset($_GET['user_id'])) {
$USER_ID = $_GET['user_id'];
} else {
header('Location: index.php');
}
// Заявка за връзка потребител - коментари
$sql = 'SELECT content, date_added, comments.book_id, comments.comment_id, books.book_title, users.username FROM comments
INNER JOIN users.users ON users.user_id = comments.user_id
INNER JOIN books.books ON books.book_id = comments.book_id
WHERE users.user_id = ' . $USER_ID . ' ORDER BY date_added DESC';
$query = mysqli_query($CONNECTION_COMMENTS, $sql);
if (HasErrorWithDataBase($query)) {
exit;
}
// Проверка за грешки
?>
<!-- Главно меню -->
<div style="float: left;"><a href="index.php">- Back to Book Catalog</a></div>
<div style="float: right;"><?php
ShowHelloScreen();
?>
</div>
<br/><br/>
<?php
<?php
session_start();
$CONNECTION_BOOKS = mysqli_connect('localhost', 'root', '', 'books');
$CONNECTION_USERS = mysqli_connect('localhost', 'root', '', 'users');
$CONNECTION_COMMENTS = mysqli_connect('localhost', 'root', '', 'comments');
if (HasErrorWithDataBase($CONNECTION_BOOKS)) {
exit;
}
// Проверка за грешки
mysqli_set_charset($CONNECTION_BOOKS, 'utf8');
function HasErrorWithDataBase($query)
{
if (!$query) {
echo '<br><span class="error">- Error in database!</span>';
return TRUE;
}
return FALSE;
}
function CheckForValidData($value, $minLength = 5)
{
if (mb_strlen($value, 'UTF-8') < $minLength) {
return FALSE;
}
for ($i = 0; $i < strlen($value); $i++) {
if (($value[$i] < 'a' || $value[$i] > 'z') && ($value[$i] < '0' || $value[$i] > '9')) {
return FALSE;
}
}
return TRUE;
}
<?php
$CONNECTION = mysqli_connect('localhost', 'root', '', 'books');
if (HasErrorWithDataBase($CONNECTION)) {
exit;
}
// Проверка за грешки
mysqli_set_charset($CONNECTION, 'utf8');
function HasErrorWithDataBase($query)
{
if (!$query) {
echo '<br><span class="error">- Error in database!</span>';
return TRUE;
}
return FALSE;
}
