Mysql Query Builder for WordPress

1.6.2 2024-02-11 07:35 UTC

This package is auto-updated.

Last update: 2024-07-11 08:41:28 UTC


Relational Database Query builder for WordPress. WP Query Builder uses PDO for database queries. It has zero dependencies with third-party query builders or any other composer library.


Documentation website here.
This Query Builder is also used in Kathamo Framework. Kathamo is a modern framework for WordPress plugin development.


Create Table

	->foreignKey('user_id', 'users.ID', 'cascade')

Insert Statement

DB::insert('querybuilder', [
        'name' => 'Keramot UL Islam',
        'email' => '',

Update Statement

DB::update('querybuilders', [
    'name' => 'Keramot UL',
    'email' => ''
->where('ID', '=', 10)
->andWhere('name', '=', 'Abm Sourav')

Select Statement

$result =
DB::select('qb.ID', ',')

// *** where clouse
$result =
DB::select('posts.ID', 'posts.post_title')
    ->from('posts posts')
    ->where('posts.post_status', '=', 'publish')
    ->orderBy('post_title', 'DESC')

// *** JOIN
DB::select('users.display_name name')
    ->count('posts.ID', 'posts')
    ->from('users users')
    ->join('posts posts')
    ->where('posts.post_status', '=', 'publish')
    ->andWhere('posts.post_type', '=', 'post')

// raw sql
    ->from('posts posts')
    ->raw("WHERE posts.post_type = 'post'")
    ->andWhere('posts.post_status', '=', 'publish')
    ->raw("LIMIT 10")

Delete Statement

// delete one row
    ->where('ID', '=', 3)

// delete all records

Drop Statement


Alter Statement

    ->modify('name', 'username')->string(455)->required()

Single instence

Expressions also can be exicuted with one instence of DB class. By doing this database connection will be stablished only once.

$db = new DB();

$result =
$db::select('posts.ID', 'posts.post_title')


Database Connection

By default database connection will set out of the box, automaically. But you can also manually input database configurations. This way, you also can debug your database queries from terminal.

$db = DB::setConnection(
		"dbhost"        => 'mysql_host',
		"dbname"        => 'database_name',
		"dbuser"        => 'database_user',
		"dbpassword"    => 'database_password',
		"prefix"        => 'database_table_prefix'


The default driver is pdo. But if you want to use wpdb which uses Mysqli, you also can do that by changing the driver.

$db = new DB('wpdb');

    ->from('posts posts')

Dev Envirenment Setup for Contributors

Want to contribute to this package? Please follow the steps below.

  • Create a local WordPress envirenment setup.
  • Create a basic plugin.
  • Run composer init into the plugin.
  • Clone into plugin folder.
  • Add repository for local package in plugin's composer.json.
    "repositories": [
    		"type": "path",
    		"url": "./howdy_qb",
    		"options": {
    			"symlink": true
  • Require this package. composer require "codesvault/howdy-qb @dev"