Example #1
0
<?php

include "../../app/conf/Connection.php";
include "../../app/inc/Model.php";
include "../../app/models/Database.php";
include "../../app/models/Dbchecks.php";
include "sqls.php";
\app\conf\Connection::$param["postgisdb"] = $_REQUEST['db'];
$conn = new \app\inc\Model();
try {
    $conn->connect();
} catch (Exception $e) {
    echo $e->getMessage() . "\n";
    die;
}
$conn->begin();
//Try to drop schema
/*
$result = $conn->execQuery("DROP SCHEMA settings CASCADE","PDO","transaction");
if (!$conn->PDOerror[0]) {
	echo "Schema dropped<br/>";
}
else {
	echo "Something went wrong; {$conn->PDOerror[0]}";
	$conn->rollback();
}
*/
//Try to create schema
$result = $conn->execQuery($sqls['schema'], "PDO", "transaction");
if (!$conn->PDOerror[0]) {
    echo "Schema created<br/>";