# PPPHP RAD Studio

> PPPHP is a PHP rapid application builder (RAD) and low-code app generator. Point it at any SQL database — MySQL, MariaDB, TiDB, PostgreSQL, CockroachDB, SQLite, SQL Server or Oracle, or its built-in zero-server Virtual Database — design every screen visually, and generate a complete, secure CRUD web application (lists, forms, dashboards, roles, reports) that you own as plain, readable PHP and can host anywhere PHP 8 runs, including inexpensive shared hosting.

PPPHP is aimed at PHP developers, web developers, low-code/no-code builders, agencies and businesses who need a working database-driven application fast — a modern, self-hosted alternative to PHPRunner and hosted low-code platforms. It is "batteries fully included": mail server, database engine, file storage, SMS, search, PDF, authentication (2FA + passkeys), a REST API, webhooks and a real-time bus are all first-party, with nothing to sign up for or pay per seat.

## Key facts
- Category: Rapid Application Builder (RAD), low-code PHP app generator, admin panel / CRUD generator.
- Databases: MySQL, MariaDB, TiDB, PostgreSQL, CockroachDB, SQLite, SQL Server, Oracle, plus a built-in zero-server Virtual Database (SQLite).
- Output: plain, readable PHP using prepared statements — you own it; built apps run with no licensing code and keep working even if the builder licence lapses.
- Runs on: PHP 8 on Windows, macOS, Linux and shared hosting.
- Highlights: 130+ visual designer components; dashboards, gauges, pivots, funnels, heatmaps; real-time updates over Server-Sent Events; secure REST API with bearer + HMAC keys, scopes and rate limits; outbound webhooks; Document Studio (PDF invoices/letterheads with QR); row-level security and AES-256 field encryption; passwordless passkeys (WebAuthn) and 2FA; full internationalisation (i18n); cloud file storage (S3, Cloudflare R2, MinIO, Google Drive, OneDrive); Bikram Sambat (Nepali) date support.

