php-dev

Secure PHP API development with Slim and PDO involves configuring a Composer project with PSR-12 compliance, using prepared statements for database queries, implementing input validation, adding CSRF protection, and structuring endpoints with Slim's routing. This Skill guides you through project layout, dependency management, and deployment-ready configurations for MySQL and Oracle databases.

PDO prepared statements are the standard defense against SQL injection. This Skill covers configuring secure PDO connections, binding parameters correctly, and integrating input validation across your Slim API endpoints. Combined with PSR-12 coding standards and PHPStan static analysis, it ensures robust query safety.

Composer manages dependencies and autoloading in PHP projects. This Skill walks you through project layout following PSR-12, configuring Composer for Slim and PDO packages, running PHPUnit and PHPStan for testing and static analysis, and setting up logging with Monolog for production-ready error handling.

Yes. Slim Framework is purpose-built for API development. This Skill shows how to design REST endpoints with Slim, connect securely via PDO, implement proper HTTP methods and status codes, add authentication and CSRF protection, and optimize performance with OPcache and caching strategies.

PHPUnit is the standard testing framework for PHP, paired with Phake for mocking dependencies. This Skill includes test configuration, writing unit and integration tests for Slim routes and PDO queries, and integrating PHPStan for static type checking to catch errors before runtime.

Production readiness includes enabling strict_types for type safety, configuring OPcache for performance, implementing error logging with Monolog, securing environment variables, testing with PHPUnit and PHPStan, and following PSR-12 standards. This Skill covers all deployment configuration steps for stable, secure APIs.