Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a car to buy. Your application must have at least two php forms i.e. one for register a car (CarRegisterForm.php) for sale and one for

image text in transcribedimage text in transcribed a car to buy. Your application must have at least two php forms i.e. one for register a car (CarRegisterForm.php) for sale and one for searching a car (CarSearchForm.php) to buy. CarRegisterForm should receive data from car seller; validate all the data using JS and send back to the web server to insert data into the database using PHP. The CarRegisterForm should contain the following form elements: Car Id (Primary key) - Text Field Car Type (Used or New) - Combo Box Car Make (Honda, Toyota , GMC etc.) - Text Field Car Model (Corolla, Civic etc.) - Text Field Car Minimum Price - number Car Maximum Price - number Car Style (SUV, Sedan, Hatchback or Minivan) - Radio Button Car Drive Type (Front Wheel Drive, All Wheel Drive, Back Wheel Drive) - Checkbox Car Manufacturing Year - Combo Box should contain years from 1981 to 2018. Car Engine Size - Text Field The CarRegisterForm should also contain three buttons as follows: Insert - send car registration data to the web-server and insert into the database after validating all the form elements. The page should display any one of the following messages: "Data Inserted Successfully" "Data Inserted Unsuccessfully" Update - update a particular car data by validating each form elements and sending back to the webserver to update into the database. The page should display any one of the following messages: "Data Updated Successfully" "Data Updated Unsuccessfully" Reset - reset all the form components. The CarSearchForm should search a car from the database by the Car id, Car Type, Car Make, Car Model, and Car Maximum Price. it must display all the car related data on the page. If no data is found, the page should display the following message: "No data found in the database" Validation Rules: Car id - must be 10 digits long and must be unique. NULL not allowed. Car Type - Null not allowed (Must select any one of the options by the user). Car Make - Must contain only letters and spaces. It should start with uppercase letter. Null not allowed. Car Model - Must contain letter, digits and space only. Null not allowed. Car Minimum Price - Minimum value is 1000 and maximum value is 1000000 and step of 1000 . Null not allowed. Car Maximum Price - Maximum value is 1000 and maximum value is 1000000 and step of 1000 . Null not allowed. Car Style - Null not allowed. Car Drive Type - Null not allowed. Car Manufacturing Year - Null not allowed. Car Engine Size - Double value only. Null not allowed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Modeling And Design

Authors: Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

5th Edition

0123820200, 978-0123820204

More Books

Students also viewed these Databases questions