php/mysql0.php

<?php
require_once('env.php');

outBegin();
$wTest = true;
$pa = realpath(envScript());
errHHact();
if (strpos($pa, '/wkData/www') === 0) {
    $my = 'wk13';
    $dbL = new PDO('mysql:host=localhost;dbname=test', 'test', 'test');
    outH("connected from $my to mysql:host=localhost;dbname=test, user test");
} elseif (strpos($pa, '/ch45859/web/wlkl.ch') !== false) {
    $my = 'wlkl.ch';
    if ($wTest) {
        $dbL = new PDO('mysql:host=localhost;dbname=ch45859_test', 'ch45859_test', 'tesT+123');
        outH("connected from $my to mysql:host=localhost;dbname=ch45859_test, user ch45859_test");
    } else {
        $dbL = new PDO('mysql:host=localhost;dbname=ch45859_solar', 'ch45859_solar', 'ralo$20S');
        outH("connected from $my to mysql:host=localhost;dbname=ch45859_solar, user ch45859_solar");
    }
} else {
 err("unsupported path $pa");
}
 
out("dbL", $dbL, print_r($dbL, true), 'info', $dbL->getAttribute(PDO::ATTR_SERVER_INFO));
$dbL->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

foreach($dbL->query('SELECT VERSION()', PDO::FETCH_ASSOC) as $row) {
    out('version', $row);
}

foreach($dbL->query('show databases', PDO::FETCH_ASSOC) as $row) {
    out('db', $row);
}

foreach($dbL->query('SELECT * from txt') as $row) {
    out($row);
}
if ($wTest) {
    $dbR = new PDO('mysql:host=wlkl.ch;dbname=ch45859_test', 'ch45859_test', 'tesT+123');
    outH("connected from $my to mysql:host=wlkl.ch;dbname=ch45859_test, user ch45859_test");
} else {
    $dbR = new PDO('mysql:host=wlkl.ch;dbname=ch45859_solar', 'ch45859_solar', 'ralo$20S');
    outH("connected from $my to mysql:host=wlkl.ch;dbname=ch45859_solar, user ch45859_solar");
} 

$dbR->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$c = 0;
out("autocommit is default, to change either change attribute or beginTransaction");
out("warning tables with engine MyIsam cannot not do transactions! uns InnnoDB instead!");
if (0)
    $dbR->setAttribute(PDO::ATTR_AUTOCOMMIT, 0);
if (1) {
    $dbR->beginTransaction(); 
    out("after beginTransaction autocommit", $dbR->getAttribute(PDO::ATTR_AUTOCOMMIT));
} else {
    out("without beginTransaction autocommit", $dbR->getAttribute(PDO::ATTR_AUTOCOMMIT));
}

foreach($dbR->query('SELECT * from hTy', PDO::FETCH_ASSOC) as $row) {
    out($row);
    $c++;
}
if ($c < 7) {
    $r = $dbR->exec("insert into hTy (t, i) values('inserted from php', $c)");
    out("inserted $r - old c=$c");
} else {
    $r = $dbR->exec("delete from hTy");
    out("deleted $r - old c=$c");
}
#    $r = $dbR->rollBack();

if (1) {
    $dbR->commit();
    out('commit');
} else {
    out("disconnect without commit implies rollback!");
}
foreach($dbR->query("SELECT * from  INFORMATION_SCHEMA.TABLES where TABLE_NAME like 'hT%'", PDO::FETCH_ASSOC) as $row) 
    out($row);
outEnd(__file__);
?>