The Code

This section details the code involved in the script. The descriptions are of a high level, as most of the topics have already been covered. Additional descriptions are provided when new topics are introduced.

meeting.sql

meeting.sql is the SQL code used to create the database for this application.

Script 9-1. meeting.sql
						1.  CREATE TABLE users (
 2.    id INT NOT NULL,
 3.    first VARCHAR(32),
 4.    last VARCHAR(32),
 5.    phone VARCHAR(16),
 6.    email VARCHAR(64),
 7.    pass VARCHAR(8),
 8.    PRIMARY KEY(id));
 9.
						10.  CREATE TABLE rooms (
11.    id INT NOT NULL,
12.    name VARCHAR(32),
13.    location VARCHAR(128),
14.    PRIMARY KEY(id));
15.
						16.  INSERT INTO rooms VALUES(0,'Virtual Room','Virtual Location');
17.
						18.  CREATE TABLE meetings (
19.  id INT ...

Get Advanced PHP for Web Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial