mop Code
( WEBSITE VERSION ) MOP is a php query handling and manipulation LIB.
Brought to you by:
bringittocode
Menu
▾
▴
Tree [d072aa] main v1.0.0 / History
| File | Date | Author | Commit |
|---|---|---|---|
| .github | 2021-08-27 |
Hazeezet
|
[40bc09] Update issue templates |
| src | 2021-11-05 |
Bringittocode
|
[865f97] Version 1.0.0 |
| CODE_OF_CONDUCT.md | 2021-08-27 |
Hazeezet
|
[15fd55] Create CODE_OF_CONDUCT.md |
| CONTRIBUTING.md | 2021-08-27 |
Hazeezet
|
[a1882b] Create CONTRIBUTING.md |
| LICENSE | 2021-08-24 |
Hazeezet
|
[3665dc] Initial commit |
| README.md | 2021-11-18 |
Hazeezet
|
[d072aa] Update README.md |
| _config.yml | 2021-09-26 |
Hazeezet
|
[d9c2c3] Set theme jekyll-theme-midnight |
| changelog.md | 2021-11-05 |
Bringittocode
|
[107e8e] Version 1.0.0 |
| composer.json | 2021-11-18 |
hazeezet
|
[2603ea] Version 1.0.0 |
Read Me
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
- PHP >= 7
Supported Query Handler
- MYSQLI
- PDO
Geting Started
you can actually run 4 lines of code and get your result with this library
php
$connect = new mysql\mop($DB_ADDRESS,$DB_USER,$DB_PASS,$DB_NAME);
$connect->query("SELECT .....");
$connect->run();
$connect->get_column('name');
Over All Preview
```php
// 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
Installation
It can be included or required in any php file or download using composer
Composer install
bash 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.
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.
Copyright 2021 Hazeezet
