Join David Gassner for an in-depth discussion in this video Creating a read-only web service in PHP, part of Foundations of Programming: Web Services.
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.…
- What is a web service?
- Understanding the available transfer protocols and message formats
- Examining SOAP request and response formats
- Creating a simple SOAP service in ASP.NET
- Choosing a SOAP implementation
- Associating REST actions with HTTP requests
- Sending RESTful requests
- Creating OData request URIs
- Securing web services