15 lines
291 B
PHP
15 lines
291 B
PHP
|
|
<?php
|
||
|
|
$db = mysqli_connect("localhost", "root", "", "szachy");
|
||
|
|
|
||
|
|
$query = mysqli_query($db, "SELECT pseudonim, klasa FROM zawodnicy ORDER BY RAND() LIMIT 2");
|
||
|
|
|
||
|
|
$json = array();
|
||
|
|
|
||
|
|
while($row = mysqli_fetch_assoc($query)) {
|
||
|
|
$json[] = $row;
|
||
|
|
}
|
||
|
|
|
||
|
|
mysqli_close($db);
|
||
|
|
|
||
|
|
echo json_encode($json);
|
||
|
|
?>
|