Advanced PHP for Web Professionals

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