Файловый менеджер - Редактировать - /home/gqdcvggs/.trash/react_announcement.php
Назад
<?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; } $data = json_decode(file_get_contents('php://input'), true); $announcementId = intval($data['announcementId']); $userId = intval($data['userId']); $reaction = $conn->real_escape_string($data['reaction']); $checkSql = "SELECT id FROM announcement_reactions WHERE announcement_id = $announcementId AND user_id = $userId"; $checkResult = $conn->query($checkSql); if ($checkResult->num_rows > 0) { $sql = "UPDATE announcement_reactions SET reaction = '$reaction' WHERE announcement_id = $announcementId AND user_id = $userId"; } else { $sql = "INSERT INTO announcement_reactions (announcement_id, user_id, reaction) VALUES ($announcementId, $userId, '$reaction')"; } if ($conn->query($sql) === TRUE) { echo json_encode(['success' => true]); } else { echo json_encode(['success' => false, 'error' => $conn->error]); } $conn->close(); ?>
| ver. 1.6 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка