<?php
require_once "functions.php";
$car_list = getCarData();
?>
<table border= 1>
<tr>
<th>id</th>
<th>user_id</th>
<th>auto nr märk</th>
<th>auto värv</th>
</tr>
<?php
//iga massiivis oleva elemendi kohta
//count($car_list) - massiivi pikkus
for ($i = 0; $i < count($car_list); $i++) {
//$i = $i + 1 == $i =+ 1 ==o $i++
echo "<tr>";
echo "<td>" . $car_list[$i]->id . "</td>";
echo "<td>" . $car_list[$i]->user_id . "</td>";
echo "<td>" . $car_list[$i]->number_plate . "</td>";
echo "<td>" . $car_list[$i]->color . "</td>";
echo "</td>";
}
?>
</table>
<?php
require_once "functions.php";
//kas kustutame
//?delete=vastav id mida kustutada on aadressireal
if (isset($_GET["delete"])) {
echo "kustutame id " . $_GET["delete"];
//käivitan funktsiooni,saadan kaasa id
deleteCar($_GET["delete"]);
}
//salvestan andmebaasi
if (isset($_POST["save"])) {
updateCar($_POST["id"], $_POST["plate_number"], $_POST["color"]);
}
//käivitan funktsiooni
$array_of_cars = getCarData();
//trükin välja esimese auto
//echo $array_of_cars[0]->id." ".$array_of_cars[0]->plate;
?>
<h2>Tabel</h2>
<table>
<tr>
<th>id</th>
<th>Kasutaja id</th>
<th>numbrimärk</th>
<th>Värv</th>
<th>Kustuta</th>
<th>Redigeeri</th>
</tr>
<?php
<?php
require_once "functions.php";
//kas kustutame, ?delete = vastav id mida kustutada on aadressireal
if (isset($_GET["delete"])) {
echo "Kustutame id" . $_GET["delete"];
//käivitan funktsiooni, saadan kaasa id
deleteCar($_GET["delete"]);
}
//salvestan andmebaasi
if (isset($_POST["save"])) {
updateCar($_POST["id"], $_POST["plate_number"], $_POST["color"]);
}
//käivitan funktsiooni
$car_array = getCarData();
//trükin välja esimese auto
//echo $car_array[0]->id." ".$car_array[0]->plate;
?>
<h2>Tabel</h2>
<table border="1">
<tr>
<th>Id</th>
<th>User id</th>
<th>Numbrimärk</th>
<th>Värv</th>
<th>X</th>
<th>Edit</th>
</tr>
<?php
<?php
require_once "functions.php";
//kas kustutame
if (isset($_GET["delete"])) {
echo "Kustutame id" . " " . $_GET["delete"];
// käivitan funktsiooni, saadan kaasa id
deleteCar($_GET["delete"]);
}
//salvestan ab'i
if (isset($_POST["Save"])) {
updateCar($_POST["id"], $_POST["number_plate"], $_POST["color"]);
}
$array = getCarData();
?>
<h2>Tabel</h2>
<table border=1>
<tr>
<th>ID</th>
<th>User ID</th>
<th>Numbrimärk</th>
<th>Värv</th>
<th>Kustuta</th>
<th>Muuda</th>
</tr>
<?php
for ($i = 0; $i < count($array); $i++) {
//kasutaja tahab muuta
if (isset($_GET["edit"]) && $array[$i]->id == $_GET["edit"]) {
echo "<tr>";
$stmt->bind_result($id, $user_id, $number_plate, $color);
$stmt->execute();
$array = array();
while ($stmt->fetch()) {
$car = new StdClass();
$car->id = $id;
$car->number_plate = $number_plate;
$car->user_id = $user_id;
$car->color = $color;
array_push($array, $car);
//echo "<pre>";
//var_dump($array);
//echo "</pre>";
}
$stmt->close();
$mysqli->close();
return $array;
}
function deleteCar($id_to_be_deleted)
{
$mysqli = new mysqli($GLOBALS["servername"], $GLOBALS["server_username"], $GLOBALS["server_password"], $GLOBALS["database"]);
$stmt = $mysqli->prepare("UPDATE car_plates SET deleted=NOW() WHERE id=?");
$stmt->bind_param("i", $id_to_be_deleted);
if ($stmt->execute()) {
header("Location: table.php");
}
$stmt->close();
$mysqli->close();
}
getCarData();
