# 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.
- [PPServer](https://ppradhan.com/ppserver/): the free local development stack PPPHP ships alongside itself — PHP 8.5, MariaDB, Caddy, phpMyAdmin and a SQLite studio in one folder, for Windows, macOS and Linux. No installer, no Docker. Backs your databases and web root up into one portable file, by hand or on a schedule, with an optional passphrase; restoring takes a safety copy first.
- [Download PPServer](https://ppradhan.com/ppserver/download/): detects your platform and offers the matching build.
- [PPServer walkthrough, 12 min 4 s](https://ppradhan.com/ppserver/#watch): the whole thing filmed on the running product — download, unpack, start with a double-click, every tab of the control panel, both database tools, backups into one portable file, light and dark, and installing PPPHP RAD Studio on top of it. Chaptered; plays in the page.
- [View pages](https://ppradhan.com/docs/page_view/): the single-record page: layout, related grids and what each action does.
- [Print pages](https://ppradhan.com/docs/page_print/): print-ready layouts for a record or a whole list.
- [Import & export](https://ppradhan.com/docs/page_export_import/): CSV and Excel in and out, with a column-mapping wizard.
- [Filters & page parameters](https://ppradhan.com/docs/page_filter/): filter panels, filter tabs and driving a whole page from one control.
- [Payments & checkout](https://ppradhan.com/docs/payments/): take money from any page — Stripe, PayPal, Razorpay, Khalti, eSewa and Fonepay, with hosted checkout.
- [Subscriptions](https://ppradhan.com/docs/subscription/): recurring plans and renewals on top of the payment gateways.
- [Bookings & appointments](https://ppradhan.com/docs/booking/): slots, availability and confirmations for an appointment-shaped app.
- [In-app messaging](https://ppradhan.com/docs/mailroom/): Mailroom: e-mail-like conversations between the people who use your app.
- [Databases & Data Studio](https://ppradhan.com/docs/database_manager/): the built-in zero-server database, and browsing or editing any connected one.
- [Sensitive fields](https://ppradhan.com/docs/sensitive_fields/): masking a value so it is shown only to the people allowed to see it.
- [The Designer workspace](https://ppradhan.com/docs/designer_workspace/): drag, drop, select, reorder and style pages in the visual designer.
- [AI — two engines](https://ppradhan.com/docs/ai/): bring your own provider (Anthropic, OpenAI, Gemini, DeepSeek, Groq, Mistral, OpenRouter) or use the model built into Chrome and Edge, where answers are free and the text never leaves the computer; per-task policy with a 'device only' mode enforced in the browser AND on the server.
- [Your app on a phone](https://ppradhan.com/docs/mobile_app/): design the phone experience — bottom tab bar, arrangeable top bar, tap effects, per-page exceptions, installable PWA, offline reading of chosen tables, swipe-to-decide Triage pages, barcode scanning as a field, home-screen shortcuts, and an idle session that locks and reopens with a fingerprint.
- [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.

## Blog
- [PPPHP RAD Studio, 0 to 100: the complete guide to building database web apps](https://ppradhan.com/blog/ppphp-rad-studio-complete-guide/): Step-by-step guide to PPPHP RAD Studio: connect any SQL database, generate CRUD pages and dashboards, then secure, build and deploy a PHP web app you own.
- [Responsive, mobile-first web apps — without writing front-end code](https://ppradhan.com/blog/responsive-mobile-first-web-apps-without-frontend-code/): Build responsive, mobile-first web apps with PPPHP: a native-style phone UI, installable PWA, offline sync, web push, dark mode and multilingual apps.
- [The modern web stack in one studio: APIs, real-time, security and deployment](https://ppradhan.com/blog/modern-web-development-stack-apis-realtime-security/): What ships in every PPPHP app: REST API, OAuth2, GraphQL, webhooks, real-time SSE, passkeys, row-level security, payments, cloud storage and AI.
- [Design the mobile app — don’t build a second one](https://ppradhan.com/blog/design-mobile-app-from-database-no-second-codebase/): Give a database app a real phone experience without a second codebase: a bottom tab bar you drag into shape, an arrangeable app bar, tap effects, per-page rules, installable PWA, offline writes and web push — from one build that still serves desktop.
- [From nothing installed to a live app on a phone](https://ppradhan.com/blog/php-local-development-environment-xampp-alternative-to-live-app/): A free, portable PHP 8.5 + MariaDB + Caddy stack that runs from one folder on Windows, macOS and Linux — no installer, no admin password, no port 80 fight — and a visual studio that turns that database into a web app, a REST API and an installable mobile app from a single build.
- [A critical PHP flaw landed. Here is where you actually stand.](https://ppradhan.com/blog/php-security-vulnerability-2026-cve-109618-patched-php-8-5-12/): Two critical remote-code-execution flaws in PHP — CVE-2026-109618 and CVE-2026-109619, CVSS 9.2 — were fixed in PHP 8.5.12, and nothing is left outstanding. A plain-English explanation of what they are, a two-minute way to check whether your server is exposed, and how PPServer shipped the patched build within days.
- [Build forms that react to what people type. No JavaScript required.](https://ppradhan.com/blog/conditional-fields-smart-filters-no-code-forms/): Conditional field visibility, star &amp; pill filters, one-click date presets, and type-ahead suggestions from your own data — the field-control upgrades in PPPHP RAD Studio that make a generated app feel hand-built, configured once and compiled into clean PHP you own.
