function insert_transaction($date, $recipient, $category, $amount, $description)
{
    $link = open_database_connection();
    $date = strtotime($date);
    $date = mysql_real_escape_string(date('Y-m-d', $date));
    $recipientName = mysql_real_escape_string(trim($recipient));
    $categoryName = $category;
    $categoryName = mysql_real_escape_string(trim($category));
    $description = mysql_real_escape_string(trim($description));
    $amount = mysql_real_escape_string(trim($amount));
    $checkRecipientQuery = "select id from Recipients where upper(name) like upper('{$recipientName}');";
    $result = mysql_query($checkRecipientQuery, $link);
    if (mysql_num_rows($result) == 0) {
        $createRecipientQuery = "insert into Recipients (name) values ('{$recipientName}');";
        mysql_query($createRecipientQuery, $link);
        $result = mysql_query($checkRecipientQuery, $link);
    }
    $row = mysql_fetch_assoc($result);
    $recipientID = $row['id'];
    $checkCategoryQuery = "select id from Categories where upper(name) like upper('{$categoryName}');";
    $result = mysql_query($checkCategoryQuery, $link);
    if (mysql_num_rows($result) == 0) {
        $createCategoryQuery = "insert into Categories (name) values ('{$categoryName}');";
        mysql_query($createCategoryQuery, $link);
        $result = mysql_query($checkCategoryQuery, $link);
    }
    $row = mysql_fetch_assoc($result);
    $categoryID = $row['id'];
    $createTransactionQuery = "insert into Transactions (date, amount, description, recipientID, categoryID) " . "values ('{$date}', '{$amount}', '{$description}', '{$recipientID}', '{$categoryID}');";
    mysql_query($createTransactionQuery, $link);
    close_database_connection($link);
}

function remove_post($id)
{
    $link = open_database_connection();
    $sql = "DELETE FROM Post WHERE id = {$id}";
    $result = mysql_query($sql, $link);
    close_database_connection($link);
    return $post;
}

function delete_post($id)
{
    $sql = "DELETE FROM post WHERE id='{$id}'";
    $link = open_database_connection();
    mysql_query($sql, $link);
    close_database_connection($link);
    return;
}

function delete_post($id)
{
    $link = open_database_connection();
    $sql = "DELETE FROM `post` WHERE id='{$id}' ";
    mysql_query($sql, $link) or die("Запрос не выполненн" . mysql_error());
    close_database_connection($link);
    return;
}

function get_thing_by_key($thingKey)
{
    $dbconn = open_database_connection();
    $thingKey = intval($thingKey);
    $result = $dbconn->query("SELECT * FROM things WHERE thingKey = " . $thingKey);
    $row = $result->fetch_assoc();
    close_database_connection($dbconn);
    return $row;
}

function insertNewRecord($playerName, $Score)
{
    $connection = open_database_connection();
    $query = "INSERT INTO highscores(Name, Score) VALUES ('{$playerName}', {$Score})";
    print '<br>';
    print $query;
    mysqli_query($connection, $query);
    close_database_connection($connection);
}

function get_post($id)
{
    $link = open_database_connection();
    $sql = "SELECT * FROM post WHERE id='{$id}'";
    $result = mysql_query($sql, $link);
    $post = mysql_fetch_assoc($result);
    close_database_connection($link);
    return $post;
}

/**
 * @param $id
 *
 * @return array|null
 */
function get_post_by_id($id)
{
    $link = open_database_connection();
    $id = intval($id);
    $query = 'SELECT id, title FROM post WHERE id = ' . $id;
    $result = mysqli_query($link, $query);
    $row = mysqli_fetch_assoc($result);
    close_database_connection($link);
    return $row;
}

function get_post_by_id($id)
{
    $link = open_database_connection();
    $id = mysql_real_escape_string($id);
    $query = 'SELECT date, title, body FROM post WHERE id = ' . $id;
    $result = mysql_query($query);
    $row = mysql_fetch_assoc($result);
    close_database_connection($link);
    return $row;
}

function edit_data($id)
{
    $autor = $_POST['autor'];
    $date = date("Y-m-d H:i:s");
    $title = $_POST['title'];
    $edit_content = $_POST['content'];
    $link = open_database_connection();
    $sql = "UPDATE `post` SET `autor` = '{$autor}', `date` = '{$date}', `title` = '{$title}', `content` = '{$edit_content}' WHERE `id` = '{$id}';";
    $add = mysql_query($sql, $link);
    close_database_connection($link);
}

function update_row()
{
    if (!($request = getRequest())) {
        return false;
    }
    $sql = "UPDATE `pages` SET `date`='" . $request['date'] . "', \n\t\t\t\t\t\t`title`='" . $request['title'] . "', \n\t\t\t\t\t\t`author`='" . $request['author'] . "', \n\t\t\t\t\t\t`content`='" . $request['content'] . "'  \n\t\t\t\t\t\t WHERE id=" . $request['id'];
    $link = open_database_connection();
    $result = mysql_query($sql, $link) or die("error! " . $sql . " == " . mysql_error());
    close_database_connection($link);
    return $result;
}

