SQL script for northwind database — creates tables and inserts data, adds relationships

  • Make a PHP page that has a drop-down select populated by a northwind query with the ProductName displaying to the user and the ProductID serving and the option’s value. Put your credentials in an included file as shown in the examples; I should be able to swap my credential file for yours and run your code without needing other changes.
  • Make a page (possibly the previous page) with a form that allows the user to enter a ProductID then use the GET method and a “prepared, parametrized” query to output the data for that product in JSON format.
  • Make a PHP page that has a set of radio buttons populated by a northwind query with Shipper Company Name displaying in a label and the ShipperID serving as the value for the radio button
  • Make a PHP page that has a table (that has the jQuery plugin data-table functionality) populated by a northwind query of the suppliers table