<?php

header("Access-Control-Allow-Origin: *");

// create connection to database

$host= "webdev.iyaserver.com"; // database server address

$userid = "dhreid";// database user account name

$userpw = "AcadDev_Reid_6608034954";// database user password

$db= "dhreid_NBA";// database name

$mysql = new mysqli(

    $host,

    $userid,

    $userpw,

    $db);

if($mysql->connect_errno) {

    echo "db connection error : " . $mysql->connect_error;

    exit();

}

// pull all data from star_players_career_totals view

$sql =      "SELECT * FROM star_players_career_totals 

WHERE FULL_NAME IN ('Damian Lillard', 'Luka Doncic', 'Michael Jordan')";

$results = $mysql->query($sql);

if(!$results) {

    echo "SQL error: ". $mysql->error . " running query <hr>" . $sql . "<hr>";

    exit();

}

$json_array = array();

while($currentrow = $results->fetch_assoc() ) {

    $json_array[] = $currentrow;

}

$json_array = json_encode($json_array, JSON_UNESCAPED_UNICODE);

echo $json_array; // Note: This is the ONLY output of the page. No other echo or var_dumps

$mysql->close();