Permalink
Cannot retrieve contributors at this time
<?php | |
const DB_MYSQL = 0; | |
const DB_POSTGRESQL = 1; | |
const DB_SQLITE3 = 2; | |
// ======== Start of user-configurable variables ======================= | |
// --- set this to use YOUR database type: ------ | |
$dbType = DB_SQLITE3; | |
// if your database is DB_SQLITE3, you need to set the path to your database file: | |
$pathToSQLite = 'sqlite\gpstracker.sqlite'; | |
// ======== End of user-configurable variables ======================= | |
$dbuser = 'gpstracker_user'; | |
$dbpass = 'gpstracker'; | |
$params = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, | |
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC); | |
switch ($dbType) { | |
case DB_MYSQL: | |
$pdo = new PDO('mysql:host=localhost;dbname=gpstracker;charset=utf8', $dbuser, $dbpass, $params); | |
$sqlFunctionCallMethod = 'CALL '; | |
break; | |
case DB_POSTGRESQL: | |
$pdo = new PDO('pgsql:host=localhost;dbname=gpstracker', $dbuser, $dbpass, $params); | |
$sqlFunctionCallMethod = 'select '; | |
break; | |
case DB_SQLITE3: | |
$pdo = new PDO('sqlite:'.$pathToSQLite, $dbuser, $dbpass, $params); | |
$sqlFunctionCallMethod = 'select '; | |
break; | |
} | |
?> |