simple gallery

simple gallery

1. Database Design

   • User Table
     • UserID
     • FistName
     • LastName
     • UserName
     • Create
     • Read
     • Update
     • Delete
     • Password
       • php function MD5 verschlüsselung
       • MD5 Hash
     • Google ID
   • Images Table
     • ImageID
     • Name
     • FileName
     • Date
       • upload date
     • Status
       • acitve =1 inactive =0
     • UserID
     • ImageDescription
     • CommentID
     • GalleryID
   • Comments Table
     • CommentID
     • Comment
   • Gallery Table
     • GalleryID
     • Name
     • State
       • private public

2. Concenpt

   • Backend
     • PHP
   • Enter Page
     • Check if User Exists
       • y / n
         • Login
           • validate login info
             • if login ok y / n
               • back
               • Gallery
                 • if Admin y / n
                   • edit Gallery
                     • change image
                     • edit mode
                     • change image description
                     • delete comments
                   • show Gallery
                   • Create Gallery
                     • upload multipe Images
                     • enter image description
         • Register
           • Registration Form
             • validate registration data
               • y/ n
                 • back
           • Google Auth