Kod formularza:
<!DOCTYPE html>
<html lang="en">
<head>
<title>Formularz</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<div id="container">
<h2>Wszystkie zlecenia</h2>
<table class="table table-bordered">
<thead>
<tr>
<th>Pracownik</th>
<th>Czas</th>
<th>Samochód</th>
<th>Kilometry</th>
<th>Koszt</th>
</tr>
</thead>
<tbody>
<?php
foreach($orders as $order){ ?>
<tr>
<td><?=$order['imie']?> <?=$order['nazwisko']?></td>
<td><?=$order['czas']?></td>
<td><?=$order['marka']?> <?=$order['model']?></td>
<td><?=$order['kilometry']?></td>
</tr>
<?php } ?>
</tbody>
</table>
<h2>Pisanie nowego zlecenie</h2>
<form action="" method="post">
<div class="form-group">
<label class="control-label col-sm-2" for="id_pracownika">Pracownik:</label>
<select name="id_pracownika" id="id_pracownika" class="form-control">
<?php
foreach($pracownik as $pracownik){ ?>
<option value="<?=$pracownik['id_pracownika']?>"><?=$pracownik['imie']." ".$pracownik['nazwisko']?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="czas">Czas:</label>
<div>
<input required type="text" class="form-control" id="czas" name="czas">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="id_samochodu">Samochód:</label>
<select name="id_samochodu" id="id_samochodu" class="form-control">
<?php
foreach($samochod as $samochod){ ?>
<option value="<?=$samochod['id_samochodu']?>"><?=$samochod['marka']." ".$samochod['model']?></option>
<?php } ?>
</select>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="kilometry">Podaj kilometry:</label>
<div>
<input required type="text" class="form-control" id="kilometry" name="kilometry">
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2">
<button type="submit" class="btn btn-danger">Wyślij</button><br />
</div>
</div>
</form>
</div>
</body>
</html>
Kod zapytań bazy:
<?php
class Resources
{
public function getPracownik()
{
$response = false;
try {
$pdo = new ConnectionDatabase();
$db = $pdo->connect();
$query = $db->prepare("SELECT * FROM pracownik");
$query->execute();
$response = $query->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$response = $e;
}
return $response;
}
public function getSamochod()
{
$response = false;
try {
$pdo = new ConnectionDatabase();
$db = $pdo->connect();
$query = $db->prepare("SELECT * FROM samochod");
$query->execute();
$response = $query->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$response = $e;
}
return $response;
}
public function getOrders()
{
$response = false;
try {
$pdo = new ConnectionDatabase();
$db = $pdo->connect();
$query = $db->prepare("SELECT * FROM zlecenie INNER JOIN pracownik ON zlecenie.id_pracownika=pracownik.id_pracownika INNER JOIN samochod ON zlecenie.id_samochodu=samochod.id_samochodu");
$query->execute();
$response = $query->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$response = $e;
}
return $response;
}
public function getOrder($id)
{
$response = false;
try {
$pdo = new ConnectionDatabase();
$db = $pdo->connect();
$query = $db->prepare("SELECT * FROM zlecenie WHERE id_zlecenia = :id");
$query->bindParam(':id', $id);
$query->execute();
$response = $query->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
$response = $e;
}
return $response[0];
}
public function createOrders($id_pracownika, $czas, $id_samochodu, $kilometry, $koszt)
{
$response = false;
try {
$pdo = new ConnectionDatabase();
$db = $pdo->connect();
$query = $db->prepare("INSERT INTO zlecenie (id_pracownika, czas, id_samochodu, kilometry, koszt)
VALUES (:id_pracownika, :czas, :id_samochodu, :kilometry, :koszt)");
$query->bindParam(':id_pracownika', $id_pracownika);
$query->bindParam(':czas', $czas);
$query->bindParam(':id_samochodu', $id_samochodu);
$query->bindParam(':kilometry', $kilometry);
$query->bindParam(':koszt', $koszt);
$query->execute();
$response = true;
} catch (PDOException $e) {
$response = $e;
}
return $response;
}
}