Lab 03
Adding New Records to the Database

Expanding CRUD Capabilities — Fleet Management

Implementation of the "Create" functionality, allowing users to seed the system with vehicle and fuel data. This version introduces Bootstrap modals for input, providing a clean, distraction-free data entry experience.

System Data Flow

Phase Operation Technical Detail
1. Input User triggers an "Add" modal via data-bs-target. Bootstrap 5.3 Modals
2. Request Form submits via POST back to the current view. HTTP Form Handling
3. Orchestration addHandlers() identifies the action and requires the controller. Controller Routing
4. Execution The controller validates input and executes a PDO prepared statement. Server-Side Logic
5. Feedback An alert is set in session and displayed via the feedback modal. Session Management

Active Dashboard Overview

Click "Add Vehicle" or "Add Fuel" below to test the functional CRUD implementation for this milestone.

VehicleVINLicense TagStateMileageActive
2020 Chevrolet Silverado 1500 (white truck)3GCUYDED0LG123456NOP012SC37800.0Active
2020 Chevrolet Malibu (gray car)1G1ZD5ST0LF123456EFG123SC30100.0Active
2018 Ford F-150 (blue truck)1FTMF1EB8JKE78901XYZ789SC46000.0Active
2019 Ford Transit (white van)1FTYE1Y89KKB12345IJK123SC67300.0Active
2021 Ford Explorer (blue suv)1FMSK8DH7MGB12345ZAB234SC24850.0Active
2019 Ford Fusion (blue car)3FA6P0HD8KR123456HIJ456SC37500.0Active
2022 Honda CBR650R (red motorcycle)JH2RC50A2NM012345MCN456SC3400.0Active
2022 Honda CR-V (silver suv)5J6RW5H5XNL123456WXY901SC9820.0Active
2019 Honda Civic (black car)2HGFC2F69KH123456DEF456SC39000.0Active
2021 Honda Accord (white car)1HGCV1F3XMA456789GHI789SC21500.0Active
2023 Hyundai Elantra (blue car)5NPCF4JE3PH123456PQR678SC3300.0Active
2021 Jeep Grand Cherokee (black suv)1C4RJFBG9MC123456KLM789SC14500.0Active
2020 Kawasaki Ninja 650 (green motorcycle)JKAZX6R16LA123456FGH890SC14350.0Active
2020 Kia Optima (red car)KNAG44A73L5678901STU901SC27000.0Active
2022 Mazda CX-5 (white car)JM3KFACM8N1234567BCD890SC9000.0Active
2019 Nissan Altima (black car)1N4BL4EV8KC123456MNO345SC42700.0Active
2019 Ram 1500 (gray truck)1C6RRFGG8KN123456TUV678SC58200.0Active
2018 Subaru Outback (green car)4S4BSACC2J3123456YZA567SC51800.0Active
2018 Suzuki GSX-R750 (yellow motorcycle)JS1GR7MA8J2101234LMN456SC22000.0Active
2022 Toyota Corolla (gray car)5YFB4RC58NX123456JKL012SC8700.0Active
2023 Toyota RAV4 (red suv)2T3A1RFV8PW123456QRS345SC6800.0Active
2020 Toyota Camry (silver car)4T1BF1FK0LU123456ABC123SC29500.0Active
2021 Volkswagen Jetta (silver car)3VWC57BU5MM123456VWX234SC19000.0Active
2021 Yamaha MT-07 (blue motorcycle)JYARM07A4MA123456CDE567SC8000.0Active
VehicleSourceGallonsCost/GalTotal CostMileageDatePayment
2021 Jeep Grand Cherokee (black suv)Shell12.90$3.721$48.0014500.0Feb 15, 2026Cash
2021 Jeep Grand Cherokee (black suv)Shell12.90$3.721$48.0014500.0Feb 15, 2026Cash
2019 Ford Fusion (blue car)Chevron13.60$3.713$50.503100.0Feb 14, 2026Credit Card
2019 Ford Fusion (blue car)Chevron13.60$3.713$50.503100.0Feb 14, 2026Credit Card
2020 Chevrolet Malibu (gray car)Exxon14.00$3.714$52.0030100.0Feb 13, 2026Fleet Card
2020 Chevrolet Malibu (gray car)Exxon14.00$3.714$52.0030100.0Feb 13, 2026Fleet Card
2022 Mazda CX-5 (white car)BP13.10$3.740$48.999000.0Feb 12, 2026Cash
2022 Mazda CX-5 (white car)BP13.10$3.740$48.999000.0Feb 12, 2026Cash
2018 Subaru Outback (green car)Shell12.70$3.661$46.4951800.0Feb 11, 2026Credit Card
2018 Subaru Outback (green car)Shell12.70$3.661$46.4951800.0Feb 11, 2026Credit Card
2021 Volkswagen Jetta (silver car)Chevron13.60$3.824$52.0119000.0Feb 10, 2026Fleet Card
2021 Volkswagen Jetta (silver car)Chevron13.60$3.824$52.0119000.0Feb 10, 2026Fleet Card
2020 Kia Optima (red car)Exxon13.00$3.769$49.0027000.0Feb 9, 2026Credit Card
2020 Kia Optima (red car)Exxon13.00$3.769$49.0027000.0Feb 9, 2026Credit Card
2023 Hyundai Elantra (blue car)BP13.50$3.778$51.003300.0Feb 8, 2026Cash
2023 Hyundai Elantra (blue car)BP13.50$3.778$51.003300.0Feb 8, 2026Cash
2019 Nissan Altima (black car)Shell12.90$3.760$48.5042700.0Feb 7, 2026Credit Card
2019 Nissan Altima (black car)Shell12.90$3.760$48.5042700.0Feb 7, 2026Credit Card
2022 Toyota Corolla (gray car)Chevron11.80$3.729$44.008700.0Feb 6, 2026Fleet Card
2022 Toyota Corolla (gray car)Chevron11.80$3.729$44.008700.0Feb 6, 2026Fleet Card
2021 Honda Accord (white car)Exxon14.00$3.786$53.0021500.0Feb 5, 2026Cash
2021 Honda Accord (white car)Exxon14.00$3.786$53.0021500.0Feb 5, 2026Cash
2019 Honda Civic (black car)BP13.20$3.788$50.0039000.0Feb 4, 2026Credit Card
2019 Honda Civic (black car)BP13.20$3.788$50.0039000.0Feb 4, 2026Credit Card
2022 Honda CBR650R (red motorcycle)Shell5.90$3.983$23.503400.0Feb 3, 2026Fleet Card
2022 Honda CBR650R (red motorcycle)Shell5.90$3.983$23.503400.0Feb 3, 2026Fleet Card
2018 Ford F-150 (blue truck)Chevron13.60$3.787$51.5046000.0Feb 2, 2026Credit Card
2018 Ford F-150 (blue truck)Chevron13.60$3.787$51.5046000.0Feb 2, 2026Credit Card
2020 Toyota Camry (silver car)Exxon12.50$3.760$47.0029500.0Feb 1, 2026Cash
2020 Toyota Camry (silver car)Exxon12.50$3.760$47.0029500.0Feb 1, 2026Cash
2018 Suzuki GSX-R750 (yellow motorcycle)BP14.00$3.714$52.0022000.0Jan 30, 2026Credit Card
2018 Suzuki GSX-R750 (yellow motorcycle)BP14.00$3.714$52.0022000.0Jan 30, 2026Credit Card
2019 Ford Transit (white van)Shell12.80$3.750$48.006700.0Jan 29, 2026Fleet Card
2019 Ford Transit (white van)Shell12.80$3.750$48.006700.0Jan 29, 2026Fleet Card
2020 Kawasaki Ninja 650 (green motorcycle)Chevron13.40$3.731$50.0014350.0Jan 28, 2026Cash
2020 Kawasaki Ninja 650 (green motorcycle)Chevron13.40$3.731$50.0014350.0Jan 28, 2026Cash
2021 Yamaha MT-07 (blue motorcycle)Exxon11.90$3.613$42.998000.0Jan 27, 2026Credit Card
2021 Yamaha MT-07 (blue motorcycle)Exxon11.90$3.613$42.998000.0Jan 27, 2026Credit Card
2021 Ford Explorer (blue suv)BP13.20$3.750$49.5024850.0Jan 26, 2026Fleet Card
2021 Ford Explorer (blue suv)BP13.20$3.750$49.5024850.0Jan 26, 2026Fleet Card
2022 Honda CR-V (silver suv)Shell12.60$3.651$46.009820.0Jan 25, 2026Credit Card
2022 Honda CR-V (silver suv)Shell12.60$3.651$46.009820.0Jan 25, 2026Credit Card
2019 Ram 1500 (gray truck)Chevron14.00$3.786$53.004550.0Jan 24, 2026Cash
2019 Ram 1500 (gray truck)Chevron14.00$3.786$53.004550.0Jan 24, 2026Cash
2023 Toyota RAV4 (red suv)Exxon13.80$3.696$51.006800.0Jan 23, 2026Fleet Card
2023 Toyota RAV4 (red suv)Exxon13.80$3.696$51.006800.0Jan 23, 2026Fleet Card
2020 Chevrolet Silverado 1500 (white truck)BP12.50$3.640$45.5014350.0Jan 22, 2026Credit Card
2020 Chevrolet Silverado 1500 (white truck)BP12.50$3.640$45.5014350.0Jan 22, 2026Credit Card
2021 Jeep Grand Cherokee (black suv)Shell12.90$3.721$48.0014300.0Jan 21, 2026Cash
2021 Jeep Grand Cherokee (black suv)Shell12.90$3.721$48.0014300.0Jan 21, 2026Cash
2019 Ford Fusion (blue car)Chevron13.60$3.676$49.993000.0Jan 20, 2026Credit Card
2019 Ford Fusion (blue car)Chevron13.60$3.676$49.993000.0Jan 20, 2026Credit Card
2020 Chevrolet Malibu (gray car)Exxon14.00$3.714$52.0030000.0Jan 19, 2026Fleet Card
2020 Chevrolet Malibu (gray car)Exxon14.00$3.714$52.0030000.0Jan 19, 2026Fleet Card
2022 Mazda CX-5 (white car)BP13.10$3.740$48.998950.0Jan 18, 2026Cash
2022 Mazda CX-5 (white car)BP13.10$3.740$48.998950.0Jan 18, 2026Cash
2018 Subaru Outback (green car)Shell12.70$3.661$46.4951200.0Jan 17, 2026Credit Card
2018 Subaru Outback (green car)Shell12.70$3.661$46.4951200.0Jan 17, 2026Credit Card
2021 Volkswagen Jetta (silver car)Exxon13.50$3.704$50.0018850.0Jan 16, 2026Fleet Card
2021 Volkswagen Jetta (silver car)Exxon13.50$3.704$50.0018850.0Jan 16, 2026Fleet Card
2020 Kia Optima (red car)Chevron12.90$3.682$47.5026600.0Jan 15, 2026Credit Card
2020 Kia Optima (red car)Chevron12.90$3.682$47.5026600.0Jan 15, 2026Credit Card
2023 Hyundai Elantra (blue car)Shell13.20$3.864$51.003250.0Jan 14, 2026Cash
2023 Hyundai Elantra (blue car)Shell13.20$3.864$51.003250.0Jan 14, 2026Cash
2019 Nissan Altima (black car)BP12.80$3.750$48.0042500.0Jan 13, 2026Credit Card
2019 Nissan Altima (black car)BP12.80$3.750$48.0042500.0Jan 13, 2026Credit Card
2022 Toyota Corolla (gray car)Exxon11.50$3.652$42.008600.0Jan 12, 2026Fleet Card
2022 Toyota Corolla (gray car)Exxon11.50$3.652$42.008600.0Jan 12, 2026Fleet Card
2021 Honda Accord (white car)Chevron14.10$3.830$54.0021200.0Jan 10, 2026Cash
2021 Honda Accord (white car)Chevron14.10$3.830$54.0021200.0Jan 10, 2026Cash
2019 Honda Civic (black car)Shell13.00$3.769$49.0038550.0Jan 9, 2026Credit Card
2019 Honda Civic (black car)Shell13.00$3.769$49.0038550.0Jan 9, 2026Credit Card
2022 Honda CBR650R (red motorcycle)Exxon5.80$3.966$23.003300.0Jan 8, 2026Cash
2022 Honda CBR650R (red motorcycle)Exxon5.80$3.966$23.003300.0Jan 8, 2026Cash
2018 Ford F-150 (blue truck)BP15.20$3.947$59.9945500.0Jan 7, 2026Fleet Card
2018 Ford F-150 (blue truck)BP15.20$3.947$59.9945500.0Jan 7, 2026Fleet Card
2020 Toyota Camry (silver car)Shell12.50$3.600$45.0029000.0Jan 5, 2026Credit Card
2020 Toyota Camry (silver car)Shell12.50$3.600$45.0029000.0Jan 5, 2026Credit Card
VehicleTypeVendorDescriptionCostMileageDateStatus
2022 Honda CBR650R (red motorcycle)Tire RotationCycle Gear ServiceTire change scheduled$150.003200.0Feb 20, 2026pending
2018 Suzuki GSX-R750 (yellow motorcycle)Oil ChangeCycle Gear ServiceOil change scheduled$45.0021800.0Feb 19, 2026pending
2020 Chevrolet Silverado 1500 (white truck)Transmission ServiceMeinekeTransmission service scheduled$289.0037800.0Feb 18, 2026pending
2022 Honda CR-V (silver suv)Brake InspectionHonda DealershipBrake inspection scheduled$0.009800.0Feb 17, 2026pending
2019 Nissan Altima (black car)Spark PlugsFirestoneSpark plugs replaced$189.0042500.0Feb 16, 2026pending
2023 Toyota RAV4 (red suv)Oil ChangeToyota DealershipSynthetic oil change$69.994400.0Feb 15, 2026completed
2023 Hyundai Elantra (blue car)Wheel AlignmentDiscount TireFour-wheel alignment$89.993200.0Feb 14, 2026completed
2019 Honda Civic (black car)Coolant FlushHonda DealershipCoolant flush and thermostat check$159.9938500.0Feb 13, 2026completed
2021 Volkswagen Jetta (silver car)PCV ValveFirestonePCV valve replaced$45.0018700.0Feb 12, 2026completed
2019 Ford Transit (white van)Oil ChangeFord DealershipTransit van oil and filter change$89.9967000.0Feb 11, 2026completed
2019 Ford Fusion (blue car)Fuel FilterFord DealershipFuel filter replaced$85.0037200.0Feb 10, 2026completed
2022 Mazda CX-5 (white car)Tire RotationDiscount TireTire rotation and balance$49.998800.0Feb 9, 2026completed
2021 Ford Explorer (blue suv)Exhaust InspectionMeinekeExhaust system inspection$49.9924700.0Feb 8, 2026completed
2020 Kia Optima (red car)Oil ChangeValvoline InstantConventional oil change$49.9926800.0Feb 7, 2026completed
2020 Chevrolet Malibu (gray car)Battery Test/ReplacementAutoZone ServiceBattery replaced — old one failed test$179.9930000.0Feb 6, 2026completed
2018 Subaru Outback (green car)Wiper BladesWalmart AutoFront and rear wiper blades replaced$24.9951500.0Feb 5, 2026completed
2019 Ram 1500 (gray truck)Differential FluidRam DealershipRear differential fluid change$149.9957800.0Feb 4, 2026completed
2018 Ford F-150 (blue truck)Brake InspectionBrakes PlusRear brake pads and rotors replaced$389.9945000.0Feb 3, 2026completed
2022 Toyota Corolla (gray car)Oil ChangeJiffy LubeSynthetic oil change and filter$79.998500.0Feb 2, 2026completed
2020 Toyota Camry (silver car)Air FilterAutoZone ServiceReplaced engine air filter$22.9928200.0Feb 1, 2026completed
2020 Kawasaki Ninja 650 (green motorcycle)Oil ChangeCycle Gear ServiceOil change$40.0014000.0Jan 31, 2026completed
2019 Nissan Altima (black car)Throttle Body CleaningFirestoneThrottle body cleaned$89.9942200.0Jan 30, 2026completed
2020 Chevrolet Silverado 1500 (white truck)Suspension InspectionMeinekeSuspension inspection — shocks good$59.9937600.0Jan 29, 2026completed
2021 Honda Accord (white car)Tire RotationDiscount TireTire rotation$29.9921000.0Jan 28, 2026completed
2021 Jeep Grand Cherokee (black suv)Brake Fluid FlushBrakes PlusComplete brake fluid flush$99.9914100.0Jan 27, 2026completed
2021 Yamaha MT-07 (blue motorcycle)Oil ChangeCycle Gear ServiceOil and filter change$42.007500.0Jan 26, 2026completed
2019 Ram 1500 (gray truck)Radiator HosesRam DealershipUpper and lower radiator hoses replaced$175.0057500.0Jan 25, 2026completed
2022 Honda CR-V (silver suv)Headlight BulbsAutoZone ServiceReplaced low beam headlight bulbs$32.009500.0Jan 24, 2026completed
2022 Mazda CX-5 (white car)Oil ChangeJiffy LubeSynthetic oil change$79.998700.0Jan 23, 2026completed
2023 Toyota RAV4 (red suv)A/C ServiceToyota DealershipA/C recharge and compressor check$199.994200.0Jan 22, 2026completed
2021 Ford Explorer (blue suv)Power Steering FluidFord DealershipPower steering fluid flush$119.9924500.0Jan 21, 2026completed
2020 Chevrolet Silverado 1500 (white truck)Tire RotationDiscount TireTire rotation and pressure check$29.9937500.0Jan 20, 2026completed
2019 Ford Fusion (blue car)Serpentine BeltFord DealershipSerpentine belt and tensioner replaced$185.0037000.0Jan 19, 2026completed
2021 Volkswagen Jetta (silver car)Oil ChangeValvoline InstantFull synthetic oil change$79.9918500.0Jan 18, 2026completed
2021 Jeep Grand Cherokee (black suv)Brake InspectionBrakes PlusFront brake pads replaced$249.9914000.0Jan 17, 2026completed
2020 Kia Optima (red car)Cabin Air FilterMeinekeReplaced cabin air filter$34.9926000.0Jan 16, 2026completed
2023 Hyundai Elantra (blue car)Oil ChangeJiffy LubeSynthetic blend oil change$59.993100.0Jan 15, 2026completed
2019 Honda Civic (black car)Wheel AlignmentDiscount TireFull 4-wheel alignment$89.9937000.0Jan 14, 2026completed
2020 Chevrolet Malibu (gray car)Spark PlugsFirestoneReplaced all spark plugs$189.0029500.0Jan 13, 2026completed
2019 Nissan Altima (black car)Wiper BladesWalmart AutoReplaced front wiper blades$18.9942000.0Jan 12, 2026completed
2022 Toyota Corolla (gray car)Battery Test/ReplacementAutoZone ServiceBattery tested — good condition$0.008200.0Jan 11, 2026completed
2018 Subaru Outback (green car)Coolant FlushSubaru DealershipCoolant flush and refill$149.9950000.0Jan 10, 2026completed
2018 Ford F-150 (blue truck)Transmission ServiceFord DealershipTransmission fluid flush and filter$289.0043500.0Jan 9, 2026completed
2022 Honda CBR650R (red motorcycle)Oil ChangeCycle Gear ServiceMotorcycle oil and filter change$45.003000.0Jan 8, 2026completed
2021 Honda Accord (white car)Air FilterAutoZone ServiceReplaced engine air filter$24.9920500.0Jan 7, 2026completed
2019 Honda Civic (black car)Brake InspectionMeinekeBrake pads and rotors inspected — pads at 60%$0.0037500.0Jan 6, 2026completed
2020 Toyota Camry (silver car)Tire RotationDiscount TireRotated all four tires$29.9927500.0Jan 5, 2026completed
2018 Ford F-150 (blue truck)Oil ChangeValvoline InstantConventional oil change$49.9944000.0Jan 4, 2026completed
2020 Toyota Camry (silver car)Oil ChangeJiffy LubeFull synthetic oil change and filter$79.9928000.0Jan 3, 2026completed
CodeTypeDescriptionInterval (Miles)Interval (Days)Cost
AC02A/C ServiceRecharge freon, check compressor24$150.00
AIR01Air FilterReplace engine air filter15000.0$25.00
BAT01Battery Test/ReplacementTest and replace battery if needed36$180.00
FLUID02Brake Fluid FlushComplete brake hydraulic system flush24$110.00
BRAKE01Brake InspectionInspect pads, rotors, and fluid12000.0365$0.00
AC01Cabin Air FilterReplace HVAC cabin air filter15000.012$35.00
COOL01Coolant FlushEngine coolant/antifreeze replacement30000.024$150.00
DIFF01Differential FluidFront/rear differential gear oil change30000.024$120.00
EXH01Exhaust InspectionMuffler, catalytic converter, pipes30000.024$0.00
FUEL01Fuel FilterReplace in-tank or external fuel filter50000.0$85.00
LIGHT01Headlight BulbsReplace low/high beam bulbs as needed$45.00
COIL01Ignition CoilsReplace ignition coil packs75000.0$250.00
OIL01Oil ChangeSynthetic oil and filter change5000.0180$65.00
OXY01Oxygen SensorsReplace upstream/downstream O2 sensors60000.0$200.00
PC01PCV SystemComplete PCV system service50000.0$80.00
PCV01PCV ValveReplace Positive Crankcase Ventilation valve40000.0$40.00
FLUID01Power Steering FluidFlush and replace power steering fluid36$95.00
HOSE01Radiator HosesReplace upper/lower radiator hoses60000.048$160.00
BELT01Serpentine BeltReplace drive belt and tensioner60000.060$110.00
SPK01Spark PlugsReplace spark plugs30000.0$120.00
SUSP01Suspension InspectionShocks, struts, ball joints, control arms50000.0$0.00
THROT01Throttle Body CleaningClean throttle body and idle air control25000.0$75.00
TIMB01Timing BeltReplace timing belt, water pump, tensioners90000.072$800.00
TIRE01Tire RotationRotate all four tires6000.0$25.00
TRANS01Transmission ServiceFluid flush and filter60000.0$250.00
ALIGN01Wheel Alignment4-wheel alignment service12000.0$90.00
WIPER01Wiper BladesReplace front and rear wiper blades12$35.00