dbraw.php 739 B

12345678910111213141516171819202122232425262728
  1. <?php
  2. function dbraw($pdo) {
  3. if (! isset($_GET['queries'])) {
  4. $statement = $pdo->query( 'SELECT id,randomNumber FROM World WHERE id = '. mt_rand(1, 10000) );
  5. echo json_encode($statement->fetch(PDO::FETCH_ASSOC));
  6. return;
  7. }
  8. $query_count = 1;
  9. if ($_GET['queries'] > 1) {
  10. $query_count = $_GET['queries'];
  11. }
  12. if ($query_count > 500) $query_count=500;
  13. $arr = [];
  14. $id = mt_rand(1, 10000);
  15. $statement = $pdo->prepare('SELECT randomNumber FROM World WHERE id = :id');
  16. $statement->bindParam(':id', $id, PDO::PARAM_INT);
  17. while ($query_count--) {
  18. $statement->execute();
  19. $arr[] = ['id' => $id, 'randomNumber' => $statement->fetchColumn()];
  20. $id = mt_rand(1, 10000);
  21. }
  22. echo json_encode($arr);
  23. }