## Primary pages
- [Home / overview](https://ppradhan.com/): what PPPHP is, how it works, who it is for.
- [Product tour video, 1 min 47 s](https://www.youtube.com/watch?v=RMrzNkNnTxQ): narrated walkthrough with real screens — create a project, model tables, design a dashboard, secure it, build and run the generated app (master–detail, live lookups), events with smart IntelliSense, plus kanban, calendars, PDF invoices, Excel import, REST API, Mailroom messaging, email, SMS and multi-language UI (on YouTube; also opens in-page at https://ppradhan.com/#tour).
- [Capabilities](https://ppradhan.com/#features): the full first-party feature set, grouped Essentials · Design · Data · Connect · Ship & secure.
- [Databases](https://ppradhan.com/#databases): the eight supported SQL engines and the Virtual Database.
- [How it works](https://ppradhan.com/#how): connect → choose pages → design → build & deploy.
- [Security](https://ppradhan.com/#security): roles, RLS, field encryption, 2FA, passkeys, auditing.
- [FAQ](https://ppradhan.com/#faq): common questions about coding requirements, hosting, ownership and trials.

## Video tutorials (YouTube)
- [PPPHP RAD Studio on YouTube](https://www.youtube.com/@PPPHPRADStudio): narrated 4K tutorials, feature spotlights and tips filmed in the real product; new videos are added as features ship.
- [Getting Started with PPPHP RAD Studio (playlist)](https://www.youtube.com/playlist?list=PLNmOx9nGNp2M): build your first app → import data, linked tables and a Kanban board → sign-in, roles, permissions and deployment → tips & tricks (help on every screen, community, email, SMS, 2FA).
- [Video tutorials section](https://ppradhan.com/#videos): the same series, introduced on the home page.

## Documentation
- [Documentation home](https://ppradhan.com/docs/): guides that ship inside the product.
- [Designer components](https://ppradhan.com/docs/component_guide/): every component you can place on a page, and how to use it.
- [Choice fields](https://ppradhan.com/docs/choice_fields/): dropdowns, radios, checkboxes and type-aheads from a table, preset or list.
- [List pages](https://ppradhan.com/docs/page_list/): filter, sort, colour rows and bulk actions.
- [Add & Edit forms](https://ppradhan.com/docs/page_add_edit/): defaults, validation, calculated and dependent fields.
- [Dashboards](https://ppradhan.com/docs/page_dashboard/): KPI tiles, charts and widgets bound to live data.
- [Master / Detail](https://ppradhan.com/docs/page_master_detail/): parent and child grids that read and write together.
- [Documents & PDF](https://ppradhan.com/docs/page_documents/): invoices, ledgers and statements with server-side PDF.
- [Events](https://ppradhan.com/docs/events/): where to put your own code — page, field and button events.
- [Working with data](https://ppradhan.com/docs/DB/): queries, relationships and database helpers.
- [SQL variables](https://ppradhan.com/docs/sql_variables/): dynamic filters with :userid, :session.x and :user.field.
- [Databases](https://ppradhan.com/docs/databases/): build once, host on MySQL, PostgreSQL, SQL Server or SQLite.
- [Search & filtering](https://ppradhan.com/docs/Search/): search boxes, filter panels and query options.
- [Calendars](https://ppradhan.com/docs/Calendar/): turn any date column into a calendar.
- [PDF & printing](https://ppradhan.com/docs/PDF/): per-record PDFs, print layouts, export formatting.
- [Email](https://ppradhan.com/docs/Email/): configure SMTP and send mail.
- [SMS](https://ppradhan.com/docs/SMS/): send text messages.
- [Notifications](https://ppradhan.com/docs/Notification/): in-app notifications.
- [Multiple languages](https://ppradhan.com/docs/languages/): offer your app in several languages, including Nepali.
- [Security](https://ppradhan.com/docs/Security/): roles, permissions, RLS, encryption, auditing.
- [Helper functions](https://ppradhan.com/docs/Helpers/): shorthand functions available anywhere in the app.
- [JavaScript API](https://ppradhan.com/docs/PPjs/): client-side hooks for custom page behaviour.

## Community
- [PPPHP Community Q&A](https://ppradhan.com/community): questions and answers on building database apps with PPPHP.
- [Tips & Tricks](https://ppradhan.com/community/tips): curated recipes for dashboards, databases, security and integrations.

## Comparisons
How PPPHP compares with other tools — a self-hosted, own-your-code PHP app generator versus hosted low-code platforms and other code generators:
- [All comparisons](https://ppradhan.com/compare/): index of every PPPHP alternative comparison.
- [PPPHP vs Retool](https://ppradhan.com/compare/retool/): own portable PHP you host anywhere vs a hosted internal-tools platform on per-seat pricing.
- [PPPHP vs Budibase](https://ppradhan.com/compare/budibase/): a standalone PHP app on plain hosting vs an open-source platform you run (Node/Docker).
- [PPPHP vs Appsmith](https://ppradhan.com/compare/appsmith/): ship a PHP app you own vs run the Appsmith platform on Docker.
- [PPPHP vs ToolJet](https://ppradhan.com/compare/tooljet/): own a portable PHP app vs self-host the ToolJet platform.
- [PPPHP vs Laravel Filament](https://ppradhan.com/compare/filament/): a visual generator with no build step vs a code-first Laravel framework (Composer + Vite).
- [PPPHP vs PHPRunner](https://ppradhan.com/compare/phprunner/): a web-based studio with a modern built-in stack vs a Windows desktop PHP generator.
- [PPPHP vs ASPRunner.NET](https://ppradhan.com/compare/asprunner/): PHP that runs anywhere vs a generated .NET / C# app.
- [PPPHP vs ASPRunnerPro](https://ppradhan.com/compare/asprunnerpro/): modern PHP 8 vs classic ASP (legacy) — a clean way to modernise.
- [PPPHP vs Xano](https://ppradhan.com/compare/xano/): a complete self-hosted app you own (frontend + backend) vs a hosted no-code backend.

## Try it
- [Request a trial](https://ppphp.ppradhan.com/request-trial): build something real on a sandbox database, no card required.
