This is a portfolio piece which I developed to demonstrate my ability to produce a database enabled website powered by PHP & MySQL along with the incorporation of CMS abilities. I used a MVC programing pattern to become acclimated with the intrinsic value it adds to development efficiencies. The add and edit forms leverage a third party embedded browser-based WYSIWYG editor (CKEditor ©) for information entered into the description fields. The categories and associated aircraft auto populate as the database tables are changed. The administration portion requires a login prior to accessing the database CMS functionality, which allows user, category, and aircraft item related management CRUD (create, read, update and delete).

WWII Database

Corsair

Corsair

Fighter

The F4U Corsair fighters first took flight in 1940. Jointly designed by Rex Beisel and Igor Sikorsky, the fighters with inverted gull wings were designed as carrier fighters from the ground up but without sacrificing much of the capabilities. The Corsair fighters were the first American fighters to reach the speech of over 717-km/h in level flight thanks to its streamlined body design (retractable landing gears, streamlined air intakes, etc.) and they packed ample firepower which led to their usage of close ground support fighters in Pacific landing operations.


Flying Fortress

Flying Fortress

Heavy Bomber

The Boeing B-17 Flying Fortress was first seen on 28 Jul 1935 as E. Gifford Emery and Edward Curtis Wells' Boeing Model 299, flown by test pilot Les Tower. It was designed as a response to the United States Army Air Corps' 1934 demand for a multi-engined bomber, but Boeing had over-done it: the four-engined bomber was so expensive that the Army instead went with the two-engined Douglas B-18 Bolo. The evaluation, though tainted with a fatal accident, impressed some top brass regardless. Through a legal loophole, the USAAC ordered 13 B-17 bombers for testing on 17 Jan 1936. Between that time and the opening of the Pacific War in 1941, fewer than 200 B-17 bombers entered service with the USAAC. Some of the early production bombers went to the British Royal Air Force which began the European War without heavy bombers. In early 1940, 20 B-17 bombers, redesignated Fortress I bombers by the RAF, were transferred to the RAF. Their first operation was against the German Kriegsmarine's facilities at Wilhelmshaven on 8 Jul 1941, and their performance left much to be desired as bombs missed their targets and machine guns froze at the high altitude. While these early B-17 bombers were being relegated to reconnaissance and patrol roles, the experiences shared by the British crews helped Boeing tweak the design of later models; mainly, the British crews expressed the need for these bombers to carry larger bomb loads and better aiming equipment.


Skymaster

Skymaster

Transport

Wikipedia: