<?php
$server = "localhost";
$username ="XXXXX";
$password = "XXXXX";
$database = "XXXX";

$conn = mysqli_connect($server,$username,$password,$database);
$dataNewCount = $_POST['dataNewCount'];


$sql = "SELECT bid,ask,curr_pair FROM wp_ticker WHERE wp_ticker.curr_pair = '$dataNewCount' LIMIT 1";

$result = mysqli_query($conn, $sql);
  if (mysqli_num_rows($result) > 0) {
      while ($row = mysqli_fetch_assoc($result)){
          $val1 = $row['bid'];
        }
}

mysqli_free_result($result);

$dataNewCountfirst3 = substr($dataNewCount, -3, 3);
if ($dataNewCountfirst3 !== "EUR"){
  $geteuro = $dataNewCountfirst3."EUR";
}


$sql = "SELECT bid,ask,curr_pair FROM wp_ticker WHERE wp_ticker.curr_pair = '$geteur' LIMIT 1";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0){
  //echo $result2->bid;
  while($row = mysql_fetch_assoc($result)){
    $val2 =$row['bid'];
  }
}

mysqli_close($conn);

$data = ["$val1", "$val2"];
echo json_encode($data);