Hi, as suggest before with elpidio, i made a first try to improve the immunization module. I add a new feature to the immunization form which allow the user to choose beetween a list of common immunizations. After select it, it will fill the form with setup values.
I rewrote the data_search.php script with backward compatibility. It can be used to fill any form using a custom sql string. You will find a new choice in tne data_search.php code. Please, See the file joint. You need to create a new sql table storing the data of immunization. See care_type_immunization.sql file. I modify the file gui_input_show_immunization.php adding a button for the search. Next step, i would like to make a report form of immunization beetween two dates. Any suggestion or request feature ? We could use the new data_search.php form with the city_town on the register data form to fill both the name of the town and the zip code. Please tell me if you think so. I will add it. regards
data_search.php
Description: application/php
gui_input_show_immunization.php
Description: application/php
# phpMyAdmin SQL Dump # version 2.5.3 # http://www.phpmyadmin.net # # Serveur: localhost # Généré le : Lundi 10 Mai 2004 à 19:04 # Version du serveur: 4.0.18 # Version de PHP: 4.3.4 # # Base de données: `caredb` # # -------------------------------------------------------- # # Structure de la table `care_type_immunization` # CREATE TABLE `care_type_immunization` ( `nr` smallint(5) unsigned NOT NULL auto_increment, `type` varchar(20) NOT NULL default '', `name` varchar(20) NOT NULL default '', `LD_var` varchar(35) NOT NULL default '', `modify_time` timestamp(14) NOT NULL, `period` smallint(6) NOT NULL default '0', `tolerance` smallint(3) NOT NULL default '0', `dosage` text NOT NULL, `medecin` text NOT NULL, `titer` text NOT NULL, `note` tinyblob NOT NULL, `application` tinyint(2) NOT NULL default '0', PRIMARY KEY (`nr`), UNIQUE KEY `tolerance` (`tolerance`) ) TYPE=MyISAM AUTO_INCREMENT=2 ;
