metadata_viewer/config.php at master · bookworm2000/metadata_viewer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<?php

//This file stores the database information

// The old non-PDO way of configuration
// $dbs = array(
//     "test" => array(
// 		"SERVER_NAME" => 'localhost',
//         "DB_NAME" => "shared",
//         "USER" => "elissa_shared",
//         "PWD" => "secret"
// 	)
// );


$path = $_SERVER['DOCUMENT_ROOT'];

// if (strpos($path, 'sharedd')) {

// 	$dbs['shared'] = array(
// 		'db' => 'sharedtest',
// 		'host' => 'fullhostname',
// 		'user' => 'elissat',
// 		'pass' => 'secret',
// 	);


// foreach($dbs as &$db){
// 		$db['conn'] = new PDO(
// 			'mysql:host='.$db['host'].';dbname='.$db['db'].';charset=utf8',
// 			$db['user'],
// 			$db['pass'],
// 			array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")
// 		);
// 		$db['conn']->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// 	}

// }

if (strpos($path, 'sharedd')) {  //this is for using docker

$dbs['shared'] = array(
		'db' => 'shared',
		'host' => 'elissat-dev.ihme.washington.edu',
		'user' => 'elissa_shared',
		'pass' => 'secret',
	);


foreach($dbs as &$db){
		$db['conn'] = new PDO(
			'mysql:host='.$db['host'].';port=3336;dbname='.$db['db'].';charset=utf8',
			$db['user'],
			$db['pass'],
			array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")
		);
		$db['conn']->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}

}


else  {   //this is for using MAMP

$dbs['shared'] = array(
		'db' => 'shared',
		'host' => 'localhost',
		'user' => 'elissa_shared',
		'pass' => 'secret',
	);


foreach($dbs as &$db){
		$db['conn'] = new PDO(
			'mysql:host='.$db['host'].';dbname='.$db['db'].';charset=utf8',
			$db['user'],
			$db['pass'],
			array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")
		);
		$db['conn']->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}

}


?>