 |  |  |
|---|---|---|
 |  |  |
 |  |  |
Once I knew what features I needed in the site and what pages needed to be created I had to decide what all to include in the database I was building.
This image is the first draft of my database structure.
Below are some Screenshots of the site mock ups created in Photoshop.
After some thought additional questions arose.
What if their login failed, I needed to create a prompt telling the user their login failed.
If the Admin needs to add a new client to an existing album but doesn't know the album ID I would need to have a way built for the user to locate that ID.
This additional sitemap shows many of these scenarios and my thought process in building the structure of this site.
To start the thought process on how I was going to build this site I wanted to know what paths a user might need to take to navigate the site, so I created a rough draft of a site map.
Starting with the login, the first choice depends on what type of user logged in, a client or an admin.
If a client logged in they would only see options for their photo albums, they can also use stars to indicate their favorites.
If an admin logs in they have access to add client information to the database; to enter new photo albums as well as to search client and photo albums.
Photography Website
This website was created using HTML, CSS, PHP and SQL. It features a database that houses login/user information and photo albums.
Each login has access to certain features and albums.
Client logins only have access to photo albums that I have granted them access to. The Admin login has access to a form to add user information.
http://letashazdenek.com/photosite/photo_login.php
username: username password: password
 |  |  |
|---|---|---|
 |  |  |
 |  |
These images are screenshots of the database structure online.
There are user databases and image databases and relational databases.
Once the database was set up and I had all of the naming and information I would need for the website, I started working using HTML, CSS and PHP with SQL to create the forms, pages and requests to make the site function.
Here are copy of screenshots of the code for the login process and form.
Staying organized is really important to me when I have a complex project. I try to keep my naming consistent and easy to understand and I use folders when types of files need to be separated.
This is an example of the main directory on my web server for this website.