README

A PHP framework for rapidly creating classes that mirror MySQL tables. The Simpl framework comes with the basic functions to list, display and edit records from the database. With this framework a simple manager and front of a site can be created within a few minutes. An example database, manager and front end are included with the framework.

Features

• No make/PEAR/Root Access required
• Database table abstraction
• Automatically configured database functions (ie. !GetInfo, !GetList, Save, Delete, Search and Form)
• Advanced automatic form creation to mirror database/class expectations, XHTML compliant and ADA accessible.
• Table structure caching, Query level caching, and saving of inserts or updates to the filesystem if the database is unavailable.
• Ability to query cross databases on the same server
• Form validation
• Upload, Move, Copy, Delete and List Files
• Resize and Rotate Images
• Email with class abstraction with support for attachments
• RSS0.91, RSS1.0, RSS2.0, ATOM Feeds
• CVS, JSON, XML and SQL Exports
• JSON encoding and decoding support

Goals

• Easy Install. No need to be an administrator.
• Minimal Server Load. Created for a high traffic shared server environment.
• Straightforward API. No need to dig through documentation, functions are naturally named.
• Stop Wasting Time. Time is precious, no need to reinvent the wheel.

🚀 Quick Start

# Test on PHP 5.5 (current production)
./test-php55.sh

# Test on PHP 8.2 (migration target)
./test-php82.sh

# Test BOTH environments
./test-all-environments.sh

📦 Environment Control

./env.sh 55      # Start PHP 5.5
./env.sh 82      # Start PHP 8.2  
./env.sh all     # Start both
./env.sh down    # Stop all

🐳 Docker Services

📋 Expected Test Results

PHP 5.5 (Current)

• ✅ Tests SHOULD PASS
• Uses mysql_* functions
• Validates current behavior

PHP 8.2 (Target)

• ✅ Tests PASS
• Uses mysqli extension
• Full PEST test suite

📖 Full Documentation

• MULTI-ENV-TESTING.md - Complete guide
• TESTING.md - General testing guide

⚙️ Manual Testing

# Access PHP 5.5 container
docker-compose exec php55 bash

# Access PHP 8.2 container
docker-compose exec php82 bash

# Run PEST tests (PHP 8.2 only - PEST requires PHP 7.3+)
docker-compose exec php82 ./vendor/bin/pest tests/Unit

# PHP 5.5 syntax validation
docker-compose exec php55 php -l lib/db.php