function get_all_rows()
{
    $link = open_database_connection();
    $result = mysql_query('SELECT * FROM pages', $link);
    $rows = array();
    while ($row = mysql_fetch_assoc($result)) {
        $rows[] = $row;
    }
    close_database_connection($link);
    return $rows;
}

function get_all_posts()
{
    $link = open_database_connection();
    $result = mysql_query('SELECT id, title FROM post', $link);
    $posts = array();
    while ($row = mysql_fetch_assoc($result)) {
        $posts[] = $row;
    }
    close_database_connection($link);
    return $posts;
}

 public function testDeleteCategory()
 {
     // Arrange
     $changeCategory = new ChangeCategory();
     $connection = open_database_connection();
     $expectedResult = $changeCategory->addCategory($connection, "PHP Unit Test Category", "", "", "PHP Unit Test Summary");
     // Act
     $result = $changeCategory->deleteCategory($connection, "PHP Unit Test Category");
     // Assert
     $this->assertEquals($result, $expectedResult);
 }

function edit_data($id)
{
    $autor = $_POST['autor'];
    $content = $_POST['content'];
    $title = $_POST['title'];
    $link = open_database_connection();
    $sql = "UPDATE `post` SET `autor` = '{$autor}', `title` = '{$title}', `content` = '{$content}' WHERE `id` = '{$id}';";
    $edit = mysql_query($sql, $link);
    close_database_connection($link);
    header('location:admin');
}

function getAllFromById($tableName, $id)
{
    $link = open_database_connection();
    $result = mysql_query('SELECT * FROM $tableName WHERE id = $id', $link);
    $posts = array();
    while ($row = mysql_fetch_assoc($result)) {
        $posts[] = $row;
    }
    close_database_connection($link);
    return $posts;
}

function add_post()
{
    $author = $_POST['add_author'];
    $time = $_POST['add_time'];
    $title = $_POST['add_title'];
    $content = $_POST['add_content'];
    $link = open_database_connection();
    $sql = "INSERT INTO `post` (`id`, `author`, `time`, `title`, `content`) \n\t\t\tVALUES (NULL, '{$author}', '{$time}', '{$title}', '{$content}');";
    $result = mysql_query($sql, $link);
    close_database_connection($link);
}

function get_row($id)
{
    $link = open_database_connection();
    $sql = "SELECT * FROM `idpages` WHERE `id`={$id}";
    $result = mysql_query($sql, $link);
    $rows = array();
    while ($row = mysql_fetch_array($result)) {
        $rows[] = $row;
    }
    close_database_connection($link);
    return $rows;
}

function get_all_posts()
{
    $link = open_database_connection();
    $sql = 'SELECT * FROM posts';
    $result = mysqli_query($link, $sql);
    $posts = array();
    while ($row = mysqli_fetch_array($result, MYSQL_ASSOC)) {
        $posts[] = $row;
    }
    close_db_connection($link);
    return $posts;
}

 /**
  * @return array
  */
 public function getImageUrlArray()
 {
     // make a new connection to the database
     $connection = open_database_connection();
     // make a new query for the CategoryID and ProductImageURL from all rows from `products`
     $query = "SELECT CategoryID, ProductImageURL FROM `products` ORDER BY CategoryID ASC";
     // get the results from the query
     $results = mysqli_query($connection, $query);
     // declare imageData to be an empty array
     // this variable will hold all the data in php array format before we json_encode() it
     $imageData = array();
     // declaring and defining a variable to represent which category(the CategoryID)
     // we're processing in the loop below
     $categoryToProcess = 0;
     // declaring and defining a variable to represent which index in its respective
     // category array in imageData we're processing
     $categoryIndexToProcess = 0;
     // check to make sure there are results from the mysql query we made earlier
     if (mysqli_num_rows($results) > 0) {
         // as long as we can retrieve another row from the database, add the row's ProductImageURL to imageData
         while ($rows = $results->fetch_assoc()) {
             // set the category we're processing to be the CategoryID of the row we retrieved
             $categoryToProcess = $rows['CategoryID'];
             if (array_key_exists($categoryToProcess, $imageData)) {
                 // If an array key exists in the object for the category we're processing,
                 // then there is an array dedicated to storing data for that category, so
                 // insert the image url in the category's array, in the next index
                 $imageData[$categoryToProcess][$categoryIndexToProcess] = "/images/" . $rows['ProductImageURL'];
             } else {
                 // If there isn't an array key for the category we're processing,
                 // then there isn't an array for this category, so create a new array,
                 $imageData[$categoryToProcess] = array();
                 // reset the index of the item we're processing to 1,
                 $categoryIndexToProcess = 1;
                 // and insert the image's url into that index
                 $imageData[$categoryToProcess][$categoryIndexToProcess] = "/images/" . $rows['ProductImageURL'];
             }
             // update the amount of items in the array of the category we're processing
             // to be the last index we processed
             $imageData[$categoryToProcess][0] = $categoryIndexToProcess;
             // update the amount of categories in the object to be the category we're processing
             // for the same reason as above
             $imageData[0] = $rows['CategoryID'];
             // process the next index
             $categoryIndexToProcess++;
         }
     }
     // close the database connection
     close_database_connection($connection);
     // return the imageData
     return $imageData;
 }