jBEexF0H

1<?php
2require_once 'KLogger.php';
3require_once 'dbconfig.php';
4
5//protected $logger = logger;
6//  public function __construct () {
7//  $this->logger = new 
8KLogger('/Users/rluth/OneDrive/Documents/GitHub/Website', KLogger::DEBUG);
9//  }
10
11try {
12//    $this->logger->logDebug("Established a database connection.");
13    $dsn = "mysql:host = $host;dbname=$db";
14    echo "gonna try to connect <br>";
15//  echo "host " . $host . "<br> db " . $db . "<br> username " . $username . "<br> password " . $password . "<br>";
16    $dbn = new PDO($dsn, $username, $password);
17    echo "connectoin succesful";
18    $dbn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
19    echo "connectoin succesful";
20
21/*  $sql_create_users_tbl = 
22    "CREATE TABLE IF NOT EXISTS Users (
23        id INT (6) UNSIGNED AUTO_INCREMENT,
24        display_name VARCHAR (30) NOT NULL,
25        email VARCHAR (50) NOT NULL,
26        password CHAR(41) NOT NULL,
27        PRIMARY KEY (id),
28        UNIQUE INDEX (email),
29        access INT(1),
30        reg_date TIMESTAMP
31    ) ENGINE = InnoDB";
32
33    $sql_create_userinfo_tbl = 
34    "CREATE TABLE IF DOES NOT EXIST UserInfo (
35        id INT NOT NULL,
36        firstname VARCHAR (30) NOT NULL,
37        lastname VARCHAR (30) NOT NULL,
38        age INT (3) NOT NULL,
39        weight INT (3) NOT NULL,
40        bodytype CHAR NOT NULL,
41        PRIMARY KEY(id)
42    )";
43
44    $msg = '';
45
46    $r = $dbh->exec(sql_create_users_tbl);
47
48    if($r !== false){
49
50        $r = $dbh->exec(sql_create_userinfo_tbl);
51
52        if($r !== false){
53            $msg = "Tables are created successfully!<br/>";
54        }else{
55            $msg = "Error creating the userinfo table.<br/>";
56        }
57
58    }else{
59        $msg = "error in creating  user table.<br/>";
60    }
61
62    if($msg !='')
63        echo $msg;
64    */
65}
66catch (Exception $e) {
67    echo "connection failed: " . $e->getMessage();
68//  $this->logger->logFatal("The database connection failed.");
69}
70?>