[{"_1":2,"_163":-5,"_164":-5},"loaderData",{"_3":4,"_18":19,"_26":27,"_142":143},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7,"_13":14,"_15":16,"_17":11},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","theme","system","contrast","normal","dockerRebrandTour","routes/_layout",{"_20":-5,"_21":22,"_23":22,"_24":11,"_25":22},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_28":29,"_30":-5,"_31":11,"_32":11,"_33":34,"_35":36,"_37":-5,"_38":11,"_39":40,"_89":-5,"_90":91,"_130":-5,"_131":11,"_132":22,"_133":11,"_134":11,"_135":-5,"_136":11,"_137":-5,"_138":139,"_140":92,"_141":-7},"canonicalUrl","https://hub.docker.com/r/kirylmi/web-php-pgsql/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","kirylmi","reponame","web-php-pgsql","cloudBuildSource","isAutobuildsAvailable","repo",{"_41":42,"_43":44,"_46":47,"_48":49,"_50":11,"_51":52,"_53":54,"_55":56,"_58":36,"_33":34,"_59":60,"_61":45,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":63,"_70":71,"_72":11,"_73":34,"_74":75,"_80":11,"_81":82,"_86":34,"_87":88},"categories",[],"content_types",[45],"image","date_registered","2020-04-15T10:23:11.799692Z","description","Apache+PHP+composer+PGAdmin4+Migrations","is_private","last_updated","2020-09-28T19:50:53.619118Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[57],"application/vnd.docker.container.image.v1+json","name","pull_count",241,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","# WEB-SDT \n### Temp info for the teacher\n### Я там налажал с коммитами и бренчами, каюсь. Много коммитов отправлял без указания какая лаба, т.к. много раз фиксил стили, функции, БД запросы которые относятся к разным лабам + обновлял readme и т.д.
\n### 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
\n### 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\n### Main Info\n- __Website__ is avaiable on(at?) the localhost:8001/
\n- __DB__ is avaiable on(at?) the localhost:5050
\n- __Docker__ is avaiable on(at?) the https://hub.docker.com/r/kirylmi/web-php-pgsql\n### Main parts:\nPHP,\nApache,\nPostgreSQL\n### Additional software:\nPGAdmin4,\nComposer\n### Libraries\nPHPMailer - https://github.com/PHPMailer/PHPMailer,
\nDotenv (for PHP) - https://github.com/vlucas/phpdotenv,
\nGD (PHP ext)
\nSLIR - https://github.com/lencioni/SLIR
\nAWS SDK for PHP (S3) - https://github.com/aws/aws-sdk-php
\n\n## Important Notes\n### Dotenv\nProgram requiers .env files:\n- .env in the main directory (with the docker-compose variables) like:\n > DB_PASSWORD
\n > DB_NAME
\n > DB_USER\n- .env in the ./www/ directory (with the Mailer variables + DB) like:\n > DB_HOST
\n > DB_PORT
\n > DB_USER
\n > DB_NAME
\n > DB_PASSWORD
\n > MAIL_USER
\n > MAIL_EMAIL
\n > MAIL_PASS
\n > MAIL_FROM
\n > MAIL_SSL
\n > MAIL_PORT
\n > S3_BUCKET
\n > S3_KEY
\n > S3_SECRET_K
\n\n## Tasks:\n- :heavy_check_mark: Docker+PHP
\n - :white_check_mark: Docker + docker-compose
\n - :white_check_mark: Apache with PHP on(in?) Docker
\n - :white_check_mark: PostgreSQL on(in?) Docker
\n - :white_check_mark: PGAdmin4 on(in?) Docker
\n - :white_check_mark: Composer on(in?) Docker
\n - :white_check_mark: Migrations in PostgreSQL(Dockerised)
\n - :checkered_flag: Tests
\n- :heavy_check_mark: Apache Rerouting
\n - :white_check_mark: .htaccess file
\n - :checkered_flag: Tests
\n- :heavy_check_mark: Registration,Sign in and activation through email
\n - :white_check_mark: Interface
\n - :white_check_mark: PHPMailer
\n - :white_check_mark: DB queries
\n - :black_square_button: Three tries*
\n - :checkered_flag: Tests
\n- :heavy_check_mark: Users list + Profile
\n - :white_check_mark: ProfilePage
\n - :white_check_mark: NavPanel
\n - :white_check_mark: UsersPage
\n - :white_check_mark: ProfilePage with photos
\n - :white_check_mark: Tests
\n- :heavy_check_mark: Profile edit
\n - :white_check_mark: Change email with reactivation
\n - :white_check_mark: Change password, name
\n - :white_check_mark: Tests
\n - :black_square_button: Change privilege (Lab N required)
\n - :white_check_mark: Tests
\n- :heavy_check_mark: Images
\n - :white_check_mark: Amazon S3
\n - :white_check_mark: Amazon S3 put
\n - :white_check_mark: Amazon S3 get
\n - :white_check_mark: Amazon S3 delete
\n - :white_check_mark: DB queries
\n - :white_check_mark: GD Tests
\n - :white_check_mark: Show and Delete interface
\n - :white_check_mark: Size control
\n - :white_check_mark: Fake images tests
\n- :heavy_check_mark: Subscriptions
\n - :white_check_mark: Idea
\n - :white_check_mark: DB (Table, functions, queries)
\n - :white_check_mark: Button:)
\n - :white_check_mark: Showing images in the correct order
\n - :white_check_mark: Styles fixes
\n - :white_check_mark: Tests
\n - :black_square_button: list of subscribers. Easy one, but should i add it?
\n- :heavy_check_mark: Comments
\n - :white_check_mark: Idea
\n - :white_check_mark: DB (Table, functions, queries)
\n - :white_check_mark: Buttons:)
\n - :white_check_mark: Showing them and synchronysing
\n - :black_square_button: Styles fixes. Will have to change a lot. Better stay as it is
\n - :white_check_mark: Tests
\n \n## P.S. \n........\n \n \n \n### For me: \n- :white_check_mark: Not ERRORS+header, create a php file with redirection, or add function \"Rerout($errormsg,$location)\"\n- :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\n- :white_check_mark::black_square_button: Delete useless comments\n","has_starred","hub_user","immutable_tags_settings",{"_76":11,"_77":78},"enabled","rules",[79],".*","is_automated","permissions",{"_83":22,"_84":11,"_85":11},"read","write","admin","user","storage_size",223830429,"orgData","recentTags",[92],{"_93":45,"_94":95,"_96":97,"_98":99,"_100":101,"_51":119,"_120":95,"_121":34,"_122":57,"_58":123,"_124":125,"_126":110,"_127":119,"_128":67,"_129":22},"content_type","creator",9563689,"full_size",167610001,"id",95558829,"images",[102],{"_103":104,"_105":106,"_107":108,"_109":110,"_111":112,"_113":114,"_115":108,"_116":-5,"_117":97,"_64":67,"_118":-5},"architecture","amd64","digest","sha256:267432eb3c10fe9978b7f7e584693bf5f1e9bd80d4e146f962f0912d2b83fd6c","features","","last_pulled","2026-10-19T18:23:45.664805312Z","last_pushed","2020-05-22T14:47:15Z","os","linux","os_features","os_version","size","variant","2020-09-28T19:50:53.331926Z","last_updater","last_updater_username","media_type","latest","repository",8839737,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxRunInCloud","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"selectedTag","attestationsUrl","routes/_layout.r.$namespace.$reponame.tags",{"_39":144,"_151":152,"_138":161,"_162":11},{"_41":145,"_43":146,"_46":47,"_48":49,"_50":11,"_51":52,"_53":54,"_55":147,"_58":36,"_33":34,"_59":60,"_61":45,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":63,"_70":71,"_72":11,"_73":34,"_74":148,"_80":11,"_81":150,"_86":34,"_87":88},[],[45],[57],{"_76":11,"_77":149},[79],{"_83":22,"_84":11,"_85":11},"tags",{"_153":65,"_154":-5,"_155":-5,"_156":157},"count","next","previous","results",[158],{"_93":45,"_94":95,"_96":97,"_98":99,"_100":159,"_51":119,"_120":95,"_121":34,"_122":57,"_58":123,"_124":125,"_126":110,"_127":119,"_128":67,"_129":22},[160],{"_103":104,"_105":106,"_107":108,"_109":110,"_111":112,"_113":114,"_115":108,"_116":-5,"_117":97,"_64":67,"_118":-5},[],"canDeleteTags","actionData","errors"]

kirylmi/web-php-pgsql

Tags for kirylmi/web-php-pgsql