Mysqly is a full-featured opensource small-overhead PHP data framework for Mysql built for fast and efficient development.
wget https://mysqly.com/mysqly.phprequire 'mysqly.php'; # include library (single file)
mysqly::auth('user', 'pwd', 'db', '127.0.0.1'); # connect to Mysql server
// Dynamic methods for table names
$users = mysqly::users(['age' => 25]); # SELECT * FROM users WHERE age = 25
$user = mysqly::users_(6); # SELECT * FROM users WHERE id = 6 LIMIT 1
// And many more features ↓- Procedural style implementation
- Single static class in a single file
- PDO based - single dependancy
- Lazy connection to optimize resources usage
- Simplified parametric queries for frequent use cases
- Lists and key-value pairs retrieval
- Dynamic methods for less code
- Native SQL support
- Secure values binding
- "IN" array values binding support
- JSON retrieval and attributes manipulation
- "Server has gone away" automatic reconnection
- Multiple DB/server connections
- Automatic fields/tables creation mode
- Key-value storage component
- Job queue component
- Cache storage with TTL support component
- CSV/TSV export
- Increment and decrement column values atomically
- Transactions support
- Mysql bit column type support
- INSERT/REPLACE support for single and batched values
