Advertisement
Halsey748

Untitled

Jun 27th, 2025
10
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. <?php
  2. header("Content-Type: application/json");
  3.  
  4. $host = 'localhost';
  5. $user = 'root';
  6. $password = 'Onetime2001';
  7. $dbname = 'test_db';
  8.  
  9. $conn = new mysqli($host, $user, $password, $dbname);
  10.  
  11. if ($conn->connect_error) {
  12. die(json_encode(['error' => 'Ошибка подключения: ' . $conn->connect_error]));
  13. }
  14.  
  15. $sql = "SELECT id, name, email, tg FROM users";
  16. $result = $conn->query($sql);
  17.  
  18. $data = [];
  19.  
  20. if ($result && $result->num_rows > 0) {
  21. while($row = $result->fetch_assoc()) {
  22. $data[] = $row;
  23. }
  24. } else {
  25. $data = ['message' => 'Нет данных'];
  26. }
  27.  
  28. $conn->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement