Skip to content
Snippets Groups Projects
Select Git revision
  • media-refactor
  • next default protected
  • update-device-seen-on-usage
  • master protected
  • make-send-leave
  • presence
  • chore/format-nix
  • all-the-lints
  • generate-config
  • push-federation-invites-to-appservices
  • unstable-msc4125
  • jonas-test-ci-docker-building-quemu-on-fsinfo-runner
  • askstate
  • recoverbroken
  • Nyaaori/temp-combined-feature-branch
  • Nyaaori/destructive-rocksdb-recovery
  • Nyaaori/full-profile-directory
  • Nyaaori/read-receipt-config-options
  • Nyaaori/private-read-receipts
  • Nyaaori/federation-backfill
  • v0.9.0 protected
  • v0.8.0 protected
  • v0.7.0 protected
  • v0.6.0 protected
  • v0.5.0 protected
  • v0.4.0 protected
  • v0.3.0 protected
  • v0.2.0 protected
28 results

conduit

  • 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)