kirylmi/web-php-pgsql repository overview

⁠WEB-SDT

⁠Temp info for the teacher

⁠Я там налажал с коммитами и бренчами, каюсь. Много коммитов отправлял без указания какая лаба, т.к. много раз фиксил стили, функции, БД запросы которые относятся к разным лабам + обновлял readme и т.д.

⁠For launching the app, .env files must be filled. Their description can be found below. I uploaded some env (without dot) files, with examples, change what must be changed, and it will be almost ready to roll

⁠Sometimes, the installation of image viewing script is needed for correct work. If images are not showing (happened to me twice, tried it on the absolutely new linux system - everything was fine) then go to the localhost:8001/slir/install
This will automatically install some additional files in the project folder, which will make images working

⁠Main Info

• Website is avaiable on(at?) the localhost:8001/
  
• DB is avaiable on(at?) the localhost:5050
  
• Docker is avaiable on(at?) the https://hub.docker.com/r/kirylmi/web-php-pgsql⁠

⁠Main parts:

PHP, Apache, PostgreSQL

⁠Additional software:

PGAdmin4, Composer

⁠Libraries

PHPMailer - https://github.com/PHPMailer/PHPMailer⁠,
Dotenv (for PHP) - https://github.com/vlucas/phpdotenv⁠,
GD (PHP ext)
SLIR - https://github.com/lencioni/SLIR⁠
AWS SDK for PHP (S3) - https://github.com/aws/aws-sdk-php⁠

⁠Important Notes

⁠Dotenv

Program requiers .env files:

• .env in the main directory (with the docker-compose variables) like:

  DB_PASSWORD
  DB_NAME
  DB_USER

• .env in the ./www/ directory (with the Mailer variables + DB) like:

  DB_HOST
  DB_PORT
  DB_USER
  DB_NAME
  DB_PASSWORD
  MAIL_USER
  MAIL_EMAIL
  MAIL_PASS
  MAIL_FROM
  MAIL_SSL
  MAIL_PORT
  S3_BUCKET
  S3_KEY
  S3_SECRET_K
  

⁠Tasks:

• :heavy_check_mark: Docker+PHP
  
  • :white_check_mark: Docker + docker-compose
    
  • :white_check_mark: Apache with PHP on(in?) Docker
    
  • :white_check_mark: PostgreSQL on(in?) Docker
    
  • :white_check_mark: PGAdmin4 on(in?) Docker
    
  • :white_check_mark: Composer on(in?) Docker
    
  • :white_check_mark: Migrations in PostgreSQL(Dockerised)
    
  • :checkered_flag: Tests
    
• :heavy_check_mark: Apache Rerouting
  
  • :white_check_mark: .htaccess file
    
  • :checkered_flag: Tests
    
• :heavy_check_mark: Registration,Sign in and activation through email
  
  • :white_check_mark: Interface
    
  • :white_check_mark: PHPMailer
    
  • :white_check_mark: DB queries
    
  • :black_square_button: Three tries*
    
  • :checkered_flag: Tests
    
• :heavy_check_mark: Users list + Profile
  
  • :white_check_mark: ProfilePage
    
  • :white_check_mark: NavPanel
    
  • :white_check_mark: UsersPage
    
  • :white_check_mark: ProfilePage with photos
    
  • :white_check_mark: Tests
    
• :heavy_check_mark: Profile edit
  
  • :white_check_mark: Change email with reactivation
    
  • :white_check_mark: Change password, name
    
  • :white_check_mark: Tests
    
  • :black_square_button: Change privilege (Lab N required)
    
  • :white_check_mark: Tests
    
• :heavy_check_mark: Images
  
  • :white_check_mark: Amazon S3
    
  • :white_check_mark: Amazon S3 put
    
  • :white_check_mark: Amazon S3 get
    
  • :white_check_mark: Amazon S3 delete
    
  • :white_check_mark: DB queries
    
  • :white_check_mark: GD Tests
    
  • :white_check_mark: Show and Delete interface
    
  • :white_check_mark: Size control
    
  • :white_check_mark: Fake images tests
    
• :heavy_check_mark: Subscriptions
  
  • :white_check_mark: Idea
    
  • :white_check_mark: DB (Table, functions, queries)
    
  • :white_check_mark: Button:)
    
  • :white_check_mark: Showing images in the correct order
    
  • :white_check_mark: Styles fixes
    
  • :white_check_mark: Tests
    
  • :black_square_button: list of subscribers. Easy one, but should i add it?
    
• :heavy_check_mark: Comments
  
  • :white_check_mark: Idea
    
  • :white_check_mark: DB (Table, functions, queries)
    
  • :white_check_mark: Buttons:)
    
  • :white_check_mark: Showing them and synchronysing
    
  • :black_square_button: Styles fixes. Will have to change a lot. Better stay as it is
    
  • :white_check_mark: Tests
    

⁠P.S.

........

⁠For me:

• :white_check_mark: Not ERRORS+header, create a php file with redirection, or add function "Rerout($errormsg,$location)"
• :white_check_mark::black_square_button: Stop using direct db.php access. There must be such hierarchy: Pages->(if needed)Functions->(if needed)Db queries
• :white_check_mark::black_square_button: Delete useless comments