PHP Recipes: Code & SQL

Tap Run and the real output appears right under the code, so you know what it does before it goes into your project. No PHP to install, no IDE, no setup, no account. 360+ short examples, one task each. Over 95% run on PHP 8.5. You know what you need, but not the exact syntax: • How do I pass values into an SQL query without concatenating strings? • How do I add a month to a date? • How do I build a random string from a given set of characters? Each has a working example here. • 21 sections, including arrays, classes and interfaces, enums, closures, exception handling, regular expressions, files, JSON and XML, databases, algorithms, and design patterns. • What changed from PHP 7.0 to 8.4, with before-and-after code: match expressions, named arguments, constructor property promotion, readonly properties, property hooks. • Reference, 150+ entries: keywords, magic methods, superglobals, and functions for strings, arrays, and files. Tap a word in the code to look it up. • 200+ SQL queries: JOIN, GROUP BY, subqueries, window functions; more than half run on a practice database. • Search looks inside the code: type array_map to find every example that uses it. • Edit an example and run your version, or write your own. • Works on iPhone, iPad, and Mac. • Everything except running code works offline. Free version: 200+ PHP examples and 120+ SQL queries, the full reference, and 12 runs and 12 edits a day (PHP and SQL runs share one limit). Full version: all examples and queries, unlimited edits and examples of your own, and up to 30 PHP and 80 SQL runs a day. One-time purchase, no subscription. Built by a developer for developers. The project behind it has been in active development since 2015.