SAAR-Server/getPostInfo.php at development · SAAR-IITP/SAAR-Server · 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
<?php
    include('init.php');

    // Inititalization of array
    $response = array();
    $post_data = array();
    $replies = array();
    $inst = array();

    if(!isset($_GET['post_id'])){
        $response['status'] = 409;
        $response['message'] = "Could not get post ID";
    }else{
        $post_ID = clean($_GET['post_id']);
        $sql = "SELECT `id`, `user_id`, `user_name`, `user_img`, `cat_id`, `post_time`, `title`, `body`, `images`, `thread_ids`, `upvotes_ids`, `downvotes_ids`,`no_of_comment` FROM `posts` WHERE `id`=$post_ID";
        $result = query($sql);
        if(row_count($result) == 0){
            $response['status'] = 409;
            $response['message'] = "Post Not Found!!";
        }else{

            $row = fetch_array($result);
            $post_data['title'] = $row['title'];
            $post_data['body'] = $row['body'];
            $post_data['post_time'] = format_date($row['post_time']);
            $post_data['user_name'] = $row['user_name'];
            $post_data['user_img'] = $row['user_img'];
            $post_data['images'] = $row['images'];
            $post_data['post_id'] = $row['id'];
            $post_data['user_id'] = $row['user_id'];
            $post_data['cat_id'] = $row['cat_id'];
            $post_data['upvotes'] = count(unserialize($row['upvotes_ids']));
            $post_data['downvotes'] = count(unserialize($row['downvotes_ids']));
            $post_data['no_of_comment'] = $row['no_of_comment'];

            $sql = "SELECT `thread_time`, `user_name`, `user_img`, `thread_body`, `thread_imgs`, `upvotes_ids`, `downvotes_ids`, `user_id`, `id` FROM `threads` WHERE `post_id`=$post_ID";
            $result = query($sql);
            while($row = fetch_array($result)){
                $inst['comment_id'] = $row['id'];
                $inst['time'] = format_date($row['thread_time']);
                $inst['body'] = $row['thread_body'];
                $inst['images'] = $row['thread_imgs'];
                $inst['user_id'] = $row['user_id'];
                $inst['user_name'] = $row['user_name'];
                $inst['user_img'] = $row['user_img'];
                $inst['upvotes'] = count(unserialize($row['upvotes_ids']));
                $inst['downvotes'] = count(unserialize($row['downvotes_ids']));
                $replies[] = $inst;
            }
            $response['data'] = $post_data;
            $response['replies'] = $replies;
            $response['status'] = 210;
            $response['message'] = "Sucess";
        }
    }
    echo json_encode($response);
?>