Show sourcecode

The following files exists in this folder. Click to view.

webbsrvprg/exercises/databaser/databaser3/

car.php
createtables.php
databaser3.php
databaser3a.php
databaser3b.php
databaser3c.php
databaser3d.php
databaser3e.php
deletetables.php
garage.php
owner.php
start.php

`deletetables.php`

55 lines ASCII Windows (CRLF)

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


<!doctype html>

<html>

<head>

<meta charset="utf-8">

<title>Create</title>

</head>



<body>

<?php

include ('../../../dbconnection.php');

try {



    // sql to delete table

    $sql = "DROP TABLE IF EXISTS car";

    //use exec() because no results are returned

    $dbconn->exec($sql);

    echo "Table deleted successfully";

}

catch(PDOException $e)

    {

    echo $sql . "<br>" . $e->getMessage();

}



try {



    // sql to delete table

    $sql = "DROP TABLE IF EXISTS garage";

    //use exec() because no results are returned

    $dbconn->exec($sql);

    echo "Table deleted successfully";

}

catch(PDOException $e)

    {

    echo $sql . "<br>" . $e->getMessage();

}



try {



    // sql to delete table

    $sql = "DROP TABLE IF EXISTS owner";

    //use exec() because no results are returned

    $dbconn->exec($sql);

    echo "Table deleted successfully";

}

catch(PDOException $e)

    {

    echo $sql . "<br>" . $e->getMessage();

}



//Rensa kopplingen till databasen

$dbconn = null;



?>

</body>

</html>