A web app that tracks clinical trials that have been terminated, suspended or withdrawn due to Covid-19
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.
 
 
 
 
 
 
The research fairy e16f353f3d Small updates to wording of landing page 56 minutes ago
Trials stopped by Covid-19 Analysis Oops wrong date 1 month ago
admin Denominator inclusion 1 month ago
css Added basic structure for displaying data 6 months ago
js Added basic structure for displaying data 6 months ago
.htaccess Added https redirect 6 months ago
LICENSE Initial commit 6 months ago
README.md Wrote out instructions for all the stuff that needs to be fine-tuned 6 months ago
cc-by-nc.png Updates to front page 5 months ago
covid-19.css Updated contact so that it works on narrow displays 4 months ago
cron.php Cron now only makes backup if update succeeds 5 months ago
db-schema.sql Updated DB schema 5 months ago
functions.php Added a link back to the main page after export 3 months ago
index.php Small updates to wording of landing page 56 minutes ago
jquery-3.4.1.min.js Added basic structure for displaying data 6 months ago
protocol.md Updated protocol; fixed typos; changed comparator to 2 years ago 4 months ago
send-message.php Added contact form 4 months ago
trial_details.php Retrieves trial details on click 6 months ago

README.md

Covid-19TrialTracker

A web app that tracks clinical trials that have been terminated, suspended or withdrawn due to Covid-19

System requirements

This web app was designed for a LAMP stack using PHP v. 7.3. It may work on other setups, but this is what it was designed and tested on.

Setup

First, create the tables as defined in db-schema.sql.

You will also need to create a file called config.php in the root web directory with the following contents:

<?php

session_start();

define('DB_USER', 'user-name');
define('DB_PASS', 'password');
define('DB_NAME', 'db-name');
define('DB_HOST', 'db-host');
define('ABS_PATH', '/absolute-path-with-trailing-slash/');
define('SITE_URL', 'https://your-url-dot-com/');

date_default_timezone_set ('America/Montreal');

include_once (ABS_PATH . "functions.php");

?>

In order to prevent non-authorized people from accessing the admin tool, edit the .htaccess file in the admin/ directory to point to an .htpasswd file that is not accessible to the web.

Run the first-run.php file, changing the bounds of the search query to scrape the trials for a month at a time or so, in order to prevent your server from timing out part-way. Delete first-run.php once this step is done.

Rename cron.php to something that no one will guess, e.g. cron-810d437f77829b6c2ae2b121824242b0e9bf423439e995234a05de7c73901ae0.php. I recommend using a random number generator. This will keep a malicious user from repeatedly pinging it. Set a cron job to call this PHP script every day.

You will also need to edit cron.php to save the SQL dump files to a new directory that is not accessible to the web.