PHPackages                             bringittocode/mop - 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. bringittocode/mop

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

bringittocode/mop
=================

Run MYSQL query faster and get result in a reliable way.

v1.1.0(3y ago)383MITPHPPHP >=7.3.0

Since Nov 18Pushed 3y ago1 watchersCompare

[ Source](https://github.com/Bringittocode/mop)[ Packagist](https://packagist.org/packages/bringittocode/mop)[ Docs](https://github.com/bringittocode/mop)[ RSS](/packages/bringittocode-mop/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (4)DependenciesVersions (5)Used By (0)

[![MOP_logo](https://user-images.githubusercontent.com/52476329/137361314-296884d7-2b98-4069-b753-c20d15ac4c67.png)](https://user-images.githubusercontent.com/52476329/137361314-296884d7-2b98-4069-b753-c20d15ac4c67.png)

[![SourceForge](https://camo.githubusercontent.com/471540932f0652eefe518d75576b38ce2f15cb0eb7953df177d0f728ed88a34d/68747470733a2f2f696d672e736869656c64732e696f2f736f75726365666f7267652f646d2f626974632d6d6f703f636f6c6f723d626c7565267374796c653d666f722d7468652d6261646765)](https://sourceforge.net/projects/bitc-mop/files/latest/download)[![SourceForge](https://camo.githubusercontent.com/f2f977450c59cd437cad66f9cbe466bc776b3ee833a009566b6c257cd59defa0/68747470733a2f2f696d672e736869656c64732e696f2f736f75726365666f7267652f64772f626974632d6d6f703f636f6c6f723d626c7565267374796c653d666f722d7468652d6261646765)](https://sourceforge.net/projects/bitc-mop/files/latest/download)[![SourceForge](https://camo.githubusercontent.com/24f9c70544190a9fcf506a4026ddb0691e9148b854f70618d64cb0409524e800/68747470733a2f2f696d672e736869656c64732e696f2f736f75726365666f7267652f64742f626974632d6d6f703f636f6c6f723d626c7565267374796c653d666f722d7468652d6261646765)](https://sourceforge.net/projects/bitc-mop/files/latest/download)

[![Packagist License](https://camo.githubusercontent.com/2ec727adace0a586b941d50a68e9ae29f67ec5ca78b7f0762282209694f8c4d2/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f6c2f6272696e676974746f636f64652f6d6f703f636f6c6f723d626c7565267374796c653d666f722d7468652d6261646765)](https://github.com/Bringittocode/mop/blob/main/LICENSE)

[![GitHub release (latest by date including pre-releases)](https://camo.githubusercontent.com/05a8458dd55ece41c3683af68fd86101563da8922185c8dae8d7f625a824c7e6/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f762f72656c656173652f6272696e676974746f636f64652f6d6f703f696e636c7564655f70726572656c6561736573267374796c653d666f722d7468652d6261646765)](https://sourceforge.net/projects/bitc-mop/files/latest/download)

[![GitHub forks](https://camo.githubusercontent.com/dd00fe07c39b2df8d65b710cfb19f52e1c2097edb8407de803f6aa53cb024bc7/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f666f726b732f6272696e676974746f636f64652f6d6f703f7374796c653d666f722d7468652d6261646765)](https://camo.githubusercontent.com/dd00fe07c39b2df8d65b710cfb19f52e1c2097edb8407de803f6aa53cb024bc7/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f666f726b732f6272696e676974746f636f64652f6d6f703f7374796c653d666f722d7468652d6261646765)[![GitHub Repo stars](https://camo.githubusercontent.com/fd80a11edd63f34d588c260b8da253b8b33cb33b54d005f6d3bcc91146301741/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f73746172732f6272696e676974746f636f64652f6d6f703f7374796c653d666f722d7468652d6261646765)](https://camo.githubusercontent.com/fd80a11edd63f34d588c260b8da253b8b33cb33b54d005f6d3bcc91146301741/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f73746172732f6272696e676974746f636f64652f6d6f703f7374796c653d666f722d7468652d6261646765)

Mysql Optimizer
===============

[](#mysql-optimizer)

mysql optimizer also known as **MOP** is a **php query handling and manipulation** library providing easy and reliable way to manipulate query and get result in a fastest way.

Recomended Requirement
----------------------

[](#recomended-requirement)

- PHP >= 7

Supported Query Handler
-----------------------

[](#supported-query-handler)

- MYSQLI
- PDO

Geting Started
--------------

[](#geting-started)

you can actually run 4 lines of code and get your result with this library

```
$connect = new Mysql\mop($DB_ADDRESS,$DB_USER,$DB_PASS,$DB_NAME);
$connect->query("SELECT .....");
$connect->run();
$connect->get_column('name');
```

**Over All Preview**

```
  // SIMPLE PREVIEW

  // connect
  $firstconnection = new Mysql\mop($DB_ADDRESS,$DB_USER,$DB_PASS,$DB_NAME);

  // query
  $query = "SELECT ....";
  $firstconnection->query($query);

  // Run query
  $firstconnection->run();

  // Get all column result as csv
  $firstconnection->csv;

  // Get column by name
  $firstconnection->get_column('columnname');

  // Get column by index
  $firstconnection->get_column(0);

  // Get number of affected or selected rows
  $firstconnection->num_of_rows;

  // IS THAT ALL? NO IS MORE THAN THAT
  // CHECK DOCUMENTATION FOR MORE

```

Documentation
-------------

[](#documentation)

- [Documentation](https://github.com/Bringittocode/mop/wiki)
- [Reference](https://github.com/Bringittocode/mop/wiki/reference)
- [Video](https://youtube.com/playlist?list=PLJPXjarj_PAq1zGQpT8gOYqedDLsrjq9C)

Installation
------------

[](#installation)

It can be **included** or **required** in any php file or download using composer

> Composer install

```
composer require bringittocode/mop
```

> Manual install

download both files in src folder and place them anywhere in your folder directory then **include** or **reqiure** mop.php file.

IF YOU GET UNKNOWN ERROR WITH THIS LIBRARY ON YOUR WEB SERVER...... YOU HAVE TO TRY THIS.

[![mop_error](https://user-images.githubusercontent.com/52476329/133803606-93310987-82cb-464f-8186-d4bab7c9667c.png)](https://user-images.githubusercontent.com/52476329/133803606-93310987-82cb-464f-8186-d4bab7c9667c.png)

Go to your cpanel, find change php version and click on it, when the page fullly loaded, first of all make sure you are using php >= 7. Then uncheck **mysqli** and check **nd\_mysqli** save it and try again with the library , everything should work fine.

**LICENSE**

fork and feel free to pull request....

MOP is licensed under the [MIT License](http://opensource.org/licenses/MIT).

###  Health Score

24

—

LowBetter than 32% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity10

Limited adoption so far

Community11

Small or concentrated contributor base

Maturity48

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 98.3% 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

Every ~133 days

Total

4

Last Release

1240d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/de0be89ed96b4ceb411dfb969e35c3cdd59c19a84a969815d10fc92e2192265e?d=identicon)[bringittocode](/maintainers/bringittocode)

---

Top Contributors

[![hazeezet](https://avatars.githubusercontent.com/u/52476329?v=4)](https://github.com/hazeezet "hazeezet (59 commits)")[![peter279k](https://avatars.githubusercontent.com/u/9021747?v=4)](https://github.com/peter279k "peter279k (1 commits)")

---

Tags

mopmysqlmysql-databasephpdatabasemysqlpdoquerymysqlimop

### Embed Badge

![Health badge](/badges/bringittocode-mop/health.svg)

```
[![Health](https://phpackages.com/badges/bringittocode-mop/health.svg)](https://phpackages.com/packages/bringittocode-mop)
```

###  Alternatives

[aura/sqlquery

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

4572.9M34](/packages/aura-sqlquery)[envms/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

925511.7k13](/packages/envms-fluentpdo)[fpdo/fluentpdo

FluentPDO is a quick and light PHP library for rapid query building. It features a smart join builder, which automatically creates table joins.

921244.9k7](/packages/fpdo-fluentpdo)[sergeytsalkov/meekrodb

The Simple PHP/MySQL Library

341387.0k10](/packages/sergeytsalkov-meekrodb)[ezsql/ezsql

Advance database access library. Make interacting with a database ridiculously easy. An universal interchangeable CRUD system.

86946.7k](/packages/ezsql-ezsql)[codesvault/howdy-qb

Mysql Query Builder for WordPress

371.2k1](/packages/codesvault-howdy-qb)

PHPackages © 2026

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