part-system/OurDatabase.php at master · netmaster296/part-system · 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
<?php

/**
 * @author Undergraduate Group One
 * Boundary class to Product Database
 */

class OurDatabase
{
  private $dsn, $username, $password, $pdo;

  //returns all rows in the Legacy Product Database
  public function accessDatabase($query)
  {
    $dsn = "mysql:host=courses;dbname=z1808910";
    $username = "z1808910";
    $password = "1994Aug19";

    try
    {
      $pdo = new PDO($dsn, $username, $password);
    }//end of try

    catch(PDOexception $e) {
      echo $e->getMessage();
    }//end of catch


    //$query = "SELECT * FROM parts;";
    $sql = $pdo->query($query);
    $rows = $sql->fetchAll();

    return $rows;
  }//end of accessDatabase

    //returns all rows in the Legacy Product Database
  public function removeFromDatabase($query)
  {
    $dsn = "mysql:host=courses;dbname=z1808910";
    $username = "z1808910";
    $password = "1994Aug19";

    try
    {
      $pdo = new PDO($dsn, $username, $password);
    }//end of try

    catch(PDOexception $e) {
      echo $e->getMessage();
    }//end of catch


    //$query = "SELECT * FROM parts;";
    $sql = $pdo->query($query);
  }//end of removeFromDatabase
}
?>