The Manual Coding Interface is written in HTML, CSS, and PHP, and needs a SQL database. Thus, if you want to use it, you need a webspace which provides all that. To adjust the tool to your needs, you additionally need at least basic knowledge in HTML, and PHP. I did not code a backend and used phpMyAdmin to import and export data. Everything is hard coded.
Warning: I coded the main part years ago and I am far away from being a good or efficient coder. This script is vulnerable to several kinds of attacks, and not very up-to-date when it comes to newer coding technology.
It still uses MySQL instead of MySQLi or PDO. This is the first thing which should be updated (maybe from me, in case I find the time).
If you still want to use it, please check out the corresponding Github page.
To “install” the MCI, you have to adjust the SQL settings in the inc/mysql.php file and upload everything to your website. Additionally, you will have to set up the databases. In my example I use phpMyAdmin:
CREATE TABLE IF NOT EXISTS `coders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`idoeq` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`password` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`databasecoder` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22
CREATE TABLE IF NOT EXISTS `example` (
`idoeq` int(11) NOT NULL,
`text` varchar(155) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`code1` int(2) DEFAULT NULL,
`code2` int(2) DEFAULT NULL,
`code3` int(2) DEFAULT NULL,
`code4` int(1) DEFAULT NULL,
`comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`entry_start` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`entry_end` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`entry_difference` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`idoeq`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
To have a working example, you might also import the example.sql database into your phpMyAdmin.
I usually create a database for every coder and import *.csv data files. After the coding process, they become exported again.
If you make sure that there is a certain number of entries which become encoded more than once, you can calculate measures of inter- and intra-coder-reliability like Kronbachs’ Alpha.
To add more codes you have to modify the SQL query in the index.php file which adds them to the database (rows 58 to 89) as well as the HTML formula itself (starting at row 243).