Photo Album

Run application

• Add a new member
• Edit a member
• Add a photo
• Show member photos
• Display a specific photo (No. 2)

Sample Code

• addMember source
• editMember source
• addPhoto source
• showPhotos source
• photo source
• connect to database
• zipped code
• To install this code as yor own application you must:
• edit albumdbx.php, replacing my username and the password with your own and save it as albumdb.php
• edit the album_drop.sql and album.sql files, replacing the database name in the 'use' statements by your own user name
• Create these tables on your mysql account on shares
1. If you are using PHPMyAdmin - Click the 'SQL' tab on the left column , then 'Import Files', then Browse to locate the script to execute.
2. If you are using a remote login to shares, use the source command to execute the SQL statements
• You need to run the additional script modifyPhoto.sql to set the photoid field to auto_increment

Entity Relationship Model (from QSEE)

QSEE is version 1.1.1