PApp::SQL 1.02

PApp::SQL is an absolutely easy yet fast and powerful sql access.

SYNOPSIS

use PApp::SQL;

my $st = sql_exec $DBH, "select ... where a = ?", $a;

local $DBH = ;
my $st = sql_exec my($bind_a, $bind_b), "select a,b ...";
my $st = sql_insertid
sql_exec "insert into ... values (?, ?)", $v1, $v2;
my $a = sql_fetch "select a from ...";
sql_fetch my($a, $b), "select a,b ...";

sql_exists "table where name like a%"
or die "a* required but not existent";

my $db = new PApp::SQL::Database "", "DBI:mysql:test", "user", "pass";
local $PApp::SQL::DBH = $db->checked_dbh; # does ping

sql_exec $db->dbh, "select ...";