SQLite3 DBE Driver

DOCUMENTATION

• NAME
• SYNOPSIS
• EXAMPLE
• DESCRIPTION
• CONNECT
• LIMITATIONS
• AUTHORS
• COPYRIGHT

NAME

SYNOPSIS

  use DBE;
  
  $dsn = "Provider=SQLite3;Db=test.db;Charset=utf-8";
  $con = DBE->connect( $dsn );
  
  $res = $con->query( 'SELECT * FROM table' );
      or
  $stmt = $con->prepare( 'SELECT * FROM table' );
  $res = $stmt->execute();
      or
  $con->prepare( 'SELECT * FROM table' );
  $res = $con->execute();

EXAMPLE

  use DBE;
  
  # connect with parameters as hash
  $con = DBE->connect(
      'provider' => 'SQLite3',
      'db' => 'test.db',
      'charset' => 'utf-8',
  );
  
  # create a table
  $con->do(
      qq/
      CREATE TABLE CFG_Config (
          CFG_Index INTEGER PRIMARY KEY,
          CFG_Name TEXT,
          CFG_Value TEXT,
          UNIQUE (CFG_Name)
      )
      /
  );
  
  # insert an entry
  $con->do( "INSERT INTO CFG_Config (CFG_Name,CFG_Value) VALUES('foo','bar')" );
  # or with placeholders
  # $con->do(
  #     "INSERT INTO CFG_Config (CFG_Name,CFG_Value) VALUES(?,?)",
  #     'foo', 'bar'
  # );
  
  # select the entry
  $res = $con->query(
      "SELECT CFG_Value FROM CFG_Config WHERE CFG_Name = 'foo'"
  );
  # or with placeholders
  # $res = $con->query(
  #     "SELECT CFG_Value FROM CFG_Config WHERE CFG_Name = ?",
  #     'foo'
  # );
  
  ($foo) = $res->fetch_row();
  print "\$foo = '$foo'\n";
  
  # output:
  # $foo = 'bar'

DESCRIPTION

CONNECT

  use DBE;
  
  DBE->connect( 'Provider=SQLite3;Database=sqlite3.db' );

• PROVIDER [SQLite3]
  Provider must be "SQLite3".

• DB | DATABASE [dbname]
  Name of the database to connect to.

LIMITATIONS

AUTHORS

COPYRIGHT