Home / Keyword Tools / NinjaDB — WordPress Plugins

NinjaDB — WordPress Plugins

A light-weight, expressive question builder for . use the identical $wbdp occasion and strategies, It will make it easier to to jot down $wpdb queries simply and expressively. At least PHP 5.three is required.

It has some superior options like:
– Query Like Laravel Basic Queries
– Where, orWhere strategies
– Search information in all of the columns or particular columns
– Easily Implement Pagination
– use insert, replace or delete strategies expressively.

The syntax is kind of much like Laravel’s question builder.

Simple Query:

The question under returns the row the place id = three, null if no rows.

$row = ninjaDB(‘my_table’)->discover(three);

Full Queries:

$question = ninjaDB(‘my_table’)->the place(‘post_author’, ‘=’, 1); // for equal you possibly can simply use the place(‘post_author, 1);
// Get consequence as array of objects
$query->get();

Full Usage API

### Initiate

// Select a desk
$question = ninjaDB()->desk(‘publish’); // publish is the desk title with out prefix;

OR You can cross your desk title as an argument

// Select a desk
$question = ninjaDB(‘my_table’); // publish is the desk title with out prefix;<h3>Query</h3>

Get Easily

The question under returns the (first) row the place id = three, null if no rows.

$row = ninjaDB(‘my_table’)->discover(three);

adobe-cc-apps/"> your row like, echo $row->title. If your subject title just isn’t id then cross the sector title as second parameter ninjaDB(‘my_table’)->discover(three, ‘author_id’);.

The question under returns the all rows as array of objects the place author_id = three, null if no rows.

$consequence = ninjaDB(‘my_table’)->discoverAll(‘author_id’, three);

Select
$question = ninjaDB(‘my_table’)->choose(‘*’);

Multiple Selects
->choose(array(‘myfield1’, ‘myfield2’, ‘amyfield3’));

Using choose technique a number of occasions choose(‘a’)->choose(‘b’) can even choose a and b. Can be helpful if you wish to do conditional selects (inside a PHP if).

Get All

Return an array of objects.

$question = ninjaDB(‘my_table’)->the place(‘author_id’, 1);
$consequence = $query->get();

You can loop by way of it like:

foreach ($consequence as $row)

Get First Row
$question = ninjaDB(‘my_table’)->the place(‘author_id’, 1);
$row = $query->first();

Returns the primary row, or null if there isn’t any document. Using this technique you can even be certain that if a document exists. Access these like echo $row->title.

Get Rows Count, MAX, MIN, AVerage, SUM
$question = ninjaDB(‘my_table’)->the place(‘author_id’, 1);
$rely = $query->rely();
$max = $query->max(‘views’); // Where `views` is the column title and all these will return integer / float
$min = $query->min(‘views’);
$avg = $query->avg(‘views’);
$avg = $query->avg(‘views’);
$sum = $query->sum(‘views’);

Where

Basic syntax is (fieldname, operator, worth), should you give two parameters then = operator is assumed. So the place(‘title’, ‘jewel’) and the place(‘title’, ‘=’, ‘jewel’) is similar.

ninjaDB(‘my_table’)
->the place(‘title’, ‘=’, ‘jewel’)
->whereNot(‘age’, ‘>’, 25)
->orWhere(‘description’, ‘LIKE’, ‘%question%’);

the placeIn
ninjaDB(‘my_table’)
->the placeIn( ‘id’, array(1,2,three) )
->get();

Limit and Offset
->restrict(30);
->offset(10);

// or you should utilize aliases
->take(30);
->skip(10);

Order By
->orderBy(‘id’, ‘ASC’);

Insert
$information = array(
‘title’ => ‘Jewel’,
‘description’ => ‘Hello, There’
);
$insertId = ninjaDB(‘my_table’)->insert($information);

insert() technique returns the insert id. optionally you possibly can cross $format of your information as `->insert($information, $format);` the place `$format` is an array of codecs to be mapped to every of the worth in $information

Batch Insert
$information = array(
array(
‘title’ => ‘Jewel’,
‘description’ => ‘Hello, There’
),
array(
‘title’ => ‘Adre’,
‘description’ => ‘Hello, I’m Adre Astrian’
),
);
$insertIds = ninjaDB(‘my_table’)->batch_insert($information);

In case of batch insert, it can return an array of insert ids.


$information = array(
‘title’ => ‘Shahjahan Jewel’,
‘description’ => ‘Hello, There’
);

ninjaDB(‘my_table’)->the place(‘id’, 5)->replace($information);

Will replace the title subject to Shahjahan Jewel and outline subject to Hello, There the place id = 5.

Delete
ninjaDB(‘my_table’)->the place(‘id’, ‘>’, 5)->delete();

Will delete all of the rows the place id is larger than 5.

If you discover any typo or prolong any performance then please edit and ship a pull request.

TODO

[ ] be a part of()
[ ] whereIN()
[ ] whereNotIN()
[ ] whereBetween
[ ] whereNotBetween
[ ] Having
[ ] GroupBy
[ ] selectDistinct

If you want to implement any of the TODO please be at liberty to do and do a pull request

And, lastly, take into account to contribute to this plugin right here.

Return back to Keyword Tools

Return back to Home

About admin

Check Also

4665 Java Development Kit 1 28 5 15

Java Development Kit 8 Update 152 (64-bit)

Java Development Kit is the official growth equipment for the Java programming language. Java Development …