Connect MySQL and PHP

  1. Write a PHP program to connect to one of your database tables and display four fields from all of the records on the table.
  2. Modify the program above to select all records that meet a criteria like state = MA. I want multiple records so you have a loop.
  3. Take in a idno or some other field that is a primary key from an html program and use that to display the contents of the record.
  4. Write a program that uses a complex SELECT with two subqueries and display records that meet the criteria.
  5. Write a program that extracts information using a substring to extract data from a field and display that data along with other fields on the record.