updateraw.php 981 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. function updateraw($pdo) {
  3. $query_count = 1;
  4. if (isset($_GET['queries']) && $_GET['queries'] > 0) {
  5. $query_count = $_GET['queries'];
  6. }
  7. if ($query_count > 500) $query_count=500;
  8. $arr = [];
  9. $id = mt_rand(1, 10000);
  10. $randomNumber = mt_rand(1, 1000);
  11. $statement = $pdo->prepare('SELECT randomNumber FROM World WHERE id = :id');
  12. $statement->bindParam(':id', $id, PDO::PARAM_INT);
  13. $updateStatement = $pdo->prepare('UPDATE World SET randomNumber = :randomNumber WHERE id = :id');
  14. $updateStatement->bindParam(':id', $id, PDO::PARAM_INT);
  15. $updateStatement->bindParam(':randomNumber', $randomNumber, PDO::PARAM_INT);
  16. while ($query_count--) {
  17. $statement->execute();
  18. $world = ['id' => $id, 'randomNumber' => $statement->fetchColumn()];
  19. $world['randomNumber'] = $randomNumber;
  20. $updateStatement->execute();
  21. $arr[] = $world;
  22. $id = mt_rand(1, 10000);
  23. $randomNumber = mt_rand(1, 10000);
  24. }
  25. echo json_encode($arr);
  26. }