?>
<?php
require_once "menu.php";
?>
<?php
require_once "functions.php";
require_once "edit_functions.php";
if (isset($_POST["update"])) {
updateCars($_POST["id"], $_POST["year"], $_POST["make"], $_POST["model"], $_POST["horsepower"], $_POST["topspeed"], $_POST["transmission"]);
}
if (isset($_GET["delete"])) {
deleteCars($_GET["delete"]);
}
$car_list = getCarsData();
?>
<table border=1 >
<tr>
<th>id</th>
<th>User ID</th>
<th>Year</th>
<th>Make</th>
<th>Model</th>
<th>Horsepower</th>
<th>Topspeed</th>
<th>Transmission</th>
<th>X</th>
<th>edit</th>
</tr>
$stmt->execute();
$array = array();
while ($stmt->fetch()) {
$cars = new StdClass();
$cars->id = $id;
$cars->year = $year;
$cars->user_id = $user_id;
$cars->make = $make;
$cars->model = $model;
$cars->horsepower = $horsepower;
$cars->topspeed = $topspeed;
$cars->transmission = $transmission;
array_push($array, $cars);
}
$stmt->close();
$mysqli->close();
return $array;
}
function deleteCars($id_to_be_deleted)
{
$mysqli = new mysqli($GLOBALS["servername"], $GLOBALS["server_username"], $GLOBALS["server_password"], $GLOBALS["database"]);
$stmt = $mysqli->prepare("UPDATE CarData SET deleted=NOW() WHERE id=?");
$stmt->bind_param("i", $id_to_be_deleted);
if ($stmt->execute()) {
header("Location: table.php");
}
$stmt->close();
$mysqli->close();
}
getCarsData();
