Webbserverprogrammering 1

Show sourcecode

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

webbserverprogrammering/exercises/mysqlintro/garage/

dbconnection.php
insert.php
select.php
select3d.php
selectOwnerOrder.php
selectSortByG.php

select3d.php

104 lines UTF-8 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
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
<?php 
session_start();
?>
<!-- selectposts.php -->
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Select</title>
<style type="text/css">
    body{
        font-family: arial;
    }
    table{
        width: 200px;
        margin: auto;
        border: 1px black solid;
    }
</style>
</head>

<body>
<?php
include('dbconnection.php');

try {

     //The SQL SELECT statement 
    $sql = "SELECT * FROM owner ORDER BY name ASC";
    $stmt = $dbconn->prepare($sql);

    $data = array();  
    $stmt->execute($data);
    $output = "<table><caption>Användare:</caption><th>OwnerID</th><th>Namn</th>";
    while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $output .= "<tr>".
            "<td>".htmlentities($res['ownerid'])."</td>".
            "<td>".htmlentities($res['name'])."</td>".
        "</tr>";
    }
    $output .= "</table>";
    echo "$output";
}
catch(PDOException $e)
{
    echo $sql . "<br />" . $e->getMessage();
}
try {

     //The SQL SELECT statement 
    $sql = "SELECT c.carid, c.regnr, c.color, g.name AS gar, o.name AS own 
    FROM car AS c
    INNER JOIN garage AS g ON c.garage=g.garageid
    INNER JOIN owner AS o ON c.owner=o.ownerid
    ORDER BY gar ASC, own ASC" ;
    $stmt = $dbconn->prepare($sql);

    $data = array();  
    $stmt->execute($data);


    $output = "<table><caption>Registrerade bilar:</caption>
    <th>Bil ID</th>
    <th>RegNr</th>
    <th>Färg</th>
    <th>Garage</th>
    <th>Owner</th>";
    while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
        /*$g = $res["garage"];
        $sql2 = "SELECT garage.name FROM garage WHERE garageid=$g";
        $stmt2 = $dbconn->prepare($sql2);
        $data2 = array();  
        $stmt2->execute($data2);  
        $res2 = $stmt2->fetch(PDO::FETCH_ASSOC); 
        $o = $res["owner"];
        $sql3 = "SELECT owner.name FROM owner WHERE ownerid=$o";
        $stmt3 = $dbconn->prepare($sql3);
        $data3 = array();  
        $stmt3->execute($data3);  
        $res3 = $stmt3->fetch(PDO::FETCH_ASSOC);   */     


        $output .= "<tr>".
            "<td>".htmlentities($res['carid'])."</td>".
            "<td>".htmlentities($res['regnr'])."</td>".
            "<td>".htmlentities($res['color'])."</td>".
            "<td>".htmlentities($res['gar'])."</td>".
            "<td>".htmlentities($res['own'])."</td>".
        "</tr>";
    }
    $output .= "</table>";
    echo "$output";
}
catch(PDOException $e)
{
    echo $sql . "<br />" . $e->getMessage();
}

$dbconn = null;

?>
<button onclick="window.location.href='../garage'">Meny</button>
</body>
</html>