prepare("SELECT id FROM transit_vehicles WHERE plate=? LIMIT 1"); $chk->execute([$plate]); if ($chk->fetch()) jsonError('Vehicle plate already registered', 409); $transit_con->prepare( "INSERT INTO transit_vehicles (org_id,plate,make,model,year,color,capacity,vehicle_type,notes) VALUES (?,?,?,?,?,?,?,?,?)" )->execute([ $transit_org_id, $plate, filterRequest('make'), filterRequest('model'), filterRequest('year','int'), filterRequest('color'), $capacity, $vType, filterRequest('notes'), ]); jsonSuccess(['vehicle_id' => (int)$transit_con->lastInsertId()], 'Vehicle added');