Ana Sayfa / Kod ve Scriptler / Supportly - Helpdesk Ticket System PHP MySQL

Supportly - Helpdesk Ticket System PHP MySQL

PHP ve MySQL arka ucu, müşteri portalı, iş saatlerine dayalı SLA sayaçları, makrolar ve raporlarla destek taleplerini yönetin.

  • Yayın tarihi13 Kasım 2026
  • Nerede çalışırNode.js 22
  • VeritabanıMySQL 5.7, MariaDB 10.x
  • Paket içeriği.php, .css, .html, .json, .svg, .sql, JavaScript .js
  • Son güncelleme13 Kasım 2026
  • Canlı demoVar
Supportly - Helpdesk Ticket System PHP MySQL

Overview

Supportly is a helpdesk for software companies and service businesses. Agents sign in from any device and share one inbox; customers contact you on a support page and follow their ticket on a private page. Everything is stored in your MySQL or MariaDB database through the included PHP API.

The customer portal is built on the server. A customer sends a request without an account and gets a ticket number and a private access code. On their ticket page they read your public replies, answer, and rate the help once it is solved. Internal notes, tags, assignees and SLA clocks never leave the agent side. For tickets that came in by email or phone, an agent copies a fresh customer link and pastes it into the reply.

The ticket lifecycle is strict on purpose: only valid status changes are offered, solving needs a public reply, a customer reply reopens a pending or solved ticket, and every change lands in the activity timeline. SLA timers count business hours in your timezone, pause while a ticket is pending, and show what needs an answer next.

Agent accounts use secure sessions with CSRF protection and rate-limited sign-in. Saves carry a version number, so two agents editing at once never overwrite each other: the app re-applies its change on the newer data. Open screens pick up new tickets and customer replies every 15 seconds. A web installer creates the tables and the first administrator.

The frontend is React 19 + TypeScript + Vite; the backend is plain PHP 8 with PDO (no framework, no Composer), so it runs on ordinary shared hosting with cPanel.

About the live demo: the demo is a static build of the same app hosted without PHP, so it runs in browser-only mode with a fictional company. Tickets there are saved in your browser, the support page finds a ticket by number and email, and incoming email can be simulated. Sign-in, accounts and access codes are server features, included in the download and documented step by step.

Limitations: no email is received or sent; customers use the support page and agents paste the customer link into their own email. Attachments are recorded by file name only. Notifications are in-app only.

Features

Server (PHP + MySQL) - Agent sign-in with administrator and member roles, password change, accounts - Tickets stored in MySQL/MariaDB with versioned saves and automatic merging of concurrent edits - Customer portal: contact form, private ticket page, customer replies, one rating per solved ticket - Access codes stored as hashes; wrong code and unknown ticket get the same answer - Rate limits for sign-in and every portal action; CSRF tokens; HttpOnly session cookie - Web installer and command-line installer; works on shared hosting

Inbox - Views: Unassigned, Assigned to me, Open, Pending, Overdue, Resolved, All, plus saved views - Filters for status, priority, assignee, team, category, channel and SLA state; search across messages - Sort by last update, newest, priority or next SLA deadline - Bulk status change and assignment with confirmation; skipped tickets are reported with the reason - CSV export

Tickets - Customer messages, public replies and internal notes, clearly separated - Reply and set the next status in one step - Assignee with each agent's open workload, team, category and tags - Activity timeline of every change - New, Open, Pending, On hold, Solved, Closed

SLA - First-response and resolution targets per priority - Business hours with timezone, or elapsed time, clearly labelled - Pending pauses the resolution clock - Due in, due soon, overdue, met and paused badges, updated when priority changes - Demo clock to move time forward (demo build)

Macros and knowledge - Macros with ticket fields such as {{customer.first_name}} and [[free]] placeholders the agent fills in - Preview before inserting; a macro can set status and tags - Sending is blocked while a placeholder is left unfilled - Knowledge snippets with search and suggestions on every ticket

Customers, reports and settings - Customer profile with organisation, previous tickets and notes - Created and solved per day, median first response and resolution, SLA attainment, backlog by age, reopened tickets, workload - Teams, agents, categories, labels, SLA targets, business hours, JSON backup and restore

Quality - Light and dark themes, keyboard support, visible focus - Responsive down to 375 px with a bottom bar on phones - 15 unit tests and 17 automated API tests against a real MariaDB database - Strict TypeScript, ESLint

Requirements

- PHP 8.1 or newer with pdo_mysql and mbstring - MySQL 5.7+ or MariaDB 10.3+ - Any host that runs PHP (shared hosting with cPanel works); HTTPS recommended - Node.js 22.12+ and npm 10+ only to build the frontend (npm run build:server)

Browser compatibility: Latest Chrome, Edge, Firefox and Safari.