0) { if ($action === 'approve') { // Approve image: move image_new → image $sql = " UPDATE main_contact SET image = image_new, image_new = NULL, image_state = 'approved' WHERE id = {$contactId} LIMIT 1 "; } else { // Reject image: remove image_new, set discard $sql = " UPDATE main_contact SET image_new = NULL, image_state = 'discard' WHERE id = {$contactId} LIMIT 1 "; } @mysqli_query($GLOBALS['mysql_con'], $sql); } echo ""; } $requests = []; if (!empty($GLOBALS['mysql_con'])) { $sql = " SELECT id, name, image_new, image_state FROM main_contact WHERE image_state = 'approve_required' AND image_new IS NOT NULL AND image_new != '' "; $res = @mysqli_query($GLOBALS['mysql_con'], $sql); if ($res) { while ($row = mysqli_fetch_assoc($res)) { $requests[] = [ 'id' => (int) $row['id'], 'user_id' => (int) $row['id'], 'photo_path' => $row['image_new'], 'username' => $row['name'], 'created_at' => "" // No date currently stored; placeholder left empty ]; } mysqli_free_result($res); } } ?>

Foto-Anfragen zur Genehmigung

Keine ausstehenden Foto-Anfragen.

Foto von <?= htmlspecialchars($username) ?>