Mysqly is a full-featured opensource small-overhead PHP data framework for Mysql built for fast and efficient development.

• Official website
• Advanced Mysql knowledge base

Install

wget https://mysqly.com/mysqly.php

Usage example

require '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 ↓

All features & documentation

• 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