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
insert.php
142 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142
<?php
session_start();
?>
<!-- insertpost.php -->
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Insert</title>
</head>
<body>
<?php
include('dbconnection.php');
$message = null;
if (isset($_POST['regnr']) && !empty($_POST['regnr']) && isset($_POST['color']) && !empty($_POST['color']) && isset($_POST['ownerid']) && !empty($_POST['ownerid']) && isset($_POST['garageid']) && !empty($_POST['garageid'])) {
$regnr = $_POST['regnr'];
$color = $_POST['color'];
$ownerid = $_POST['ownerid'];
$garageid = $_POST['garageid'];
try {
# prepare
$sql = "INSERT INTO car (regnr, color, owner, garage)
VALUES (?, ?, ?, ?)";
$stmt = $dbconn->prepare($sql);
# the data we want to insert
$data = array($regnr, $color, $ownerid, $garageid);
# execute width array-parameter
$stmt->execute($data);
echo "New record created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
}
elseif (isset($_POST['name']) && !empty($_POST['name'])) {
$namn = $_POST['name'];
try {
# prepare
$sql = "INSERT INTO owner (name)
VALUES (?)";
$stmt = $dbconn->prepare($sql);
# the data we want to insert
$data = array($namn);
# execute width array-parameter
$stmt->execute($data);
echo "New record created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
}
elseif (isset($_POST['garagename']) && !empty($_POST['garagename'])) {
$garagename = $_POST['garagename'];
try {
# prepare
$sql = "INSERT INTO garage (name)
VALUES (?)";
$stmt = $dbconn->prepare($sql);
# the data we want to insert
$data = array($garagename);
# execute width array-parameter
$stmt->execute($data);
echo "New record created successfully";
}
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
}
else {
$message .= "<br/>Du kan bara fylla i en tabell i taget<br/><br />";
}
echo $message;
?>
<form method="post" action="">
<table>
<tr><td><strong>Lägg till ägare</strong></td><td></td></tr>
<tr>
<td>Namn:</td>
<td><input type="text" name="name" size=20 maxlength=15></td>
</tr>
<tr><td><strong>Lägg till Garage</strong></td><td></td></tr>
<tr>
<td>Garagenamn:</td>
<td><input type="text" name="garagename" size=20 maxlength=15></td>
</tr>
<tr><td><strong>Lägg till Bil</strong></td><td></td></tr>
<tr>
<td>RegNr:</td>
<td><input type="text" name="regnr" size=20 maxlength=30></td>
</tr>
<tr>
<td>Färg:</td>
<td><input type="text" name="color" size=20 maxlength=20></td>
</tr>
<tr>
<td>Ägar ID:</td>
<td><select name="ownerid">
<?php
$sql = "SELECT * FROM owner ORDER BY name ASC";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo "<option value=".$res['ownerid']."> ".$res['name']." </option>";
}
?>
</select>
</td>
</tr>
<tr>
<td>Garage ID:</td>
<td><select name="garageid">
<?php
$sql = "SELECT * FROM garage ORDER BY name ASC";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo "<option value=".$res['garageid']."> ".$res['name']." </option>";
}
?>
</select></td>
</tr>
<tr>
<td></td>
<td><button type="submit">Lägg till</button></td></tr>
</table>
</form>
<button onclick="window.location.href='../garage'">Meny</button>
</body>
</html>