3v4l.org

run code in 300+ PHP versions simultaneously
<?php $con = mysqli_connect(home.fgx.com.br,"fgxbidper","QajCBPx4W2Zw9U6c","fgx_bidper"); $sql = "SELECT peopleID, firstName, lastName, valueEx FROM exchange inner join people on people.id = exchange.peopleID WHERE curHave = (SELECT CurWant FROM exchange WHERE peopleID = 24) and finished = 0 and peopleID <> 24"; $res = mysqli_query($con,$sql); $result = array(); while($row = mysqli_fetch_array($res)){ array_push($result, array('id'=>$row[0], 'curHave'=>$row[1], 'curWant'=>$row[2], 'countryLive'=>$row[3])); } echo json_encode(array("result"=>$result)); mysqli_close($con); ?>

preferences:
49.13 ms | 402 KiB | 5 Q