<?php
header("Content-Type: application/json; charset=UTF-8");
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST');
$servername = 'localhost';
$username = 'c1bitrendy';
$password = 'VictoR2015';
$dbname = 'c1bitrendy';
$postdata = file_get_contents("php://input");
$request = json_decode($postdata);
$player_id = $request->playerid;
$player = $request->whichplayer;
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if (!mysqli_set_charset($conn, "utf8")) {
        } else {
        }
$sql = 'select looks.id AS lookid,looks.url_img AS imgurl,looks.short_url AS shorturl,items_tallas.quantity AS numerounidades, bloggers.id AS playerid,bloggers.ig_username AS playerrusername,bloggers.ig_bio AS playerbio, bloggers.ig_full_name AS playerfullname, bloggers.ig_website AS playerwebsite,bloggers.ig_profile_picture AS playerprofilepicture,(select count(*) from items_users where items_users.item_id = items.id) AS numberventas from looks,bloggers,bloggers_looks,items_tallas,items,items_looks where items_looks.item_id = items.id and items_looks.look_id = looks.id and items_tallas.item_id = items.id and bloggers.id = "' . $player_id . '" and bloggers_looks.blogger_id = bloggers.id and bloggers_looks.look_id = looks.id group by looks.id order by looks.created desc';
if($player == 2){
    $sql = 'select looks.id AS lookid,looks.url_img AS imgurl,looks.short_url AS shorturl,items_tallas.quantity AS numerounidades, brands.id AS playerid,brands.ig_username AS playerrusername, brands.ig_full_name AS playerfullname, brands.ig_website AS playerwebsite,brands.ig_profile_picture AS playerprofilepicture,(select count(*) from items_users where items_users.item_id = items.id) AS numberventas from looks,brands,brands_looks,items_tallas,items,items_looks where items_looks.item_id = items.id and items_looks.look_id = looks.id and items_tallas.item_id = items.id and brands.id = "' . $player_id . '" and brands_looks.brand_id = brands.id and brands_looks.look_id = looks.id group by looks.id order by looks.created desc';
}
$result = $conn->query($sql);
$arr = array();
if($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $arr[] = $row;
    }
}
echo $json_response = json_encode($arr);
mysqli_close($conn);
?>