query.php

<?php
//TODO вынести $liker куда нибудь
function getUser(int $user_id): User | null{
    if($user_id <= 0){
        return null;
    }
    $data = DataBaseGetLine("SELECT * FROM v_user WHERE id = {$user_id} LIMIT 1;");
    if(isset($data) && is_array($data)){
        return new User($data);
    }
	return null;
}

function getPostUser(int $user_id, int $list): array{
    $ret = [];
    if($user_id <= 0 || $list <= 0){
        return $ret;
    }
    $from = ($list - 1) * COUNT_LIST;
    $liker = "(liker = ".SESSION_ID." OR liker IS NULL) ORDER BY id DESC";

    $arr = DataBaseGetArray("SELECT * FROM v_post_2 WHERE user = {$user_id} AND {$liker} LIMIT {$from}, ".COUNT_LIST);
    
    for($i = 0; $i < count($arr); $i++){
        $ret[] = new Post($arr[$i]);
    }
    return $ret;
}

function getPost(int $post_id, int $child_list): Post | null{
    if($post_id <= 0 || $child_list <= 0){
        return null;
    }
    $liker = "(liker = ".SESSION_ID." OR liker IS NULL) ORDER BY id DESC";

    $data = DataBaseGetLine("SELECT * FROM v_post_2 WHERE id = {$post_id} AND {$liker} LIMIT 1;");
    if(isset($data) && is_array($data)){
        return new Post($data, true, $child_list);
    }
	return null;
}
function getPostFather(int $post_id): Post | null{
    if($post_id <= 0){
        return null;
    }
    $liker = "(liker = ".SESSION_ID." OR liker IS NULL) ORDER BY id DESC";

    $data = DataBaseGetLine("SELECT * FROM v_post_2 WHERE id = {$post_id} AND {$liker} LIMIT 1;");
    if(isset($data) && is_array($data)){
        return new Post($data);
    }
	return null;
}
function getPostChild(int $post_id, int $list = 1): array{    
    $ret = [];
    if($list <= 0 || $post_id <= 0){
        return $ret;
    }
    $from = ($list - 1) * COUNT_LIST;
    $liker = "(liker = ".SESSION_ID." OR liker IS NULL) ORDER BY id DESC";

    $arr = DataBaseGetArray("SELECT * FROM v_post_2 WHERE answer = {$post_id} AND {$liker} LIMIT {$from}, ".COUNT_LIST);

    for($i = 0; $i < count($arr); $i++){
        $ret[] = new Post($arr[$i]);
    }
    return $ret;
}
?>