- header: documentation ( source)
<?php
require_once "src/init.php";
include('src/connect.php');
$user = new User();
if ($user->isLoggedIn()) {
$u = $user->getData();
}
// new data
$id = $_POST['memids'];
$truck_no = $_POST['truck_no'];
$vin = $_POST['vin'];
$plate = $_POST['plate'];
$trk_status = $_POST['status'];
// query
$sql = "UPDATE truck
SET truck_no=?, vin=?, plate=?, trk_status=?, user_id=?
WHERE id=?";
$q = $db->prepare($sql);
$q->execute(array($truck_no,$vin,$plate,$trk_status,$u->username,$id));
header("Location: truck.php");
exit;
?>