Creating a read-only web service in PHP

At certain points in this course, I've pointed to some…web services, hosted in a…fictional company's website named Explore California.…There are three flavors of web services, with three different formats.…One set of services in RSS, one set in plain old XML and one in JSON.…Now, I'm going to show you the actual scripts that are driving this database.…I provided them in the course exercise files…in a folder named REST ExCalServices.…I'll start with this SQL script explorecalifornia.sql.…This is a script for the database MySQL.…

It defines a number of tables and for each table, first, it…drops the table if it already exists and then it creates the structure.…And then it inserts data into the table where necessary.…There are a number of tables…that are defined in this script but only two of them are used in the web services.…There's an Admin table and an Explorer's table.…But then we get to the first table that's a part of the web service named Packages.…The Packages table has four…fields, PackageID, PackageTitle, PackageDescription and PackageGraphic.…