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.

• PHP >= 7

• MYSQLI
• PDO

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
• Reference
• Video

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.

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.