O'Reilly logo

Advanced PHP for Web Professionals by Christopher Cosentino

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required