Show sourcecode
The following files exists in this folder. Click to view.
webbserverprogrammering/exercises/ovn_db/ovn_db3/
db/
garage.php
show_tables.php
show_tables_b.php
show_tables_c.php
show_tables_e.php
show_tables_b.php
121 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Garage</title>
</head>
<body>
<?php
require __DIR__ . '/../../../dbconnect.php';
$stmt = $dbconn->prepare("SELECT * FROM garage");
$stmt->execute();
?>
Hittade följande data i tabellen garage:
<table>
<tr>
<td>Index</td>
<td>Namn</td>
</tr>
<?php
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
?>
<tr>
<td><?php echo $res["garageid"]; ?></td>
<td><?php echo $res["name"]; ?></td>
</tr>
<?php
}
?>
</table>
<?php
$stmt = $dbconn->prepare("SELECT * FROM owner ORDER BY name");
$stmt->execute();
?>
Hittade följande data i tabellen owner:
<table>
<tr>
<td>Index</td>
<td>Namn</td>
</tr>
<?php
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
?>
<tr>
<td><?php echo $res["ownerid"]; ?></td>
<td><?php echo $res["name"]; ?></td>
</tr>
<?php
}
?>
</table>
<?php
$stmt = $dbconn->prepare("
SELECT
c.carid,
c.regnr,
c.color,
g.name AS garage_name,
o.name AS owner_name
FROM car AS c
INNER JOIN garage AS g ON c.garage = g.garageid
INNER JOIN owner AS o ON c.owner = o.ownerid
");
$stmt->execute();
?>
Hittade följande data i tabellen car:
<table>
<tr>
<td>Index</td>
<td>Reg.nummer</td>
<td>Färg</td>
<td>Garage-id</td>
<td>Owner-id</td>
</tr>
<?php
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
print_r($res);
?>
<tr>
<td><?php echo $res["carid"]; ?></td>
<td><?php echo $res["regnr"]; ?></td>
<td><?php echo $res["color"]; ?></td>
<td><?php echo $res["garage_name"]; ?></td>
<td><?php echo $res["owner_name"]; ?></td>
</tr>
<?php
}
?>
</table>
</body>
</html>