1#@!#!123s

22527 1#@!#!123s
: / home / ubuntu / letsfamebackup / lf260325 / letsfame / api /
Filename : list_artise_api.php-23-12-24
back
<?php

include("../includes/connect.php");

header('Access-Control-Allow-Origin: *');  
header('Access-Control-Allow-Methods: GET, POST, OPTIONS');
header('Access-Control-Allow-Headers: Content-Type');

if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit;
}

$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$pageSize = isset($_GET['pageSize']) ? (int)$_GET['pageSize'] : 10;
$profession = isset($_GET['profession']) ? $_GET['profession'] : ''; // Get profession if passed

$start = ($page - 1) * $pageSize;

// Modify SQL query based on whether profession is passed
if (!empty($profession)) {
    // If profession is provided, filter by profession
    $sql = "SELECT id, name, profession, country, state, city, 
            profile AS profile_image, banner AS cover_image, 
            about AS biography, insimg, insname, insurl, inscnt, 
            faceimg, facename, faceurl, facecnt, youimg, youname, 
            youurl, youcnt, status, datetime 
            FROM book_artist  
            WHERE status = 'Active' AND profession = '$profession' 
            ORDER BY id DESC 
            LIMIT $start, $pageSize";
} else {
    // If no profession is passed, list all active data
    $sql = "SELECT id, name, profession, country, state, city, 
            profile AS profile_image, banner AS cover_image, 
            about AS biography, insimg, insname, insurl, inscnt, 
            faceimg, facename, faceurl, facecnt, youimg, youname, 
            youurl, youcnt, status, datetime 
            FROM book_artist  
            WHERE status = 'Active' 
            ORDER BY id DESC 
            LIMIT $start, $pageSize";
}

$result = $connect->query($sql);
$response = array();
$data = array();
$data['posts'] = array();

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $followers = array();

        if (!empty($row['inscnt'])) {
            $followers['instagram'] = array(
                'img' => $row['insimg'],  
                'name' => $row['insname'],  
                'url' => $row['insurl'],    
                'followers' => $row['inscnt']   
            );
        }

        if (!empty($row['facecnt'])) {
            $followers['twitter'] = array(
                'img' => $row['faceimg'],  
                'name' => $row['facename'],  
                'url' => $row['faceurl'],    
                'followers' => $row['facecnt'] 
            );
        }

        if (!empty($row['youcnt'])) {
            $followers['youtube'] = array(
                'img' => $row['youimg'],  
                'name' => $row['youname'], 
                'url' => $row['youurl'],    
                'followers' => $row['youcnt']  
            );
        }

        $post = array(
            'id' => $row['id'],
            'name' => $row['name'],
            'profession' => $row['profession'],
            'country' => $row['country'],
            'state' => $row['state'],
            'city' => $row['city'],
            'profile_image' => $row['profile_image'],
            'cover_image' => $row['cover_image'],
            'biography' => $row['biography'],
            'status' => $row['status'],
            'datetime' => $row['datetime'],
            'followers' => $followers 
        );

        $data['posts'][] = $post;
    }

    $countSql = "SELECT COUNT(*) as total FROM book_artist WHERE status = 'Active'";
    // If profession is passed, count only those with the given profession
    if (!empty($profession)) {
        $countSql .= " AND profession = '$profession'";
    }

    $countResult = $connect->query($countSql);
    $totalRows = $countResult->fetch_assoc()['total'];

    $data['pagination'] = array(
        'page' => $page,
        'pageSize' => $pageSize,
        'totalPages' => ceil($totalRows / $pageSize),
        'totalPosts' => $totalRows
    );

    $response['status'] = true;
    $response['statusCode'] = 200;
    $response['data'] = $data;
    $response['message'] = "Data fetched successfully.";
} else {
    $data['pagination'] = array(
        'page' => $page,
        'pageSize' => $pageSize,
        'totalPages' => 0,
        'totalPosts' => 0
    );

    $response['status'] = false;
    $response['statusCode'] = 404;
    $response['data'] = $data;
    $response['message'] = "No data found.";
}

header('Content-Type: application/json');
echo json_encode($response, JSON_PRETTY_PRINT);

$connect->close();

?>