Menu ▾ ▴

Home

Lucio Marinelli

Changelist

20221101

  • updated PHP syntax and functions to comply with PHP versions since 7.0.0
  • corrected bug in SQL query generating notice about last time inserted/changed anamnesipd
  • the list of "anamnesi" and clinical scales is no longer within the database but in the config.inc.php: please configure the new config.inc.php and remove the "listanamnesi" and "listascale" tables during upgrades!
  • updated database_structure.sql
  • minor code cleanup

20180331

  • Updated phpMySQLAutoBackup to version 1.6.3 (refer to http://dwalker.co.uk/phpmysqlautobackup/ )
  • added mysql_set_charset('utf8'); before all queries to allow correct write of extended characters to the database
  • added mysql_query ("SET NAMES 'UTF8'") right after connecting to the database in order to force PHP to send characters as UTF8 instead of latin1 (based on instructions: https://github.com/phpmyadmin/phpmyadmin/wiki/Garbled_data)
  • updated database structure: all tables are InnoDB & utf8_unicode_ci (manually update your existing database!)
  • database connect commands moved to required dbconnect.inc.php

20161219

  • Deceased patients in a separate page
  • Added age calculation also for "old" patients
  • Changed collation in MySQL tables to UTF-8
  • Improved CSS
  • Improved JavaScript in visit list in order to link the visit label with the visit box

20150207

  • Thorough CSS optimization for mobile visualization and CSS cleanup
  • Improved HTML5 conformance
  • Strenghtened security against MySQL injection attacks in the login page

20141115

  • Removed default message from backup emails
  • Layout optimized for mobile use
  • General CSS cleanup favouring em units
  • ANAGRAFICA_OLD now include patients who did not get in touch for the last 2 years; the page is separated from the original anagrafica
  • Each patient visit has a white background if it'a a telephone/email visit, otherwise the background is yellow
  • Added field "decesso" in table "anagrafica" to indicate deceased patients [TINY INT=1] correponding to a checkbox in mod_pz.php. Dead patients are moved to anagrafica_old list and a cross symbol is added next to the name - REMEMBER TO UPDATE THE ANAGRAFICA TABLE STRUCTURE!

20131221

  • Fixed error inserting single quotes into MySQL database consequent to "magic quotes" suppression following upgrade to PHP 5.4. Added mysql_real_escape_string() filter to all fields before entering the query
  • Changed field name "Codice esenzione" instead of "Numero libretto ASL" now almost useless (remember to purge existing content on the DB)
  • Added HTML5 validation to all forms

20131013

  • Report of last 20 logged operations added to statistics page
  • Table layout corrected in statistics page

Future directions

  • Improving graphic and usability

  • Translate into English and languages other than Italian

  • Ambulatorio is currently designed for neurological "movement disorders" outpatients; making it suitable for other specialities implies adding specific structured history (anamnesi strutturata) and dedicated clinical scales (scale cliniche)

  • Adding support for databases other than MySQL (MariaDB...)

  • Improve code readability

  • Encrypt sensitive informations

  • ... suggest other implementations!

Project Admins:

MongoDB Logo MongoDB