Home

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:

• Lucio Marinelli