Skip to content
Snippets Groups Projects
Select Git revision
  • master default protected
1 result

website

  • Clone with SSH
  • Clone with HTTPS
  • Name Last commit Last update
    ..
    PdoSqlWrapper.php
    README.md
    composer.json

    PdoSqlWrapper


    Simple wrapper for mysql with PDO

    Installation


    composer require komalbarun\pdosqlwrapper

    Dependencies


    • php >= 7.0

    Usage


    <?php
    
    require_once './vendor/autoload.php';
    
    use Komalbarun\PdoSqlWrapper;
    
    //config assoc
    $config = [
        'host' => '',
        'dbname' => '',
        'user' => '',
        'password' => '',
        'charset' => ''
        'port' => ''
    ];
    
    $db = new PdoSqlWrapper($config);
    
    // no user input fetch
    // $results is a generator object.
    $results = $db->fetch_simple_sql($sql);
    
    // user input fetch (uses prepared statement).
    // $results is a generator object.
    // $data is an array 
    $results = $db->fetch_prepared_sql($sql, $data);
    
    // no user input CUD
    $db->simple_execute_sql($sql);
    
    // User input CUD (uses prepared statement)
    // // $data is an array 
    $db->prepared_execute_sql($sql, $data)
    
    //PDO::fetchAll()
    $db->fetch_simple_sql_all($sql)
    
    //PDO::fetchAll()
    $db->fetch_prepared_sql_all($sql, $data)