PHPackages                             wpdiggerstudio/wpzylos-database - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. wpdiggerstudio/wpzylos-database

ActiveLibrary[Database & ORM](/categories/database)

wpdiggerstudio/wpzylos-database
===============================

Safe wpdb wrapper with query builder for WPZylos framework

v1.0.0(3mo ago)02783MITPHPPHP ^8.0CI passing

Since Feb 1Pushed 3mo agoCompare

[ Source](https://github.com/WPDiggerStudio/wpzylos-database)[ Packagist](https://packagist.org/packages/wpdiggerstudio/wpzylos-database)[ Docs](https://github.com/WPDiggerStudio/wpzylos-database)[ Fund](https://www.paypal.com/donate/?hosted_button_id=66U4L3HG4TLCC)[ RSS](/packages/wpdiggerstudio-wpzylos-database/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (1)Dependencies (5)Versions (2)Used By (3)

WPZylos Database
================

[](#wpzylos-database)

[![PHP Version](https://camo.githubusercontent.com/911a83e2aa6fe73660ab613629a95c76622bf03049a7344e80c5ea72d4ef9c7d/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d253545382e302d626c7565)](https://php.net)[![License](https://camo.githubusercontent.com/f8df3091bbe1149f398a5369b2c39e896766f9f6efba3477c63e9b4aa940ef14/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d677265656e)](LICENSE)[![GitHub](https://camo.githubusercontent.com/dbe820b98864e115173c422b9472b725cfa678bee03b66ff2c453dad95a3d20b/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4769744875622d575044696767657253747564696f2d3138313731373f6c6f676f3d676974687562)](https://github.com/WPDiggerStudio/wpzylos-database)

Safe wpdb wrapper with query builder for WPZylos framework.

📖 **[Full Documentation](https://wpzylos.com)** | 🐛 **[Report Issues](https://github.com/WPDiggerStudio/wpzylos-database/issues)**

---

✨ Features
----------

[](#-features)

- **Query Builder** — Fluent interface for SQL queries
- **Safe Queries** — Automatic $wpdb->prepare() integration
- **CRUD Operations** — insert, update, delete, select
- **Table Prefixing** — Automatic table prefix handling
- **Transactions** — Database transaction support

---

📋 Requirements
--------------

[](#-requirements)

RequirementVersionPHP^8.0WordPress6.0+---

🚀 Installation
--------------

[](#-installation)

```
composer require wpdiggerstudio/wpzylos-database
```

---

📖 Quick Start
-------------

[](#-quick-start)

```
use WPZylos\Framework\Database\DB;

// Simple queries
$users = DB::table('users')->get();
$user = DB::table('users')->find(1);

// Query builder
$products = DB::table('products')
    ->where('status', 'active')
    ->where('price', '>', 100)
    ->orderBy('created_at', 'desc')
    ->limit(10)
    ->get();
```

---

🏗️ Core Features
----------------

[](#️-core-features)

### Select Queries

[](#select-queries)

```
// Get all records
$users = DB::table('users')->get();

// Get first record
$user = DB::table('users')->where('email', $email)->first();

// Select specific columns
$names = DB::table('users')->select('id', 'name')->get();

// With conditions
$active = DB::table('users')
    ->where('status', 'active')
    ->where('role', 'admin')
    ->get();
```

### Insert

[](#insert)

```
DB::table('users')->insert([
    'name' => 'John Doe',
    'email' => 'john@example.com',
]);

// Get insert ID
$id = DB::table('users')->insertGetId([
    'name' => 'Jane Doe',
    'email' => 'jane@example.com',
]);
```

### Update

[](#update)

```
DB::table('users')
    ->where('id', 1)
    ->update(['status' => 'inactive']);
```

### Delete

[](#delete)

```
DB::table('users')
    ->where('id', 1)
    ->delete();
```

### Transactions

[](#transactions)

```
DB::transaction(function () {
    DB::table('orders')->insert($order);
    DB::table('inventory')->decrement('stock', 1);
});
```

---

📦 Related Packages
------------------

[](#-related-packages)

PackageDescription[wpzylos-core](https://github.com/WPDiggerStudio/wpzylos-core)Application foundation[wpzylos-migrations](https://github.com/WPDiggerStudio/wpzylos-migrations)Database migrations[wpzylos-scaffold](https://github.com/WPDiggerStudio/wpzylos-scaffold)Plugin template---

📖 Documentation
---------------

[](#-documentation)

For comprehensive documentation, tutorials, and API reference, visit **[wpzylos.com](https://wpzylos.com)**.

---

☕ Support the Project
---------------------

[](#-support-the-project)

If you find this package helpful, consider buying me a coffee! Your support helps maintain and improve the WPZylos ecosystem.

[ ![Donate with PayPal](https://camo.githubusercontent.com/ab874f7381c27789efc0a8502714f480bb5ddcc2de7008417d26b5069068341c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f446f6e6174652d50617950616c2d626c75652e7376673f7374796c653d666f722d7468652d6261646765266c6f676f3d70617970616c)](https://www.paypal.com/donate/?hosted_button_id=66U4L3HG4TLCC)---

📄 License
---------

[](#-license)

MIT License. See [LICENSE](LICENSE) for details.

---

🤝 Contributing
--------------

[](#-contributing)

Contributions are welcome! Please see [CONTRIBUTING.md](CONTRIBUTING.md) for guidelines.

---

**Made with ❤️ by [WPDiggerStudio](https://github.com/WPDiggerStudio)**

###  Health Score

37

—

LowBetter than 83% of packages

Maintenance80

Actively maintained with recent releases

Popularity11

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity39

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

106d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/87be74120ef333e9f794308da1fdcb9505f3e1b255926014a144e6360bb29c08?d=identicon)[WPDiggerStudio](/maintainers/WPDiggerStudio)

---

Top Contributors

[![WPDiggerStudio](https://avatars.githubusercontent.com/u/55980087?v=4)](https://github.com/WPDiggerStudio "WPDiggerStudio (2 commits)")

---

Tags

wordpressdatabaseormsqlquery builderwpdbwpzylos

###  Code Quality

TestsPHPUnit

Static AnalysisPHPStan

Code StylePHP\_CodeSniffer

Type Coverage Yes

### Embed Badge

![Health badge](/badges/wpdiggerstudio-wpzylos-database/health.svg)

```
[![Health](https://phpackages.com/badges/wpdiggerstudio-wpzylos-database/health.svg)](https://phpackages.com/packages/wpdiggerstudio-wpzylos-database)
```

###  Alternatives

[cycle/orm

PHP DataMapper ORM and Data Modelling Engine

1.3k835.4k65](/packages/cycle-orm)[cycle/database

DBAL, schema introspection, migration and pagination

64690.9k31](/packages/cycle-database)[dbout/wp-orm

WordPress ORM with Eloquent.

1279.6k1](/packages/dbout-wp-orm)[williarin/wordpress-interop

Interoperability library to work with WordPress database in third party apps

6610.9k2](/packages/williarin-wordpress-interop)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)