Overview

WPZylos Database provides safe $wpdb wrapper with fluent query builder.

Key Features

• Prepared Queries - All queries use $wpdb->prepare()
• Query Builder - Fluent select/insert/update/delete
• Context-Aware - Table names use $context->tableName()
• Transactions - beginTransaction(), commit(), rollback()

Quick Start

use WPZylos\Framework\Database\Connection;

$db = new Connection($context);
$users = $db->table('users')
    ->where('status', 'active')
    ->orderBy('created_at', 'DESC')
    ->limit(10)
    ->get();

Query Builder

// Select
$db->table('posts')->select('id', 'title')->where('status', 'published')->get();

// Insert
$db->table('logs')->insert(['message' => 'Event', 'level' => 'info']);

// Update
$db->table('users')->where('id', 1)->update(['name' => 'John']);

// Delete
$db->table('sessions')->where('expired', true)->delete();

API Reference