You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
enp0s25 f0ef489830 Merge pull request 'XSS protection on write to DB' (#6) from testing into master 7 months ago
actions XSS protection on write to DB 7 months ago
static adding consultations 7 months ago
.gitignore added db_auth.php to gitignore 7 months ago
LICENSE Initial commit 7 months ago
README.md XSS protection on write to DB 7 months ago
consultations.php adding consultations 7 months ago
db_auth.php.template db_auth template added 7 months ago
footer.php move CSS and JS from HTML into static files 7 months ago
header.php move CSS and JS from HTML into static files 7 months ago
index.php WIP consultation creating 7 months ago
login.php slightly improved login page 7 months ago
logout.php basic session and login/logout functionality 7 months ago
mk_db.sql working comments 7 months ago
view.php WIP consultation creating 7 months ago

README.md

gjh-consultations

TODO

  • optimize reservation.php
  • compress similar SQL queries
  • XSS protection (extra on render, on write should be good already)
    • user: username / full name
    • consultation: name / description / note
    • comments
  • add comments to code
  • improve code structure to improve readability
  • table rendering code in a function / extra file?

Database

  • notifications might get extra table in the future

table users

  • id int (primary key)
  • username varchar(255)
  • full_name varchar(255)
  • password varchar(255)
  • type int

table consultations

  • id int (primary key)
  • author_id int (secondary key?)
  • author_note text / varchar(255)
  • time_start smalldatetime
  • time_end smalldatetime
  • available int

table reservations

  • id int (primary key)
  • consultation_id int
  • reservator_id int
  • name varchar(255)
  • description text
  • confirmed int

table comments

  • id int (primary key)
  • author_id int
  • reservation_id int
  • time timestamp
  • content text