🛠️ SimpleMySQL — Lightweight MySQL Library for PHP

SimpleMySQL is a lightweight 💡 and minimalistic 📦 PHP library for working with MySQL using mysqli.
It’s designed to make SQL interaction in your PHP projects easier, cleaner, and safer — no frameworks required!

---

✨ Key Features

• 🔐 Safe prepared statements with parameter binding
• 🔁 Full transaction control: start() / finish() / stop()
• 📋 Fetch one or many rows easily
• 📂 Read cached JSON files for fast offline access
• ⚙ Get server variables like max_connections
• 🌐 UTF-8 charset by default
• 🧩 Fully standalone — no dependencies!

---

🚀 Quick Start

📦 Initialize the class

require_once 'database.php';
$db = new SimpleMySQL();

---

🔍 Fetch a single row

$user = $db->fetch("SELECT * FROM users WHERE id = ?", [1]);
echo $user['name'];

---

📄 Fetch multiple rows

$users = $db->fetchAll("SELECT * FROM users WHERE status = ?", ['active']);
foreach ($users as $user) {
    echo $user['email'] . "<br>";
}

---

📝 Execute insert / update / delete

$db->execute("UPDATE users SET role = ? WHERE id = ?", ['admin', 3]);

---

🆔 Get last inserted ID

$db->execute("INSERT INTO logs (message) VALUES (?)", ['User added']);
$id = $db->lastInsertId();

---

🔁 Transaction example

$db->start();

try {
    $db->execute("DELETE FROM sessions WHERE user_id = ?", [2]);
    $db->execute("UPDATE users SET status = ? WHERE id = ?", ['inactive', 2]);
    $db->finish(); // ✅ commit
} catch (Exception $e) {
    $db->stop(); // ❌ rollback
}

---

📥 Read data from JSON cache

$data = $db->readCache('cache/data.json');
if ($data) {
    foreach ($data as $row) {
        echo $row['title'] . "<br>";
    }
}

---

⚙ Get MySQL server variable

echo "Max Connections: " . $db->getVariable("max_connections");

---

❎ Close connection

$db->close();

---

✅ When to Use It?

• You need a lightweight PHP tool to connect to MySQL ✅
• You don’t want heavy frameworks ❌
• You want safety and clarity 🔐
• You just want to get things done 🧠

---

📄 License

MIT — free to use and modify.

Built with ❤️ by Temirkhan
@temirkhanrustemov • temirkhan.onyx@gmail.com