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 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 | <?php define('__ROOT__', dirname(__FILE__)); // Set default timezone date_default_timezone_set('UTC'); try { /************************************** * Create databases and * * open connections * **************************************/ // Create (connect to) SQLite database in file $db = new PDO('sqlite:'.__ROOT__.'/data/dcaas.sqlite3'); // Set errormode to exceptions $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $e) { // Print PDOException message echo $e->getMessage(); } function includeHeader($title) { ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="description" content=""> <meta name="author" content=""> <link rel="shortcut icon" href="../../docs-assets/ico/favicon.png"> <title>Starter Template for Bootstrap</title> <!-- Bootstrap core CSS --> <link href="js/dynatable/jquery.dynatable.css" rel="stylesheet"> <link href="css/bootstrap.css" rel="stylesheet"> <!-- Custom styles for this template <link href="starter-template.css" rel="stylesheet">--> <!-- Just for debugging purposes. Don't actually copy this line! --> <!--[if lt IE 9]> <script src="../../docs-assets/js/ie8-responsive-file-warning.js"></script><![endif]--> <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script> <script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script> <![endif]--> </head> <body> <div class="navbar navbar-inverse navbar-fixed-top" role="navigation"> <div class="container"> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a class="navbar-brand" href="#">Project name</a> </div> <div class="collapse navbar-collapse"> <ul class="nav navbar-nav"> <li class="active"><a href="#">Home</a></li> <li><a href="#about">About</a></li> <li><a href="#contact">Contact</a></li> </ul> </div> <!--/.nav-collapse --> </div> </div> <div class="container"> <br/> <br/> <br/> <?php } function includeFooter() { global $db; try { /************************************** * Close db connections * **************************************/ // Close file db connection $db = null; } catch(PDOException $e) { // Print PDOException message echo $e->getMessage(); } ?> </div> <!-- /.container --> </body> </html> <?php } |