Файловый менеджер - Редактировать - /home/gqdcvggs/go.imators.com/search_clubs.php.tar
Назад
home/gqdcvggs/.trash/search_clubs.php 0000644 00000001410 15114734620 0013645 0 ustar 00 <?php header('Content-Type: application/json'); header('Access-Control-Allow-Origin: *'); require_once 'config.php'; $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME); if ($conn->connect_error) { echo json_encode(['success' => false, 'error' => 'Database connection failed']); exit; } $query = $conn->real_escape_string($_GET['query']); $sql = "SELECT id, name, logo FROM clubs WHERE name LIKE '%$query%' ORDER BY name LIMIT 10"; $result = $conn->query($sql); $clubs = []; if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $clubs[] = [ 'id' => intval($row['id']), 'name' => $row['name'], 'logo' => $row['logo'] ]; } } echo json_encode(['clubs' => $clubs]); $conn->close(); ?>
| ver. 1.6 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка