PHP code example of bringittocode / mop

1. Go to this page and download the library: Download bringittocode/mop library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

bringittocode / mop example snippets


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

    // 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