Title: NinjaDB Author: Shahjahan Jewel Published: 26.09.2017 Last modified: 26.09.2017 --- ჩადგმების ძებნა ![](https://ps.w.org/ninjadb/assets/banner-772x250.png?rev=1736466) ეს პლაგინი **არ დატესტილა WordPress-ის 3 ძირითად ვერსიაზე**. როგორც ჩანს, ის უკვე აღარ არის მხარდაჭერილი და შესაძლოა არ იყოს თავსებადი WordPress-ის მიმდინარე ვერსიასთან. ![](https://ps.w.org/ninjadb/assets/icon-256x256.png?rev=1736466) # NinjaDB ავტორი: [Shahjahan Jewel](https://profiles.wordpress.org/techjewel/) [ჩამოტვირთვა](https://downloads.wordpress.org/plugin/ninjadb.zip) * [დეტალები](https://ka.wordpress.org/plugins/ninjadb/#description) * [მიმოხილვა](https://ka.wordpress.org/plugins/ninjadb/#reviews) * [დაყენება](https://ka.wordpress.org/plugins/ninjadb/#installation) * [დეველოპმენტი](https://ka.wordpress.org/plugins/ninjadb/#developers) [მხარდაჭერა](https://wordpress.org/support/plugin/ninjadb/) ## აღწერა A lightweight, expressive query builder for WordPress. NInjaDB use the same `$wbdp` instance and methods, It will help you to write $wpdb queries easily and expressively. At least PHP 5.3 is required. It has some advanced features like: – Query Like Laravel Basic Queries – Where, orWhere methods – Search data in all the columns or specific columns – Easily Implement Pagination – use insert, update or delete methods expressively. The syntax is quite similar to Laravel’s query builder. **Simple Query:** The query below returns the row where id = 3, null if no rows. ``` $row = ninjaDB('my_table')->find(3); ``` **Full Queries:** ``` $query = ninjaDB('my_table')->where('post_author', '=', 1); // for equal you can just use where('post_author, 1); // Get result as array of objects $query->get(); ``` ### Full Usage API ### Initiate ``` // Select a table $query = ninjaDB()->table('post'); // post is the table name without prefix; ``` **OR You can pass your table name as an argument** ``` // Select a table $query = ninjaDB('my_table'); // post is the table name without prefix;

Query

``` ### Get Easily The query below returns the (first) row where id = 3, null if no rows. ``` $row = ninjaDB('my_table')->find(3); ``` Access your row like, `echo $row->name`. If your field name is not `id` then pass the field name as second parameter `ninjaDB('my_table')->find(3, 'author_id');`. The query below returns the all rows as array of objects where author_id = 3, null if no rows. ``` $result = ninjaDB('my_table')->findAll('author_id', 3); ``` ### Select ``` $query = ninjaDB('my_table')->select('*'); ``` #### Multiple Selects ``` ->select(array('myfield1', 'myfield2', 'amyfield3')); ``` Using select method multiple times `select('a')->select('b')` will also select ` a` and `b`. Can be useful if you want to do conditional selects (within a PHP `if`). #### Get All Return an array of objects. ``` $query = ninjaDB('my_table')->where('author_id', 1); $result = $query->get(); ``` You can loop through it like: ``` foreach ($result as $row) { echo $row->name; } ``` #### Get First Row ``` $query = ninjaDB('my_table')->where('author_id', 1); $row = $query->first(); ``` Returns the first row, or null if there is no record. Using this method you can also make sure if a record exists. Access these like `echo $row->name`. #### Get Rows Count, MAX, MIN, AVerage, SUM ``` $query = ninjaDB('my_table')->where('author_id', 1); $count = $query->count(); $max = $query->max('views'); // Where `views` is the column name 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, value)`, if you give two parameters then ` =` operator is assumed. So `where('name', 'jewel')` and `where('name', '=', 'jewel')` is the same. ``` ninjaDB('my_table') ->where('name', '=', 'jewel') ->whereNot('age', '>', 25) ->orWhere('description', 'LIKE', '%query%'); ``` ### whereIn ``` ninjaDB('my_table') ->whereIn( 'id', array(1,2,3) ) ->get(); ``` ### Limit and Offset ``` ->limit(30); ->offset(10); // or you can use aliases ->take(30); ->skip(10); ``` ### Order By ``` ->orderBy('id', 'ASC'); ``` ### Insert ``` $data = array( 'name' => 'Jewel', 'description' => 'Hello, There' ); $insertId = ninjaDB('my_table')->insert($data); insert() method returns the insert id. optionally you can pass $format of your data as `->insert($data, $format);` where `$format` is an array of formats to be mapped to each of the value in $data ``` #### Batch Insert ``` $data = array( array( 'name' => 'Jewel', 'description' => 'Hello, There' ), array( 'name' => 'Adre', 'description' => 'Hello, I am Adre Astrian' ), ); $insertIds = ninjaDB('my_table')->batch_insert($data); ``` In case of batch insert, it will return an array of insert ids. ### Update ``` $data = array( 'name' => 'Shahjahan Jewel', 'description' => 'Hello, There' ); ninjaDB('my_table')->where('id', 5)->update($data); ``` Will update the name field to `Shahjahan Jewel` and description field to `Hello, There` where `id = 5`. ### Delete ``` ninjaDB('my_table')->where('id', '>', 5)->delete(); ``` Will delete all the rows where id is greater than 5. If you find any typo or extend any functionality then please edit and send a pull request. ### TODO * [ ] join() * [x] whereIN() * [ ] whereNotIN() * [ ] whereBetween * [ ] whereNotBetween * [ ] Having * [ ] GroupBy * [x] selectDistinct _If you would like to implement any of the TODO please feel free to do and do a pull request_ And, finally, consider to contribute to this plugin [here](https://github.com/WpManageNinja/NinjaDB). ## დაყენება In the search field type “NinjaDB” and click Search Plugins. Once you’ve found this plugin you can view details about it such as the point release, rating and description. Most importantly of course, you can install it by simply clicking “Install Now”. ## ხდკ Installation Instructions In the search field type “NinjaDB” and click Search Plugins. Once you’ve found this plugin you can view details about it such as the point release, rating and description. Most importantly of course, you can install it by simply clicking “Install Now”. Where can I find documentation and user guides? For Expressive Documentation please [follow github repo](https://github.com/WpManageNinja/NinjaDB) ## მიმოხილვები There are no reviews for this plugin. ## მონაწილეები & დეველოპერები “NinjaDB” ღია პროგრამული უზრუნველყოფაა. შემდეგმა ადამიანებმა წვილი შეიტანეს მის განვითარებაში. მონაწილეები * [ Shahjahan Jewel ](https://profiles.wordpress.org/techjewel/) * [ Mahmudul Hasan Arif ](https://profiles.wordpress.org/adreastrian/) [გადათარგმნეთ NinjaDB თქვენს ენაზე.](https://translate.wordpress.org/projects/wp-plugins/ninjadb) ### დაინტერესებული ხართ დეველოპმენტით? [დაათვალიერეთ კოდი](https://plugins.trac.wordpress.org/browser/ninjadb/), შეამოწმეთ [SVN რეპო](https://plugins.svn.wordpress.org/ninjadb/), ან გამოიწერეთ [შექმნის ჟურნალი](https://plugins.trac.wordpress.org/log/ninjadb/): [RSS](https://plugins.trac.wordpress.org/log/ninjadb/?limit=100&mode=stop_on_copy&format=rss). ## ცვლილებები #### 0.8 – 2017-09-10 * Initial Release ## მეტა * Version **0.8** * Last updated **9 წელი წინ** * Active installations **10-ზე ნაკლები** * WordPress version ** 4.0, ან უფრო მაღალი ** * Tested up to **4.8.28** * Language * [English (US)](https://wordpress.org/plugins/ninjadb/) * [დამატებითი ხედი](https://ka.wordpress.org/plugins/ninjadb/advanced/) ## რეიტინგები No reviews have been submitted yet. [Your review](https://wordpress.org/support/plugin/ninjadb/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/ninjadb/reviews/) ## მონაწილეები * [ Shahjahan Jewel ](https://profiles.wordpress.org/techjewel/) * [ Mahmudul Hasan Arif ](https://profiles.wordpress.org/adreastrian/) ## მხარდაჭერა გაქვთ კომენტარი? გჭირდებათ დახმარება? [მხარდაჭერის ფორუმის ნახვა](https://wordpress.org/support/plugin/ninjadb/) ## შემოწირულობა გსურთ ამ ჩადგმის განვითარების მხარდაჭერა? [ შეწირეთ თანხა ამ ჩადგმას ](https://paypal.me/zalam)