15 lines
273 B
PHP
15 lines
273 B
PHP
|
<?php
|
||
|
|
$db = mysqli_connect("localhost", "root", "", "szachy");
|
||
|
|
|
||
|
|
$query = mysqli_query($db, "SELECT * FROM zawodnicy WHERE ranking > 2800");
|
||
|
|
|
||
|
|
$json = array();
|
||
|
|
|
||
|
|
while($row = mysqli_fetch_assoc($query)) {
|
||
|
|
$json[] = $row;
|
||
|
|
}
|
||
|
|
|
||
|
|
mysqli_close($db);
|
||
|
|
|
||
|
|
echo json_encode($json);
|
||
|
|
?>
|